Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 

  • Inserting data using replace statement

    @suresh.ramola
    Recommendations Offline Message

    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 0
    • 471
    Comment on it

    REPLACE INTO Statement:

    It is used to insert a row in a table.It is similar to INSERT INTO statement but it does not allow duplicate row as it replaces the old one with the new one.

    Syntax: 

    1. REPLACE INTO tablename (column1, column2, column3) VALUES( value1, value2, value3);

    Example:

    1. REPLACE INTO Employee (name, city) VALUES ( 'Amit', 'Dehradun');

    This query will insert Amit in name column and dehradun in city column but if the same name and city are already present in the employee table than it will replace the old one with the new one.

    mysql sql
    Comment on it

 0 Comment(s)

Sign In
Forgot Password?
                           OR                           
Create an account !!
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Reset Password
Fill out the form below and reset your password: