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;)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment