How to create mysql table with auto increment?

Discuss
#1

I want to create a MySQL table with an auto-increment from the user application when the user is login.
but i don’t know how to set the auto increment from the user app.

#2

When you create your table, set your field to AI, auto increment.
When a record is inserted in the table, this auto-increment field will have the value of the previous record + 1.

2 Likes
#3

i cant create because it each user will have there own table with there own id, table will be create after user login

#4

Use cCreate Table command :

#5

i dont have idea about that

#6

CREATE TABLE Users(
Id int NOT NULL AUTO_INCREMENT,
Name varchar(255) NOT NULL,

);

#7

where should i use it… i dont have an extention

#8

In initialize your screen, call this command in your Kodular blocks.

#9

which block ??
Screenshot_12
is this extension usefull

#10

Where you call SQL conmands.

#11

i use deep host mysql extension but there is no auto increment block or option

#12

Deephost not provide support so use method providing by Puravida

1 Like
#13

Do have any extension?

#14

You are confused . Talks about MySQL, shows SQLite extension … To create auto-increment field, you need to execute SQL command. So you need a block that executes the SQL command. This extension is not commented on here in the community.

1 Like
#15

Use this method for run Mysql Queries

3 Likes
#16

i download this extension just now

#17

Or This

2 Likes
#18

You are discussing about Mysql Or SQLite :man_shrugging:

#19

Suggestion: Do a database study

1 Like
#20

SQ lite is extension for Mysql data base rit