Avoiding auto-increment holes on InnoDB with INSERT IGNORE

Are you using InnoDB tables on MySQL version 5.1.22 or newer? If so, you probably have gaps in your auto-increment columns. A simple INSERT IGNORE query creates gaps for every ignored insert, but this is undocumented behaviour. This documentation bug is already submitted. Firstly, we will start with a simple question. Why do we have [...] [...more]

MySQL Comments (0)

MySQL on Amazon RDS part 1: insert performance

Amazon’s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers with EBS volumes (see SSD versus EBS death match), and one of them wanted to evaluate RDS as a replacement. It is built on the same technologies, but the hardware and networking are supposed [...] [...more]

MySQL Comments (4)

Aula 1248 banco de dados SQL – MySQL 5 Insert

Aqui mais de 1.600 vídeo aulas no site www.informaticon.com.br. Desenvolvido pelo professor Neri Aldoir Neitzke, pós-graduado em Desenvolvimento para Web, professor da Universidade Ulbra e proprietário da Informaticon, email videoaulas@informaticon.com.br 0xx543330-1222 Carazinho-RS Brasil Obs.: No youtube.com, as video aulas não estão nítidas e apenas a metade das vídeo aulas estão aqui. Caso queira, posso enviar [...] [...more]

MySQL Comments (5)

Brian Aker: Why does MySQL insert a NULL when a column is declared NOT NULL?, Other Thoughts…

Here is one, but not all of the culprits in the codebase: /* Count warnings for all inserts. For single line insert, generate an error if try to set a NOT NULL field to NULL. */ session->count_cuted_fields= ((values_list.elements == 1 && !ignore) ? CHECK_FIELD_ERROR_FOR_NULL : CHECK_FIELD_WARN); With MySQL you have to keep your mind firmly [...] [...more]

Drizzle Comments (0)

Create Members Area -Insert Register Form Lesson3

www.1stoptutorials.com – In this tutorial we will add our folder to dreamweaver my creating a new site. We will then get into setting up our database information so that we can have all our forms working. next we will get in our register form and save it out as a php document. Any problems let [...] [...more]

MySQL Comments (8)


 

February 2012
M T W T F S S
« Jan    
 12345
6789101112
13141516171819
20212223242526
272829