MENU

数据库学习课程001

May 16, 2018 • Read: 1735 • mysql学习阅读设置

条件
where

查看库
show databases;

选库
use test;

查看库下的表
show tables;

查表
select*from cat;

查看表结构
desc user

<增> insert
插入两列数据ued列和name列,values 后跟值
inser into user <uid,name> values <2,‘zhangsan’>

<改> update
update user set age=99 wehre name='yumli'
update  表名 set
列 1 =  新值 1,
列 2 =  新值 2
where expr

<删>delete
delete from user where uid=8;

<查>select
select * from user;(查询表名)

兼总条贯 知至知终

最后编辑于: August 19, 2018