https://wenku.baidu.com/view/86558b7df12d2af90342e61a.html
1
mysql -u root -p
2
show databases;
create database test001;
use test001;
3
show tables;
create table students(id int unsigned not null auto_increment primary key,name char(8) not null,sex char(4) not null,age tinyint unsigned not null);
describe students;
4
select * from students;
insert into students value (‘1’,‘Tom’,‘F’,‘18’ );
select * from students;
load data local infile ‘D:\student.txt’ into table students;
mysql建库建表、插入数据和导数文件
最新推荐文章于 2023-01-05 15:44:45 发布