?? create_wedding_database.sql
字號:
-- Delete any existing wedding databaseDROP DATABASE IF EXISTS wedding;CREATE DATABASE wedding;USE wedding;-- Define the gifts tableCREATE TABLE `gifts` ( `gift_id` SMALLINT NOT NULL AUTO_INCREMENT, `description` VARCHAR(255) NOT NULL, `shop` VARCHAR(100) NOT NULL, `quantity` SMALLINT NOT NULL, `color` VARCHAR(30) DEFAULT NULL, `price` VARCHAR(30) DEFAULT NULL, `username` VARCHAR(30) DEFAULT NULL, PRIMARY KEY (`gift_id`));-- Define the users tableCREATE TABLE `users` ( `username` VARCHAR(30) NOT NULL, `password` VARCHAR(30) NOT NULL, PRIMARY KEY (`username`));
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -