MySQL jadval yaratish
Jadval yaratish
MySQL da jadval yaratish uchun “CREATE TABLE” iborasidan foydalaning.
Ulanishni yaratishda ma’lumotlar bazasi nomini aniqlaganingizga ishonch hosil qiling:
Misol
"Mijozlar" nomli jadval yarating:
let mysql = require('mysql');
let con = mysql.createConnection({
host: "localhost",
user: "yourusername",
password: "yourpassword",
database: "mydb"
});
con.connect(function(err) {
if (err) throw err;
console.log("Connected!");
let sql = "CREATE TABLE customers (name VARCHAR(255),
address VARCHAR(255))";
con.query(sql, function (err, result) {
if (err)
throw err;
console.log("Table created");
});
});
Misolni ishga tushirish »
Yuqoridagi kodni "demo_create_table.js" deb nomlangan faylga saqlang va faylni ishga tushiring:
"demo_create_table.js" ni ishga tushiring
C:\Users\Your Name>node demo_create_table.js
Bu sizga bu natijani beradi:
Connected!
Table created
Asosiy kalit
Jadvalni yaratishda siz har biri uchun noyob kalitga ega ustunni ham yaratishingiz kerak rekord.
Buni ustunni "INT AUTO_INCREMENT PRIMARY KEY" sifatida belgilash orqali amalga oshirish mumkin har bir yozuv uchun noyob raqam. 1 dan boshlanadi va har biri uchun bittaga oshiriladi rekord.
Misol
Jadval yaratishda asosiy kalit yarating:
let mysql = require('mysql');
let con = mysql.createConnection({
host: "localhost",
user: "yourusername",
password: "yourpassword",
database: "mydb"
});
con.connect(function(err) {
if (err) throw err;
console.log("Connected!");
let sql = "CREATE TABLE customers (id INT AUTO_INCREMENT PRIMARY
KEY, name VARCHAR(255),
address VARCHAR(255))";
con.query(sql, function (err, result) {
if (err)
throw err;
console.log("Table created");
});
});
Misolni ishga tushirish »
Agar jadval allaqachon mavjud bo‘lsa, ALTER TABLE kalit so‘zidan foydalaning:
Misol
Mavjud jadvalda asosiy kalit yarating:
let mysql = require('mysql');
let con = mysql.createConnection({
host: "localhost",
user: "yourusername",
password: "yourpassword",
database: "mydb"
});
con.connect(function(err) {
if (err) throw err;
console.log("Connected!");
let sql = "ALTER TABLE customers ADD COLUMN id INT AUTO_INCREMENT
PRIMARY KEY";
con.query(sql, function (err, result) {
if (err)
throw err;
console.log("Table altered");
});
});
Misolni ishga tushirish »
W3Schools Pathfinder
Yutuqlaringizni kuzating – bu bepul!