-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 1:57 PM
To: Marcus Ouimet
Subject: Re: Subtraction of part of a field
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 06, 2001 1:57 PM
To: Marcus Ouimet
Subject: Re: Subtraction of part of a field
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, June 04, 2001 11:54 PM
To: Marcus Ouimet
Subject: Re: Select Letter/Number
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter
I opened a very large .sql file with pico and well it seems to have hung
up MySQL for some reason. If you type mysqladmin shutdown you just get a
blank response same as if you use any mysql command. I tried kill the
PID's but it won't kill them they just stay there. Even tried kill -9.
Any help
I went into my database today and noticed that there was 102,000 entries.
Somehow a whole pile of crap was added to the end of the database. I think
it can easily be fixed but am not sure. Is there a way that I can eliminate
all entries with a field that is blank? ie:
if the table
I am trying to load data from several lists. This is what I was trying:
LOAD DATA INFILE '*.*' INTO TABLE table2 FIELDS TERMINATED BY '\t';
For a single file I would have used:
LOAD DATA INFILE 'data.txt' INTO TABLE table2 FIELDS TERMINATED BY '\t';
Any ideas? I have several files that all
I hate to ask this question but I have tried everything. I am installed
mysql on a new server and everything seems to be OK except it never created
mysql.sock? Here is how I installed it:
cd mysql-3.23.29a-gamma/
groupadd mysql
useradd -g mysql mysql
./configure
My database was working fine then the server crashed and now I am getting
this error:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)
I have checked and verified that the file exists:
srwxrwxrwx 1 root root0 Jan 16 23:00
I was looking through my website and everything was fine and then all of a
sudden I got this error:
ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (111)
It was working fine, and now for some reason won't connect? Any suggestions
how to fix this and why it would
Could someone help me out with the following line I think the slashes are
causing the problem but I am not sure:
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
Can someone help me with the following command? The slashes seem to be
causing a problem. It doesn't find /images/covers?
update products set products_image='images/covers' where
products_image='/images/covers%';
-
Before
One quick question, I am trying just replace part of the entry ie:
change:
/image/covers/009.jpg
to
image/covers/09.jpg
I have tried to update products set products_image='image/covers' where
products_image like '/images/covers%'; but it seems to replace the whole
field and not leave the
OK, I am really stuck sorry to have to post this. I have searched through the
documentation and maybe I am just searching with the wrong words on the MySQL site. I
am wanting to reorder the fields I have in a table - not the data in the fields (I
have lots of info on this) but the actual
13 matches
Mail list logo