MySQL操作

【MySQL操作】今天具体学了下 MySQL的操作;
mysql 对大小写不敏感 所以大写只是为了区分关键字与 数据

create database databasename; create table tablename; describe tablename; select * from tablename; select columnname1,..., from tablename; altertable tablename add constriant primary key column1; insert into tablename values(.......,.....,.....); select ................where ....like ''// '_'代表一个字符 '%'代表多个字符 order bydesc 降序/asc升序 innot in andor

    推荐阅读