Help for this page

Select Code to Download


  1. or download this
    INSERT INTO tablename (col1, col2, col3) VALUES
    (value1, value2, value3), 
    (value1, value2, value3), 
    (value1, value2, value3), 
    (value1, value2, value3);
    
  2. or download this
    my @values = (
        ["A", "B", "D", "0"],
    ...
              . join(",\n", ( map { "(". join ( ", ", 
                map {$dbh->quote($_)} @$_). ")" }
                @values));
    
  3. or download this
    ALTER TABLE tablename DISABLE KEYS;
    
    # do the insertion
    
    ALTER TABLE tablename ENABLE KEYS;