MySQL-练习答案.pptxVIP

Oracle Java实训教材系列MySQL数据库设计与开发 — 课后练习答案版本D第一章 走进MySQL数据库2: mysql create database world; mysql create database league;3: Source c:\world.sql; Source c:\league.sql;第二章 MySQL服务器与客户端3: mysql -uroot -p mysql -uroot -proot4: select division(); select database();第三章 MySQL数据库结构1：show tables from league;2：desc country; desc city\G show create table city;3：select code,name from country order by name limit 3;4：select count(distinct countrycode) from city where population 7000000;5：select distinct district from city;6：select language, count(countrycode) from countrylanguage group by language havin