Posts by M. Martins • 71 points

• 5

  votes

  1

  answer

  166

  views

  Q: What are these sql modes for in mysql?

  Here is the code: SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; SET SQL_MODE=@OLD_SQL_MODE; SET…

  mysql

  asked 6 years, 9 months ago M. Martins 71

• 2

  votes

  1

  answer

  47

  views

  Q: Using the Handler function is skipping the ids. How do I make it not happen?

  Take the example: create table time( id int not null primary key auto_increment, nome varchar(50) unique )engine=innodb; delimiter $$ CREATE PROCEDURE insertteam (nometime varchar(50)) begin declare…

  mysql handler

  asked 6 years, 10 months ago M. Martins 71