How to use tables in mysql

MySQL table is a structure for storing data. Use the CREATE TABLE command to create a table, the INSERT INTO command to insert data, the SELECT command to query data, the UPDATE command to update data, and the DELETE command to delete data.

How to use MySQL tables

MySQL tables are structures used to store and manage data. They are an essential building block in any MySQL database and can be used to organize and store various types of information.

Create table

To create a table, use the following syntax:

<code class="sql">CREATE TABLE table_name (
  column1_name data_type,
  column2_name data_type,
  ...
);</code>

For example, to create a table named "customer", जिसमें "id", "name" and "address" columns, please run the following query:

<code class="sql">CREATE TABLE customer (
  id INT NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  address TEXT NOT NULL
);</code>

Insert data

To insert data into the table, use the following syntax :

<code class="sql">INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);</code>

For example, to insert a record into the "customer" table, run the following query:

<code class="sql">INSERT INTO customer (name, address) VALUES ('John Doe', '123 Main Street');</code>

Query data

To query the table For data in the table, use the following syntax:

<code class="sql">SELECT column1, column2, ... FROM table_name WHERE condition;</code>

For example, to get all records from the "customer" table, run the following query:

<code class="sql">SELECT * FROM customer;</code>

Or to get only those for a specific "id" records, please run the following query:

<code class="sql">SELECT * FROM customer WHERE id = 1;</code>

Update Data

To update the data in the table, use the following syntax:

<code class="sql">UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;</code>

For example, to To update the "name" of the record with "id" 1 in the "customer" table, run the following query:

<code class="sql">UPDATE customer SET name = 'Jane Doe' WHERE id = 1;</code>

Delete data

To delete data from the table , please use the following syntax:

<code class="sql">DELETE FROM table_name WHERE condition;</code>

For example, to delete all records from the "customer" table, run the following query:

<code class="sql">DELETE FROM customer;</code>

Or to delete only the records with "id" 1, Please run the following query:

<code class="sql">DELETE FROM customer WHERE id = 1;</code>

The above is the detailed content of How to use tables in mysql. For more information, please follow other related articles on the PHP Chinese website!