4/5/2023 0 Comments Navicat 15 for mysql keyLEFT JOIN b2_sac_numbers AS sc ON sc.sac_number = app.covid_idįirst SELECT (SELECT COUNT(id) +1) as id, Image SELECT sc.id as b2_id,app.covid_id,app.payroll_batch,app.paid_by,app.date_receive,app.remarks,app.eligible,app.amount,app.amount_paid,app.amount_unpaid I want to add primary key column autoincrement before column1 which is id using select query based on number of data from the other column.Įxpected output id column1 column2 column3 ![]() I'm having a trouble on how can I add a column before column1 which is ID primary key autoincrement in Navicat sql query.The expected output should automatically increment the number based on the total number selected query
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |