Re: EXPLAIN: Select tables optimized away

Hi Counts are extremely fast and since you have no WHERE statement, it takes the count value straight from the internals and does not look at the tables or an index if I remember correctly. Mike - Original Message - From: Gabriel PREDA [EMAIL PROTECTED] To: mysql@lists.mysql.com

Re: MySQL Perl

Hi Gerald Looks like you need a username Jerry not gjw, here is the format I use to connect. Mike $dsn = DBI:mysql:host=$host_name;database=$db_name return (DBI-connect ($dsn, $username,$password, {PrintError = 0, RaiseError = 1})); - Original Message - From: Gerald Preston

Re: [Bulk] Re: MySQL speed

You have not mentioned the use of a multiple column index, for that matter, no indexes at all. I would suggest a multiple column index in the form of hidden, touser. That index form should speed up your queries and solve the problem. Mike - Original Message - From: Fagyal Csongor

Re: mysql /dbi issues

Hi When building my server I came across a similar situation. The .10 and .14 are builds of the same library but are complied using a different C library when building the kernel. If your kernel was built and needs .14 you should be able to find builds for your kernel. In the end, I tried

Re: oracledump.pl error

Hi Maybe I am missing something. Why not install MySQL on a windows box and use one of those porters. Then just copy your tables to the Linux box. Mike - Original Message - From: J. Allen Crider [EMAIL PROTECTED] To: Rhino [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: February

Re: PHP or Perl?

Hi Mark I can only tell you about my experience from the Perl side of things. The integration to the database is great and the amount of things you can do with the data once you get it in the script is the biggest bonus. My feeling is that a combination of the two would probably be the

Re: connection

Hi Sounds like you need to update your path in your shell profile. Check out the file dot file in your home directory and add the /usr/local/mysql/bin directory to it. Mike - Original Message - From: aaldrik groenewold [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: August 6, 2003

Re: Running two Servers?

Hi Why would you need two servers running when you could just have separate databases?? Is there a reason why these two cannot share?? Mike - Original Message - From: Ola Ogunneye [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: August 7, 2003 8:46 AM Subject: Running two Servers?

Re: ARGGH! - User password problems

Hi Did you remember to flush??? - Original Message - From: Adam Fortuno KOVICK [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: July 31, 2003 4:33 PM Subject: ARGGH! - User password problems All, I've been attempting to assign a password to a user with the following statement:

Re: Books advice

Hi I guess I will plug Paul's books. I have his MySQL book and his MySQL and Perl for the Web. I really enjoyed the second one but the MySQL book was very well written. I also have read Sam's teach yourself MySQL in 21 days which seemed pretty light weight and I never look up anything in

Re: LEFT SELF Join -- LEFT join on same table

Hi Let me take a stab at it. I don't think you need a join at all. Check the syntax but I think you can do it like this. SELECT *,concat(slm,item,cust,year) as result1,concat(slm,item,cust,2003) as result2 from sales where result1!=result2 AND date2001 year would be taken from your date

Re: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR

Hi Your first statement looks ok to me but the one you have below has no space before AGAINST. Otherwise, I cannot see the problem myself. Mike - Original Message - From: Francis Van-Lare [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: July 12, 2003 2:42 AM Subject: MATCH AGAINST ()

Re: mysqldump

Hi Just read this last night. Try mysqldump databasename -u username --password=yourpassword /to/a/directory/dump.sql Mike - Original Message - From: Kalle Saarinen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: July 7, 2003 8:21 AM Subject: mysqldump Hello I'm trying to

Re: Big problem with autoincrementing

Hi First, auto increment is a column type. You set the column to add one to the highest value in that column. If you would like the records to start at 10, either enter you first record with the Client_ID value explicitly set at 10 or enter a dummy MySQL statement like INSERT INTO Clients

Re: Can't drop a database

Hi I really don't have an answer but would question whether MySQL will allow zero db's with it's own grant tables. Usually there is a test db, at least after an install. Why not try adding a database and then try to drop clone_updater??. Mike - Original Message - From: Leo

Re: mysql: bug in update (?)

Hi Your problem lies in your columns. A timestamp field has the special property of recording when a record is created or modified. However, only the first timestamp column in a row is treated this way. I hope this helps. Mike - Original Message - From: Dmitry Kosoy [EMAIL

Re: I thought single UPDATE statements were atomic

Hi You are not defining num so you are adding 1 to 0 to get 1 and you already have that record. Sounds like you need an autoincrement field. Mike - Original Message - From: Mark Rages [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: June 5, 2003 7:52 PM Subject: I thought single

Rating rows only with FULLTEXT

if something might be done in the myisam/ftdefs.h source file to remove the dataset weighting feature. Thanks Mike O'Krongli O'K Web Design -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]