trainerer.blogg.se

LEFT JOIN b2_sac_numbers AS sc ON sc.sac_number = app. 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 LEFT 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 Download Latest Version for Windows How to Use Navicat For MySQL By PremiumSoft CyberTech, Navicat is a high-performance, in-memory data access library for MySQL that supports a wide range of data manipulation functions.