Hi Ken, > Oracle has "Dual" does MySql have something similar?
MySQL doesn't have a "dual" table. But if you take a look at the "Dual" in Oracle, you'll only see this: CREATE TABLE Dual (Dummy VARCHAR(1)); INSERT INTO Dual ('X'); So you can easily create one yourself. > In Oracle I use SYSDATE and USER a lot as default column values when > creating a table. Can you do something similar in MySql and how? According to http://www.mysql.com/doc/en/CREATE_TABLE.html a DEFAULT is: "A DEFAULT value has to be a constant, it cannot be a function or an expression." > Does MySql support sequences? How? No, not as seperate objects. It does support an auto-inc type column. > Relationships - can the code be interfered with or do I have to wait for > triggers? Foreign key constraints? Only available in the "InnoDB" table type. Read the docs on that. With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.upscene.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]