MySQL 4.1 Script & Shut Down Issues

After installing MySQL 4.1 on a Win2K machine, I tried to run the mysql_fix_privilege_tables.sql script. I got the duplicate column name errors which the documentation says I can safely ignore. However, I also got this error: ERROR 1064 at line 67: You have an error in your SQL syntax. Check the m

[Fwd: MySQL 4.1 Script & Shut Down Issues]

--- Begin Message --- After installing MySQL 4.1 on a Win2K machine, I tried to run the mysql_fix_privilege_tables.sql script. I got the duplicate column name errors which the documentation says I can safely ignore. However, I also got this error: ERROR 1064 at line 67: You have an error in your S

Trying to upgrade

install everything? This is a working db Thanks for any suggestions Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Syntax question for a beginner..

ebsd4.3 (i386) Any help would be appreciated, - randy P.S. Fist time poster, first time lister :) = r a n d y / sesser at mac.com - Before posting, please check: http://www.mysql.com/manual.php

Re: Syntax question for a beginner..

ow you can't do nested selects :\ - randy = r a n d y / sesser at mac.com > From: "Rolf Hopkins" <[EMAIL PROTECTED]> > Date: Fri, 6 Jul 2001 13:57:27 +0800 > To: "{ randy }" <[EMAIL PROTECTED]>, "MySQL" <[EMAIL PROTECTED]

Re: Syntax question for a beginner..

You are the man...thanks a bunch! that's what I needed. = r a n d y / sesser at mac.com > From: "Rolf Hopkins" <[EMAIL PROTECTED]> > Date: Fri, 6 Jul 2001 14:39:59 +0800 > To: "{ randy }" <[EMAIL PROTECTED]>, "MySQL&

Re: Looking for best performance

I'd go with the SUN...can't tell you why or back up my answer, but I'd just go with the SUN = r a n d y / sesser at mac.com > From: "Kissandrakis S. George" <[EMAIL PROTECTED]> > Date: Fri, 06 Jul 2001 10:41:50 +0300 > To: [EMAIL PROTECTED] > Subject: Looking for best

Re: Installing on FreeBSD 3-4

I have it running on FreeBSD 4.3-RELEASE. I just installed it form the ports collection: /usr/local/ports/database/mysql323-client & mysql323-server Everything seems to work well. = r a n d y / sesser at mac.com > From: "Gustavo Santos" <[EMAIL PROTECTED]> > Date: Fr

Re: mysql on OSX v. 10.0.4

When I was running OS X, I just used the installer that I found on versiontracker.com . If you do a search for MySQL, it should bring up a precompiled version of MySQL. It should be the most rescent, the guy who provides it usually keeps it up to date. He even has instructions on his site about se

Is this a bug?

Hi People, I'm trying to execute this Simple query: SET SQL_SAFE_MODE=0; The server doesn't like it; However, SET any other option will work fine except this one. I'm still using mysqld v3.23.36 . If someone can try it on the latest version.

DSN-Less connection Strange error!

;", con When moving into the recordset , i'm able to move through the first record and get the first field , but when I rst.MoveNext I get the E-Fail error . I tried "SHOW Columns ..." but same result. "show datbases ..." is OK &

DSN-Less connection Strange error!

;", con When moving into the recordset , i'm able to move through the first record and get the first field , but when I rst.MoveNext I get the E-Fail error . I tried "SHOW Columns ..." but same result. "show datbases ..." is OK &

Record Locking?

ranet, and seconds later, so does PersonB on the other side of the office. Is there any way to prevent PersonB from making changes, and saving them, overwriting what PersonA just updated? If there is an obvious solution that I am missing, I apologize.. Thanks

mysqldump question

to the old way of separate inserts for each row? Thanks Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

please help, can not delete database

. Do you really want to drop the 'billmax' database [y/N] y Database "billmax" dropped But it does not do anything. I have tried restarting the DB and restarting the box as well Please help Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/

Help with this query. How to do a group by on a datetime just the month/day/year

Hello, Not sure if i can do this. I have a table with a datetime column I would like to do group by a day of the month. if i do something like select count(*) from MTracking where mallarea=1001 group by timeofclick every one is listed because time. So is this possible? Thanks Randy

table hangs on a large query

Hello, I have a table (see below) that has 111599 records in it. When i do a query like select * from gallery_object where dir = 'dirname' this query takes a very long time and while the query is going on it locks the entire table so no one else can query it yet a query like select * from galler

Re: table hangs on a large query

On 8/14/06, Dan Buettner <[EMAIL PROTECTED]> wrote: Randy, it's possible your indexes are sadly out of date, or corrupted somehow. Can you post the output of EXPLAIN select * from gallery_object where dir = 'dirname'; as well as of EXPLAIN select * from gallery_object wh

Re: table hangs on a large query

>the query that was giving me grief in the previous message returned >immediately > >Thanks >Randy Randy, Then it could have been index corruption. You could do a back up of the table and then run a Repair Table on it (or MyISAMChk) and then Optimize it. See http://dev.mys

help trying to add an autoincrement col to an exisiting table

Hello, currently i have the following table structure CREATE TABLE users ( uname varchar(20) NOT NULL default '', passwd varchar(15) NOT NULL default '', fname varchar(25) NOT NULL default '', lname varchar(40) NOT NULL default '', dir varchar(28) NOT NULL default '', pict varchar(50) NOT N

looking for direction on how to debug this message

Hello, My log file is getting filled with these. How do i start debugging this? Thanks Randy //-snip-// 050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an er

Log file full of Got an error reading communication packets

Hello, My log file is getting filled with these. Can someone tell me what these mean? Thanks Randy //-snip-// 050122 20:28:00 Aborted connection 53561 to db: 'unitnet' user: 'paries' host: `local.flanders' (Got an er

RE: Log file full of Got an error reading communication packets

directory I have a file called millhouse.unitnet.com.err My main db is unitnet It appears this is a good link that I received from GLEB http://dev.mysql.com/doc/mysql/en/communication-errors.html I am going down that path right now Thanks Randy -Original Message- From: [EMAIL PROTECTED

RE: looking for direction on how to debug this message

see ? In the mysql variables. In 5 days I have 11885 aborted_clients. I assume this is probably pretty high? Thanks for any more help Randy -Original Message- From: Gleb Paharenko [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 20, 2005 3:27 PM To: mysql@lists.mysql.com Subject

MySQL Proxy - Select Proxy On Auth

Hi, I have a situation where I need clients to connect to a proxy server and to then determine which MySQL server to forward their connection to based on the username supplied. Does anyone know if this is possible using mysql-proxy with Lua? Or by any other means? Thanks. REW

best way to query this table

have indexed the column, but i am wondering if i should create a couple of int columns that would be day of week, week of year and month and query against these instead. would love you opinions thanks Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

How to query

way as to do it all in one query and to order by the 10 or so products I'm interested in. MySQL is 4.0.12. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to query

leaves it up to me to solve the problem. Any help would be appreciated. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Field Count Mismatch Using Code

this error could actually mean? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Locking one table blocks others

g the update method of the connection object, etc. etc. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Blocking One Table Blocks Others

Randy Chrismon wrote: Kim G. Pedersen wrote: BUT just a little hint , u sure it not ur _ (underscore) in table name which is a kind of wildcard that give u trouble ?? This raises an interesting question. I wrote earlier about troubles with mismatch field count and missing field errors. I

Possible MyODBC Bug?

s familiar with LotusScript so as to verify that I'm doing this right; but I have a strong suspicion that this is an ODBC issue. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Multiple Outer Joins

ght or wrong? Or, maybe the better question is, how can this be done? Any and all help appreciated. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Lock Wait Timeout

transactions which, I believe, releases any locks up to that point. I've increased lock_wait_timeout to 75 (what is a reasonable higher end limit for this?) but still get the error. I'm using v.4.0.16 on a RH 9.0 box. Any thoughts on what might be happening here? Thanks. Randy -- MySQL General Ma

Re: Lock Wait Timeout

xisted. In addition, I had already updated 26,000 records so I can't figure out what's wrong with this one particular record. Any thoughts appreciated. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Lock Wait Timeout

,000 records before failing on the one. There is nothing particularly unique or unusual about the one record if failed on except that it was one of the newer documents. Thanks for the thoughts. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Null Values & Foreign Keys

s an empty string... not the null \N. In fact, I'm not sure I can even change this Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Question on 2 different tables

one and Table 2 if the value in table one is not in table 2 then display the number to the screen? Can somebody show me what the sql statement would look like? Thanks Randy

Re: Question on 2 different tables

> SELECT * FROM tableone WHERE value NOT IN (SELECT column FROM tabletwo) > ; > > On Wed, 2004-01-21 at 15:26, Randy Johnson wrote: > > > > This example is simplified. I hope you understand > > > > Each table has one field called ID which

Re: Passwords and ODBC - what am I missing

can easily find the switch by searching the MySQL documentation at their site. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Passwords and ODBC - what am I missing

Oh, and one other thing, you have to create the passwords AFTER you use the switch! That was probably obvious to you but it took me a while to figure out. Randy Randy Chrismon wrote: Ken Brown wrote: Just installed 4.1.1 on windows 2000 with current odbc layer Connects fine with root and no

question about number of processes.

Hello I have a number of servers. I have one running RH7.3 with mysql-3.23.56-1.73 one running RH9 with mysql-3.23.58-1.9 My question is when i do a ps -ef on RH7.3 a get a number of /usr/libexec/mysqld on RH9 i only get one. can someone please explain why. does RH9 display thread differe

insert hang problem on Solaris 8

et more debug data. The mysql software was built with gcc 3.2.2, again, on solaris 8. If anyone's got any suggestions let me know! Thanks! Unfortunately I'm gonna have to restart this sooner than later. :/ -Randy "Swiss American Securities Inc. MMS " ma

Re: insert hang problem on Solaris 8

It looks like my MYI file was seriously corrupted, beyond myisamchk being able to do a thing with it. Has anyone seen this before on Solaris 8? Fortunately the data was trashable but when this hits production it wont always be. Thanks.. Randy On Wed, 2003-06-18 at 21:46, Nils Valentin wrote

RE: Long Running Queries

SELECT or UPDATE a single row. You might get better results from this list if you include your table structure and your queries along with your question. Randy Clamons Systems Programming Astro-auction.com > Original Message > From: "Danny Willis" <[E

Re: MySQL v ASP problem

ively recently, but it seems likely that if you add the ",3,3" to the second rs.Open statement your app will behave properly. Randy Clamons Systems Programming Astro-auction.com > Original Message > From: "J.R. Bullington" <[EMAIL PROTECTED

Replication Issue

provide you with any other information? Thanks! Randy Here is output from Show Slave Status \G mysql> show slave status \G *** 1. row *** Slave_IO_State: Waiting for master to send event Master_Host: localh

RE: Replication Issue

eplication started in log 'www-bin.001' at position 4 [EMAIL PROTECTED] mysql5]# -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 12:21 PM To: [EMAIL PROTECTED] Subject: Re: Replication Issue "Randy Johnson" <[EMAIL

RE: Replication Issue

Does this table say that mysql 3.23.33 and up is not compatible to replicate to a mysql 5.0 slave? Thanks! Randy -Original Message- From: Egor Egorov [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 12:21 PM To: [EMAIL PROTECTED] Subject: Re: Replication Issue "

RE: Replication Issue

Here is the url sorry: http://dev.mysql.com/doc/mysql/en/Replication_Compatibility.html -Original Message- From: Randy Johnson [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 27, 2004 2:07 PM To: [EMAIL PROTECTED] Subject: RE: Replication Issue Does this table say that mysql

Building new db linux box, Hardware questions

Hello, I am building a new linux box , just to be an mysql server I have a couple of questions. 1) would it be better to go brandnew with a single processor or like a quad p4 that's a year or two old. 2) I am going to running raid 5, so I assume that I should run scsi drives? 3) my database i

Re: Alias query problem in 4.1.7?

ter. MySQL doesn't act any differently no matter which way you do it. Randy Clamons Systems Programming Astro-auction.com > Original Message > From: "Rhino" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED], [EMAIL PROTECTED], [EMAIL PROT

Help getting mysqld to read my my.cnf on start from init.d on mandrake 10.1 and mysql 4

nded That part that confuses me is in the script /etc/rc.d/init.d/mysqld (I put in some debug echos to see where it is exiting) When I run the startup it print "2" But I am not failure with /usr/bin/my_print_defaults Thanks for any help! Randy ==

RE: moving DB from one box to another.

Sorry, When I do the mysql dbname < oldbox.sql I get the error message It creates mysqldump dbname -h oldbox > oldbox.sql fine Thanks -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 15, 2004 11:25 PM To: Randy Paries; [EMAIL PRO

RE: (FIXED...)moving DB from one box to another.

Thanks for all your help FYI, I had to add this to the my.cfg set-variable= max_allowed_packet=16M Randy -Original Message- From: William R. Mussatto [mailto:[EMAIL PROTECTED] Sent: Thursday, December 16, 2004 11:55 AM To: [EMAIL PROTECTED] Subject: Re: moving DB from one box to

moving DB from one box to another.

hello, I have built a new DB box. Orig db is mysqld Ver 3.23.58 New DB is mysqld Ver 4.0.20 I want to move the data from one box to another. I have a couple of really large tables with longtext fields. This data is a bunch of HTML My plan was to do a mysqldump dbname -h oldbox > oldbox.sql then

Query help

get these rows a group at a time? There is also could be where clauses Thanks for any direction Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Trying fulltext search

es where description like '%bird%'; I get records back, but if I try to do SELECT * FROM community_files WHERE MATCH (description) AGAINST ('bird' ); I get nothing back I am running mysqld Ver 3.23.58 on rh9 Thanks for any help Randy -- MySQL General Mailing List F

Does NULL == ""?

;s a difference between a field with NULL in it and a field with a zero-length ("") string in it. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Does Null == ""?

T NULL default "", ...) and exporting my values from Notes as "" rather than using NULL. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Lotus Notes/Script...

rs but I haven't had time to figure out how to get one system to talk to the other. HTH. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

LOAD Fails on Lost Connection

immediately, so I'm having a hard time believing it's a connection time-out. Any thoughts? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re Does NULL == ""?

hing is a character), many of which contain "" as a value? Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: LOAD Fails on Lost Connection

s mis-leading. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: LOAD Fails on Lost Connection

the SQL files and a small set of data to the list or directly to Egor? Thanks for the help. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Grant to Partially Specified Host

I have several machines and wander from office to office as part of the job. As I read the MySQL docs, I have two choices for granting privileges: grant ... to randy@'%' or grant ... to [EMAIL PROTECTED] The first form is too vulnerable for the folks around here. The second f

Can't Show Warnings

\r\n' -> ; Query OK, 16374 rows affected (20.83 sec) Records: 16374 Deleted: 0 Skipped: 0 Warnings: 69 mysql> show warnings; Empty set (0.00 sec) What am I doing wrong that I can't find out what the 69 warnings are? I'm using 4.1.0 alpha. Thanks. Randy -- MySQL General

Re: Can't Show Warnings

> For LOAD DATA, it works better in 4.1.1, as indicated here: I read that and immediately went looking on the MySQL site for 4.1.1. All I can find is 4.1.0-alpha. Where can I get 4.1.1? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscr

Load Takes Too Long?

I just loaded about 125,000 records, each containing about 30 columns into an empty, newly created, mysql table. It took 56 minutes. Isn't that a little long? The table design was driven, in part, by an existing reporting application. The data to populate the table is being exported from Lotus Not

Structuring a Load File

ement field? Do I include a first field with \N? If the MySQL table has 20 columns with the first being the autoincrement, can my load file be only 19 columns? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[

Connect to 4.1 using MyOBDC

eeper, a C compiler, and learn how to use them to get an OBCD driver that will work with our server? Thanks Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Connect to 4.1 using MyOBDC

s their an environment variable that would do this? This is starting to make me look bad... Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Slow Deletes

created -- although show index says it was. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Composit Key - Is it possible, and if so, what is the syntax?

Try taking out the identifier name for the primary key (pk_foo). The way I read the documentation, MySQL does not support identifiers or names for primary keys although it does for other index types. HTH Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Can't Access DB from MySQLCC

This irritating rather than life-threatening: I can connect to the MySQL database on my Linux box, from my Win2K box, using the command line environment just fine: c:>mysql --protocol=TCP -h host_name -u my_name -p mysql No matter what I try, however, I can't connect using MySQLCC. I always get

Re: Can't Access DB from MySQLCC

MySQL database which also happens to be a 4.0.15 setup on a Win2K desktop. So, I guess it's one of those things where it's both fish and fowl. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Can't Access DB from MySQLCC

and the remote 4.0.15 database. Trying to connect to the 4.1.0 database yields the same upgrade-your-client error message I get with the command line if I leave off the ---protocol=TCP option. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Re: Select statement to get the difference

>I need to know which id is not present in the other table. Stefan: A left join should do it: select t1.id from t1 left join t2 on t1.id=t2.id where t2.id is null I learned this from this mailing list about two weeks ago. HTH. Randy -- MySQL General Mailing List For list archives: h

I need to know which id is not present in the other table.

l 4.1.0 database and to the remote 4.0.15 database WITHOUT using --protocol=TCP. I CANNOT connect the command line to the remote 4.1.0 database without using --protocol=TCP. Passwords are required for root and user IDs in all cases. Very strange. Randy -- MySQL General Mailing List

Re: Wrong Thread: (sorry) I need to know which id is not present in the other table.

Response should have been to problem connecting to 4.1.0 Sorry about that. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Good SQL Cookbook

to combine these two into a single statement so that if I send it all to an outfile, I have a readable report? This is just an example of the kinds of things I'd like to be able to get a handle on through some sort of reference. Thanks, Randy -- MySQL General Mailing List For list archives: htt

MyIsam or InnoDB? (WARNING -- LONG MSG)

ot to MyIsam, that is the question. Thanks and apologies again for the long post. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Unmet Dependency Hell

I installed 4.1.0 alpha from the RPMS on Redhat 9. I had to use --force (or is it --nodeps, I can never remember) because MySQL wants libcrypto and libssl 0.9.6 and Redhat 9 has 0.9.7. First question (coming from that other world) why aren't these dependencies 0.9.6, or greater, instead of being

MyIsam v. InnoDB and other questions

copying the subdir and changing the path in my.cnf? (I forget what the my.cnf option is, but I'll find it.) Somehow, that sounds too easy... Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Lotus Notes/Domino Access MySQL DB

I've been searching the Lotus site and have gotten kind of lost. Does anybody have any experience using Lotus Notes as a front end to a MySQL database? If so, what drivers did you use? JDBC? Lotus's LS:DO? Am I barking up the wrong tree? Thanks. Randy -- MySQL General Mailing Lis

Adding space to /var/lib/mysql

r/lib/mysql to it then permanently mount it as /var/lib/mysql? Or is MySQL somehow going to know that the /var/lib/mysql it's looking at now isn't the one it was looking at an hour ago? Of course, I would have mysql shut down while I pull these shenanigans. Thanks. Randy -- MySQL General M

Error "Cant get stat"

Tried to do a load of data from a file in my home directory on Linux. Got this message: ERROR 13: Can't get stat of '/home/rchrismon/mysql/ArchiveEC02-Invoices.txt' (Errcode: 13) What does this mean and what can I do about it? Thanks Randy -- MySQL General Mailing List For list

Disable/Enable Keys and Duplicate Records

I'm not clear on this. What happens to duplicates under the following scenario? MyISAM table with either (or both!) a primary key or a unique index. Alter table my_table disable keys. Import 200K records. Alter table my_table enable keys. But it turns out there are duplicate records. Does MySQL a

Re: deleting rows which table1.row=table2.row

[EMAIL PROTECTED] wrote: how to delete rows which table1.field=table2.field thanks delete t1 from t1,t2 where t1.field=t2.field at least, that's how I read the manual. Works for me. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.

Connection Time Out

will be appreciated. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Connection Time Out

esktop? Again, using the console on the box hosting MySQL, I get frequent server gone away errors. At the same time, using the console on my laptop but accessing the very same MySQL server over the network, I have no such problems. That seems precisely bass-ackwards to me! ;-) Ra

What provides libmysqlclient.so?

I'm trying to upgrade my KDE setup but it fails on a dependency for libmysqlclient.so. I've looked at all the MySQL rpm files and none of them seem to provide this file. Does anyone know where this one comes from? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: What provides libmysqlclient.so?

Jeremy Zawodny wrote: On Wed, Oct 15, 2003 at 10:46:59PM -0400, Randy Chrismon wrote: I'm trying to upgrade my KDE setup but it fails on a dependency for libmysqlclient.so. I've looked at all the MySQL rpm files and none of them seem to provide this file. Does anyone know wher

Failed Red Hat 9 Dependencies

times but no answers. Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Find non-unique values

m, or web site devoted to SQL questions -- particularly the dialect of SQL spoken by MySQL? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Update Syntax

tty much the same except for the prefix and a where clause on the end of the update. Am I right that I can't do this?? Thanks. Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

My Company DB Wars

on, does MySQL run on the AS400? Randy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

very simple query question

Hello i have a simple query select u.*,p.* from users u, profiles p where u.uname = p.uname and u.level != 0 Is there any tricks to make this use an index. If i do level=0 is uses an index , but != does not. -- MySQL General Mailing List For list archives: http://lists.mysql.com

Stupid newbie question - adding comments for columns & tables?

Apologies for what is a pitifully simple question from someone who has just started using MySQL 4.0. I've looked in the documentation and elsewhere, but can't find the exact syntax for adding comments to columns when creating a table. My attempts at guessing the syntax so far have failed. Tips,

Best practice question

question. 1)there will never be more than two columns 2)the majority of articles will only be one column Does a majority of two empty text fields out way the penalty of a join with a "Column table" Do empty text columns take up much room? Thanks for any help randy smime.p7s Descripti

  1   2   >