插入表自身数据mysql_mysql创建数据库表插入数据

一、mysql安装

所有平台的 MySQL 下载地址为： MySQL 下载. 挑选你需要的 MySQL Community Server 版本及对应的平台

注意：安装过程我们需要通过开启管理员权限来安装，否则会由于权限不足导致无法安装。

二、MySQL 连接

以下是从命令行中连接mysql服务器的简单实例：

mysql -u root -p

Enter password:******

如下图所示表示成功：

创建并选择进入数据库ams

create database ams;

use ams;

MySQL 创建数据表users并插入数据

create table users(id int primary key auto_increment,username varchar(20) unique,nickName varchar(20),password varchar(20),sex tinyint,birthday date,job varchar(20),email varchar(40) NOT NULL,phone varchar(11));

insert into users(username,nickName,password,sex,birthday,job,email,phone)values('admin','超级管理员','111111',1,'20180308','管理员','admin@test.com.cn','18187654321');

insert into users(username,nickName,password,sex,birthday,job,email,phone)values('zhangsan','张三','111111',1,'20180308','Android','zhangsan@test.com.cn','18187654321');

insert into users(username,nickName,password,sex,birthday,job,email,phone)values('lisi','李四','111111',1,'20180308','iOS','lisi@test.com.cn','18187654321');

insert into users(username,nickName,password,sex,birthday,job,email,phone)values('wangwu','王五','111111',1,'20180308','Android','wangwu@test.com.cn','18187654321');

insert into users(username,nickName,password,sex,birthday,job,email,phone)values('zhaoliu','赵六','111111',1,'20180308','Android','zhaoliu@test.com.cn','18187654321');

insert into users(username,nickName,password,sex,birthday,job,email,phone)values('zhaoliu','赵六','111111',1,'20180308','iOS','zhaoliu@test.com.cn','18187654321');

insert into users(username,nickName,password,sex,birthday,job,email,phone)values('qianqi','钱七','111111',1,'20180308','iOS','qianqi@test.com.cn','18187654321');

insert into users(username,nickName,password,sex,birthday,job,email,phone)values('sunba','孙八','111111',1,'20180308','iOS','sunba@test.com.cn','18187654321');

insert into users(username,nickName,password,sex,birthday,job,email,phone)values('yangjiu','杨九','111111',1,'20180308','WEB','yangjiu@test.com.cn','18187654321');

insert into users(username,nickName,password,sex,birthday,job,email,phone)values('wushi','吴十','111111',1,'20180308','WEB','wushi@test.com.cn','18187654321');

select * from users;

#或者有时间和图片的如下

create table users(id int primary key auto_increment,username varchar(20) unique,nickName varchar(20),password varchar(20),sex tinyint,birthday date,job varchar(20),email varchar(40) NOT NULL,phone varchar(11),created_at datetime NOT NULL DEFAULT CURRENT_TIMESTAMP(),images varchar(255));

insert into users(username,nickName,password,sex,birthday,job,email,phone,created_at,images)values('admin','超级管理员','111111',1,'20180308','管理员','admin@test.com.cn','18187654321',CURRENT_TIMESTAMP,'1528796774389.png');

insert into users(username,nickName,password,sex,birthday,job,email,phone,created_at,images)values('zhangsan','张三','111111',1,'20180308','Android','zhangsan@test.com.cn','18187654321',CURRENT_TIMESTAMP,'1528796774389.png');

insert into users(username,nickName,password,sex,birthday,job,email,phone,created_at,images)values('lisi','李四','111111',1,'20180308','iOS','lisi@test.com.cn','18187654321',CURRENT_TIMESTAMP,'1528796774389.png');

insert into users(username,nickName,password,sex,birthday,job,email,phone,created_at,images)values('wangwu','王五','111111',1,'20180308','Android','wangwu@test.com.cn','18187654321',CURRENT_TIMESTAMP,'1528796774389.png');

insert into users(username,nickName,password,sex,birthday,job,email,phone,created_at,images)values('zhaoliu','赵六','111111',1,'20180308','Android','zhaoliu@test.com.cn','18187654321',CURRENT_TIMESTAMP,'1528796774389.png');

insert into users(username,nickName,password,sex,birthday,job,email,phone,created_at,images)values('zhaoliu','赵六','111111',1,'20180308','iOS','zhaoliu@test.com.cn','18187654321',CURRENT_TIMESTAMP,'1528796774389.png');

insert into users(username,nickName,password,sex,birthday,job,email,phone,created_at,images)values('qianqi','钱七','111111',1,'20180308','iOS','qianqi@test.com.cn','18187654321',CURRENT_TIMESTAMP,'1528796774389.png');

insert into users(username,nickName,password,sex,birthday,job,email,phone,created_at,images)values('sunba','孙八','111111',1,'20180308','iOS','sunba@test.com.cn','18187654321',CURRENT_TIMESTAMP,'1528796774389.png');

insert into users(username,nickName,password,sex,birthday,job,email,phone,created_at,images)values('yangjiu','杨九','111111',1,'20180308','WEB','yangjiu@test.com.cn','18187654321',CURRENT_TIMESTAMP,'1528796774389.png');

insert into users(username,nickName,password,sex,birthday,job,email,phone,created_at,images)values('wushi','吴十','111111',1,'20180308','WEB','wushi@test.com.cn','18187654321',CURRENT_TIMESTAMP,'1528796774389.png');

select * from users;

以上就是基础的mysql