mysql
SQL结构化查询语言structure query language
从cmd 进入:cd d:\programmer\mysql5.5\bin mysql mysql -u root -p
查数据库 show databases;创建create database s001;删除drop database s001;改只能改字符集 进数据库use s001;正在使用哪个select database();
查全表show tables;查本表desc student;改表名rename table student to newstudent;增学生表create table student(id int primary key auto_increment,name varchar(30),sex int);删drop table student;
改列 增grade列alter table student add grade int;删一列 alter table student drop grade;改列名alter table student grade newgrade int;


