Hi Dean,
If I'm not mistaken, it looks like you are just joining the two tables
(list_rank and entry) and not specifying which matching records you want
(with a "where..." clause), so mysql is matching each row in one table with
each row in the other table. That will be a HUGE result set, so it w
Hi Karl,
I have my rule in Outlook set up as:
"Apply this rule after the message arrives
with lists.mysql.com in the message header
move it to the MySQL and PHP folder"
I hope that helps.
Bob Loeffler :)
-Original Message-
From: karl james [mailto:[EMAIL PROTECTED]
Sen
This is a test e-mail for Karl. Please disregard it.
Thanks,
Bob
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Caroline,
The syntax is:
delete from where ;
So, try this:
delete from members where username='John Smith';
When deleting records from a table, always make sure you have a good
condition clause, because if you don't have one, or if it's not correct, you
could delete ALL of the records
Hi John,
I've been getting those fake e-mails for a month, but I joined this mailing
list only a week ago, so they definitely did not start coming from this
list.
Bob
-Original Message-
From: John Griffin [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 04, 2003 11:30 AM
To: [EMAIL PR
Hi Binay,
Use the mysql client to open the "mysql" database. For example, enter the
following at the "mysql>" prompt:
use mysql
Then type:
select * from user;
Bob
-Original Message-
From: Binay [mailto:[EMAIL PROTECTED]
Sent: Friday, December 05, 2003 12:26 AM
To: mysql users
Subje
Hi Iain,
Did you alter the tables since your original message? In the original
message, you didn't have a "caption" column in the properties table. It
might be easiest if you showed us your current table structures and partial
data, like this:
Countries
+--+---+
| Fi
click on the OK button in each of those dialogs to save the info. Now
you shouldn't have a problem the next time you open a command prompt window
and type in 'mysql' to run the mysql client application.
Bob Loeffler :)
-Original Message-
From: Betta Jazzy Brown [mailto:[E
Hi Jess,
If there will never be another ID number, something like the following
should work (although I don't know about the "\n" part):
$Row = mysql_fetch_array ($Result);
print ("ID: $Row[id]\n");
print ("$Row[technotes]\n");
while ($Row = mysql_fetch_array ($Result))
{
print ("$Row[
Hi, I don't know much about the foreign key syntax, but I would think it
should reference a field in a different table. If I'm wrong, I'm sorry.
:-)
Bob
-Original Message-
From: Mofeed Shahin [mailto:[EMAIL PROTECTED]
Sent: Sunday, December 14, 2003 9:56 PM
To: Paul DuBois; [EMAIL PROTE
Hi all!
I would like to update many records in a table called "pictures" where I
find a string in the "caption" column. If the string (e.g. "www.bob.com")
is found, replace it with another string (e.g. "www.bubba.com").
Unfortunately, there is other text in the caption column of these records,
so
Awesome! It worked perfectly! Thanks Pat and Stephen.
Bob
-Original Message-
From: Patrick [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 25, 2003 4:20 PM
To: Bob Loeffler; [EMAIL PROTECTED]
Subject: Re: Replacing text using the Update command?
Bob,
Try:
UPDATE pictures set
I think mysqldump does that. It creates a script that contains SQL
statements to create the table and then the data to populate the table.
Mysqldump has command line parameters, but I don't know which ones you would
need to use.
Bob
-Original Message-
From: Zenzo [mailto:[EMAIL PROTECTED
13 matches
Mail list logo
