Questions tagged [auto-increment]
a database constraint that automatically increases from the last record when making an INSERT
auto-increment
2,685
questions
1
vote
2
answers
63
views
Add 1 to number from cell in last row of sheet in other workbook and enter on sheet in currently open workbook
I have a "My Quote" template workbook which has a quote number in cell "I1" of the "Quote" sheet.
Upon opening that workbook I want to go to another (unopened) "...
- 11
0
votes
1
answer
42
views
How can i implement a auto Increment pk in a interative grid
I tried to implement an auto increment on my default interactive grid page by following several tutorials on YouTube, but each tutorial taught differently and none solved my problem,
the new line is ...
0
votes
1
answer
35
views
C# - Adjust an auto-incremented field of an object when item is removed from Bindinglist
I have a class for a "Car" object which I have added several instances of to a Bindinglist attached to a Datagridview. I am trying to make a specific field of this object increment every ...
- 3
0
votes
2
answers
63
views
Autoincremental values for multiple columns in snowflake
is there a way to create sequence without any gaps in snowflake. I cannot use row number as I am running the updates/inserts multiple times which will end up creating same row numbers 1 to n on every ...
0
votes
1
answer
39
views
How to create table with identity column using entity framework core code first migration to oracle db?
This is the code generated by ef core after we do add-migration
migrationBuilder.CreateTable(
name: "Provinces",
////schema: "some schema",
columns: table => new
...
- 17.4k
0
votes
0
answers
44
views
Mysql increment field didn't work property with mybatis plus
1.entity
public class SaledData implements Serializable {
private static final long serialVersionUID = 1L;
@TableId(value = "id", type = IdType.AUTO)
private Long id;
...
- 1
0
votes
0
answers
41
views
How to auto-increment a composite key as a calculated field?
How is it possible to auto-increment a composite key (string text) in Excel while satisfying two logical conditions?
I am trying to construct a calculated field [transaction_id] by satisfying two ...
1
vote
2
answers
104
views
Auto Increment value for non-primary key column
In my MariaDB I have two tables project and issue, the issue table contains all issues created for all projects
create table if not exists Project(
id integer PRIMARY KEY auto_increment,
`name` ...
- 23
0
votes
0
answers
210
views
dbt Incremental Model Issue with Snowflake Autoincrement Column
I am encountering an error while utilizing an autoincrement column named col_2 in Snowflake within my dbt incremental model. The column col_2 is defined in Snowflake as:
col_2(18,0) autoincrement ...
0
votes
2
answers
107
views
How to definitelly fix Potgresql autoincrement problem with unique constraint violation
How to fix Potgresql autoincrement problem with unique constraint violation?
Is there some option in Postgres which set up sequence value after any insert properly?
I am alway getting error when ...
- 4,044
0
votes
0
answers
23
views
Auto increment ID in kotlin xml
When I wanted to copy and paste in xml, the id was automatically increasing. I deleted Android Studio and downloaded it again. That feature is gone and I'm having a lot of problems. How can I turn on ...
0
votes
1
answer
56
views
Laravel Pest test ignore not resetting mariadb autoincrement ids
I have a laravel pest test that checks a redirect after data is submitted to a controller to create a client.
it('redirects to the clients show page', function () {
$user = User::factory()->...
- 1,120
0
votes
1
answer
45
views
Generate Automatic increment for "alt" html field on images
I'm using a php gallery script and I need to add numbers (auto increment) in the "alt" field (images).
I already tried several options from stackoverflow and unfortunately I didn't succeed.
...
- 45
0
votes
1
answer
206
views
Setting auto-increment after filling table (Firebird) with existing data (from SQL Server)
I have a table in SQL Server. Its PK, ID, is of type INT and is auto-incremented. The task I have is to get this table in a Firebird database (version 4.0.4). Remarks: we have a website that uses this ...
- 165
0
votes
2
answers
193
views
How to create incremental counter in mulesoft dataweave
We have multilevel array so we are using transformation of multiple map function. In this case how to assign a field ID with incremental value.
Input:
[
{
"productNo": "00011111&...
- 17