TABLES

 CREATE DATABASE clg;

USE clg;

CREATE TABLE student(id INT PRIMARY KEY,name VARCHAR(50),age INT NOT NULL);

INSERT INTO student VALUES(1,"abhi",21);

INSERT INTO student VALUES(2,"ashwith",21);

INSERT INTO student VALUES(3,"bharath",20);

INSERT INTO student VALUES(4,"vinay",21);

SELECT * FROM student;

CREATE DATABASE IF NOT EXISTS clg;

CREATE DATABASE ngo;

DROP DATABASE IF EXISTS ngo;

SHOW DATABASES;

SHOW TABLES;

DROP TABLE student;

CREATE TABLE sm(name VARCHAR(500) PRIMARY KEY,nick VARCHAR(500));

INSERT INTO sm( name,nick)

VALUES('ab','kothi'),('bh','deyyam');

SELECT * FROM sm;

SHOW TABLES;