RE: Changing the locations of the tables

Here you go:-) [root@server src]# rpm -i MySQL-3.XX.XX-1.src.rpm [root@server src]# tar -xvzf ../../src/redhat/SOURCES/mysql-3.XX.XX.tar.gz [root@server src]# cd mysql-3.XX.XX [root@server mysql-3.XX.XX]# ./configure \ --prefix=/usr/lib/mysql [root@server mysql-3.XX.XX

RE: changing column order in MySQL tables?

Or the way they go in when you issue a INSERT query. If you still need to have the field (we'll call the field "C") you can add a NEW column where you want the this existing column "C" (we'll call this field "C1"). Next, update all your data that's in "C" so It's also in "C1". Next, alter the

RE: very strange query behavior

I would have to guess that you have a broken index. bill -Original Message- From: Daren Cotter [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 3:50 PM To: [EMAIL PROTECTED] Subject: very strange query behavior can anybody explain this to me? mysql> select count(*) from memb

RE: Debugging: Analysis

Try fixing all tables/indexes. -Original Message- From: s. keeling [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 30, 2001 5:55 PM To: mysql_mailing list Subject: Re: Debugging: Analysis On Thu, Aug 30, 2001 at 05:01:14PM -0700, Rodney Broom wrote: > > mysqld is restarting, a lot.

RE: Run Mysql command from a file.

Maybe he's running in some windows version?? It seems to me that your example using std-in is the easiest. I would suggest also writing a perl program but in this case I thing your example is right on. Then again if he's using the windows version, I have no idea. -Original Message- From