The SELECT statement is used to select data from the table.
The result is stored in a result table (called a result set).
SQL SELECT Syntax
SELECT column name from table name and:
SELECT * FROM table name NOTE: SQL statements are insensitive to case. Select is equivalent to select
Instance
CREATE TABLE Manufacturers
(
Manfid CHAR (8) Not NULL PRIMARY KEY,
Manfname VARCHAR () not NULL
)
Engine=innodb;
INSERT into manufacturers
VALUES (' abc123 ', ' abcqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq '),
(' def456 ', ' defwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwwww '),
(' ghi789 ', ' ghieeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee '),
(' jkl123 ', ' jklrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr '),
(' mno456 ', ' mnottttttttttttttttttttttttttttttttttttttttttttttttttttttt ');
CREATE TABLE Parts
(
PartID SMALLINT not NULL PRIMARY KEY,
PartName VARCHAR () not NULL,
Manfid CHAR (8) Not NULL
)
Engine=innodb;
INSERT into Parts
VALUES (' DVD burnerrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr ', ' abc123 '),
(102, ' CD driveeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee ', ' jkl123 '),
(Hard, ' 80-gb diskkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk ', ' mno456 '),
(The ' mini-towerrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr ', ' ghi789 '),
(The ' Power supplyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy ', ' def456 '),
(The ' LCD monitorrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr ', ' mno456 '),
(Driveeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee, ' Zip ', ' ghi789 '),
(108, ' Floppy driveeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee ', ' jkl123 '),
(109, ' Network adapterrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr ', ' def456 '),
(HUBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBBB, ' network ', ' jkl123 '),
(MR, ' Routerrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr ', ' mno456 '),
(112, ' Sound cardddddddddddddddddddddddddddddddddddd ', ' ghi789 '),
(113, ' Standard keyboarddddddddddddddddddddddddddddd ', ' mno456 '),
(114, ' Ps/2 mouseeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee ', ' jkl123 '),
(56-k, ' modemmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmmm ', ' ghi789 '),
(116, ' Display adapterrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr ', ' mno456 '),
(117, ' IDE controllerrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr ', ' def456 ');
SELECT PartName, Manfname
From Parts as p, manufacturers as M
WHERE P.manfid = M.manfid
Order BY PartName;
EXPLAIN SELECT PartName, Manfname
From Parts as p, manufacturers as M
WHERE P.manfid = M.manfid
Order BY PartName;
With an expression
MySQL Tutorial > SELECT @min_price: =min (Price), @max_price: =max (price) from the;
+------------------------+------------------------+
| @min_price: =min (Price) | @max_price: =max (Price) |
+------------------------+------------------------+
| 2.34 | 21.29 |
+------------------------+------------------------+
1 row in Set (0.00 sec)
Most simple select query
Mysql> SELECT FirstName, lastName from Employee where > 32;
+-----------+----------+
| FirstName | LastName |
+-----------+----------+
| Mike | Harper |
+-----------+----------+
1 row in Set (0.00 sec)