How to create Table and insert data into table in MYSQL

Create table Create table if not exists `tblTest` ( `id` int(10) not null auto_Increment, `Name` nvarchar(50), `Email` nvarchar(50), `Password` nvarchar(50) )ENGINE = MYISAM default charset =utf8 Auto_Increment = 1; Select Statement Select * from tblTest; Insert data into table insert into tblTest(Name, Email, Password) values('praveen','its@gmail.com','1234');

0 Comments