#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2004
    Posts
    14
    Rep Power
    0

    Question Explain SQL Basic Statement


    Hi all,
    I don't know SQL Statement, so explain me.

    Thank!

    kyawmh@mail2world.com
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2004
    Posts
    14
    Rep Power
    0
    Rapid
  4. #3
  5. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Dec 2003
    Posts
    249
    Rep Power
    14
    http://www.w3schools.com/sql/default.asp


    With regards,

    Martijn Tonies
    Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server.
    Upscene Productions
    http://www.upscene.com
    Martijn Tonies
    Database Workbench: developer IDE for Firebird, MySQL, InterBase, MSSQL Server and Oracle
    Upscene Productions
    http://www.upscene.com
  6. #4
  7. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2004
    Location
    Cape Town, South Africa
    Posts
    51
    Rep Power
    10

    Thumbs up


    Hi tambaro

    You better go any get a book on SQL because the syntax differs slightly for every Database Type and is to much to try and explain in a forum.

    But here is a list of the different basic SQL statements that you get.

    1. Select Statement
    2. Update Statement
    3. Insert Statement
    4. Delete Statement

    There is more to SQL than just these 4 statements, but these are the basic SQL statement types that you need to know.
    When working with proper SQL databases like Firebird, M$ SQL Server and Oracle you will propably need to know some DDL (Data Definition Language) Statements aswell. These SQL like statements are used to create and drop tables, view and fields....but their syntax also differ from database to database.
  8. #5
  9. Bug Hunter
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2003
    Location
    Transylvania (Romania)
    Posts
    309
    Rep Power
    23

    Wink


    Originally Posted by tambaro
    Rapid
    there is "sql in 21 days" very fast
    My home page: http://www.firebirdsql.org and work place :http://www.reea.net

IMN logo majestic logo threadwatch logo seochat tools logo