Re: Newbie - from Oracle

2004-01-14 Thread Martijn Tonies
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

Newbie - from Oracle

2004-01-14 Thread Ken Brown
Oracle has "Dual" does MySql have something similar? 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? Does MySql support sequences? How? Relationships - can the code be interfered with or do I have to w