数据库操作

表table_name
SELECT * FROM table_name LIMIT 0 ,30 //查询30条数据
SELECT DISTINCT data FROM table_name //不重得的数据
SELECT * FROM table_name ORDER BY id DESC //按不ID排序的数据 DESC倒排序
INSERT INTO table_name(data)  VALUES('text') //插入一条数据
UPDATE table_name SET data = 'admin' WHERE id = 1 更新一条数据
DELETE FROM table_name WHERE id = 1 //删除一条数据

PHP操作数据库
<?php
$con = mysql_connect('location','root','123456');
mysql_select_db('my_db',$con);
$result = mysql_query('SELECT * FROM table_dat');
while($row = mysql_fetch_array($result)){
echo $row['id'];
}

?>

创建数据库

CREATE DATABASE mydb DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;