Questions tagged as 'auto-incremento'

2
answers

MySQL Auto increment number pair

I have a MySQL database with a id field that is AUTO_INCREMENT . You have some configuration problem in it because at the time of making the auto increment it is coming out exactly in this sequence: ID: 2 ID: 12 ID: 22 ID: 32 ID: 42...
asked by 10.02.2017 / 14:59
1
answer

How to customize the Auto_Increment numbering in MySQL?

I have a Contrato column in my MySQL database, it is as Auto_Increment, numbering the contracts as 1 , 2 , 3 in> ... But I needed, if possible, to organize these numbers in the actual format of contract numbers. It works lik...
asked by 28.02.2015 / 20:37
3
answers

how to increment letters in php? [duplicate]

I need to make a program in php that increments a letter in the name received ex: If the user types the letter B, it needs to transform it into a C-word.     
asked by 04.07.2017 / 14:23
1
answer

How does auto increment work with composite keys in the MyISAM engine?

I ended up getting a table to manipulate, I noticed that sometimes the value of auto increment was repeated, the first thing that called me to Attention was that the primary key was composed of two fields, one of which was AI and the other not....
asked by 18.02.2016 / 17:11
3
answers

How to organize the auto-increment numbering of an id column of a table in MySQL?

I would like after each insertion or delete of my table to use a SQL script to rearrange the Ids. Currently it looks something like this: Id Nome 1 João 3 José 5 Ricardo I want to leave it like this: Id Nome 1 João 2 José 3 Ricar...
asked by 18.12.2013 / 18:00
1
answer

ID (auto-increment) too high can be harmful?

I have a table that has a very high turnover of information, that is, many records come in and many come out as well. With this the ID (auto-increment) is much higher than the data value in the table. For example, the table has 530 records an...
asked by 19.01.2016 / 18:30
1
answer

Print form with: 1.photo uploaded in post 2. id auto increment generated in form insert. In PHP has it?

At the moment of registering the form, the user will put the photo, so that's fine. My problem is that I need to print this form already with the photo and the id auto increment of the bank. The idea was to register the data 60 fields...
asked by 10.08.2015 / 03:46
2
answers

mongodb error getNextSequence is not defined

Good morning, I can not create and execute this function in mondodb 3.4 I'm following this tutorial: Create an Auto-Incrementing Sequence Field Error Error: ReferenceError: getNextSequence is not defined: @ (shell): 3: 6 function getNex...
asked by 23.05.2017 / 19:19
1
answer

Learn ABC in C language?

How do I in this code, when it enters a letter read by the keyboard with the scanf of type (char) it repeats until the Z? #include <stdio.h> #include <stdlib.h> int main() { char c; /*for (c= 'A'; c<='Z'; c++){...
asked by 13.05.2015 / 15:24
2
answers

How to make an auto increment ID relative to another field in PostgreSQL "PostgreSQL"? [duplicate]

id_empresa | id_pedido 1 | 1 1 | 2 1 | 3 1 | 4 2 | 1 2 | 2 3 | 1 I already thought of doing only one trigger and procedure for all the tables, but I do not know how to...
asked by 03.12.2018 / 14:07