mysql语句
查看当前所有数据库
show databases;
查看当前所有表
show tables;
查看表结构
desc user;
创建数据库
create database msg;
创建数据库
create table use (
id int not null primary key auto_increment,
user varchar(20) not null,
pass varchar(100) not null
)charset utf8;
查看表所有内容
select * from user;
根据条件查看表内容
select id,user,pass from user;
修改表数据
uodate user set user='administrator' where id=1;
增加一条数据
insert into user (id,user,pass,age) value (6,'yes','no',10);
增加多条数据
insert into user (id,user,pass,age) value (8,'yes2','no2',10),(7,'yes1','no1',11);
删除数据
delete from user where id=7;
删除表
delete from user;
php操作mysql语句
//打开数据库，并返回一个资源
$conn = mysql_connect('localhost', 'root' , 'root');
mysql_query('use msg' , $conn);//选择数据库
mysql_query('set names utf8' , $conn);//设置字符集
//查看数据库数据
$sql = 'select * from user';
//插入一条语句
$sql = "insert into user (id , user , pass , age) value (1 , 'admin' , 'admin' , 20)";
//修改数据
$sql = 'update user set user = "shu" where id =1';
//删除数据
$sql = "delete from user where id = 1";
$res = mysql_query($sql);//执行sql语句,返回一个资源
//循环取出所有数据
//mysql_fetch_assoc此函数同mysql_fetch_row类似
$date = array();
//从res资源中取出数据放到row中，循环row，直到等于false停止循环
while ( ($row = mysql_fetch_row($res)) != false){
$date[] = $row;
}
print_r($date);
//mysql_errno(0);//查看报错信息
mysql_close($conn);//关闭资源
