mysql - update, MySQL

mysql - update

#MySQL 5.7.12

-- drop table tutorial_tbl;

DROP TABLE IF EXISTS tutorials_tbl;
 
create table tutorials_tbl(
   tutorial_id INT NOT NULL AUTO_INCREMENT,
   tutorial_title VARCHAR(100) NOT NULL,
   tutorial_author VARCHAR(40) NOT NULL,
   submission_date DATE,
    datetime DATETIME,
    timestamp TIMESTAMP,
    year YEAR,
   PRIMARY KEY ( tutorial_id )
);

INSERT INTO tutorials_tbl 
   (tutorial_title, tutorial_author,submission_date ,datetime,year)
   VALUES
   ("Learn PHP", "John Poul", NOW(),NOW(),NOW());
   
 INSERT INTO tutorials_tbl 
   (tutorial_title, tutorial_author,submission_date ,datetime,year)
   VALUES
   ("Learn PHP4", "John Poul", NOW(),NOW(),NOW());
   
 INSERT INTO tutorials_tbl 
   (tutorial_title, tutorial_author,submission_date ,datetime,year)
   VALUES
   ("Learn PHP5", "John Poul", NOW(),NOW(),NOW());
   
UPDATE tutorials_tbl
      SET tutorial_title="5"-1-"" ,submission_date='1973-12-30' - INTERVAL -1 DAY
      WHERE tutorial_id=1;
      
      
  UPDATE tutorials_tbl
      SET tutorial_title=4 ,tutorial_author='xxx'  
      WHERE tutorial_id=2   and 1=1;
      
  UPDATE tutorials_tbl
      SET tutorial_title=4 ,tutorial_author='yyy'  
      WHERE tutorial_title='Learn PHP5' and '1'; 
 
select * from tutorials_tbl;


run \| edit \| history \| help	0