前提:本章总结一些mysql基本的操作,很肤浅的~,以后有新学的只关于mysql的知识点,都会记录在这里,giao~
备注:mysql 5.7.18 node v8.11.4 系统 macOS
创建数据库,以及增删改查基本操作
$ create database test //创建数据库,test为数据库名字
$ use test //选择要操作的数据库
$ 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; //创建表,runoob_tbl为表名,括号里面是各个字段
$ INSERT INTO runoob_tbl
-> (runoob_title, runoob_author, submission_date)
-> values
-> ("学习 js", "sure", NOW()); //插入数据
$ select * from runoob_tbl //查询整个表
结果:
+-----------+--------------+---------------+-----------------+
| runoob_id | runoob_title | runoob_author | submission_date |
+-----------+--------------+---------------+-----------------+
| 1 | 学习 js | sure | 2018-11-16 |
+-----------+--------------+---------------+-----------------+
$ DROP TABLE runoob_tbl //删除表