MySql Basic Quries

CRUD Operations: show version of mysql Database select version() show current date and time selectcurrent_date,show now() show user select user() Crate DataBase: create database Test; Make your DataBase as Default: use Test; Crate Table: create table test(id bigint(10) default null auto_increment,name varchar(20) default null,primary key(id)); Insert a record: insert into test(name) values('Shashank'); Update a record: … Continue reading MySql Basic Quries

Advertisements