mysql常用命令

mysql：

建

CREATE DATABASE IF NOT EXISTS CoreDB DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

CREATE USER 'test1'@'localhost' IDENTIFIED BY 'test1';

插

insert into table values(‘xx’,‘xxx’,‘xxxx’)

insert into table(name,age,class) values(‘xiaoming’,23,‘classone’)

insert into student1 (name,age,class) select name,age,class from student

删

drop database coredb；

DROP TABLE persons;

DROP TABLE table1_name, table2_name, ...;

DELETE FROM student WHERE `name` = '张三'

改

update tablename Set column_name = new_value Where column_name = some_value

UPDATE Person SET Address = 'Stien 12', City = 'Stavanger' WHERE LastName = 'Rasmussen'

查

select * from tablename

SELECT column1, column2, ... FROM table_name;