Creating Tables in MySQL
CREATE TABLE
CREATE TABLE users (
id INT AUTO_INCREMENT PRIMARY KEY,
username VARCHAR(50) NOT NULL UNIQUE,
email VARCHAR(100) NOT NULL,
password VARCHAR(255) NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);
Common Data Types
| Type | Use |
|---|
| INT | Integers |
| VARCHAR(n) | Variable strings |
| TEXT | Long text |
| DECIMAL(p,s) | Precise decimals |
| DATE | YYYY-MM-DD |
| TIMESTAMP | Date + time |
| BOOLEAN | 0 or 1 |
ALTER TABLE
ALTER TABLE users ADD COLUMN age INT;
ALTER TABLE users DROP COLUMN age;
ALTER TABLE users MODIFY COLUMN email VARCHAR(150);