hai shawn green,
thanks for ur response.My situation is to generate a production
plan.for this I collect the data from sales orders and compare the stock
availability in rthe warehouse and if the stock is less than the ordered
quantity I plan for production and for this I have to issue t
I have written a .cfm to output a listing of columns with Name, Format, Size,
NULL, KEY, etc.
One thing I need to include is whether the Primary Key is AUTO_INCREMENT
That element does not appear to be in the same SCHEMA table.
Where is it ? and How can I use it with this Query ... ?
in information_schema.tables
e.g.
SELECT AUTO_INCREMENT from information_schema.tables where
WHERE TABLE_NAME = "Products" AND TABLE_SCHEMA = "bs3578";
Viel Gluck,
Martin
__
Disclaimer and Confidentiality/Verzicht und Vertraulichkeitanmerku
