MySQL基础语法

---

一、使用windows下的dos命令操作数据库

1. 启动数据库服务

net start [mysql server name]

2.登录数据库

mysql –u root –p

3.查看数据库列表

show databases;

4.选择数据库并进入

use [database name];

5.查看数据表

show tables;

6.退出数据库

exit;

二、基本SQL语句

1.查询

select * from [table] where [column] = ?

查询相关的习题见该文章：MySQL基础查询训练

2.添加

INSERT INTO [table](column,column…) VALUES([v1],[v2]…)

INSERT INTO cla_info(cla_id, cla_name, cla_teacher) VALUES('7', '七年级一班', '梨花');

INSERT INTO cla_info SET cla_id = '7', cla_name = '七年级一班', cla_teacher = '梨花';

INSERT INTO cla_info VALUES('7', '七年级一班', '梨花');

INSERT INTO cla_info(cla_name, cla_teacher) SELECT Sname, Class FROM student;

3.修改

UPDATE [table] SET [column] = [v1] WHERE [column] = [v2]

UPDATE cla_info SET cla_teacher = '梨花' WHERE cla_id = 9;

4.删除

DELETE FROM [table] WHERE [column] = [v1]

DELETE FROM cla_info WHERE cla_id = 9;

三、常用内置函数

-- 聚合函数

-- 求总行数
SELECT COUNT(</