в 13:46, 26 мая 2010

2010-05-26T13:46:00Z

Admin: 1 версия

2010-05-26T10:16:40Z

1 версия

Новая страница

==Explain select command==



<source lang="sql">

CREATE TABLE Manufacturers
(
ManfID CHAR(8) NOT NULL PRIMARY KEY,
ManfName VARCHAR(30) 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(30) NOT NULL,
ManfID CHAR(8) NOT NULL
)
ENGINE=INNODB;

INSERT INTO Parts
VALUES (101, "DVD burnerrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr", "abc123"),
(102, "CD driveeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee", "jkl123"),
(103, "80-GB hard diskkkkkkkkkkkkkkkkkkkkkkkkkkkkkkk", "mno456"),
(104, "Mini-towerrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr", "ghi789"),
(105, "Power supplyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy", "def456"),
(106, "LCD monitorrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr", "mno456"),
(107, "Zip driveeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee", "ghi789"),
(108, "Floppy driveeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee", "jkl123"),
(109, "Network adapterrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr", "def456"),
(110, "Network hubbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbbb", "jkl123"),
(111, "Routerrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrrr", "mno456"),
(112, "Sound cardddddddddddddddddddddddddddddddddddd", "ghi789"),
(113, "Standard keyboarddddddddddddddddddddddddddddd", "mno456"),
(114, "PS/2 mouseeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeeee", "jkl123"),
(115, "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;

</source>

← Предыдущая	Версия 13:46, 26 мая 2010
(нет различий)

SQL/MySQL/Select Clause/Simple Select - История изменений

в 13:46, 26 мая 2010

Admin: 1 версия