How to get the next auto-increment id in mysql

Question

How to get the next id in MySQL to insert it in the table

INSERT INTO payments (date, item, method, payment_code)

VALUES (NOW(), '1 Month', 'paypal', CONCAT("sahf4d2fdd45", id))

Answer 1

Try using the below code:

SELECT AUTO_INCREMENT

FROM information_schema.tables

WHERE table_name = 'table_name'

AND table_schema = DATABASE( ) ;

But if you don't want to use information_schema then use this

SHOW TABLE STATUS LIKE 'table_name'