本文共 630 字,大约阅读时间需要 2 分钟。
select host,user,password from user;
show databases;
select database();
use mysql;
create table Student(name VARCHAR(6), schoolId CHAR(6));
show tables;
SHOW FULL COLUMNS FROM Student;
alter table Student CHANGE schoolId studentId CHAR(6);
insert into Student(name, studentId) values("wuchen","163402");
drop table Student;
create database mydb;
alter table user add primary key(user_account);
delete from session where user_account = "xxxxx@qq.com";
UPDATE Person SET FirstName = 'Fred' WHERE LastName = 'Wilson'
转载地址:http://bzbtb.baihongyu.com/