MySQL基础操作之对数据库和表的增删改查

1 mysql -u root -p;

1 SHOW DATABASES;

CREATE DATABASE MyDATA;

CREATE DATABASE MYDATA DEFAULT CHARACTER SET UTF8;

DROP DATABASE MYDATA;

SHOW CREATE DATABASE MYDATA;

ALTER DATABASE MYDATA DEFAULT CHARACTER SET GBK;

USE MYDATA;

SHOW TABLES;

CREATE TABLE STUDENT(SID INT,
SNAME VARCHAR(20),
SAGE INT
);

DESC STUDENT;

DROP TABLE STUDENT;

ALTER TABLE STUDENT ADD COLUMN SGENDER VARCHAR(2);

ALTER TABLE STUDENT DROP COLUMN SGENDER;

ALTER TABLE STUDENT MODIFY COLUMN SNAME VARCHAR(100);

ALTER TABLE STUDENT CHANGE COLUMN SNAME USERNAME VARCHAR(2);

ALTER TABLE STUDENT RENAME TO TEACHER;