改变记录日志位置:\T+空格+路径
增:
- 数据库:CREATE DATABASE name;
- 表: CREATE TABLE stuff( id INT(20) NOT NULL PRIMARY KEY AUTO_INCREMENT, name VARCHAR(20) NOT NULL );
- 字段:alter table examstudent add Type varchar(20);
- 值:1、insert into student_info(stuName,stuAge) select
studentName_B,studentAge_B from student_info_B ;
2、insert into student_info(stuName,stuAge) values('zhanghua',13),
('zhanghua',14),('zhanghua',15);
删:
- 数据库:DROP DATABASE NAME;
- 表:DROP TABLE table_name ; DELETE FROM info WHERE 1=1;清空数据表
- 字段:alter table examstudent drop column Type;
- 值:DELETE FROM examstudent WHERE FlowID="201702";
改:
- 数据库:RENAME database olddbname TO newdbname;
- 表:alter table name1 rename name2;
- 字段:alter table newexample change name username varchar(50);
- 值:UPDATE 表名 SEt 字段名='字符串' WHERE 字段='替换的字符串' AND 条件;
査:
- 数据库:SHOW DATABASES; USE name;
- 表:SHOW TABLES;
- 字段:DESC tablename;
- 值:select id, name from users where id =value;
SELECT*FROM info WHERE id BETWEEN 1 AND 3;