codehaven - php snippets - coding help
Generic filters
Exact matches only
    • octopus energy discount code

    Lock read/write MySQL tables to update

    10th February 2015

    MySql

    mysql codehaven category

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
     
    LOCK TABLES table1 WRITE;
     
    TRUNCATE table1; //if you want to empty it all
     
    INSERT INTO `table1` (`id`, `accountid`,`client`) VALUES
    (18, '3174349665', 'myclient'),
     
     
    UNLOCK TABLES;
     

    Was this code snippet helpful?

    RSS Latest Snippets
    LINKS
    A Repository of Code Snippets in many Programming Languages:-

    PHP – JQUERY
    CSS – MYSQL
    WORDPRESS – JAVASCRIPT
    WOOCOMMERCE – HTML

    © 2022 CODEHAVEN