Comment Re:9 years later, still won't trade my Pioneer Pla (Score 0) 418
While we're fixing things: "the LCD's on the market can't match its picture."
CREATE TABLE emps (id INT(10) AUTO_INCREMENT,
fname VARCHAR(50) NOT NULL,
sname VARCHAR(50) NOT NULL);
INSERT INTO emps (fname) VALUES ('John');
In a proper RDBMS, that would fail for violating a constraint. MySQL/MariaDB just massage the missing sname into an empty string, which is about as valid as just sticking 'sldfjpsdj;ksdj;fsdljkfsd.'
There are two ways to write error-free programs; only the third one works.