Wednesday, February 27, 2008

Mysql

today we learn about database using mysql...start the server using mysql..then we learned how to make a database by command prompt...to create a database in the c/prompt type (mysqladmin -u root create suki) suki is the database name...to view all the databases..just type (mysqlshow -u root) then enter...to use that database...type (use suki)...then we have to create a table named student...( create table student(id int(4), name char(20));).. to view that table just type (show tables;)

No comments: