Zaenal Arifin

Posted on Sep 23, 2023

MySQL Database Management

#mysql #programming #beginners #tutorial

Creating a Database

To create a new database in MySQL, you can use the following SQL command:

CREATE DATABASE your_database_name;

After creating a database, you can use it by executing the following SQL command:

USE your_database_name;

To create a table in a MySQL database, you can use the following SQL syntax:

CREATE TABLE table_name (
      column1 datatype1 constraints,
      column2 datatype2 constraints,
      ...
    );

CREATE TABLE users (
      id INT AUTO_INCREMENT PRIMARY KEY,
      name VARCHAR(50),
      email VARCHAR(100)
    );

To insert data into a table, you can use the following SQL syntax:

INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, ...);

INSERT INTO users (name, email) VALUES ('John Doe', 'john@example.com');

To update data in a table, you can use the following SQL syntax:

UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition;

UPDATE users SET email = 'newemail@example.com' WHERE id = 1;

To delete data from a table, you can use the following SQL syntax:

DELETE FROM table_name WHERE condition;

DELETE FROM users WHERE id = 1;

To drop (delete) a table from the database, you can use the following SQL syntax:

DROP TABLE table_name;

DROP TABLE users;