Search results for query: *

Hi, I found the syntax for auto_increment column while creating the table. I want to know whether this auto_increment supports properties like INITIAL VALUE, INCREMENT VALUE, etc.. (similar to Cloudscape or IBM DB2)????????????? This is urgent, pls try to make it soon. Regards, Stephenraj

Hi, I want to know whether auto increment column is supported in MySQL or Not? For example this is equivalent to IDENTITY column and sequence in case of IBM DB2. If this is supported in MySQL(either IDENTITY or SEQUENCE, or both) please provide the exact syntax for creating, altering...

Hi Sathyaram, Thanx a lot for for ur valuable help. Regards, stephenraj

Hi Fernando, Thanx a lot for ur valuable information. I will try to get the Fixpaks. Regards, stephenraj

Hi, Could u please tell me that sequences are supported in which version of IBM DB2. Right now IBM DB2 Universal Database Version - 7 is installed in my machine. Is Sequences supported in this version or not?? Please respond me immediately, Regards, stephenraj

Hi, How to retrieve the sequence names from the db2 database. It is retrieved by use of tables like USER_SEQUENCE and ALL_SEQUENCES in case of oracle. How it is done in case of DB2. If i can get the exact the SQL Statement for both these tables it is well and good. Please reply me...

Hi Shriyan, I have asked for auto increment column support in Informix database, u have given a solution of a datatype called serial, thanks for the same. In ur example u have created a temporary table. Example Given by You. -------------------- create temp table tab1 (f1 serial) with no...

Hi, Thanks for your reply, 1. To add on , is the serial column applicable only for the temporary tables? 2. Can we alter a serial column, if so can i just get the corresponding alter statement Regards Stephen