Skip to main content

MYSQL INSERT OR UPDATE in Single SQL Statement

You might want to update or insert Database single statement rather than checking the record is inserted or and again go to the update.

But using following SQL statement you can run First run and check Insert statement and if that fails Update statement after that.


Assume my table structure as follows

Create the sample table as below


CREATE TABLE IF NOT EXISTS `tbl_test` (

 cat_id int AUTO_INCREMENT,
 name varchar(50),
 primary key(cat_id)

)

add some records to tbl_test


INSERT INTO tbl_test (name) VALUES ('cat 111'),('cat 2'),('cat 3');


and finally you can update the record or insert by following


INSERT INTO tbl_test (cat_id,name) VALUES (1,' cat 1 ')
ON DUPLICATE KEY UPDATE name=' cat 1 '

That's IT.

Cheers

Comments

Post a Comment

Popular posts from this blog

Application Configuration FIle Visual Studio 2005

Through the application configaration file You can easily save values to later usage. you can create a application configuration file from project > Add New Item (Ctrl + Shift + A) example You want to add get string from config file Create a Config file using above step. after that insert following code to the config file. its a XML file. appsettings add key="DatabasePath" value="c:\\projects\data\spider.mdb" add key="SupportEmail" value="webmaster-1@dotnetspider.com" appsettings configuration in the coding add following Dim app As New System.Configuration.AppSettingsReader Dim s As String s = app.GetValue("DatabasePath", Type.GetType("System.String")) MessageBox.Show(s) its very easy when you are handling databases. you can store database connection string in that config for later reusabilty. Please post your comments
Post a Comment
Read more

Expire Session When the Browser Close [Codeigniter]

I wanted user to log again to the site whenever they close the browser. i searched everywhere and i found the easiest way. application/config/config.php sess_expire_on_close = TRUE Easy Session Preferences You'll find the following Session related preferences in your file: Preference Default Options Description sess_cookie_name ci_session None The name you want the session cookie saved as. sess_expiration 7200 None The number of seconds you would like the session to last. The default value is 2 hours (7200 seconds). If you would like a non-expiring session set the value to zero: 0 sess_expire_on_close FALSE TRUE/FALSE (boolean) Whether to cause the session to expire automatically when the browser window is closed. sess_encrypt_cookie FALSE TRUE/FALSE (boolean) Whether to encrypt the session data. sess_use_database FALSE TRUE/FALSE (boolean) Whether to save the session data to a database. You must...
3 comments
Read more