进入数据库:
sudo mysql -u root
数据库分号;结尾
查看文件:
show databases;
进入文件:
use mechnical-dev;
查看有没有数据表:
show tables;
创建数据表:
create table photos(id smallint,pictures_description varchar(38));
varchar
查看数据表内容 结构:
desc photos;
查看表里内容:
select * from photos
*是指所有的Colum所有的字段
CRUD指create read update delete增删查改
增:
insert into photos(id,pictures_description) Values(1, ‘机构运动图’)
查:
select * from photos;所有字段
也可以select pictures_description from photos;查看某一字段的
改:
update photos set pictures_description='机构运动图1' where id=1;注意要标注id号
删:
delete from photos where id=1;
default null说明可以为空
增多个例如:
insert into photos(person_id,fname,lname,gender,street,city,country) Values(1, '晓彤','田','f','铁骑山路','青岛','中国');
stored procedure
show procedure status;
产生procedure:
DELIMITER //回车
CREATE PROCEDURE FINDME con CHAR(20)
BEGIN
SELECT country,fname,lname FROM person
WHERE country=con
END//回车
DELIMITER;不再是delimiter了
使用procedure:
call FINDME('canada');
查看如何创建的procedure:
show create procedure FINDME;
country变量名
delimiter //指后面的内容是一整句话
换一种更直接的方法查看FINDME:
exit;
sudo mysql -u root mechnical_dev --silent --row
show create procedure FINDME;
另一种:在上一种基础上
select * from person;
还有一种:在上上种基础上
select * from person \G;
删除procedure:
drop procedure FINDME;