create table if not exists tb( t_id int unsigned auto_increment, t_title varchar(100) not null, t_author varchar(40) not null, t_date date, primary key (t_id) )engine=innoDB default charset=utf8;
php在studb下创建数据表teach
$dbuser='root';//mysql用户名字$dbpass='';//mysql密码$conn=mysqli_connect($dbhost,$dbuser,$dbpass);if(!$conn){
die('数据库连接失败'.mysqli_error($conn));}echo'数据库连接成功<br \>';$sql="create table if not exists teach("."te_id int not null auto_increment,"."te_title varchar(100) not null,"."te_author varchar(40) not null,"."te_date date,"."primary key(te_id)".")engine=innoDB default charset=utf8;";//选择数据库表studbmysqli_select_db($conn,"studb");$retval=mysqli_query($conn,$sql);if(!$retval){
die('数据表创建失败'.mysqli_error($conn));}echo'数据teach表创建成功';mysqli_close($conn);?>