Mysql
光图强
这个作者很懒,什么都没留下…
展开
-
php笔记本-看笔记难道不香吗
<?php // 假定数据库用户名:root,密码:123456,数据库:RUNOOB $con=mysqli_connect("localhost","root","123456","RUNOOB"); if (mysqli_connect_errno($con)) { echo "连接 MySQL 失败: " . mysqli_connect_error(); } $sql="SELECT id,name,pwd FROM user ORDER BY id";if ($res原创 2020-12-17 11:29:38 · 165 阅读 · 0 评论 -
Mysql如何设置id自增
Mysql如何设置id自增(1)设置自增方案一:CREATE TABLE IF NOT EXISTS `user`( `id` INT UNSIGNED AUTO_INCREMENT, `name` VARCHAR(100) NOT NULL, `sex` VARCHAR(40) NOT NULL, `age` INT(11), PRIMARY KEY ( `id` ))ENGINE=InnoDB DEFAULT CHARSET=utf8;方案二:alte原创 2020-11-06 17:17:44 · 41048 阅读 · 0 评论