PHP + MySQL 命令备忘

最新推荐文章于 2024-09-13 22:38:14 发布

ga6840

最新推荐文章于 2024-09-13 22:38:14 发布

阅读量843

点赞数

文章标签： mysql php database insert table 脚本

本文链接：https://blog.csdn.net/ga6840/article/details/6221907

版权

初学数据库，记录一些简单命令，用于备忘.

命令行下创建 database:

C:/Program Files/MySQL/MySQL Server 5.5/bin>mysql.exe -uroot -pg131517 //进入时省略了host参数,默认是'localhost'。 mysql> create database twbook; mysql> create database twbook2; mysql> show databases; mysql> drop database twbook2;//删除 mysql> show databases; mysql> use twbook;

命令行下添加 table:

mysql> create table stu(id int unsigned primary key,name char(50)); mysql> show tables; //mysql> drop table stu;删除它 mysql> describe stu;

命令行下添加一些对象:

mysql> insert into stu values(33,'zhong'); mysql> insert into stu values(32,'tang ding hao');

命令行下 select的使用：

mysql> select id from stu; mysql> select name,id from stu; mysql> select * from stu; mysql> select * from stu where id = 33; mysql> select * from stu where name = 'zhong'; mysql> select * from stu where name = "zhong"; mysql> select * from twbook.stu where name = 'zhong'; mysql> select * from stu where name like("% hao"); //简单模糊查找一个叫什么 hao 的人 mysql> select * from twbook.stu order by id; //按元素排序 mysql> select * from twbook.stu order by id desc; mysql> select * from twbook.stu order by (-id); //指定按照descending排序 //二者等价 mysql> select avg(id) from stu; //利用avg()命令函数求stu的id 的平均数

命令行下删除对象：

mysql> delete from stu where id = 33;

命令行下删除table：

mysql> drop table stu;

php脚本开始使用:

//以下是php里面: @ $aaa = new mysqli('localhost','root','g131517','twbook'); if(mysqli_connect_errno()) { echo " NO!!! "; exit; }

php脚本插入数据:

$num = 12; $urname = $_POST['urname']; $qqqq = "insert into stu values(".$num.",'".$urname."')"; //echo $qqqq; $result = $aaa->query($qqqq); if($result) { echo "aaaaaaa"; }

(注意上例固定 $num = 12;而stu的第一个属性id是primary key .所以只能插入一次)

php脚本读入数据:

$query = "select * from stu"; $result = $aaa->query($query); $num = $result->num_rows; echo "有 $num 个:"; for($i = 0 ; $i< $num ; $i++) { $row = $result->fetch_assoc(); echo " "; echo $i ; echo ' : '; echo $row['name'] ; echo ""; } $result->free();

顺便由于我的php文件用记事本 gb2312中文编码写，所以经常要添加：