INSERT. INSERT, SQL-, phpMyAdmin INSERT.
INSERT INTO `countries`
(`country_code`, `country_name`)
VALUES ('ca', 'Canada');
INSERT INTO, . MySQL, "`", , . , , . VALUES, , , , .
, .
`cities` :
INSERT INTO `cities`
(`id`, `city_name`, `latitude`, `longitude`,
`population`, `country_code`)
VALUES ('', 'Sherbrooke', '45 23 59.00',
'-71 46 11.00', 125000, 'ca'
);
, id, . , `population` - , .
.
INSERT INTO `countries`
(`country_code`, `country_name`)
VALUES ('zh', 'China');
INSERT INTO `cities`
(`id`, `city_name`, `latitude`, `longitude`,
`population`, `country_code`)
VALUES ('', 'Shanghai', '31 13 58.00', '121 26 59.99',
11000000, 'zh'
);
UPDATE. `population` 130000.
UPDATE `cities` SET `population` = '130000'
WHERE `id` = '1' LIMIT 1;
`UPDATE`, . `SET` ( `population`) " = ".
WHERE `id` = '1', , `population` , .. .
LIMIT 1 phpMyAdmin , , . `UPDATE` :
UPDATE `cities` SET `city_name` = 'Sherbrooke, Quebec',
`population` = '130001'
WHERE `id` = '1' LIMIT 1;
DELETE. SQL- , :
DELETE FROM `cities` WHERE `id` = '1' LIMIT 1;
, , . WHERE UPDATE DELETE SQL, !
|
|
SELECT. . , SELECT : " , ?". phpMyAdmin SQL- SELECT , Browse `cities`.
SELECT * FROM `cities` LIMIT 0,30;
" ". FROM , . LIMIT 0,30 , 0 ( ), 30 .
Search SELECT. Search `cities` , . `population` :
phpMyAdmin :
SELECT `city_name`, `population`
FROM `cities`
WHERE 1
ORDER BY `population` DESC
LIMIT 0,30;
, . WHERE 1, phpMyAdmin, . , . ORDER BY , , DESC (ASC ).
SQL-. phpMyAdmin SQL-query Edit , "Query". `country`:
SELECT `city_name`, `population`
FROM `cities`
WHERE country_code = 'zh'
ORDER BY `population` DESC;
, . . :
100000:
WHERE population > 100000 AND country_code = 'ca';
, "A":
WHERE city_name like 'A%';
. . :