M\u1ed9t b\u1ea3ng c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL c\u00f3 t\u00ean duy nh\u1ea5t c\u1ee7a n\u00f3 v\u00e0 bao g\u1ed3m c\u00e1c c\u1ed9t v\u00e0 h\u00e0ng.<\/p>\n\n\n\n
C\u00e2u l\u1ec7nh\u00a0 Ch\u00fang ta s\u1ebd t\u1ea1o m\u1ed9t b\u1ea3ng c\u00f3 t\u00ean “MyGuests”, v\u1edbi n\u0103m c\u1ed9t: “id”, “firstname”,”lastname”, “email” v\u00e0 “rag_date”:<\/p>\n\n\n\n M\u1ed9t s\u1ed1 l\u01b0u \u00fd v\u1ec1 b\u1ea3ng tr\u00ean:<\/strong><\/p>\n\n\n\n Ki\u1ec3u d\u1eef li\u1ec7u ch\u1ec9 \u0111\u1ecbnh lo\u1ea1i d\u1eef li\u1ec7u c\u1ee7a c\u1ed9t c\u00f3 th\u1ec3 c\u00f3. \u0110\u1ec3 c\u00f3 m\u1ed9t th\u01b0 m\u1ee5c \u0111\u1ea7y \u0111\u1ee7 t\u1ea5t c\u00e1c c\u00e1c d\u1ea1ng d\u1eef li\u1ec7u c\u00f3 th\u1ec3 cung c\u1ea5p, h\u00e3y v\u00e0o khu v\u1ef1c Th\u01b0 M\u1ee5c Ki\u1ec3u D\u1eef Li\u1ec7u c\u1ee7a ch\u00fang t\u00f4i.<\/p>\n\n\n\n Sau ki\u1ec3u d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ec9 \u0111\u1ecbnh c\u00e1c thu\u1ed9c t\u00ednh tu\u1ef3 ch\u1ecdn kh\u00e1c cho m\u1ed7i c\u1ed9t:<\/p>\n\n\n\n M\u1ed7i b\u1ea3ng ph\u1ea3i c\u00f3 m\u1ed9t kho\u00e1 ch\u00ednh (primary key \u2013 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 c\u1ed9t “id”). Gi\u00e1 tr\u1ecb c\u1ee7a n\u00f3 ph\u1ea3i duy nh\u1ea5t cho m\u1ed7i b\u1ea3n ghi trong b\u1ea3ng.<\/p>\n\n\n\n C\u00e1c v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y hi\u1ec3n th\u1ecb c\u00e1ch t\u1ea1o b\u1ea3ng trong PHP:<\/p>\n\n\n\n V\u00ed d\u1ee5 (MySQLi H\u01b0\u1edbng \u0111\u1ed1i t\u01b0\u1ee3ng)<\/strong>:<\/p>\n\n\n\n V\u00ed d\u1ee5 (MySQLi Th\u1ee7 t\u1ee5c):<\/strong><\/p>\n\n\n\n V\u00ed d\u1ee5 (PDO):<\/strong><\/p>\n\n\n\n M\u1ed9t b\u1ea3ng c\u01a1 s\u1edf d\u1eef li\u1ec7u MySQL c\u00f3 t\u00ean duy nh\u1ea5t c\u1ee7a n\u00f3 v\u00e0 bao g\u1ed3m c\u00e1c c\u1ed9t v\u00e0 h\u00e0ng. T\u1ea1o m\u1ed9t b\u1ea3ng MySQL s\u1eed d\u1ee5ng MySQLi v\u00e0 PDO C\u00e2u l\u1ec7nh\u00a0CREATE TABLE\u00a0\u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u1ea1o b\u1ea3ng trong MySQL. Ch\u00fang ta s\u1ebd t\u1ea1o m\u1ed9t b\u1ea3ng c\u00f3 t\u00ean “MyGuests”, v\u1edbi n\u0103m c\u1ed9t: “id”, “firstname”,”lastname”, “email” v\u00e0 “rag_date”: …<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[238],"tags":[],"yoast_head":"\nCREATE TABLE<\/code><\/strong>\u00a0\u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u1ea1o b\u1ea3ng trong MySQL.<\/p>\n\n\n\nCREATE TABLE MyGuests (\nid INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,\nfirstname VARCHAR(30) NOT NULL,\nlastname VARCHAR(30) NOT NULL,\nemail VARCHAR(50),\nreg_date TIMESTAMP\n)<\/code><\/pre>\n\n\n\nNOT NULL<\/code> \u2013 M\u1ed7i h\u00e0ng ph\u1ea3i bao g\u1ed3m m\u1ed9t gi\u00e1 tr\u1ecb cho c\u1ed9t \u0111\u00f3, gi\u00e1 tr\u1ecb null kh\u00f4ng \u0111\u01b0\u1ee3c ph\u00e9p;<\/li>DEFAULT<\/code> \u00a0\u2013 Thi\u1ebft l\u1eadp gi\u00e1 tr\u1ecb m\u1eb7c \u0111\u1ecbnh \u0111\u01b0\u1ee3c th\u00eam v\u00e0o khi kh\u00f4ng gi\u00e1 tr\u1ecb n\u00e0o kh\u00e1c \u0111\u01b0\u1ee3c th\u00f4ng qua;<\/li>UNSIGNED<\/code> \u2013 S\u1eed d\u1ee5ng cho ki\u1ec3u s\u1ed1, gi\u1edbi h\u1ea1n l\u01b0u tr\u1eef d\u1eef li\u1ec7u cho ki\u1ec3u s\u1ed1 d\u01b0\u01a1ng v\u00e0 zero;<\/li>AUTO INCREMENT<\/code> \u2013 MySQL t\u1ef1 \u0111\u1ed9ng t\u0103ng gi\u00e1 tr\u1ecb l\u00ean m\u1ed9t m\u1ed7i khi c\u00f3 b\u1ea3n ghi m\u1edbi \u0111\u01b0\u1ee3c th\u00eam v\u00e0o;<\/li>PRIMARY KEY<\/code> \u2013 S\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ea1o \u0111\u1ecbnh danh duy nh\u1ea5t c\u1ee7a c\u00e1c h\u00e0ng trong m\u1ed9t b\u1ea3ng. C\u1ed9t v\u1edbi PRIMARY KEY<\/code> \u0111\u01b0\u1ee3c thi\u1ebft l\u1eadp th\u01b0\u1eddng v\u1edbi m\u1ed9t s\u1ed1 ID<\/code> v\u00e0 th\u01b0\u1eddng s\u1eed d\u1ee5ng AUTO_INCREMENT<\/code>;<\/li><\/ul>\n\n\n\n<?php\n$servername = \"localhost\";\n$username = \"username\";\n$password = \"password\";\n$dbname = \"myDB\";\n\n\/\/ Ket noi csdl\n$conn = new mysqli($servername, $username, $password, $dbname);\n\n\/\/ Kiem tra ket noi\nif ($conn->connect_error) {\ndie(\"Ket noi bi loi: \" . $conn->connect_error);\n}\n\n\/\/ sql de tao bang\n$sql = \"CREATE TABLE MyGuests (\nid INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,\nfirstname VARCHAR(30) NOT NULL,\nlastname VARCHAR(30) NOT NULL,\nemail VARCHAR(50),\nreg_date TIMESTAMP\n)\";\n\nif ($conn->query($sql) === TRUE) {\necho \"Bang MyGuests da tao thanh cong\";\n} else {\necho \"Gap loi khi tao bang: \" . $conn->error;\n}\n\n$conn->close();\n?><\/code><\/pre>\n\n\n\n
\n\n\n\n<?php\n$servername = \"localhost\";\n$username = \"username\";\n$password = \"password\";\n$dbname = \"myDB\";\n\n\/\/ Ket noi csdl\n$conn = mysqli_connect($servername, $username, $password, $dbname);\n\n\/\/ Kiem tra ket noi\nif (!$conn) {\ndie(\"Loi ket noi: \" . mysqli_connect_error());\n}\n\n\/\/ Tao bang SQL\n$sql = \"CREATE TABLE MyGuests (\nid INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,\nfirstname VARCHAR(30) NOT NULL,\nlastname VARCHAR(30) NOT NULL,\nemail VARCHAR(50),\nreg_date TIMESTAMP\n)\";\n\nif (mysqli_query($conn, $sql)) {\necho \"Bang da tao thanh cong\";\n} else {\necho \"Loi khi tao bang: \" . mysqli_error($conn);\n}\n\nmysqli_close($conn);\n?><\/code><\/pre>\n\n\n\n
\n\n\n\n<?php\n$servername = \"localhost\";\n$username = \"username\";\n$password = \"password\";\n$dbname = \"myDBPDO\";\n\ntry {\n$conn = new PDO(\"mysql:host=$servername;dbname=$dbname\", $username, $password);\n\n\/\/ \u0111\u1eb7t ch\u1ebf \u0111\u1ed9 l\u1ed7i PDO th\u00e0nh ngo\u1ea1i l\u1ec7\n$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);\n\n\/\/ T\u1ea1o b\u1ea3ng SQL\n$sql = \"CREATE TABLE MyGuests (\nid INT(6) UNSIGNED AUTO_INCREMENT PRIMARY KEY,\nfirstname VARCHAR(30) NOT NULL,\nlastname VARCHAR(30) NOT NULL,\nemail VARCHAR(50),\nreg_date TIMESTAMP\n)\";\n\n\/\/ su dung exec() vi khong co ket qua tra ve\n$conn->exec($sql);\necho \"Tao bang MyGuests thanh cong\";\n}\ncatch(PDOException $e)\n{\necho $sql . \u201c<br>\u201d . $e->getMessage();\n}\n\n$conn = null;\n?><\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"