mysql操作数据库

MYSQL主键自增用法

<?php
header('content-type:text/html;charset=utf-8');
$mysqli=new mysqli('localhost','root','root','stu');
$i=1;
// while ($i <= 100) {
//   $sql="insert into user(uname,uage) values ('hdw{$i}',$i)";
//   $mysqli->query($sql);
// $i++;
// }
$sql='select * from user';
$result=$mysqli->query($sql);
while ($row=$result->fetch_assoc()) {
  echo "学员名:".$row['uname']."\t年龄：".$row['uage']."<br/>";
}
 ?>

create table user(
     id integer primary key,
     firstname varchar(200) not null,
     lastname varchar(200) not null,
     age integer
 );
 alter table user modify id integer auto_increment ;
 alter table user modify id integer default '1';
 alter table user add createtime timestamp default current_timestamp;

 create table dd(
     id int primary key not null auto_increment,
     name varchar(20),
     time timestamp default current_timestamp
 );