summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTheSiahxyz <164138827+TheSiahxyz@users.noreply.github.com>2024-12-17 00:53:05 +0900
committerTheSiahxyz <164138827+TheSiahxyz@users.noreply.github.com>2024-12-17 00:53:05 +0900
commita495e2447f5c2cb79cd329437f523232f4bb6827 (patch)
treefb3685edb310b8f740e8dc6d5b00edf3bc373f8b
parent535b9982bdc51dea0d060533390311f6af49162d (diff)
modified MySQL.md
-rw-r--r--SI/Resource/Data Science/SQL/MySQL/MySQL.md5
1 files changed, 3 insertions, 2 deletions
diff --git a/SI/Resource/Data Science/SQL/MySQL/MySQL.md b/SI/Resource/Data Science/SQL/MySQL/MySQL.md
index 9a43806..59a56a1 100644
--- a/SI/Resource/Data Science/SQL/MySQL/MySQL.md
+++ b/SI/Resource/Data Science/SQL/MySQL/MySQL.md
@@ -1,8 +1,9 @@
---
-id: 2023-12-19
+id: "2023-12-19"
aliases:
- December 19
- "2023"
+ - MySQL
tags:
- link-note
- MySQL
@@ -47,7 +48,7 @@ DESC table_name;
```sql
CREATE TABLE table_name (
-- attributes variables (KEY types) (options)
- id INT PRIMARY KEY AUTO_INCREMENT,
+ id INT PRIMARY KEY AUTO_INCREMENT, -- (Optional) default
name VARCHAR(46) NOT NULL,
major VARCHAR(10) DEFAULT value,
column_name VARCHAR(10) UNIQUE,