php

2022.04.26 14:03

Create Table

$sql = "CREATE TABLE MyGuests (

id INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,

firstname VARCHAR(30) NOT NULL,

lastname VARCHAR(30) NOT NULL,

email VARCHAR(50),

reg_date TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

)";


//(1)

$mysqli->query($sql);

//$result = $mysqli->query($sql);


//(2)

//mysqli_query($mysqli, $sql);

//$result = mysqli_query($mysqli, $sql);


  • 공유링크 복사
  • 이전글INSERT INTO2022.04.26
  • 다음글Create database2022.04.26
  • 댓글목록

    등록된 댓글이 없습니다.