-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 ap
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 cha
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 product
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 --with-named-curses-libs=/usr/lib/
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 mysql.soc
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
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 trai
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 posti
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/
I am trying to figure out how to change content using wildcards. Something
like:
if the data in the field "date" in the table products equals 2001*.* change
to 200100
Any help/direction is appreciated. Thanks in advance.
MySQL was working fine but now it seems to be giving me an error:
user:/usr/local/apache/bin# mysql -uusername -pmypassword
Can't read dir of '.' (Errcode: 2)
or
user:/usr/local/apache/bin# mysqladmin -uusername -pmypassword create catalog
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 fields
15 matches
Mail list logo
