查询数据库信息:
mysql> status;
创建数据库 : create database pepole;
\
创建表 :create table 表名;
2、显示
使用表:use 表名或数据库名
如:use name_fill;
显示所有的表名:show databases;
显示某一个表的结构:show tables;
显示表的详细文件详细信息:desc 文件名;
查看表结构1:
desc studentss;
查看表结构2:show columns from gire (表名):
3.1、删除
数据库
drop:允许用户删除数据库、表;
3.2删除表:drop table kkknam(删除表名);
4、修改表结构(在表中添加字段):alter table gire(表名) add familey(添加的字段) varchar(50) not null;
5、修改表名:rename table man_voman to mans;
将
man_voman
修改成
mans
6、
查询:select语句;查询一个数据表:select * from gire(表名);
7、插入记录insert: insert into gire(表名) (name,beatafull,file,age,family)
->value( 'kus ','a2 ',' english', ' 26', ' mather');
8.1、查询表中的一列或多列:select selection_list(要查询的内容,选择那些列) from 表名 where 查询条件
如:select name,beatafull, file, age (
要查询的内容,选择那些列
)from gire(
表名
) where age = 27(
查询条件
);
8.2、查询一列:select* from gire where age = 36;
9、修改记录:update;
修改某一条语句的内容格式如下:
update gire(表名) set name='liu jia lin'(修改语句) where age = 21(修改那一条,通过where 语句);
1 0、删除某一条记录:delete;
语法格式:delete from gire(表名) where age = 21(删除的条件);
最常用表:
常用查询类:
数据库创建表的正确使用方法:
//加班调休记录
//序号 类型 开始时间 结束时间 时间 记录时间 记录人 备注
//id typess firstTime endTime useTime recodeTime recoder remarks
RDOP TABLE IF EXISTS `staff_graff`;
CREATE TABLE `staff_graff` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`typess` varchar(50) NOT NULL,
`firstTime` varchar(50) NOT NULL,
`endTime` varchar(50) NOT NULL,
`useTime` int(10) NOT NULL,
`recodeTime` varchar(50) NOT NULL,
`recoder` varchar(50) NOT NULL,
`remarks` text,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=01 DEFAULT CHARSET=utf8;
//插入数据
INSERT INTO `staff_graff` VALUES ('','加班','2016-03-27','2016-03-27','1','2016-04-13 15:26:54','陈云燕','------------');
//关联查询
表:tp_classes;
表:tp_stup;
第一种方法:
select * from tp_classes,tp_stup where
tp_classes.cid = tp_stup.cid;
第二种方法:
select * from tp_stup join
tp_classes
on tp_stup.cid = tp_classes.cid;
该语句: SELECT * FROM `tp_stup` join tp_classes On tp_stup.cid = tp_classes.cid
< =>
// 多表查询
// 多表查询之join,支持字符串和数组
public function meney_table() {
$data = M ( 'tp_stup' )->join ( 'join tp_classes on tp_stup.cid = tp_classes.cid' )->select ();
echo M ()->getLastSql ();
dump ( $data );
}
SELECT * FROM `tp_stup` join tp_classes on tp_stup.cid = tp_classes.cid
array (size=6) 0 =>array (size=5) 'sid' => string '1' (length=1) 'sname' => string '一年级' (length=9) 'time' => string '1324582321' (length=10) 'cid' => string '1' (length=1) 'id' => string '1' (length=1) 1 =>array (size=5) 'sid' => string '2' (length=1) 'sname' => string '二年级' (length=9) 'time' => string '1324582321' (length=10) 'cid' => string '2' (length=1) 'id' => string '2' (length=1) 2 =>array (size=5) 'sid' => string '3' (length=1) 'sname' => string '一年级' (length=9) 'time' => string '1324581231' (length=10) 'cid' => string '1' (length=1) 'id' => string '1' (length=1) 3 =>array (size=5) 'sid' => string '4' (length=1) 'sname' => string '三年级' (length=9) 'time' => string '132123' (length=6) 'cid' => string '3' (length=1) 'id' => string '3' (length=1) 4 =>array (size=5) 'sid' => string '5' (length=1) 'sname' => string '二年级' (length=9) 'time' => string '132451321' (length=9) 'cid' => string '2' (length=1) 'id' => string '2' (length=1) 5 =>array (size=5) 'sid' => string '6' (length=1) 'sname' => string '一年级' (length=9) 'time' => string '1235582321' (length=10) 'cid' => string '1' (length=1) 'id' => string '1' (length=1)
/*** 多表查询之union查询*/public function union_table() {$data = M ( 'tp_stup' )->field ( 'sname' )->union ( array ('field' => 'sname','table'=>'tp_classes'), true )->select ();echo M ()->getLastSql ();dump ( $data );}
SELECT `sname` FROM `tp_stup` UNION ALL SELECT `sname` FROM `tp_classes`array (size=9) 0 =>array (size=1) 'sname' => string '小明' (length=6) 1 =>array (size=1) 'sname' => string '小红' (length=6) 2 =>array (size=1) 'sname' => string '小王' (length=6) 3 =>array (size=1) 'sname' => string '小周' (length=6) 4 =>array (size=1) 'sname' => string '小胖' (length=6) 5 =>array (size=1) 'sname' => string '小琴' (length=6) 6 =>array (size=1) 'sname' => string '一年级' (length=9) 7 =>array (size=1) 'sname' => string '二年级' (length=9) 8 =>array (size=1) 'sname' => string '三年级' (length=9)
/*** 多表查询之distinct, 过滤查询*/public function distinct_table() {$data = M ( 'tp_stup' )->distinct(true)->field ( 'cid' )->order('cid asc')->select ();echo M ()->getLastSql ();dump ( $data );}
SELECT DISTINCT `cid` FROM `tp_stup` ORDER BY cid ascarray (size=3) 0 =>array (size=1) 'cid' => string '1' (length=1) 1 =>array (size=1) 'cid' => string '2' (length=1) 2 =>array (size=1) 'cid' => string '3' (length=1)
从一个页面交换到另外一个页面:
../admin/html/aaa.html
<td valign="top" align="right" width="26" height="15">
<a
href="../admin/html/aaa.html"> 换页面</a></td>