Главная » Ссылки с тэгом "sql"

Ссылки с тэгом "sql" 

Визуальное представление работы команды JOIN языка SQL

В очень простой форме (собственно в виде примеров в картинках) показано как работают различные JOIN'ы в SQL.

I thought Ligaya Turmelle's post on SQL joins was a great primer for novice developers. Since SQL joins appear to be set-based, the use of Venn diagrams to explain them seems, at first blush, to be a natural fit. However, like the commenters to her post, I found that the Venn diagrams didn't quite match the SQL join syntax reality in my testing.

I love the concept, though, so let's see if we can make it work. Assume we have the following two tables. Table A is on the left, and Table B is on the right. We'll populate them with four records each.

Читать полностью
Теги: mysql, sql, программирование, уроки, шпаргалки,

Welcome to Lion PHP Framework

Lion is an emerging open source PHP framework for creating rich web applications as a combination of the most valuable features and patterns taken from the development community.

This PHP framework is the perfect balance between rapid development, scalability and performance, meaning that it has been specially designed for people who need to reduce engineering efforts, people who need scalable architectures to maintain as well as people who need a thin-layer PHP framework to increase the performance as much as possible.

Читать полностью
Теги: cms, mysql, php, sql, фрэймворки,

Using PHP/MySQL with Google Maps

This tutorial is intended for developers who are familiar with PHP/MySQL, and want to learn how to use Google Maps with a MySQL database. After completing this tutorial, you will have a Google Map based off a database of places. The map will differentiate between two types of places—restaurants and bars — by giving their markers distinguishing icons. An info window with name and address information will display above a marker when clicked.

Читать полностью
Теги: api, mysql, php, sql, сервисы, уроки,

Тьма сниппетов для вэб-разработчиков

Большая коллекция сниппетов (готовых к использованию кусков кода) для вэб-разработчиков.

Читать полностью
Теги: ajax, css, html, javascript, mysql, php, sql, программирование,

dbForge Studio for MySQL

Отличнейший бесплатный инструмент для администрирования баз данных и не только. Жаль, что нет версии под линукс 

Читать полностью
Теги: mysql, sql, утилиты,

Bookmark and Share
Страницы: 1
Просто совет
Два месяца бесплатного использования VPS-сервера с 20Гб SSD на борту. Интересует?
Тогда жми сюда.
Follow TanitaCMS in Twitter