mysql 1

//drop database <数据库名>;

mysql -uroot -p(密码)
CREATE DATABASE IF NOT EXISTS RUNOOB DEFAULT CHARSET utf8 COLLATE utf8_general_ci;

show databasees;
use 库名;  //进入库

show tables;  //查看说有表

CREATE TABLE IF NOT EXISTS `runoob_tbl`(
   `runoob_id` INT UNSIGNED AUTO_INCREMENT, `runoob_title` VARCHAR(100) NOT NULL, `runoob_author` VARCHAR(40) NOT NULL, `submission_date` DATE, PRIMARY KEY ( `runoob_id` ) )ENGINE=InnoDB DEFAULT CHARSET=utf8;

desc 表名;   //查看表

DROP TABLE table_name ;   //删除表
//插入数据
INSERT INTO runoob_tbl 
(runoob_title, runoob_author, submission_date)
values
("学习 PHP", "菜鸟教程", NOW());

INSERT INTO runoob_tbl 
(runoob_title, runoob_author, submission_date)
values
("学习 Java", "菜鸟教程", NOW());

INSERT INTO runoob_tbl 
(runoob_title, runoob_author, submission_date)
values
("学习 HTML", "菜鸟教程", NOW());

select * from runoob_tbl; //读取表数据

转载于:https://www.cnblogs.com/dianzan/p/9768284.html