① 怎麼用php在mysql創建一表，並且要id欄位為自增長的，
$servername="localhost";
$username="username";
$password="password";
$dbname="myDB";
//創建連接
$conn=newmysqli($servername,$username,$password,$dbname);
//檢測連接
if($conn->connect_error){
die("Connectionfailed:".$conn->connect_error);
}
//sqltocreatetable
$sql="CREATETABLEMyGuests(
idINT(6)UNSIGNEDAUTO_INCREMENTPRIMARYKEY,
firstnameVARCHAR(30)NOTNULL,
lastnameVARCHAR(30)NOTNULL,
emailVARCHAR(50),
reg_dateTIMESTAMP
)";
if($conn->query($sql)===TRUE){
echo"";
}else{
echo"Errorcreatingtable:".$conn->error;
}
$conn->close();