12.30 mysq数据使用

使用mysql

--------------------------------------

1 管理工具

mysql.exe 官方客户端工具

 

mysql -uroot

mysql -hlocalhost -uroot -p -P3306

 

 

sqlyog

 

 

 

建立数据库

 

使用数据库

 

删除数据库

 

建立表

 

查看表结构

 

删除表

 

create 创建

drop 删除

alter 修改

 

表数据的CRUD 增删改查

insert 插入

delete 删除

update 修改

select 查询

 

 

 

show databases;

use db;

show create database db;

 

show tables;

create table wx_student(

id int unsigned auto_increment,

name varchar(30) not null,

address varchar(50) not null,

dept varchar(30),

score tinyint unsigned,

money decimal(9,2),

birthday datetime,

regtime date,

info text,

primary key(id)

)engine=innodb auto_increment=1;

 

 

insert into wx_student values(null,'李四','郑州市','计算机科学',80,8000,'1985-10-20 10:10:10','2019-10-12','这是一个爱学习的学生。');

 

select * from wx_student;

 

 

 

 

select version();

 

create database db;

use db;

 

 

show tables;

-- 建立表

create table blog_student(

id int unsigned auto_increment,

name varchar(30),

money decimal(9,2),

birthday date,

primary key(id)

);

 

drop table student;

 

desc student;

 

desc student;

 

-- 数据插入

insert into `student` values(null,'李四1',800,'1985-10-30');

insert into `student` values(null,'李四2',800,'1985-10-30');

insert into `student` values(null,'李四3',800,'1985-10-30');

insert into `student` values(null,'李四4',800,'1985-10-30');

insert into `student` values(null,'李四5',800,'1985-10-30');

 

-- 查询

select * from student order by id desc limit 1;

 

 

-- 删除数据

delete from student where id = 5;

 

-- 修改数据

update student set name = '李丽',money = 1600.18 where id = 6;

update student set birthday = '1988-3-1' where id=6;

 

 

create database `database`;

drop database `database`;

 

create database `student info database`;

 

show databases;

 

 

 

 

 

 

2 java程序 jdbc for mysql 驱动