· 6 years ago · Jun 17, 2019, 08:06 PM
1mysql -u root -p
2SHOW DATABASES;
3USE java29;
4CREATE TABLE IF NOT EXISTS weekdays(
5dayNumber INT UNSIGNED NOT NULL DEFAULT 0,
6dayName varchar(9) NOT NULL DEFAULT '',
7PRIMARY KEY (dayNumber)
8);
9INSERT INTO weekdays VALUES (1, 'Sunday'),
10(2, 'Monday'),
11(3, 'Tuesday'),
12(4, 'Wednesday'),
13(5, 'Thursday'),
14(6, 'Friday'),
15(7, 'Saturday');
16SELECT * FROM weekdays;