joining 3 tables

e '45' and '3' being the values coming from my variables in PHP. We only have MySql 4.0 so I can't use a subquery. If anyone has any suggestions I would be very thankful. Please also let me know if I need to provide more information about the problem. Thank you for

Database Internals Engineer opportunity

Outstanding opportunity for someone in the San Diego area. Database Internals Engineer Successful candidate will be responsible for the architecture, design and implementation of a database engine and its interface with a variety of commercial databases. Responsibilities include authoring o

Re: Continuing problem

Server and a Unix Client). It may be helpful to include this. Regards, [filter fodder: sql, mysql, query] ^^ filter fodder: Good idea. Thanks again. -- Amy and Joseph Kormann - Before posting, please check: http

Continuing problem

sting something like this to the win32 list, but didn't get any responses. I need this for a school project. Thanks. -- Amy and Joseph Kormann - Before posting, please check: http://www.mysql.com/manual.php (the ma

Re: cygwin strangeness

Mark, thanks for your reply. My commends inline below. Mark Matthews wrote: Amy & Joseph Kormann wrote: Feels strange being the only one replying to myself, but I'm hoping that someone will come up with a suggestion if I keep posting what I'm doing. I've downloaded th

Re: cygwin strangeness

ing for a school project. Thanks, Joseph -- Amy and Joseph Kormann - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request th

Re: C API Changes?

Stephen Brownlow wrote: "ggelu" <[EMAIL PROTECTED]> wrote: --- Amy & Joseph Kormann <[EMAIL PROTECTED]> wrote: Are there any (significant) changes in the C API between MySQL 3.X and 4.X? If so, where are they located. Yes. Are some changes between ver 3

C API Changes?

Are there any (significant) changes in the C API between MySQL 3.X and 4.X? If so, where are they located. mail-filter: sql,query,queries,smallint -- Amy and Joseph Kormann - Before posting, please check: http

Re: Error with libmyclient.a

binary format (RPM) from What's RPM mean? I figured it's a compression and packaging format, but what are the initials? Any cousin to RTFM.. -- Amy and Joseph Kormann - Before posting, please che

cygwin strangeness

d to 0; I print the value before I enter a for-loop to display the number of fields and columns. When I get into the for-loop, the value changes. I'm also attaching the file - forgive the obvious spastic debugging. Any suggestions? Thanks in advance. -- Amy and Joseph Korman

lost connection when modifying indexes

Time Id CommandArgument Has anyone else seen this behavior? This is MySQL Max 4.0.1-alpha using InnoDB tables on Linux 2.4.3 SMP (Intel libc6) (I should probably upgrade to 4.0.3) Amy - Before posting, please check:

msql.h

Where is msql.h located? - 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 unsubscri

@INC

I'm a little confused on how to add things to @Inc path...i'm trying to install Msql-Mysql-modules and it says that my DBI/DBD is not in the @INC Thanks Amy - Before posting, please check: http://www.mysql.com/

mysqld

sure how to do this. Can anyone help? Thanks~ Amy - 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 <[EM

Re: Passwords

> Hello~ > > I read the MySQL manual on how to set passwords but i'm a little confused. > How can i remove privileges so that you cant log on anonymously? > Thanks. > Amy > - Before post

Socket trouble

> When trying to connect to mysql database i get this error message "Cant > connect to local MySQL server through socket "/tmp/mysql.sock" > > Yet I can connect through TCP/IP ~ what happened to my socket? > >

Socket trouble

When trying to connect to mysql database i get this error message "Cant connect to local MySQL server through socket "/tmp/mysql.sock" Yet I can connect through TCP/IP ~ what happened to my socket? Any suggesti

empty?

I have my MySQL database up and running, but its empty...did i miss a step? Thanks Amy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

make test]

ta infile '../../std_data/words.dat' into table t1' failed: 1085: The file '../../std_data/words.dat' must be in the database directory or be readable by all real 0.04 user 0.01 sys 0.01 Aborting any suggestions? Amy -

error - please help

after trying to execute the scripts/mysql_install_db i get this error message: my_print_defaults: not found Didnt find usr/local/libexec.mysqld you should do a make install before executing this script any suggestions? amy

source code

Can i download the source code for MySQL? - 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 PROTECT

mysql-test-run errors

1085: The file ../../std_data/words.dat' must be in the database directory or be readable by all real 0.08 user 0.02 sys 0.00 Aboring. To continue, re-rum with '--force' Ending Tests Shutting-down MySQL daemon Help please! Amy -

include/mysql.mysql.h

Error message: Cannot find one of include/mysql/mysql.h, include mysql.h in home/local/mysql at lib/DBD/mysql/Install.pm line 165, chunk 4 This came after i tried to tell it where mysql was installed any suggestions? - Befo

Re: ezmlm response

eas on how to fix these? > > Also, when installing modules for Perl, i get an "Error Code 13" after i > execute make install > > Thanks > Amy - Before posting, please check: http://www.mysql.com/manu

Re: segmentation fault

Maybe it's about time you stopped being a fuckwit and read the whole message dip shit. file://Kris -Original Message- From: Gerald Clark <[EMAIL PROTECTED]> To: Breughel Macabuhay <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Thursday, 12 July 2001 12:36 Subject: Re

Re: Query Slowness

yes i search on phone number. it's indexed(7) and the format of the phone data is (XX) . is there anyway this could be optimized. I will eventually remove the spaces and the first 4 characters from the input data and reload it in Kris Amy -Original Message- From: Don

Query Slowness

ch the database. there is ~8.5 million records in it though. Anyone know howto speed this up? Kind Regards Kris Amy

RE; mysql user connections.

anyone know howto get mysql to allow multiple connections to a user? i'm trying to get a db working also using php4 but when someone is searching the db someone else can't query it. (it's http://virtuozo.hn.org/wp/ ) Kind Regards kris Amy

FW: ERROR 1136: Column count doesn't match value count at row 1

hannel VALUES (1, 'RADIO','WAPE','WAPE > FM','CHR',14,'95.1 > FM','http://www.wape951.com','http://www.wape951.com','fl_jacksonville > _wape.jpg','','','',2,1,'A'); > > I got the follow error > > ERROR 1136: Column count doesn't match value count at row 1 > > WHY IS THAT? > > Amy

FW: ¯º¸Ü

|­û½s¸¹¬O ME78131385 ==== Amy ¶K¤ß¹q¤l³ø ¦pªG±z¤£·Q¦A¦¬¨ì¹q¤l³ø¡A½Ð«ö http://home.domaindlx.com/maillist/ad.asp?action=REMOVE&[EMAIL PROTECTED] ÁÂÁÂÅo!!