SQL SYNTAX
All SQL SYNTAX OF DATABASES 1. HOW TO CREAE DATABASE? SYNTAX- create database database_name; Example: mysql> CREATE DATABASE TOTALSACH; 2. HOW TO SHOW DATABASE LIST? SYNTAX: show databases; Example: mysql> SHOW DATABASES; 3. HOW TO USE DATABASE? SYNTAX- use database_name; Example: mysql> USE TOTALSACH; 4. HOW TO CREAE TABLE IN A DATABASE? SYNTAX- create table table_name (column1 datatype(), column2 datatype(), colunm3 datatype(), column4 datatype()); Example: mysql> CREATE TABLE STUDENTS (SRNO INT, NAME VARCHAR(20), CONTACT INT, SALARY VARCHAR(10)); 4. HOW TO RENAME TABLE IN A DATABASE? SYNTAX- alter table old_table_name rename to new_table_name; Example: mysql> alter table studentsss rename to student; 5. HOW TO INSERT VALUES IN TABLE? SYNTAX- insert into table_name values(values1, "value2", value3, "value4"); Example: m...