mysqldump table order with foreign keys

2003-12-19 Thread sean peters
ated. I swear that i've seen a solution to this somewhere, but for the life of me i have not been able to find the answer (now that i need it) Thanks much, sean peters [EMAIL PROTECTED] filter fodder: mysql, query -- MySQL General Mailing List For list archives: http://lists.mysql

errno 138

2003-12-17 Thread sean peters
ss. Im not sure what other info to provide, ask and i'll tell thanks much, sean peters [EMAIL PROTECTED] filter buster: mysql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

decimal field oddity

2003-11-13 Thread sean peters
omecooked). I'm not arguing that this behaviour is a bug, i am more interested in knowing why this behaviour is the way that it is. thanks much, sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unusual date storage requirement

2003-10-27 Thread sean peters
y users will raise a major stink if i tell them that the date is the first, but it actually isn't, so the display functionality for the system will check the date validity flag, and if invalid, only display the month and year. The flag field is there for exactly this purpose. thanks sea

Unusual date storage requirement

2003-10-27 Thread sean peters
malization, etc. but i haven't come up with a better solution. Also note that this is for a data warehouse, and myself and 1 other programmer are the only people who manipulate the data. thanks in advance sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: ht

bind params and default values

2003-10-27 Thread sean peters
Hi all, i've been having an issue with binding params. If i have created an INSERT query with a param binding to a particular column, call it column "A", is there any way that i can use that (prepared) query to get the db defined default value into column A? Im at a loss! tha

4.1 in production

2003-10-24 Thread sean peters
figure out if it is wise to upgrade mysql yet. thanks much, sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Updated: How to write this query

2003-10-01 Thread sean peters
and C for each record in A, but if not, this returns nothing. So, short of querying each table, i cant come up with a good solution to my problem. If there were only 2 tables, a LEFT JOIN would work fine, but both B and C want to be left joined to A, which i dont know how to do. thanks sean p

Re: How to write this query

2003-10-01 Thread sean peters
; SELECT A_data, B_data, C_data > FROM A LEFT JOIN B ON A.A_ID = B.B_ID LEFT JOIN C ON A.A_ID = C.C_ID > WHERE A.A_ID = 4; > > > -----Original Message- > > From: sean peters [mailto:[EMAIL PROTECTED] > > Sent: Wednesday, October 01, 2003 12:07 PM > > To

How to write this query

2003-10-01 Thread sean peters
good solution to my problem. If there were only 2 tables, a LEFT JOIN would work fine, but both B and C want to be left joined to A, which i dont know how to do. thanks sean peters [EMAIL PROTECTED] --- mysql, query -- MySQL General Mailing List For list archives: http://lists.mysql.com/mys

Innodb & disk geometry

2003-09-23 Thread sean peters
Hi all, i've been trying to follow the Innodb upgrade that will allow setting up multiple separate blocks of disk for different databases, where the admin has the ability to put databases in specific tablespaces. There has been a bit of talk here, but whenever i go to the MySQL or Innodb web si

Innodb multiple tablespaces

2003-09-08 Thread sean peters
Hi all, A few weeks ago, someone mentioned that Innodb would soon have multiple tablespaces available under MySQL. I saw that Innodb.com shows this on their to do list. Is anyone aware of the status of this upgrade, or a site that would have details regarding the upgrade? thanks -- MySQL Gen

InnoDB & multiple mysqld's on 1 server

2003-08-14 Thread sean peters
Hi all, i've been weighing the pros and cons of running multiple concurrent mysqld's on one server, to have better control over what databases are on what physical disks. System: 4 processor sun box running solaris with eighteen 36Gb drives. The situation is that i have a bunch of databases on

Re: InnoDB & multiple mysqld's on 1 server

2003-08-14 Thread sean peters
omes, i'll surely upgrade so our internal programs will run faster. thanks much On Wednesday 13 August 2003 17:04, you wrote: > On Wed, Aug 13, 2003 at 04:07:24PM -0500, sean peters wrote: > > Hi all, i've been weighing the pros and cons of running multiple > > concurr

IN & LIKE

2003-06-03 Thread sean peters
e, i've tried many syntax variations. Could someone confirm my suspicions, or prove me wrong. thanks, sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

SQL database design patterns

2003-06-03 Thread sean peters
known (to others) information, i should be able to gain that same understanding faster, and be more productive. So, if anyone could point me at such a book, or online tutorials, that would be great. Thanks much, sean peters [EMAIL PROTECTED] Filter info: mysql, query -- MySQL General Ma

mysql text client crashes

2003-05-30 Thread sean peters
Hi all, I've inadvertently ran across a weird issue with the text client. I have found that if you press [SHIFT][ENTER] the program seg faults. This is consistent behaviour as far as i know. Im running redhat 9 and MySQL 4.0.12-max Does anyone else see this behaviour? thanks -- MySQL Genera