How to update table data using primary key

Viewed 11

CREATE TABLE tableb ( ID int(11) NOT NULL AUTO_INCREMENT, IP varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL, BATCH_ID varchar(225) COLLATE utf8_unicode_ci DEFAULT NULL, STATUS int(11) DEFAULT NULL, TEMP_TABLE_NAME varchar(225) COLLATE utf8_unicode_ci DEFAULT NULL, CREATED timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, UPDATED timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (ID), UNIQUE KEY tableb _BATCH_ID (IP,BATCH_ID), KEY tableb _STATUS (STATUS) )

0 Answers
Related