RE: Do you run multiple servers on WIndows?

2002-07-26 Thread Xavier Prélat
True, MySQL server does not support several instances on the same windows machine. For comparison, It is possible to install multiple instances of MS SQL Server 2000 !! Xavier -Message d'origine- De : Bhavin Vyas [mailto:[EMAIL PROTECTED]] Envoyé : vendredi 26 juillet 2002 04:09 À : Paul

RE: Date function

2002-04-19 Thread Xavier Prélat
This should work : $SQL = "INSERT INTO orders (Customer_Id, Order_Date)". "VALUES($CustID,Now())"; Xavier -Message d'origine- De : Alia Mikati [mailto:[EMAIL PROTECTED]] Envoyé : vendredi 19 avril 2002 11:28 À : [EMAIL PROTECTED] Objet : Date function Hello I

Normalization and Retrieval

2002-04-16 Thread Xavier Prélat
I want to know what kind of normalization to use to solve and retrieve data for this SQL based application: Following descritpion is the way I can do it. I want to store data about contacts : -> table Contacts(ID,Name,EMail) and data about list of users : -> table Lists(IDList, L

INSERT with pID use

2002-02-28 Thread Xavier Prélat [webcentric]
Hi, Is there any ways to re-use an auto_increment table unique ID in others record fields, like this : INSERT INTO SET = pID, = "aaa" where pID is the ID of the inserted record! with this table schema : --- : primary key, auto_increment, unique :

Multiple "replace" into a SQL query

2002-02-25 Thread Xavier Prélat [webcentric]
, "@TITLE@", title), replace(message, "@SIGNATURE@", signature) FROM *** But it generates 2 different query results Any ideas of syntax for the right query!!! __ Xavier Prélat w e b c e n t r i c 25,

RE: Question about SQL...

2002-02-22 Thread Xavier Prélat [webcentric]
ELECT id FROM table2); by writing this : SELECT table1.* FROM table1,table2 WHERE table1.id=table2.id; Hope it helps.. Cheers. Xavier Xavier Prélat CTO Webcenbtric 25 rue de Ponthieu 75008 PARIS -Message d'origine- De : Guillaume BABIK [mailto:[EMAIL PROTECTED]] Envoyé