Page 2 of 2 FirstFirst 12
Results 11 to 12 of 12

Thread: What is MySQL?

  1. #11
    Join Date
    Sep 2006
    Location
    Kerala, India
    Posts
    17,476

    Default

    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.

  2. #12
    Join Date
    Jul 2007
    Posts
    9

    Default 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

Page 2 of 2 FirstFirst 12

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •