Which manipulations can be done on Mysql database?

Discussion in 'MySQL' started by computerzworld, May 24, 2007.

  1. #1
    Hi. I want the all manipulations that can be done on mysql database by using query.Which manipulations can be done on mysql database? Please tell me. Thanks in advance.
     
    computerzworld, May 24, 2007 IP
  2. HuggyCT2

    HuggyCT2 Guest

    Messages:
    222
    Likes Received:
    2
    Best Answers:
    0
    Trophy Points:
    0
    #2
    There are too many to list but the basics are these.

    
    INSERT INTO - For adding a new entry
    UPDATE `table` SET var = '$var' - For updating a entry
    DELETE FROM `table` - For delete
    SELECT `colum` FROM `table` - Selecting data (* Wild Card)
    WHERE `var` = '$var' - This is something used within other querys for individuals
    
    HTML:
    They are the basics and you could make most normal scripts with just using that. I would post a link to some, but I cant yet :p
     
    HuggyCT2, May 24, 2007 IP
  3. gibex

    gibex Active Member

    Messages:
    1,060
    Likes Received:
    21
    Best Answers:
    0
    Trophy Points:
    95
    #3
    gibex, May 24, 2007 IP