Re: Sorting Problem

The query using JOIN syntax (you can read about this in the documentation) describes the interelationship between the three tables you described, in this way you can select information based on a WHERE clause as it relates to the category table, while still ordering by the business table.

MySQL XA Transactions and PHP

Hi, Is it possible using PHP (PDO or native mysql/mysqli drivers) to do XA transactions over two seperate database servers. In my case I need to process remove rows from a production database server only once the slave has processed the rows, and using XA transactions sounds like the better way

improving performance of server

hello, i am having some trouble getting mysql to perform decently on my machine. it is a 2 GHz dual core AMD 64 machine (although i am presently running a 32 bit linux system) with 1 Gb RAM and 1 Gb swap partition. the data i am using is loaded into a table described by: CREATE TABLE IF NOT

Re: Functions and NULL with standard install

Hello Lucas, [EMAIL PROTECTED] wrote: I don't see how to use this here, I will have to research the |/||/| select rpad(|IFNULL(|null, ''),5,'1'); |/||/| snip The function you want to use is IFNULL() documented here:http://dev.mysql.com/doc/refman/5.0/en/control-flow-functions.html

RE: Sorting Problem

Micah, I think I understand, here is my query, however I get a syntax error report and it is not clear what the problem is. Any suggestions: select * from business_names left join business_entries using business_entries.bus_id left join business_categories using

Select into outfile on nfs mount point

I'm unable to select into an outfile, the path is in an nfs mount point. I'm sure it's some sort of permissions issue or something, but I can't figure it out. I've googled everything I can think of and haven't found anything. Any help or suggestions would be greatly appreciated. The error I'm

Re: Sorting Problem

Try: select * from business_names left join business_entries using (bus_id) left join business_categories using (bcat_id) where business_categories.bcat_id=17 order by business_names.organisation You must have brackets around column name after USING and do not write table names there, 'cause

RE: Select into outfile on nfs mount point

Can you touch the file name? It might be a permission issue at the directory level, it has to be writeable. Regards, Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 -Original Message- From: David Ruggles

RE: Select into outfile on nfs mount point

Yes, but wouldn't it be the user that the mysql service is running as? That is the user I am logging in as to test this. Thanks, David Ruggles CCNA MCSE (NT) CNA A+ Network EngineerSafe Data, Inc. (910) 285-7200 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED]

RE: Sorting Problem

Thank you. You say the column must be in both tables, do you mean that the column name must be the same in each table? Sid. Sid Price Software Design http://www.softtools.com _ From: Ales Zoulek [mailto:[EMAIL PROTECTED] Sent: Monday, March 26, 2007 10:06 AM To: [EMAIL

Re: mysql InnoDB table creation problem

On 3/26/07, Anil D [EMAIL PROTECTED] wrote: Varchar = 0 bytes I don't think this is right, see below. Charset used: UTF8 UTF8 means that some characters may be two bytes, see below. Note: When consider even the size Varchar(m) = m+1 bytes, the size of row has reached 35,000 bytes.

Getting SQL errors porting databases between MySQL v4 and v5

Hi, I am porting over 6 databases from a MySQL v4 installation to a MySQL v5 installation and getting an SQL error in the process. I am using the following command to dump the data in the v4 installation: mysqldump -u root --password=secret --add-drop-table --databases db1 db2 db3 db4 db5 db6

Re: Getting SQL errors porting databases between MySQL v4 and v5

The 'group' column needs to be quoted (use --quote-names with mysqldump). cheers, --bemansell On 3/26/07, Rob Tanner [EMAIL PROTECTED] wrote: Hi, I am porting over 6 databases from a MySQL v4 installation to a MySQL v5 installation and getting an SQL error in the process. I am using the

Re: Finding a record in a result set

Let me describe the problem another way, too. It's related to creating a paging interface to view many records. I figured that people deal with paging all the time and the solution to my problem may already be out there. Typically when you access a single record via a top down method,

RE: Select into outfile on nfs mount point

I have verified that the user can read and write as I mentioned in my first post. Thanks, David Ruggles CCNA MCSE (NT) CNA A+ Network EngineerSafe Data, Inc. (910) 285-7200 [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday,

Re: Finding a record in a result set

Thanks Maciek: The table that I'm doing this query on will be huge. It's essentially the users table for an online activity with, we hope, lots of users. :) The thing is that if I do a query for the entire result set and use PHP to figure out the position of the user and then do a query

Re: Sorting Problem

When using USING clause, yes the column must have the same name. But there is an alternative called ON clause. Example usage of USING: table t1, columns a,b table t2: columns a,c You want match t1.a against t2.a: SELECT t1.a, t1.b, t2.c FROM t1 LEFT JOIN t2 USING(a);

RE: Select into outfile on nfs mount point

Yes I can touch the file with the mysql user. The only thing I can't do is a select into file. However select into file works anywhere else on the filesystem. Thanks, David Ruggles CCNA MCSE (NT) CNA A+ Network EngineerSafe Data, Inc. (910) 285-7200 [EMAIL PROTECTED] -Original

Why doesn't the InnoDB count() match table status?

Aside from the incredibly annoying fact that InnoDB tables don't store a total COUNT(), my question is... Why are these numbers different? I could easily parse out the second query which is REDICULOUSLY faster. BTW, why doesn't mySQL just 'alias' the first query behind the scenes for us and parse

Database Connection Problem with MAMP (Mac)

I installed a preconfigured package called MAMP on my MacBook Pro and have just about everything working except my database connections. I can use phpMyAdmin to manipulate databases and tables, but I can't connect to those databases from Dreamweaver. I read somewhere that you have to use a

Re: Why doesn't the InnoDB count() match table status?

In the last episode (Mar 26), Daevid Vincent said: Aside from the incredibly annoying fact that InnoDB tables don't store a total COUNT(), my question is... Why are these numbers different? I could easily parse out the second query which is REDICULOUSLY faster. BTW, why doesn't mySQL just

RE: Why doesn't the InnoDB count() match table status?

In the last episode (Mar 26), Daevid Vincent said: Aside from the incredibly annoying fact that InnoDB tables don't store a total COUNT(), my question is... Why are these numbers different? I could easily parse out the second query which is REDICULOUSLY faster. BTW, why doesn't

Re: Why doesn't the InnoDB count() match table status?

In the last episode (Mar 26), Daevid Vincent said: In the last episode (Mar 26), Daevid Vincent said: Aside from the incredibly annoying fact that InnoDB tables don't store a total COUNT(), my question is... Why are these numbers different? I could easily parse out the second query

Re: Why doesn't the InnoDB count() match table status?

Daevid Vincent wrote: Is mySQL planning on fixing this BUG. YES -- it is a BUG. A BIG FAT HARRY ONE. I think you mean 'hairy', not 'harry'. There are no 'harry' bugs, apart from that British fool who's in line for the throne. It's completely stupid that I can't query and get an

Re: Getting SQL errors porting databases between MySQL v4 and v5

group is a reserved word, so MySQL thinks you're attempting a 'group by' statement. Put backticks around group, you should always quote your table and column names. DROP TABLE IF EXISTS `admission_quotes`; CREATE TABLE `admission_quotes` ( `id` int(4) NOT NULL auto_increment, `quote` text,

RE: Why doesn't the InnoDB count() match table status?

Is mySQL planning on fixing this BUG. YES -- it is a BUG. A BIG FAT HARRY ONE. I think you mean 'hairy', not 'harry'. There are no 'harry' bugs, apart LOL! Doh! Yeah. I was so blinded by rage that I forgot my spelling. It's completely stupid that I can't query and get an

RE: Why doesn't the InnoDB count() match table status?

You're about 5 years too late for this converation, but I recall it Really? People have just happily accepted this absurd limitation for _five_ years? Wow. having to do with the fact that when you're on a table that supports transactions, you don't know exactly how many records a particular

RE: Why doesn't the InnoDB count() match table status?

On Mon, March 26, 2007 16:21, Daevid Vincent said: You're about 5 years too late for this converation, but I recall it Really? People have just happily accepted this absurd limitation for _five_ years? Wow. having to do with the fact that when you're on a table that supports transactions,

Re: Why doesn't the InnoDB count() match table status?

Hi Daevid, Ugh. How about not going berserk on the public mailing list? We can understand that you're upset that you didn't read the manual before starting a MyISAM to InnoDB conversion. You didn't do your research and now you're being hit by a very simple (and not really all that

RE: Getting SQL errors porting databases between MySQL v4 and v5

Use --allow-keywords option with mysqldump command Anil -Original Message- From: Brian Mansell [mailto:[EMAIL PROTECTED] Sent: Monday, March 26, 2007 11:18 PM To: Rob Tanner Cc: mysql@lists.mysql.com Subject: Re: Getting SQL errors porting databases between MySQL v4 and v5 The 'group'

Re: right configuration.

Hi Friends, Can you please help me this info, it would be of great help. regards anandkl On 3/25/07, Ananda Kumar [EMAIL PROTECTED] wrote: Hi Friends, We are in the processing of building a new Mysql database. We are planing to use innodb. I need help on couple of questions. 1. What are