4 MySQL简单使用
显示已存在的数据库:mysql>show databases;
创建数据库:mysql>create database CRMDB;(CRMDB数据库名)
使用数据库 :mysql>use CRMDB;(CRMDB数据库名)
查看表 :show tables;
创建表:
CREATE TABLE student (
id int,
name varchar(20)
);
insert into student values(2001,'LiSi');
insert into student values(2002,'ZhangSan');
insert into student values(2003,'WangWu');
select * from student;