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;