What is an SQL Database?
An SQL database is a relational database that uses Structured Query Language (SQL) to store, manage, and retrieve data. Common SQL databases include:
-
MySQL
-
PostgreSQL
-
SQLite
-
Microsoft SQL Server
-
Oracle Database
๐น Common SQL Commands
๐ ️ Create Table
CREATE TABLE users (
id INT PRIMARY KEY,
name VARCHAR(100),
email VARCHAR(100) UNIQUE
);
๐ฅ Insert Data
INSERT INTO users (id, name, email)
VALUES (1, 'Alice', 'alice@example.com');
๐ Select Data
SELECT * FROM users;
No comments:
Post a Comment