Access to MySQL query problem

I'm coverting an Access database to MySQL 4.1.1 and I need help with a near impossible query. In the Access DB I used a stored procedure; I think I should be able to solve this problem with a subselect in MySQL but so far I'm not having any luck. Here's the problem; In my stored precedure query I

Re: Limiting the data returned to just what I need

On Sun, 28 Mar 2004, Scott Haneda wrote: > Client wants a "hitlist" that shows the user data and the associated serial > numbers for a list of users. If the query returns 20 serial numbers, I am > going to get back 19 name, address, state, zip etc rows that I don't need, I > can easily discard th

Limiting the data returned to just what I need

Wonder if there is a more efficient way of dealing with the following... I have a user table and a serial_numbers table User table has name, address, state, zip etc Serial_numbers table has a id and a serial number. Client wants a "hitlist" that shows the user data and the associated serial numb

Re: to_days() error?

hat? curdate( ) + 0, curdate( ) + 7 20040328 20040335 no month i know of has 35 days in it. You're right. But the *number* 20040328 plus 7 *does* equal 20040335. You're thinking that the value of CURDATE() when used in a numeric context is actually a date, right? It's a number. 3.23

Re: need reference for a good book

At 13:41 3/28/2004, A Mathias wrote: >Preferably one that is for begginers to medium and thats covers both mySQL >and PHP > >Thanks I like the Welling & Thomson book: http://tinyurl.com/3cpk5 Start Here to Find It Fast!™ -> http://www.US-Webmasters.com/best-start-page/ -- MySQL General Mailing

Re: to_days() error?

, curdate( ) + 7 20040328 20040335 no month i know of has 35 days in it. 3.23.58 on red hat 7.3 Steve p.s. any tips for a query on today and today +7 days? You can't simply go: curdate() + x like you are trying to, as curdate() returns an integer, and your '+ x' adds o

Re: Create table 'LIKE' ....Error 1064

At 7:48 -0800 3/28/04, Khashan wrote: Hello All, I have MySQL 4.0.16 on Windows 2000 pro. I am trying to create a table in an existing database. according to the manual, I can use one of these statements: 6.5.3 CREATE TABLE Syntax CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_defin

to_days() error?

20040328 20040335 no month i know of has 35 days in it. 3.23.58 on red hat 7.3 Steve p.s. any tips for a query on today and today +7 days? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Create table 'LIKE' ....Error 1064

Hello All, I have MySQL 4.0.16 on Windows 2000 pro. I am trying to create a table in an existing database. according to the manual, I can use one of these statements: 6.5.3 CREATE TABLE Syntax CREATE [TEMPORARY] TABLE [IF NOT EXISTS] tbl_name [(create_definition,...)] [table_options] [select_st

need reference for a good book

Preferably one that is for begginers to medium and thats covers both mySQL and PHP Thanks

QMySQLBackup-Tool

Hello, I have written a little backup tool for mysql databases with a graphical user interface. It is written in Qt and only supports very basic features. Perhaps some of you would like to help makeing it better. It is open source - written with Qt - so it is available on Windows, Linux, Unix a

RE: Getting count(*) with LIMIT in SQL

In 4+ you can use SQL_CALC_FOUND_ROWS flag http://www.mysql.com/doc/en/SELECT.html -Original Message- From: Steffan A. Cline [mailto:[EMAIL PROTECTED] Sent: Sunday, March 28, 2004 8:47 AM To: MySql Subject: Getting count(*) with LIMIT in SQL I have been tinkering with finding the fastes

Getting count(*) with LIMIT in SQL

I have been tinkering with finding the fastest way to do my searches and return less info for faster performance. In a project I have, I build the sql query with information from a form page. The query may look like this: SELECT * FROM masterlist WHERE market LIKE "%%" AND source LIKE "%%" AND cli

Re: Bug in MySQL with Correlated Subqueries?

Are you saying this is a bug which has already been fixed for the next release? In any case, it may be worth noting that the manual says correlated subqueries "are inefficient and likely to be slow. Rewriting the query as a join might improve performance."

Re: 6.5 seconds seems slow for the following search?

On Sat, 2004-03-27 at 13:59, Dan Nelson wrote: > In the last episode (Mar 26), Kyle Renfro said: > > I am testing MySQL as a possible replacement for our proprietary db > > server for several large databases. I really want MySQL but I am > > getting what seems like slow search times. > > > > Does

Re: Multiple-table Update

which ver of mysql are you using? multiple table update is possible only with ver starting from 4.0.4. HTH.. Nitin - Original Message - From: "Laercio Xisto Braga Cavalcanti" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, March 26, 2004 11:39 PM Su

Query-cache questions

Hello, I just upgraded to MySQL 4.0.18. I have a question about the new query-cache. The documentation says: "The FLUSH TABLES statement also flushes the query cache." What does that mean exactly? Does it mean FLUSH TABLES, in effect, is equal to RESET QUERY CACHE, in that it purges the cache? O