PROGRAMMING

 
REMEMBERS




Last update:   29-10-2021

Ingnore primary key

 
CREATE TABLE file_names (
     id int(11) NOT NULL auto_increment,
     file_name text NOT NULL,
     PRIMARY KEY (id),
     UNIQUE KEY file_name (file_name(200))
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;
... 1 lines
 
Insert Query    (2/2)

Insert query

 
INSERT IGNORE INTO file_names (id , file_name) 
VALUES (NULL , 'a'), (NULL , 'a');
The table now contains one row with a filename of 'a'
Questions    
Errors

        A B C D E F
🔔
1/1