 |
 |
Bloglar | MySQL(i), PDO bo'yicha | MYSQLda ustun yaratish
MYSQL ma'lumotlar bazasida ustun yaratish haqida kichik qo'llanma.
"show" nomi bilan yaratiladi. Jadvalga, "id" va "name" nomli ustunlar qo'shiladi.
#000000">
/> <?
#0000BB"><?
/>
CREATE TABLE `#007700">` style="color: #DD0000">show style="color: #007700">` (
/>
`id#DD0000">id style="color: #007700">` style="color: #0000BB">int style="color: #007700">( style="color: #0000BB">12 style="color: #007700">) style="color: #0000BB">unsigned NOT NULL AUTO_INCREMENT style="color: #007700">,
/>
`name#DD0000">name style="color: #007700">` style="color: #0000BB">varchar style="color: #007700">( style="color: #0000BB">100 style="color: #007700">) DEFAULT style="color: #0000BB">NULL style="color: #007700">,
/>
PRIMARY KEY #0000BB">PRIMARY KEY style="color: #007700">(` style="color: #DD0000">id style="color: #007700">`)
/>
) ENGINE#0000BB">ENGINE style="color: #007700">= style="color: #0000BB">MyISAM AUTO_INCREMENT style="color: #007700">= style="color: #0000BB">1 style="color: #007700">DEFAULT style="color: #0000BB">CHARSET style="color: #007700">= style="color: #0000BB">utf8 style="color: #007700">;
/>
?>
#0000BB">?>
/>
Buyruqlar va ularning tavsifi:
Create table `show` - `show` nomli jadval yarat.
`id` int(12) unsigned NOT NULL AUTO_INCREMENT - `id` nomli 12 birlikdagi va umuman NULL qiymatiga ega bo'lmagan, 0 ga teng yoki 0 dan yuqori bo'lgan ma'lumotlar saqlash va shuningdek avtoraqamlash huquqiga ega ustun qo'sh.
`name` varchar(100) DEFAULT NULL - `name` nomli 100 birlikka ega va asosi NULL ya'ni qiymat qo'shilmagan vaqtda NULL holatida saqlash mumkin bo'lgan ustin qo'sh.
ENGINE=MyISAM - bu borada aloxida blog yozaman, nasib etsa!
AUTO_INCREMENT=1 - id ustunidagi tartib raqami nechidan boshlanishi haqida
DEFAULT CHARSET=utf8 - saqlash turi.
"show" nomi bilan yaratiladi. Jadvalga, "id" va "name" nomli ustunlar qo'shiladi.
#000000">
/> <?
#0000BB"><?
/>
CREATE TABLE `#007700">` style="color: #DD0000">show style="color: #007700">` (
/>
`id#DD0000">id style="color: #007700">` style="color: #0000BB">int style="color: #007700">( style="color: #0000BB">12 style="color: #007700">) style="color: #0000BB">unsigned NOT NULL AUTO_INCREMENT style="color: #007700">,
/>
`name#DD0000">name style="color: #007700">` style="color: #0000BB">varchar style="color: #007700">( style="color: #0000BB">100 style="color: #007700">) DEFAULT style="color: #0000BB">NULL style="color: #007700">,
/>
PRIMARY KEY #0000BB">PRIMARY KEY style="color: #007700">(` style="color: #DD0000">id style="color: #007700">`)
/>
) ENGINE#0000BB">ENGINE style="color: #007700">= style="color: #0000BB">MyISAM AUTO_INCREMENT style="color: #007700">= style="color: #0000BB">1 style="color: #007700">DEFAULT style="color: #0000BB">CHARSET style="color: #007700">= style="color: #0000BB">utf8 style="color: #007700">;
/>
?>
#0000BB">?>
/>
Buyruqlar va ularning tavsifi:
Create table `show` - `show` nomli jadval yarat.
`id` int(12) unsigned NOT NULL AUTO_INCREMENT - `id` nomli 12 birlikdagi va umuman NULL qiymatiga ega bo'lmagan, 0 ga teng yoki 0 dan yuqori bo'lgan ma'lumotlar saqlash va shuningdek avtoraqamlash huquqiga ega ustun qo'sh.
`name` varchar(100) DEFAULT NULL - `name` nomli 100 birlikka ega va asosi NULL ya'ni qiymat qo'shilmagan vaqtda NULL holatida saqlash mumkin bo'lgan ustin qo'sh.
ENGINE=MyISAM - bu borada aloxida blog yozaman, nasib etsa!
AUTO_INCREMENT=1 - id ustunidagi tartib raqami nechidan boshlanishi haqida
DEFAULT CHARSET=utf8 - saqlash turi.
Ma'lumotlar
Yaratilgan vaqt: 24 Jul 2018, 13:16
Muallif: @BahhTeeUz (4)
Raxmat aytishgan: 6 kishi
Fikrlar: 4 ta
Ko'rilgan: 63 marta
Shikoyatim bor
Muallif: @BahhTeeUz (4)
Raxmat aytishgan: 6 kishi
Fikrlar: 4 ta
Ko'rilgan: 63 marta
Shikoyatim bor
Blog bilan bo'lishish
Onlayn 217 (0/217)
Forumga a'zo bo'lish
Forumdan qidirish
Bosh sahifa