Re: Limit and Order by

versions of MySQL had a bug with order by and limit clauses, though... --jeff - Original Message - From: Michelle de Beer [EMAIL PROTECTED] To: Alliax [EMAIL PROTECTED]; mysql list [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 4:39 PM Subject: RE: Limit and Order by you mean mySQL

Re: DateTime Calculations

Try this: select sec_to_time(unix_timestamp(column_two) - unix_timestamp(column_one)) Should give you the elapsed time in hh:mm:ss format. --jeff - Original Message - From: Peter Abilla [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 8:45 AM Subject: DateTime

mysql.sock error

at first when trying to run mysql it did this: [root@shadow mysql]# bin/safe_mysqld --user=mysql [1] 3124 [root@shadow mysql]# Starting mysqld daemon with databases from /var/lib/mysql 021121 02:27:42 mysqld ended [1]+ Donebin/safe_mysqld --user=mysql then, i stopped

Help Transferring Data from MS Access to mySQL

I'm very new to mysql and haven't got much of a background in databases generally, so thanks in advance to any who have the patience to deal with my question. I'm trying to get data from ms access 97 to mysql by exporting to a text file then using the load data command to import it. The data in

Re: displaying a letter based on a query value

select if(captain = 1, 'C', '') from stats where captain 0 and number = $number group by number This returns 'C' whenever the captain field is 1 and '' (empty string) otherwise. --jeff - Original Message - From: Alex Behrens [EMAIL PROTECTED] To: DL Neil [EMAIL PROTECTED]; MYSQL [EMAIL

Re: PHP mysql

with extensions in it [App Mappings] Click Add Under 'Executable' browse and find your php.exe Under 'Extension' put .php or .phtml - or to really throw off the crackers .asp If that doesn't do it for you - I'm out of ideas. :) Jeff - Original Message - From: Bob G [EMAIL PROTECTED

RE: PHP mysql

to the directory that contains php.exe. In other words, you have to tell IIS to parse .php files with php.exe. Hope that helps! Jeff ** Hi guys, I hope you can show me where I am going wrong. I have ASP working with MySQL I have recently tried to install PHP. I

RE: newbie: SQL question

Try this: http://www.devshed.com/Server_Side/MySQL - Hi, I am just a starter. Anyone can suggest me good web resources for learning SQL command that I can use (compatible) with mySQL ? I read from www.mysql.com documentation, but it's not complete ... Well, if you

RE: Multiple MySQL Instances...

only be accessed by them and couldn't be squashed (or even accessed) by other departments. Just a thought! jeff -- Hey All, On Redhat Linux is there an easy way to have an ISP style setup where each user has their own database directory? Long story short, we have to implement

Re: Mysql Innodb performance slow

and insert. (2) drop all indexes on your table(s). rebuild them after loading (this alone can give orders of magnitude improvement) (3) commit every 10,000 records or so. I can load several million rows into our InnoDB tables in a few minutes. good luck jeff Richard Clarke wrote: Jeroen

Re: Mysql Innodb performance slow

statement for every insert. I'm now using JDBC, and havne't explored this yet. I'm coming from the Oracle camp, and have only been using mysql for less than a month. so far, i find it very snappy. I do miss the ability to have stored procedures, triggers and views however. jeff Dan Nelson wrote

show version problem

' works fine. any help you all can give wold be appreciated. thanks jeff mathis -- Jeff Mathis, Ph.D. 505-995-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6http://www.predict.com Santa Fe, NM 87505

Re: Replication Error

RESET MASTER RESET SLAVE This is a handy page to bookmark, if you're doing replication: http://www.mysql.com/doc/en/Replication_SQL.html --jeff - Original Message - From: walt [EMAIL PROTECTED] To: Lewis Watson [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Tuesday, October 22

error executing 'show variables' and 'show table status from [table]'

' works fine. any help you all can give wold be appreciated. thanks jeff mathis -- Jeff Mathis, Ph.D. 505-995-1434 The Prediction Company [EMAIL PROTECTED] 525 Camino de los Marquez, Ste 6http://www.predict.com Santa Fe, NM 87505

Re: Query using the same table twice

AND psh.Visitor = pt2.TeamID; --jeff - Original Message - From: Michael J. Mitchell [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, October 15, 2002 12:24 PM Subject: Query using the same table twice I am trying to make a query that usses the same table twice. I have a table

Re: Query using the same table twice

Yeah, I know. I just meant the comma with the appropriate WHERE clause was equivalent to INNER JOIN with an ON or USING clause. Sorry if that wasn't clear. I prefer the comma operator. By using commas, I was able to get rid of all the parenthesis and simplify the FROM and WHERE clauses. --jeff

Re: Default data dir

You can relocate an entire database with a symbolic link: ln -s /path/to/database/files /var/lib/mysql/database_name --jeff - Original Message - From: Niranjan Patel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 14, 2002 10:50 AM Subject: Default data dir Hello

Re: Default data dir

Not on a per database basis, that I know of. Anybody else? --jeff - Original Message - From: Niranjan Patel [EMAIL PROTECTED] To: Jeff Kilbride [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, October 14, 2002 11:19 AM Subject: Re: Default data dir I get that point

MySQL insert issue related to a unique column

Please do not hesitate to contact us if you have any problems. Jeff Zanzinger Trowbridge and Associates 321-725-2981 (Phone) [EMAIL PROTECTED] 100% Committed to Customer Satisfaction -Original Message- From: Jeff Zanzinger [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 10

Re: How to connect web database from Local machine

http://www.php.net/manual/en/ref.mysql.php - Original Message - From: Vinod Bhaskar [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, October 06, 2002 3:56 AM Subject: How to connect web database from Local machine Hi all, I am having MySQL database on web. (eg., at

RE: myodbc prolbems between linux windows

granted. Host Db User 192.168.0.ntsmaster mysql (all privileges selected) - Original Message - From: John Jacques To: Jeff Bluemel Sent: Saturday, October 05, 2002 6:26 PM Subject: Re: myodbc prolbems between linux windows Ha, I don't recall either

Re: [PHP] recent encrpyt decrypt code... (problems)

PROTECTED] To: Jeff Bluemel [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, October 05, 2002 1:09 PM Subject: Re[2]: [PHP] recent encrpyt decrypt code... (problems) Hi, Sunday, October 6, 2002, 4:20:40 AM, you wrote: JB here is the URL that will give you the php compile info on my website

myodbc prolbems between linux windows

mysql on a linux box (IP 192.168.0.1), and I've got a windows 2000 box that I am trying to connect to with with odbc. I am getting the following error message [MySQL AB][MyODBC] ERROR : Can't connect to MySQL server on 192.168.0.1 (10061) Jeff Bluemel Jeff Bluemel

MySQL and ODBC prolbme

this problem Jeff Bluemel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail

Re: MySQL and ODBC prolbme

well - I can't telnet to that port, but I have a web server up running, and I cannot telnet to port 80 either, but my web browser does work. I am also connecting to it on port 3306 locally. - Original Message - From: Jeremy Tinley [EMAIL PROTECTED] To: 'Jeff Bluemel' [EMAIL PROTECTED

Re: Mysql vs. Oracle and concat '||'

Hi Frank, You can use the concat() function: select concat(numer, ',', text) from Table. The online docs for MySQL contain a great reference for functions: http://www.mysql.com/doc/en/Functions.html --jeff Hi all, I'm a DBA in the Oracle World. I want to make a sql query in mysql

Re: OT: Multiple Referral Levels

COUNT(*), ref_level FROM referrals WHERE ref_id=10 GROUP BY ref_level; Or for everybody at once: SELECT COUNT(*), ref_id, ref_level FROM referrals GROUP BY ref_id, ref_level; Etc... Does this make sense? --jeff - Original Message - From: Daren Cotter [EMAIL PROTECTED] To: MySQL Mailing

Re: 3.23.52 hitting system loads of 25+?

Michael, what compiler/version did you use? Thanks, --jeff - Original Message - From: Michael Bacarella [EMAIL PROTECTED] To: John Stanforth [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, August 31, 2002 6:58 AM Subject: Re: 3.23.52 hitting system loads of 25+? We

RE: Not sure which list to use - this is a real strange one with ODBC

which is version 0.45_15. Regards, Jeff -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Norris, Joseph Sent: Wednesday, August 21, 2002 2:35 PM To: 'Gerald Clark'; Norris, Joseph Cc: Mysql_List (E-mail); Perl Database (E-mail); Perl Web (E-mail); Perl

Re: High volume HEAP table

HEAP tables can have more than one index, but indexes only match = and != -- so you can't use , , etc... Also, comparisons only match the entire index, not the left-most prefix like MyISAM tables. There are a few other quirks, also: http://www.mysql.com/doc/en/HEAP.html --jeff On Sunday 18

Further information re Error 13 updating table structure

-alpha-nt Thanks in advance Jeff Dyer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

Re: subquery syntax

Forget it (at least for the forseeable future) This is the well known MySQL feature that means that MySQL is not even SQL compatible. Argg. Apparently you will have to wait for version 4.1. Subqueries are not supported Jeff - Original Message - From: [EMAIL PROTECTED

Re: subquery syntax

It would, BUT if you have just spent months developing and debugging a generic SQL compatible application, capable of running on MS SQL, Interbase, Access etc and wanted to port it to MySQL, what would you bother rewriting all your queries and go through all the testing again? Jeff

Error updating table structure.

XP Professional, MySQL 4.0.1-alpha-nt. Anyone know what's wrong? What do other people use to edit table structures (and don't say SQL queries because that's not a productive option when compared to MS Access linked to SQL Server. Regards Jeff Dyer Logic Software Design www.logicsoftware.co.uk

Re: 3.23.51 problems

Your /tmp directory is only accessible by root? What distribution are you using? /tmp is normally world readable/writeable. I would think you'd have problems with other software, too, if this wasn't setup correctly. --jeff - Original Message - From: Rob Lambden [EMAIL PROTECTED

Re: date subtraction error

) - TO_DAYS(order_date) AS days_elapsed ... --jeff - Original Message - From: Brandon McCombs [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, July 13, 2002 8:34 PM Subject: date subtraction error Hi, Maybe I'm missing something but I tried solution someone posted for someone else's

Re: Replication - Error reading packet from server: (server_errno=1159)

Yeah, I'm getting these errors all the time on 3.23.51, also. I agree that the slave_net_timeout variable is definitely not being paid any attention. However, I'm not comfortable just upping the net_read_timeout without knowing what other effects it might have. --jeff - Original Message

Re: Replication - Error reading packet from server: (server_errno=1159)

Is there a web-based interface for bug reporting? Or is there a way to use the mysqlbug program when my database machine isn't connected to the internet? Thanks, --jeff - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Mark Hughes [EMAIL PROTECTED] Cc: Nilesh Shah [EMAIL

Replication errors

to up the value or prevent these errors from being logged? Thanks, --jeff sql,query - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: Distorted display of query output in W2K

now know from MySQLFront that it _is_ a display problem only. The actual data appears to be correct. I'd still like to resolve it, however, so if anyone has any further ideas ... Jeff Original Message Follows From: mos [EMAIL PROTECTED] To: Jeff Allen [EMAIL PROTECTED] CC: [EMAIL

Distorted display of query output in W2K

in a distorted display. I've been working from a command prompt window. Pasted below is the output of one session. Is this a bug in the windows version of MySQL, or am I screwing up? Also, is there a free GUI available for the MySQL client? Jeff Allen

Re: Load problems with 3.23.51

. Is there a timeout value I can adjust? It's just annoying to see my error log growing so much with no activity. Thanks, --jeff - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Steven Roussey [EMAIL PROTECTED] Cc: 'Mysql' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, June 23

Re: Understanding relational database setup/construction

relational db system. --jeff - Original Message - From: Timothy J. Luoma [EMAIL PROTECTED] To: MySQL List [EMAIL PROTECTED] Sent: Saturday, June 22, 2002 2:05 PM Subject: Understanding relational database setup/construction I've looked through Google and the MySQL website without luck. I'm

MSAccess to MySQL

running out of ideas. Can anyone please, help me. Thank you for your time! jeff --- [This E-mail scanned for viruses by The Park Net] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

MySQL, ext3 and noatime

Does mounting ext3 MySQL data directories with the noatime option improve performance? I ran across an article that said it really helped with ext2 and was wondering if the same benefits applied with ext3. Thanks, --jeff

Re: replication problems

carefully to remain employed. I tried with both master and slave running mysql-3.23.47-pc-linux-gnu-i686 and then tried moving the slave to 3..23.51 with the same error results. Thanks for any assistance, Jeff Jeff Hill www.HRpost.com Ph: 416-604-7251 Fx: 647-439-1414

INSERT to table from text file

for any in site or comments, Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED

Re: replication problems -- resolution

Just to let you know that when I installed 3.23.51 binary on both Debian Linux boxes, same problem, but when I re-installed the 3.23.49a binary on both boxes the problem went away. Uncertain why. Regards, Jeff Hill At 08:25 AM 18/06/2002 -0400, Jeff Hill wrote: I'm having the same problems

Replication logging

. Right now, it's occurring every 30 seconds, so my log files are growing on my slave machine with no real activity. Any hints on how to up the timeout value or have the server ignore these errors and not log them? My slave_net_timeout value is already set to 3600. Thanks, --jeff sql,query

Error In Tranfer

out of ideas. Can anyone please, help me. Thank you for your time! jeff --- [This E-mail scanned for viruses by The Park Net] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: SET query question (was ENUM query question)

Yes! My apologies; didn't have my coffee this morning. The column is of type SET. Jeff -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 12, 2002 12:50 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: ENUM query question At 12:42

Re: MySQL AB: Need documentation clarification

ensure the key distribution for the table in question was up to date. I've seen a lot of other posts on this list from people who advocate running ANALYZE TABLE on a regular basis. You're saying this in not necessary? Thanks, --jeff

Apache 2.0

Dear Sir or Ms. Is there a stable version of MySQL that runs on Apache 2.0? Thanks for your time. Jeff Whitman Managing Member JW NetSource, LLC Contact Information: Jeff Whitman JW NetSource, LLC PO Box 702 115 East Main

Creating A New Database (NEWBIE)

know a lot of people ask you a lot of dumb questions and, what I ask must be at the top of your, Hey guys, look at this e-mail but, I could really use the help. Thankx so much for reading this, Jeff Hertel --- [This E-mail scanned for viruses by Declude Virus

Re: mysql_pconnect doesn't work in php

process with no persistent connection the first several times. After a while, your connections will level out, but they may (probably will) go as high as the number of webserver processes that are running. That's one major drawback to php's pconnect. --jeff - Original Message - From: Ê© Á

Re: new functions in MySQL ?

Try here: http://www.mysql.com/doc/A/d/Adding_functions.html --jeff - Original Message - From: a a [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 23, 2002 6:14 AM Subject: new functions in MySQL ? Hi, Can we create and add new functions in MySQL with windows NT

Re: SELECT and WHERE clause

You should also get rid of the quotes, so MySQL doesn't have to convert from string to integer: SELECT team_id,name FROM team WHERE deleted != 1 ORDER BY 'name' --jeff - Original Message - From: Steve Buehler [EMAIL PROTECTED] To: Keith C. Ivey [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent

change default root user name?

extra security measure would be to change the name; then someone pounding your server trying all possible password combos with root won't stand a chance. Am I missing anything? Jeff - Before posting, please check: http

RE: change default root user name?

That seems like it should work as well. Just want to make sure that root doesn't have any privileges over and beyond what a regular added user with all privileges would have. I wouldn't think so, but sometimes this is something that's not specifically documented. Thanks! Jeff -Original

replication questions

. Does this make sense? Anyway, I hope I've made this clear enough for someone to jump with answers and comments. Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Best book on MySQL

is why I finally chose MySQL. Thanks again, --jeff - Original Message - From: mos [EMAIL PROTECTED] To: Jeff Kilbride [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 8:14 AM Subject: Re: Best book on MySQL At 04:34 PM 5/14/2002, you wrote: I'd be interested in how

Re: Best book on MySQL

Thanks for the insight. --jeff - Original Message - From: Mike Grover [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 6:07 AM Subject: RE: Best book on MySQL Mainly what hooked me on mySQL was the static record layout for MyISAM tables. I have to import

Re: Problem with DDL

I don't think quoted identifiers are supported in 3.22.x. --jeff - Original Message - From: Steve Edberg [EMAIL PROTECTED] To: Elliot L. Tobin [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, May 13, 2002 3:42 PM Subject: Re: Problem with DDL 'when' is a reserved word: http

Re: Best book on MySQL

Hi Mike, What did you think of Firebird vs. MySQL? I haven't seen any comparisons by people who have used both. Thanks, --jeff - Original Message - From: Michael Grover [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, May 11, 2002 7:25 PM Subject: Re: Best book on MySQL I

Re: NOW()

The first timestamp field in any table is always updated when the row changes: http://www.mysql.com/doc/D/A/DATETIME.html If you don't want this behavior, use a date or datetime field instead. --jeff - Original Message - From: Damnish [EMAIL PROTECTED] To: Edilson Vasconcelos de Melo

Re: Problem with DDL

WHEN is listed as a reserved word: http://www.mysql.com/doc/R/e/Reserved_words.html --jeff - Original Message - From: Elliot L. Tobin [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, May 13, 2002 1:22 PM Subject: Problem with DDL I pulled this DDL from a MySQL server and am

Re: Best book on MySQL

MySQL Paul DuBois New Riders Plus, he's here on the list answering questions... :) --jeff - Original Message - From: Todd Cary [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, May 11, 2002 8:43 AM Subject: Best book on MySQL I need to convert a PHP app from using Interbase

Re: Strategies for maintaining tables calculated from other tables?

MySQL has a column type for that, so you don't have to use an INT or BIGINT: http://www.mysql.com/doc/S/E/SET.html --jeff - Original Message - From: Harald Fuchs [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, May 03, 2002 4:19 AM Subject: Re: Strategies for maintaining tables

Re: ensuring that I'm getting the correct last insert ID

will be fine. --jeff - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, May 02, 2002 8:36 AM Subject: RE: ensuring that I'm getting the correct last insert ID if you are using a connection pool the [close database connection] part of your

Re: Re: How to Count(*) with LIMIT

the entire result set, which is what you are trying to avoid. So, if you want to support more than 5 people on your site, use COUNT(*). --jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: FullText Search 3.23.49-nt

Fulltext search is based on relevance. If the words you're searching for appear in over 50% of the rows, MySQL assumes they aren't relevant because they occur too often. Try inserting more rows with different info in the fields that have the fulltext index -- then try your search again. --jeff

using currentdate in queries

anyone know how we can run this type of query and have it also select the right day? Thanks, Jeff O'Neal Quality Engineering [EMAIL PROTECTED] If you think you can or you think you can't You're right - Before posting, please

Re: select by total goals

Try: SELECT SUM(goals) AS leaders FROM stats GROUP BY [player_field] ORDER BY leaders DESC --jeff - Original Message - From: Alex Behrens [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED] Sent: Tuesday, April 30, 2002 6:55 PM Subject: select by total goals hey guys, I'm working

Re: Problem with JDBC2 driver across databases

First, I would recommend upgrading to the latest release of mm.mysql -- which I think is 2.0.12. You can get the latest from sourceforge: http://mmmysql.sourceforge.net/ 2.0.4 is pretty old now. --jeff - Original Message - From: Alan Jones [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent

subselect query

this? I could probably order descending by the added date and then just LIMIT 1, but I don't think that's very clean. 'mysql --version' returns: mysql Ver 11.15 Distrib 3.23.41, for -freebsd4.4 (i386) Thanks in advance, -- Jeff Shippy Shipman E-Mail: [EMAIL PROTECTED] Computer Science

Re: subselect query

. On Monday 15 April 2002 2:45 pm, Jeff Shipman wrote: I'm trying to do a fairly simple select of a column from a table where the date of that column happens to be the highest value. I tried this: SELECT name FROM products WHERE prod_type='foo' AND added=(SELECT MAX(added) FROM products WHERE

Re: SQL Question...

The other way to do this is with the DATE_ADD function: select [columns] where [date column] DATE_ADD(NOW(), INTERVAL -7 DAY) --jeff - Original Message - From: Chuck PUP Payne [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, April 07, 2002 10:29 AM Subject: Re

Re: DATE_ADD ?

Use a combination of the DATE_ADD function and the NOW function: SELECT DATE_ADD(NOW(), INTERVAL 20 MINUTE) --jeff - Original Message - From: Edilson Vasconcelos de Melo Junior [EMAIL PROTECTED] To: MYSQL [EMAIL PROTECTED] Sent: Monday, April 01, 2002 12:04 PM Subject: DATE_ADD ? Hi

Re: problem with '

http://www.php.net/manual/en/function.addslashes.php http://www.php.net/manual/en/function.stripslashes.php --jeff - Original Message - From: Alex Behrens [EMAIL PROTECTED] To: Son Nguyen [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, March 31, 2002 11:35 AM Subject: Re: problem

Replication and indexing...

and heavily index the slave. Can this be done and, more importantly, are there any problems associated with doing it? I'm not anticipating any CREATE INDEX or DROP INDEX commands on the master. Thanks, --jeff sql,query - Before

auto_increment question

, there are sequence gaps in the idx field. We would like to be able to use those numbers again for incoming clients...Is this possible? Thank you, Jeff _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Help with JOIN query

am assuming both tables have the exact same number of records. Any ideas on how i can do this? Thanks, Jeff SQL query _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp

Re: How can I Sort by Relevance?

Just an aside, the like comparison is case insensitive -- so you don't need the UCASE in this example. like '%A%' will match both A and a. --jeff - Original Message - From: Walter D. Funk [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, March 27, 2002 10:05 AM Subject: How can

Re: Update change values in wrong column

to change both your start and stop columns to DATETIME -- otherwise, the stop column will become the first TIMESTAMP and will begin updating automatically. http://www.mysql.com/doc/D/A/DATETIME.html --jeff - Original Message - From: Shawn McCool [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent

Re: Getting Found Count When Using Limit

Interesting comment in the manual, though, where someone says they tried both methods and found the multiple statements to be faster than SQL_CALC_FOUND_ROWS. --jeff - Original Message - From: Roger Baklund [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Fletcher Sandbeck [EMAIL PROTECTED

random (load-related?) unknown database errors

check the symptoms are gone. The databases clearly haven't moved. What could cause this? Are there any fixes or workarounds? I also see the 99% CPU issue frequently, but as I see in the list archive that hasn't been tracked down yet. -- Jeff DeFouw [EMAIL PROTECTED

Complex query

for this item: 990227 03-08-02 WAITING Is there a good way to do this in one or two queries? Any tips would be most appreciated. Thanks in advance! Jeff Shipman E-Mail: [EMAIL PROTECTED] Systems Programmer Phone: (505) 835-5748 NMIMT Computer Center http://www.nmt.edu/~jeff

will this alter table lock selects?

it is done, I know that it will lock inserts and updates while the alter is running, that's fine with me. query sql -- Jeff Bearer, RHCE Webmaster PittsburghLIVE.com 2002 EPpy Award, Best Online U.S. Newspaper - Before

Re: INSERT ... SELECT not supported?

example of this in Paul DuBois' book MySQL from New Riders. --jeff - Original Message - From: Allon Bendavid [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, March 18, 2002 7:57 PM Subject: INSERT ... SELECT not supported? Hello All- I just read that an Insert ... Select naming

Two questions (combining UPDATE queries and free up locks)

in perl and PHP and would like to be able to free it up through one of these languages but am unsure of how to unlock it in mySQL alone. Jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: About to pull my hair out :o) setting up Connection to MySQL

. This usually contains all the configuration info for the program. There's a section in this file called 'Server configuration' and you should be able to find the host information there. --jeff - Original Message - From: Theresa Messenger [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday

SQL question -- can this be done?

DISTINCT? I've tried a few different things, but haven't been able to get it to work. Does anyone know if this can or can't be done? Thanks, --jeff - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: SQL question -- can this be done? FOUND IT!

, --jeff - Original Message - From: Jeff Kilbride [EMAIL PROTECTED] To: MySQL [EMAIL PROTECTED] Sent: Saturday, March 09, 2002 1:16 PM Subject: SQL question -- can this be done? I have a table with 3 fields: initDate datetime not null id int unsigned not null ipAddress int unsigned

Re: SQL question -- can this be done?

Thanks, Rob. Yeah, I just figured it out myself. I think I convinced myself that it couldn't be that easy! --jeff - Original Message - From: Rob [EMAIL PROTECTED] To: Jeff Kilbride [EMAIL PROTECTED]; MySQL [EMAIL PROTECTED] Sent: Saturday, March 09, 2002 1:26 PM Subject: Re: SQL

Re: [Mysql] Sorry for the reply.

The list has an automatic filter that blocks any message that doesn't contain either sql or query in it. Pain in the butt sometimes -- that's why you'll see sql query at the bottom of a lot of people's emails, or in their signature. --jeff - Original Message - From: Chuck PUP Payne

Re: Re: [ANN] Blue World Announces Lasso vs. PHP White Paper

Ok, now *that's* funny!! :o) Guess Blue World's dev team haven't read the White Paper... --jeff - Original Message - From: James Cox [EMAIL PROTECTED] To: Mysql [EMAIL PROTECTED] Sent: Thursday, March 07, 2002 3:45 PM Subject: FW: Re: [ANN] Blue World Announces Lasso vs. PHP White

Re: Boolean operators doesnt work in fulltext searched (4.0.1)

You need to add the 'IN BOOLEAN MODE' modifier. Try: SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+database +tutorial' IN BOOLEAN MODE); and SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('+database -tutorial' IN BOOLEAN MODE); --jeff - Original Message - From

Re: Query structure puzzle

. --jeff - Original Message - From: John Hughes [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, March 02, 2002 12:32 AM Subject: Query structure puzzle I have a table with approximately 600 rows. Two of the fields are record_date and status Every record

Re: 2 seperate mysql-servers cooperate???

to the central database -- as long as the changes on the laptop don't conflict with other changes someone else may make on your central database. See the doc: http://www.mysql.com/doc/B/i/Binary_log.html --jeff - Original Message - From: Bram Vaessen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent

Re: mysql.sock

), and: /var/tmp/mysql.sock /var/lib/mysql/mysql.sock At least on RedHat -- I'm not sure about SUSE, but it's worth a look. Check these places and see if it exists. If you find it, update your my.cnf file with the correct path. Good luck! --jeff - Original Message - From: Intrex [EMAIL PROTECTED

<    2   3   4   5   6   7   8   9   >