Distinctive Analytics

SQL CRUD basics are the fundamental procedures that you must know in order to deal with databases. CRUD is a term that refers to commands in SQL Create, Read, Update, and Delete.

CREATE

To create a new table in a database, you can use the CREATE TABLE statement. You need to specify the name of the table, the columns and their data types, and any constraints or indexes that you want to apply. For example, this code creates a table called customers with four columns: id, name, email, and phone.

CREATE TABLE customers (
  id INT PRIMARY KEY,
  name VARCHAR(50) NOT NULL,
  email VARCHAR(50) UNIQUE,
  phone VARCHAR(15)
);

MySQL returned an empty result set (i.e. zero rows). (Query took 0.0502 seconds.)

Run Tutorial

Pages: 1 2 3 4 5