Ipctrd (A Computer Learning Blogs)

MySQL Queries:- A list of commonly used MySQL queries to create database, use database, create table, insert record, update record, delete record, select record, truncate table and drop table are given below. 1) MySQL Create Database MySQL create database is used to create database. For example create database db1;  2) MySQL Select/Use Database MySQL use database is used to select database. For example use db1;  Ipctrd Inc. 3) MySQL Create Query MySQL create query is used to create a table, view, procedure and function. For example: CREATE TABLE customers    (id int(10),     name varchar(50),     city varchar(50),   PRIMARY KEY (id )    );    4) MySQL Alter Query MySQL alter query is used to add, modify, delete or drop colums of a table. Let's see a query to add column in customers table: ALTER TABLE customers  ADD age varchar(50);    5) MySQL Insert Query MySQL ins...