-
At MySql commandline :
use <databse>; --- Changes the database.
Show databases; --- Shows the databases created.
SELECT * FROM `users` LIMIT 0 , 30; --- displays 30 records from users table.
CREATE DATABASE `test` ; - Crates a database named test.
CREATE TABLE `Personal_details` (`Name` VARCHAR( 15 ) NOT NULL ,`P_NO` VARCHAR( 7 ) NOT NULL ,`City` VARCHAR( 10 ) NOT NULL ,`DOJ` DATE NOT NULL ,PRIMARY KEY ( `P_NO` ) ) COMMENT = 'Personal details of Employees';
- Creates a table named Personal details with Name, P_No, City and DOJ as fields.
-
in thailand have a lot manual about php+mysql
i begin with dbase ->clipper -> fox
msaccess (mdb) -> mssql and mysql
mysql is free
mssql is no free
in thailand have a lot manual about php+mysql
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
Bookmarks