如何构建MAX(InvoiceNo)值应为的动态MySQL查询
1a,1b,1c...1z,2a,2b...2z,3a...
查询是
$max = "SELECT MAX( InvoiceNo ) as InvoiceNomulti FROM invoice_balance";
这是我的小提琴
试试这个
Select InvoiceNo from invoice_balance order by InvoiceNo asc limit 3
此查询将返回1a、1b、1c
如何构建MAX(InvoiceNo)值应为的动态MySQL查询
1a,1b,1c...1z,2a,2b...2z,3a...
查询是
$max = "SELECT MAX( InvoiceNo ) as InvoiceNomulti FROM invoice_balance";
这是我的小提琴
试试这个
Select InvoiceNo from invoice_balance order by InvoiceNo asc limit 3
此查询将返回1a、1b、1c