hintcnuie

Join Rows    To combine matching rows in multiple tables, use a join     SELECT nm.id ANSWER ,jb.job ID NAME JOB FROM emp_nm nm ,emp_jb jb 10 Sanders Sales WHERE nm.id = jb.id 20 Pernal Clerk ORDER B...

常用MYSQL命令 启动：net start mySql; 　　进入：mysql -u root -p/mysql -h localhost -u root -p databaseName; 　　列出数据库：show databases; 　　选择数据库：use databaseName; 　　列出表格：show tables； 　　创建数据表：mysql> CREAT...