Re: !! Help with query: Where Date = MAX(Date)

On Fri, 2005-02-04 at 09:19, Graham Cossey wrote: > Could someone please offer a little help. > > I have a table like: > > Year, Month, Start_date > 20041020041102 > 20041120041203 > 20041220050104 > 20050120050204 > 20050220050303 > > I need to get the la

RE: !! Help with query: Where Date = MAX(Date)

> > As I'm using 4.0.20 I can't use subqueries so how can I create > a query that > > does this? > > > > SELECT year, month > > FROM `dc_months` > > WHERE start_date = (SELECT MAX(start_date) > > from dc_months > > where start_date <= '20050204') > >

Re: help please : ERROR 2006: MySQL server has gone away

Hello. 4.0.17 is old enough. You may switch to the debug version and attempt to find the clues in debug or trace files. Can you reproduce an error on the latest release (4.1.9 now)? Do you lost connection to the server with other statements, than 'SHOW DATABASES'? Please answer on this questi

Re: !! Help with query: Where Date = MAX(Date)

Graham Cossey wrote: Could someone please offer a little help. I have a table like: Year, Month, Start_date 20041020041102 20041120041203 20041220050104 20050120050204 20050220050303 I need to get the latest Year,Month for a given date, so for example today (

RE : help please : ERROR 2006: MySQL server has gone away

d my mysql user have access to write into my errorlog file and in my directories. David David Marois -Message d'origine- De : Michael Dykman [mailto:[EMAIL PROTECTED] Envoyé : 3 février, 2005 10:02 À : Marois, David Cc : "MySQL List" Objet : Re: help please : ERROR 2006: MySQL

Re: help please : ERROR 2006: MySQL server has gone away

max_allowed_packet - one has client, another has server. > Run mysql with --max_allowed_packet=16M and mysqld with the same value. > May be you have some ulimits which cause such behaviour? > > > -----Message d'origine- > De : Marois, David > Envoyà : 2 fÃvrier, 2005

Re: help please : ERROR 2006: MySQL server has gone away

Hello. Does the problem remain? What is in the error log? Please, send us information about MySQL and operating system versions. There are two variables: max_allowed_packet - one has client, another has server. Run mysql with --max_allowed_packet=16M and mysqld with the same value. May be yo

Re: help please : ERROR 2006: MySQL server has gone away

sage- >> From: Gleb Paharenko [mailto:[EMAIL PROTECTED] > >> Sent: woensdag 2 februari 2005 12:46 >> To: [EMAIL PROTECTED] >> Subject: Re: help please : ERROR 2006: MySQL server has gone away >> >> Hello. >> >> What's the value of the inter

Re: help please : ERROR 2006: MySQL server has gone away

L PROTECTED] > >> Sent: woensdag 2 februari 2005 12:46 >> To: [EMAIL PROTECTED] >> Subject: Re: help please : ERROR 2006: MySQL server has gone away >> >> Hello. >> >> What's the value of the interactive_timeout system variable? See:

Re: help please : ERROR 2006: MySQL server has gone away

Hello. I've asked you about interactive_timeout, not wait_timeout. Mark <[EMAIL PROTECTED]> wrote: >> -Original Message- >> From: Gleb Paharenko [mailto:[EMAIL PROTECTED] >> Sent: woensdag 2 februari 2005 12:46 >> To: mysql@lists.mysql.com

RE: help please : ERROR 2006: MySQL server has gone away

> -Original Message- > From: Gleb Paharenko [mailto:[EMAIL PROTECTED] > Sent: woensdag 2 februari 2005 12:46 > To: mysql@lists.mysql.com > Subject: Re: help please : ERROR 2006: MySQL server has gone away > > Hello. > > What's the value of the interact

Re: help please : ERROR 2006: MySQL server has gone away

Hello. What's the value of the interactive_timeout system variable? See: http://dev.mysql.com/doc/mysql/en/server-system-variables.html http://dev.mysql.com/doc/mysql/en/gone-away.html "Marois, David" <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding 7bit, charset: iso-8859-1, 19

Re: Help with a query using multiple LEFT JOINS

In article <[EMAIL PROTECTED]>, "Graham Cossey" <[EMAIL PROTECTED]> writes: > I'm hoping someone can help with a little problem I'm having with a query. > In the query below I wish to return as least one row per tbl1, however I am > only getting rows where there is at least an entry for tbl2 : >

RE: Help with a query using multiple LEFT JOINS

Thanks Tom Doing as you suggested as well as applying the "st.group = 'B'" in the tbl4 ON achieved what I wanted. Graham > -Original Message- > From: Tom Crimmins [mailto:[EMAIL PROTECTED] > Sent: 01 February 2005 00:03 > To: Graham Cossey > Cc: mysql@

RE: Help with a query using multiple LEFT JOINS

If you mean that you want to get a row even if tbl2 does not have a matching row for dcode, then move the conditions into the ON clause. Example based off of what you had: SELECT FROM tbl1 as d LEFT JOIN tbl2 as r ON (d.dcode=r.dcode AND r.mcode='AB' AND r.year=2004 AND r.month IN (1,2,3,4,5,6,7,

Re: help please !! [MySQL][ODBC 3.51Driver][mysqld-4.1.8-nt-log]Unknow MySQL error

Hello. You can enable logging on the server. See: http://dev.mysql.com/doc/mysql/en/log-files.html You need the error log, query log, slow log. But be careful! Heavy loaded server can produce a lot of messages and your files will grow quickly. If you use InnoDB, you can enable the InnoD

Re: Help with MySQL 4.1.8 Not starting under Fedora Core3

> When I su mysql and run mysqld I get this: > 050107 14:09:12 [Warning] Asked for 196608 thread stack, but got 126976 > mysqld: Can't create/write to file '/tmp/ib5ArcLz' (Errcode: 13) > 050107 14:09:12 InnoDB: Error: unable to create temporary file; errno: 13 > 050107 14:09:12 [ERROR] Can't init

Re: Help with MySQL 4.1.8 Not starting under Fedora Core3

Permission problem: [EMAIL PROTECTED] santino]$ perror 13 Error code 13: Permission denied Check /tmp permission and check /usr/local/mysql/data/ user and group of this directory must be mysql:mysql if not: chown -R mysql:mysql /usr/local/mysql/data/ Santino PS: /usr/local/mysql is a symbolic lin

Re: Help with a join query please!

A.Project_ID = 11 ORDER BY User_Firstname; Thanks, Shaun From: [EMAIL PROTECTED] To: "shaun thornburgh" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com,[EMAIL PROTECTED] Subject: Re: Help with a join query please! Date: Wed, 29 Dec 2004 15:58:43 -0500 "shaun thornburgh" <[EMA

Re: Help with a join query please!

Shawn Green Database Administrator Unimin Corporation - Spruce Pine > > >From: [EMAIL PROTECTED] > >To: "shaun thornburgh" <[EMAIL PROTECTED]> > >CC: mysql@lists.mysql.com,[EMAIL PROTECTED] > >Subject: Re: Help with a join query please! > >Date: Thu, 23

RE: Help with an UPDATE query please

[snip] I am using version 3.23.54, unfortunately I am unable to supply test data but basically I need to update the Task_ID column for the Bookings table so that it is the same as the Task_ID for Tasks and the Task_Name is 'Booking' and the Bookings Project_ID is the same as the Tasks Project_ID

RE: Help with an UPDATE query please

<[EMAIL PROTECTED]> To: "shaun thornburgh" <[EMAIL PROTECTED]>, Subject: RE: Help with an UPDATE query please Date: Wed, 29 Dec 2004 13:53:07 -0600 [snip] I am having trouble with an UPDATE query. I have three tables as defined below. My database holds data for bookings. Each booki

Re: Help with a join query please!

ticular project. Thanks again for your help! From: [EMAIL PROTECTED] To: "shaun thornburgh" <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com,[EMAIL PROTECTED] Subject: Re: Help with a join query please! Date: Thu, 23 Dec 2004 10:14:24 -0500 So -- what's the field that relates a boo

RE: Help with an UPDATE query please

[snip] I am having trouble with an UPDATE query. I have three tables as defined below. My database holds data for bookings. Each booking relates to a project. Each project has many tasks, one of which is a booking. I have now added the column Task_ID to the bookings table. How can I update all t

Re: Help: Index performance on moderately sized table

Well, obviously I would try creating compound indexes. So one index would be created, author and the other would be author, created. But it seems like you tried that. You say you adjusted the max_seeks_for_key, but have you adjusted the sort_buffer? Sorting does seem to be your bottleneck and t

Re: Help upgrading from 4.1.1 to 4.1.8

Hello. At first you should look through all changes from 4.1.1 to 4.1.8 listed in manual. There are extra steps which required during upgrade in some cases. >I haven't found anything in the documentation that will help me upgrade >mysql from 4.1.1 to 4.1.8. We have several databases runn

Re: Help with a join query please!

uces exactly the same result... > > Any ideas? > > >From: Sasha Pachev <[EMAIL PROTECTED]> > >To: shaun thornburgh <[EMAIL PROTECTED]> > >CC: mysql@lists.mysql.com > >Subject: Re: Help with a join query please! > >Date: Tue, 21 Dec 2004 14:57:

Re: Help with a join query please!

Hi, Thanks for your reply but that produces exactly the same result... Any ideas? From: Sasha Pachev <[EMAIL PROTECTED]> To: shaun thornburgh <[EMAIL PROTECTED]> CC: mysql@lists.mysql.com Subject: Re: Help with a join query please! Date: Tue, 21 Dec 2004 14:57:43 -0700 shaun thornbur

Re: Help with a join query please!

shaun thornburgh wrote: Hi, I have (among others) three tables in my database that i am struggling with a join query on. The database holds dates for Bookings. If Users are Allocated to a particular Project they can be booked. However if a user is booked but then unallocated I want to be able to

Re: HELP: utf8 chracters replace by ?

Hello. There a lot of things that can produce such unexpected behavior (even wrong codepage in you browser). At first you should carefully read pages from manual related to character sets. See: http://dev.mysql.com/doc/mysql/en/Charset.html "Andy Low" <[EMAIL PROTECTED]> wrote: > Hi, >

Re: Help with a join query please

From: "Rhino" <[EMAIL PROTECTED]> To: "shaun thornburgh" <[EMAIL PROTECTED]>,<[EMAIL PROTECTED]> Subject: Re: Help with a join query please Date: Thu, 16 Dec 2004 14:59:48 -0500 - Original Message - From: "shaun thornburgh" <[EMAIL

Re: Help with a join query please

- Original Message - From: "shaun thornburgh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Thursday, December 16, 2004 2:02 PM Subject: Help with a join query please > Hi, > > I have (among others) three tables in my database that i am struggling with > a join query on. The databas

Re: Help me optimize this query

>Thanks for your inputs Eric. >I tried this but it couldn't give me any insight abt >how can optimize this >for space saving of temp tables. >Maybe I am not expert enough to interpret this output, >so here it is - >- Manish Seeing the explain log, it looks to me like you donot have any index def

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

do it the correct way... thanks What did mysqld --help report for the set of option files that mysqld will read? -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 15, 2004 11:08 AM To: Randy Paries; [EMAIL PROTECTED] Subject: Re: Help getting mysqld to re

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

At 11:02 -0600 12/15/04, Randy Paries wrote: Hello, I am building a new DB box. The box is mandrake 10.1 and mysql 4.0.20 All my other boxes are RH9 and mysql 3 The one problem I am having is they appear to do the my.cnf differently There was no my.cnf in the /etc dir, so I created one from my-huge

Re: Re: Help me optimize this query

>Thanks for your inputs Eric. >I tried this but it couldn't give me any insight abt >how can optimize this >for space saving of temp tables. >Maybe I am not expert enough to interpret this output, >so here it is - >- Manish Seeing the explain log, it looks to me like you donot have any index def

Re: Help Required!

Check here. You will find examples here. http://www.geocities.com/jahan.geo [EMAIL PROTECTED] wrote: Hi, I am building the insert string for inserting into particular table t1 using C program. The below string is stored in a variable. say sqlstmt = 'INSERT INTo T1 values(:id,:ename);' The values fo

Re: Help interpreting SHOW INNODB Status Message

L PROTECTED]> Vastaanottaja: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Lähetetty: Wednesday, December 08, 2004 12:16 AM Aihe: Re: Help interpreting SHOW INNODB Status Message Heikki, Thanks for the input. Right now we can't move to 4.1, we're stuck with 4

Re: help me pls

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Wu_Yang_SKZ, JPcommon wrote: > java.sql.SQLException: Communication failure during handshake. Is there a > server running on localhost:3306? > at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java:275) > at org.gjt.mm.mysql.Connection.(Connection.

Re: Help me optimize this query

(0.00 sec) Any inputs??? TIA, - Manish - Original Message - Sent: Saturday, December 04, 2004 10:26 AM Subject: Re: Help me optimize this query > If you change the update to a select you can use explain to see it's > execution path just like you would with a normal sel

Re: Help interpreting SHOW INNODB Status Message

p MyISAM > tables > http://www.innodb.com/order.php > > > - Original Message - > From: "Emmett Bishop" <[EMAIL PROTECTED]> > Newsgroups: mailing.database.myodbc > Sent: Tuesday, December 07, 2004 5:44 PM > Subject: Re: Help interpreting SHOW INNOD

Re: Help interpreting SHOW INNODB Status Message

t Bishop" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, December 07, 2004 5:44 PM Subject: Re: Help interpreting SHOW INNODB Status Message Heikki, We're using MySQL 4.0.20. Here's the full output: = 041207

Re: Help interpreting SHOW INNODB Status Message

Heikki, We're using MySQL 4.0.20. Here's the full output: = 041207 8:33:26 INNODB MONITOR OUTPUT = Per second averages calculated from the last 15 seconds -- SEMAPHORES -- OS WAIT ARRAY INFO: reservation coun

Re: Help interpreting SHOW INNODB Status Message

Emmett, - Original Message - From: "Emmett Bishop" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, December 07, 2004 6:01 AM Subject: Help interpreting SHOW INNODB Status Message Howdy all, We're having concurrency problems with a table in our database and I'm not

Re: Help me optimize this query

If you change the update to a select you can use explain to see it's execution path just like you would with a normal select. The rows returned are the rows that would be matched by the update query. Example: explain select * from t1, t2 where t1.YYY=t2. and t2. like '%X%'; Optimize the q

Re: Help with installation: MySQL, FreeBSD 5, Sparc64

cd /usr/ports/databases/mysql41-server && make install clean - Original Message - From: "Dan Nelson" <[EMAIL PROTECTED]> To: "Richard C Komatz" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, December 01, 2004 12:00 PM Subject

Re: Help with installation: MySQL, FreeBSD 5, Sparc64

In the last episode (Dec 01), Richard C Komatz said: > I am having trouble installing MySQL on my system (Netra X1 - UltraSparc II > - FreeBSD 5). I can't find any documentation on how to install for this > system, nor can I find the binaries. cd /usr/ports/mysql41-server ; make install should be

Re: help with SQL (join?) query

MAIL PROTECTED]> Sent: Tuesday, November 30, 2004 7:08 PM Subject: Re: help with SQL (join?) query No offense but your response has created more confusion about this.. Here is a more simple diagram for what I'd like to get from an SQL query: Table users: uid username 1 john 2 jim

Re: help with SQL (join?) query

How so? Is there something you didn't understand? Peter's solution is the right idea. You need to join the groups table to the users table once to get the creatorname and again to get the ownername. Maybe it will be clearer if we rewrite the query to make the join conditions explicit: SEL

Re: help with SQL (join?) query

No offense but your response has created more confusion about this.. Here is a more simple diagram for what I'd like to get from an SQL query: Table users: uid username 1 john 2 jim 3 mary Table groups: id name creator owner 1 test 11 2 abc 1

Re: help with SQL (join?) query

Kris zoob-at-doomstar.com |Lists| wrote: I am trying to join to tables: users: uid name 1 john 2 jim 3 mary groups: groupid groupname groupowner groupcreator 1 test1 1 1 2test2 1 2 3

Re: Help optimizing query

On Tue, Nov 23, 2004 at 09:55:15PM +0100, [EMAIL PROTECTED] wrote: > * Jesse Sheidlower > [...] > > CREATE TABLE `citation_subject` ( > > `id` int(11) NOT NULL auto_increment, > > `citation_id` int(11) NOT NULL default '0', > > `subject_id` int(11) NOT NULL default '0', > > PRIMARY KEY (`i

Re: Help optimizing query

* Jesse Sheidlower [...] > CREATE TABLE `citation_subject` ( > `id` int(11) NOT NULL auto_increment, > `citation_id` int(11) NOT NULL default '0', > `subject_id` int(11) NOT NULL default '0', > PRIMARY KEY (`id`), > KEY `citation_id` (`citation_id`,`subject_id`) > ) Try adding an index

Re: Help needed in creating primary key ,foreign key on a varchar datatype colum

I just checked the definition of CREATE TABLE in the MySQL manual and I didn't see anything that suggests that primary keys based on VARCHAR columns need to be treated differently than other column types in MySQL. However, when I tried to create

Re: Help needed in creating primary key ,foreign key on a varchar datatype colum

Dayakar, - Original Message - From: ""Dayakar"" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Sunday, November 21, 2004 7:39 AM Subject: Help needed in creating primary key ,foreign key on a varchar datatype colum --=_NextPart_000_000B_01C4CFBA.91C9BA80 Content-Type:

RE: Help with query performance anomaly

Thanks for the advice Steven, I'll bear it in mind and do some reading. Graham > -Original Message- > From: Steven Roussey [mailto:[EMAIL PROTECTED] > Sent: 13 November 2004 02:52 > To: 'Graham Cossey' > Cc: [EMAIL PROTECTED] > Subject: RE: Help with qu

RE: Help with query performance anomaly

For production systems, I would never let the mysql optimizer guess a query plan when there are joins of big tables and you know exactly how it should behave. Once you think a query is finished, you should optimize it yourself. Use STRAIGHT_JOIN and USE INDEX as found here in the manual: http://de

RE: Help with query performance anomaly (SOLVED)

It turns out that it appears to be a data discrepancy that caused the query optimiser to, well, not optimise. I thought the main table (r) with 3million records would be the problem, but it was table p with 3100 records on the live server and 3082 records on my dev pc that caused the problem. Alt

RE: Help with query performance anomaly

[snip] > > Have just run 'top' on the live server... > > Before running the query I get: > > 13:56:09 up 45 days, 11:47, 1 user, load average: 0.00, 0.28, 0.44 > 24 processes: 23 sleeping, 1 running, 0 zombie, 0 stopped > CPU0 states: 0.0% user 0.0% system0.0% nice 0.0% iowait 100.0% >

RE: Help with query performance anomaly

^ Does not look good to me !! Comments? Advice? Thanks Graham > -Original Message- > From: Jamie Kinney [mailto:[EMAIL PROTECTED] > Sent: 11 November 2004 19:25 > To: Graham Cossey > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: Help with query performance ano

Re: Help with query performance anomaly

How do the OS statistics look on both boxes. Do top, sar, vmstat or iostat show any CPU, memory or I/O performance issues? Does anything odd appear in the /var/log/messages file? -Jamie On Thu, 11 Nov 2004 18:42:48 -, Graham Cossey <[EMAIL PROTECTED]> wrote: > > > [big snip] > > > > > Th

RE: Help with query performance anomaly

[big snip] > > These are two different plans. Your development machine is using > the index > yr_mn_pc on the r table and is joining that table last. On your > production > server, the r table is joined second and is joined by the index PRIMARY. > Let me know how the ANALYZE TABLE I suggested in

RE: Help with query performance anomaly

Response at end "Graham Cossey" <[EMAIL PROTECTED]> wrote on 11/11/2004 12:19:17 PM: > > Thanks Shaun > > > > EXPLAIN shows the same 'possible keys' for each table but 'key' and > > 'key-len' columns are different, as are the 'rows' as well of course. > > > > I guess this points to a probable

RE: Help with query performance anomaly

> Thanks Shaun > > EXPLAIN shows the same 'possible keys' for each table but 'key' and > 'key-len' columns are different, as are the 'rows' as well of course. > > I guess this points to a probable difference in key definitions? > > Can 2 installations with the same table definitions produce differe

RE: Help with query performance anomaly

ke this? Maybe something in the configs? > > Thanks > > Graham > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > > Sent: 11 November 2004 16:28 > > To: Graham Cossey > > Cc: [EMAIL PROTECTED] > > Subject: Re

RE: Help with query performance anomaly

le definitions produce different results like this? Maybe something in the configs? Thanks Graham > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 11 November 2004 16:28 > To: Graham Cossey > Cc: [EMAIL PROTECTED] > Subject: Re: Help with

Re: Help with query performance anomaly

What does EXPLAIN show for the query on both systems? (I am wondering if you may have an index on your development system that you do not have on your production server.) Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Graham Cossey" <[EMAIL PROTECTED]> wrote on 11/11/200

Re: Help using SSL from VB client, using MyODBC

Hello. I'm not a VB expert, but some notes about methods of establishing such connections can be found at: http://dev.mysql.com/doc/mysql/en/Windows_and_SSH.html http://dev.mysql.com/doc/mysql/en/mysql_ssl_set.html William Blair Wagner <[EMAIL PROTECTED]> wrote: > I'm kind of new t

Re: help with dbf and dbt

On Mon, 8 Nov 2004, José Antonio Viadas O. wrote: > Can someone help me, i have two files one dbf and one dbt thant i need to > import it in mysql, can someone help me telling me how can i do this. Have a look at dbf2mysql (http://dbf2mysql.soourceforge.net) - this will import .dbf files. I'm not

Re: Help with SLOW query

You are always getting "filesort, where and temporary" because the optimizer cannot use an index. Both your WHERE clause and your ORDER BY clause use computed values. None of those values exist in an index because you calculate them for every query. What I did below is not a refactoring, just

RE: Help with a DATETIME Query Please Using 3.23.54

From: shaun thornburgh [mailto:[EMAIL PROTECTED] > Hi, > > The following query works out the amount of hours a user has > been booked for on a particular day: > > SELECT > (SUM(((DATE_FORMAT(B.Booking_End_Date, "%k") * 60 ) + > DATE_FORMAT(B.Booking_End_Date, "%i")) - > ((DATE_FORMAT(B.Booking

Re: Help! Question on backup

Hi. Windows filesystem is not case sensitive. See: http://dev.mysql.com/doc/mysql/en/Name_case_sensitivity.html Stuart Felenstein <[EMAIL PROTECTED]> wrote: > I apologize for the missing information. > First the server was on 4.0.20 now on 4.0.22. Apache > 1.3.x not sure of the linu

Re: Help! Question on backup

Hi. How did you backed up the data? Stuart Felenstein <[EMAIL PROTECTED]> wrote: > My database got hosed last night due to some version > upgrade. > Anyway an older copy was restored on the server. I > have a more recent backup on my local machine. > However, when I have done the data

Re: Help! Question on backup

Hi. Also check the value of lower_case_table_names. Stuart Felenstein <[EMAIL PROTECTED]> wrote: > My database got hosed last night due to some version > upgrade. > Anyway an older copy was restored on the server. I > have a more recent backup on my local machine. > However, when I have

Re: Help! Question on backup

I apologize for the missing information. First the server was on 4.0.20 now on 4.0.22. Apache 1.3.x not sure of the linux The local machine is windows xp with mysql v. 4.0.20a I did the data transfer running Navicat, so that may not be so clear to anyone, but the only options that were enabled:

Re: help with proper conditions and indexes needed

correction so I think I don't understand that and I decided to write to the list with respect DeRyl - Original Message - From: <[EMAIL PROTECTED]> To: "DeRyl" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, October 27, 2004 3:53 PM Subject: Re

Re: help with proper conditions and indexes needed

I really hate to do this to you but if I tried to answer your questions I would be copying from the book anyway. There is a section in the manual that deals specifically with query optimization. It covers index creation and usage, when an order by will and won't use and index and a bunch of ot

Re: Help with query

Shawn, Thank you very for your answer. Actually, I thought that a main SELECT couldn´t be filtered by the WHERE clause refered to a field in a LEFT JOIN. Now, looking better in the JOIN documentation I see this issue. Thank´s, Ronan This is a very FAQ: SELECT t1.* FROM TABLE_1 t1 LE

Re: Help with query

This is a very FAQ: SELECT t1.* FROM TABLE_1 t1 LEFT JOIN TABLE_2 t2 ON t1.id = t2.table1_id WHERE t2.id is null Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Ronan Lucio" <[EMAIL PROTECTED]> wrote on 10/27/2004 10:12:42 AM: > Hi, > > I have two tables: > > TAB

Re: Help with query

SELECT `TABLE_1`.* FROM `TABLE_1` JOIN `TABLE_2` USING (`id`) WHERE `TABLE_2`.`id` IS NULL Asuming that the "reference" is the id field... Regards, Jigal. - Original Message - From: "Ronan Lucio" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, October 27, 2004 3:12 PM Subject

Re: Help with ALTER TABLE error

John Stile <[EMAIL PROTECTED]> wrote: > I have Mysql Cluster (version 4.1.16-gama) running, and now I need to > convert database tables from engine MyISAM to NDBCLUSTER, but ALTER > TABLE fails on some tables. > > Does anyone know what the error means or how to get around it? > > mysql> use data

Re: Help with ALTER TABLE error

On Tue, 2004-10-19 at 21:42, John Stile wrote: > I have Mysql Cluster (version 4.1.16-gama) running, and now I need to Sorry, I meant version mysql-max-4.1.6-gamma-pc-linux-i686. signature.asc Description: This is a digitally signed message part

Re: help with table structure

Also International Numbers Have you seen any address books accomodating 3 digit Country Code?? Martin- - Original Message - From: <[EMAIL PROTECTED]> To: "Chris W. Parker" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, October 12, 2004 1:20 PM

RE: help with table structure

You were wondering about a separate phone number table? Most phone numbers (esp. cell phones and home phones) belong to only one person. If that were your only data, then creating a new table may not make sense. However, dozens of people can share a common number (like in a large office. Each p

Re: help with table structure

Chris W. Parker wrote: interesting you say that because i was going to do this same thing except not as completely as i probably should (which i think is what you are suggesting). what i mean is, my extra table of addresses was going to be merely shipping addresses for the customer and nothing else

RE: help with table structure

Justin Smith on Tuesday, October 12, 2004 8:48 AM said: > What you have so far looks good, but what I learned from doing my > ecomm project was that it is beneficial to make a separate table for > anything and everything that you might have more than one of... > Add

Re: help with table structure

What you have so far looks good, but what I learned from doing my ecomm project was that it is beneficial to make a separate table for anything and everything that you might have more than one of... Addresses, phone numbers, and email addresses are all great candidates for breaking out into an

Re: Help for a query with MYSQL 3.23.58

First, let's just consider finding the id_products in the products_value table which match the given list of id_values. Here are 2 ways to do accomplish that: 1) Join the table to itself once for each member of the list, requiring the id_value for each copy to match one of the values in your l

RE: Help for a query with MYSQL 3.23.58

Michele on Friday, October 08, 2004 4:57 PM said: > Have I well understood the meaning of your answer ? It was meant as a joke and not a serious response to your question. I apologize for the confusion. Chris. -- MySQL General Mailing List For list archives: htt

Re: Help for a query with MYSQL 3.23.58

> 2) I'm looking for id_product that can contemporaneously satisfy more > than an id_value (NOT ONLY ONE!!) contemporaneously? that's got be one of the best made up wor... wait what? you mean it's a real word? http://dictionary.reference.com/search?q=contemporaneously I'm not sure to understand

RE: Help for a query with MYSQL 3.23.58

Michele on Friday, October 08, 2004 3:23 PM said: > 2) I'm looking for id_product that can contemporaneously satisfy more > than an id_value (NOT ONLY ONE!!) contemporaneously? that's got be one of the best made up wor... wait what? you mean it's a real word? http:

Re: Help with PHP to MySQL db connection

This is really just a PHP question, I think. Are MySQL and Apache running on the same machine? What version of MySQL are you running? Typically, you need a PHP mysql_connect() call including the MySQL host, username, and password. You only list the host above. With a default installation of MySQ

Re: help!!!!!!!!!!

You're probably going to need to create some indexes on your tables. If you have no indexes, MySQL can only do a full tablescan. See the manual for the syntax of the statement that creates an index. Rhino - Original Message - From: "Sven" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sen

Re: help!!!!!!!!!!

Sven, This warning is telling you there your query is going to execute very slowly. The EXPLAIN that it talks about is mentioned in the manual here: http://dev.mysql.com/doc/mysql/en/EXPLAIN.html You should also search the manual for sections on query optimization and index usage. Here is anoth

Re: Help regarding securing data files

On Tue, 21 Sep 2004, VijayKumar Dogra wrote: > is there any way by which I can secure my data files such that even if > the data files are copied to other mysql server it cannot be accessed. > Some form of password protection or similar ? The short answer is: 'no'. You have to protect your server

Re: Help with query

Shawn > SELECT CityName, Count(ClientID) as ClientCount > FROM City > INNER JOIN Client > on City.CityID = Client.CityID > GROUP BY CityName > HAVING ClientCount > 30; Thank you very much, It should solve by problem... :-) Ronan -- MySQL General Mailing List For list archives: http:/

Re: Help with query

SELECT CityName, Count(ClientID) as ClientCount FROM City INNER JOIN Client on City.CityID = Client.CityID GROUP BY CityName HAVING ClientCount > 30; Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Ronan Lucio" <[EMAIL PROTECTED]> wrote on 09/10/2004 11:14:37 AM: >

Re: help urgent please

One thing Jim didn't mention is that mysqldump is not a mysql client command but a standalone executable. Run it from a shell prompt (DOS prompt if you are using windows) Shawn Green Database Administrator Unimin Corporation - Spruce Pine "Jim Grill" <[EMAIL PROTECTED]> wrote on 09/09/2004 11:

Re: help urgent please

> > -- > help please > > please tell me how to extract a script file of a database from mysql commandprompt. > > s.deepak > > > This life is a hard fact; work your way through it boldly, though it may be adamantine; no matter, the soul is stronger > > Swami Vivekananda > Are you looking for mysql

Re: Help needed with MySQL C API-based client (segfault)

have you tried ? http://www.geocities.com/jahan.geo/mysql_c_by_example.html Ruben Safir Secretary NYLXS wrote: On Fri, Sep 19, 2003 at 09:18:22AM +0500, Vikram Vaswani wrote: Hello, I need to write a simple C client for a project. I am using the MySQL C API. Attached is the code. It occassionally s

<    2   3   4   5   6   7   8   9   10   11   >