Posts

Showing posts with the label MySQL queries

Steps to start with Mysql:

 Steps to start with Mysql: 1.    Create Database 2.    Use database 3.    Create table. 4.    Insert data in table 5.    Update data in table 6.    Display data stored in table 7.    Delete data from table 8.    Delete table 9.    Delete database First create database : Create database database_name; Use database_name Example: Create database spp; Use spp Create table example :- . create table student (    student_id INT NOT NULL AUTO_INCREMENT ,    student_name VARCHAR ( 100 ) NOT NULL ,    student_Add VARCHAR ( 40 ) NOT NULL ,    date_of_birth DATE ,    PRIMARY KEY ( student_id ) ); Insert into student values(1,’smita’,’kothrud’,’2000-09-09’); Select * from student; update student set student_name=’Rima’ where student_id=1; delete * from student; DROP TABLE table_name ; ...