RE: Complex SQL assistance

Check the mySQL REPLACE syntax... that's what you need. -Message d'origine- De : Corey Wallis [mailto:[EMAIL PROTECTED]] Envoyé : vendredi 26 juillet 2002 11:17 À : [EMAIL PROTECTED] Objet : Fw: Complex SQL assistance Peoples, I'm currently trying to work out if this is possible by

RE: mysql error

Yes, it simply means that you have single quotes inside the string you try to save, and you need to escape them. Alain Fontaine Consultant developer VAlain S.A. http://www.valain.lu/ -Message d'origine- De : W. Enserink [mailto:[EMAIL PROTECTED]] Envoyé : lundi 15 juillet 2002 15:07 À

RE: Interesting

http://www.mysql.com/doc/D/E/DELETE.html In MySQL 3.23, DELETE without a WHERE clause will return zero as the number of affected records. Alain Fontaine Consultant developer VAlain S.A. http://www.valain.lu/ -Message d'origine- De : Bhavin Vyas [mailto:[EMAIL PROTECTED]] Envoyé

RE: subselect in an insert

MySQL, as of yet, doesn't support sub-selects ! -Message d'origine- De : daniel [mailto:[EMAIL PROTECTED]] Envoyé : jeudi 11 juillet 2002 02:37 À : [EMAIL PROTECTED] Objet : subselect in an insert why is it that this doens't work? INSERT INTO mytable (column0, column1, column2,

RE: ORDER BY RAND() not working

What does your PHP code look like ? It might be a syntax problem inside PHP -Message d'origine- De : Jamie Tibbetts [mailto:[EMAIL PROTECTED]] Envoye : jeudi 11 juillet 2002 18:22 A : [EMAIL PROTECTED] Objet : ORDER BY RAND() not working I'm running PHP 4.1.2 and MySQL 3.23.39. I

RE: Deep Nesting

Hello, With a decent database design, you won't need as many tables. Let me try: Tables for each basic object: (1) One table for stellar objects (2) One table for user comments (3) One table for ratings (4) One table for conjunctions (5) One table for users Link tables: One table to link them

RE: how to limit the cpu usage in MySql

Hello, If your main concern is spider-bots, why not use a (possibly dynamic!) robots.txt file? -Message d'origine- De : Edwin Wang [mailto:[EMAIL PROTECTED]] Envoyé : mardi 4 juin 2002 17:53 À : [EMAIL PROTECTED] Objet : how to limit the cpu usage in MySql I want to find a way to

mySQL 4 - FullText searching syntax?

: -- snip -- select BienID from biens where MATCH(Notes) AGAINST('appartemen*' IN BOOLEAN MODE) AND NOT MATCH(Notes) AGAINST('lux*' IN BOOLEAN MODE) AND NOT MATCH(Notes) AGAINST('prop*' IN BOOLEAN MODE) -- snip -- What have I understood wrong? --- Alain Fontaine

RE: dumping between tables?

Paul, RTFM : http://www.mysql.com/doc/I/N/INSERT_SELECT.html [quote] INSERT [LOW_PRIORITY] [IGNORE] [INTO] tbl_name [(column list)] SELECT ... With INSERT ... SELECT statement you can quickly insert many rows into a table from one or many tables. INSERT INTO tblTemp2 (fldID) SELECT

RE: dumping between tables?

Hello Paul, Why don't you just use mysqldump to dump the data to a textfile, and then insert the data from the textfile into your new table? --- Alain Fontaine Consultant Developer VAlain S.A. Tel: +32-4-2522950 --- -Original Message- From: Paul

RE: long query on php

Have you tried just putting the querys into a variable and pass the var along to mysql_query() ? Did it not work? --- Alain Fontaine Consultant Developer VAlain S.A. Tel: +32-4-2522950 --- -Original Message- From: savaidis [mailto:[EMAIL

mySQL 4 - FullText searching syntax?

: -- snip -- select BienID from biens where MATCH(Notes) AGAINST('appartemen*' IN BOOLEAN MODE) AND NOT MATCH(Notes) AGAINST('lux*' IN BOOLEAN MODE) AND NOT MATCH(Notes) AGAINST('prop*' IN BOOLEAN MODE) -- snip -- What have I understood wrong? --- Alain Fontaine

RE: long query on php

Have you tried just putting the querys into a variable and pass the var along to mysql_query() ? Did it not work? --- Alain Fontaine Consultant Developer VAlain S.A. Tel: +32-4-2522950 --- -Original Message- From: savaidis [mailto:[EMAIL

RE: dumping between tables?

Hello Paul, Why don't you just use mysqldump to dump the data to a textfile, and then insert the data from the textfile into your new table? --- Alain Fontaine Consultant Developer VAlain S.A. Tel: +32-4-2522950 --- -Original Message- From: Paul

RE: dumping between tables?

.fldOrder_ID FROM tblTemp1 WHERE tblTemp1.fldOrder_ID 100; . . [/quote] --- Alain Fontaine Consultant Developer VAlain S.A. Tel: +32-4-2522950 --- -Original Message- From: Paul Reilly [mailto:[EMAIL PROTECTED]] Sent: Thursday, February 07, 2002 1:54

RE: Extracting fields from a table

. Is that what you need? It works the same way if you don't use timestamps, by the way. timestamps are just more convenient ;) --- Alain Fontaine Consultant Developer VAlain S.A. Tél: +32-4-2522950 --- -Original Message- From: Victoria Reznichenko