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 SQL
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
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 200
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 ha
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, column3,
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 th
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 limit
How about:
select some_data from the_table order by the_date ASC limit 1
?
-Message d'origine-
De : Solsberry, Glendon [mailto:[EMAIL PROTECTED]]
Envoye : vendredi 5 juillet 2002 16:52
A : [EMAIL PROTECTED]
Objet : MIN/MAX Date Field
Is there a way to select some data from a table whe
theMinTime < col < $theMaxTime. 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
---
-Origi
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:[E
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-
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 tblTemp1.fl
OT MATCH(Notes) AGAINST('prop*' IN BOOLEAN MODE)
<-- snip -->
What have I understood wrong?
---
Alain Fontaine
Consultant & Developer
VAlain S.A.
Tél: +32-4-2522950
---
-
Before posting, please che
theMinTime < col < $theMaxTime. 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
---
-Origi
.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,
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-
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:[E
OT MATCH(Notes) AGAINST('prop*' IN BOOLEAN MODE)
<-- snip -->
What have I understood wrong?
---
Alain Fontaine
Consultant & Developer
VAlain S.A.
Tél: +32-4-2522950
---
-
Before posting, please che
18 matches
Mail list logo
