Qeury Help - Joining 4 tables!

Can anyone tell me a more efficient way to structure this query? It works fast enough now, but I don't have that much data yet. I am concerned with future performance. I need all of the rows from the project table that match the first where clause. The other information saves me from having to

mysqlmanager

in the '{MYSQLROOT}/bin' there are two executables in particular. mysqlmanager mysqlmanagerc I see these are version 1.0, and such are recently added. Can anyone tell me: What does bin/mysqlmanager do, and how do I use it? Why does the bin/mysqlmanagerc give me an

RE: Fail on restart

Yes, it is running. (I have had this problem with installs on both Redhat 7.1 and YellowDog 2.1). David -Original Message- From: Batara Kesuma [mailto:[EMAIL PROTECTED]] Sent: Sunday, March 31, 2002 7:52 AM To: [EMAIL PROTECTED] Subject: Re: Fail on restart Hi David, On Sun, 31 Mar 2

help: MYSQL_FIELD

Is there a way I can save the members that I manipulate in the MYSQL_FIELD struct? MYSQL_FIELD *field; field->name = "newcolumnname"; How could I save this as the new column name? Thanks -- Romans 12:9 "Let love be without hypocrisy. Abhor what is evil. Cling to what is good." ---

Re: filemaker to mysql

I got some more information -- rory oconnor asked: > I have a new client that wants to use filemaker on his mac to enter data > for site information. I'm sure that I can take that and export the > files and import into the site's MySQL database...but I'm wondering if > it is possible to link his

PS: Re: Newbie - Different commands....?

At this 14:24 1/04/02 +1200 Gordon Stewart told us all something interesting :- >I've been following the website of :- > >http://www.wdvl.com/Authoring/DB/SQL/Build/ > >And its the best ive seen - so far... > >Im up to this page :- > >http://www.wdvl.com/Authoring/DB/SQL/Build/build4-5.html > >&

Newbie - Different commands....?

Hi there, Im a newbie... Ive installed PHP/MySQL 2 nights ago & have been Surfing various websites re installing & setting up MySqld using CGi/Perl.. I can do most things online _ in a DOS window - But i want to do them online - PHP file / CGI.. I've been following the website of :- http://

output to a file

Hey Guys, I know this is more of a PHP question, but since most people here now a lot about PHP I thought I'd ask. I have a script that outputs headlines for reviews and I need to output it to a file for inserting into my page, because I can't use php on this specific page so I want to output it

problem for starting or connecting ?

Hi all, I accidently move some database dir temporary (for space pb) but when moving I surely forget something I cant no longer start my server. I put the sock file where it had to be but nothing more. See that www:/var/lib/mysql# ls -ls total 100 4 drwxr-xr-x2 mysqlmysql4096

Updating 2 tables using flags

Hello everyone, I have 2 MySQL tables called ANNOUNCEMENT1, and ANNOUNCEMENT2 CREATE TABLE ANNOUNCEMENT1( AnnouncementID bigint(20) unsigned DEFAULT '0' NOT NULL, Title varchar(250), DatePosted date DEFAULT '-00-00' NOT NULL, Content text, ArchiveDate date, DateShown date DEFAULT '

Re: problem with '

Thanks Peter, you gave me a lot work with I'm going to experiement with it all. Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1391 ICQ: 3

RE: problem with '

Hi php probably adds slashes to all the " and ' in the statement. Is it worth trying backslashing all the variables individually? $field1 = addslashes($field1); $field2 = addslashes($field2); etc $query="INSERT .. VALUES ('$field1','$field2',)'; If they come from form data php4+ adds

Re: problem with '

Hey. My statement is this and it still gives me an error and wont add the data, the addslashes doesn't seem to be working: $sql = addslashes("INSERT INTO hwureviews (name,title,picurl,url,author,email,category,num,info) VALUES ('$name','$title','$picurl','$url','$author','$email','$category','

Solaris 8 Library Problems.

Hi, I am new to MYSQl so any help is much apreciated! I have recently instaled mysql version 3.23.45 on Sun solaris 8 (sparc). The server installed fine but I am unable to connect to the server using the mysql command due to some missing libs. Both the server and client are running locally. # ./

Import Oracle tables into mysql

Does anyone know how or where there is a howto to import tables from an Oracle Database into Mysql and then to keep the Mysql syncronized with the Oracle database? Art - Before posting, please check: http://www.mysql.com/ma

Re: problem with '

http://www.php.net/manual/en/function.addslashes.php http://www.php.net/manual/en/function.stripslashes.php --jeff - Original Message - From: "Alex Behrens" <[EMAIL PROTECTED]> To: "Son Nguyen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, March 31, 2002 11:35 AM Subject: Re: pr

Multiple Inserts

Hi, if I need to do multiple INSERTS (I mean into different tables) which is the best way to manage this? Do I have to run a different Query for each INSERT ? Or is there a faster & better way to do it. Thanks. - Before posting

Re: problem with '

At 01:10 PM 3/31/02 -0600, Alex Behrens wrote: >Hey, > >I'm trying to insert data into a table with a TEXT field but the data I am >inserting into the table has a ', present in the data and it gives me an >error, the text is as follows: > >Of all the motherboard manufacturers in the world, there a

Re: problem with '

Is it possible to have my script do this automatically if it detects a ' in the data being inserted? would you know the command to do this, I would assume it would be PHP based. -mysql Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-m

Re: problem with '

--- Alex Behrens <[EMAIL PROTECTED]> wrote: > Hey, > > I'm trying to insert data into a table with a TEXT field but the data > I am > inserting into the table has a ', present in the data and it gives me > an > error, the text is as follows: > > Of all the motherboard manufacturers in the world

problem with '

Hey, I'm trying to insert data into a table with a TEXT field but the data I am inserting into the table has a ', present in the data and it gives me an error, the text is as follows: Of all the motherboard manufacturers in the world, there are only about half-a-dozen who consistently make relia

Re: primary key

Sorry I meant without deleting the table or affecting any present data. is this possible? Thanks! -Alex "Big Al" Behrens E-mail: [EMAIL PROTECTED] Urgent E-mail: [EMAIL PROTECTED] (Please be brief!) Phone: 651-482-8779 Cell: 651-329-4187 Fax: 651-482-1

Re: (newbie) What's wrong with this READ DATA INFILE?

Antoine wrote: > > Richard Trahan wrote: > > I'm using 3.23.49 on Windoze 98. I'm trying to execute this: > > > > mysqlc> load data local infile "c:/temp/e-headhunters.txt" > > -> into table headhunters > > -> lines terminated by '\r\n' > > -> (email); > > > > Table headhunters

Re: (newbie) What's wrong with this READ DATA INFILE?

Richard Trahan wrote: > I'm using 3.23.49 on Windoze 98. I'm trying to execute this: > > mysqlc> load data local infile "c:/temp/e-headhunters.txt" > -> into table headhunters > -> lines terminated by '\r\n' > -> (email); > > Table headhunters contains several fields, including

(newbie) What's wrong with this READ DATA INFILE?

I'm using 3.23.49 on Windoze 98. I'm trying to execute this: mysqlc> load data local infile "c:/temp/e-headhunters.txt" -> into table headhunters -> lines terminated by '\r\n' -> (email); Table headhunters contains several fields, including 'email varchar(40)'. The inpu

Re: Fail on restart

Hi David, On Sun, 31 Mar 2002 07:23:46 -0800 "David McInnis" <[EMAIL PROTECTED]> wrote: > > Mysql is running. So why would I get this message when I try to restart > it? > > [root@content mysql]# /etc/rc.d/init.d/mysqld restart > Stopping MySQL:[FAI

Fail on restart

Mysql is running. So why would I get this message when I try to restart it? [root@content mysql]# /etc/rc.d/init.d/mysqld restart Stopping MySQL:[FAILED] Starting MySQL:[ OK ] David McInnis ---

VC++ Examples

Hi all, Just wondering if there are any examples on the web that will compile using VC++ 5.0 SP3. I have downloaded the MySQL++ 1.7.1 API and cannot get the example to compile. Thanks in advance Troy - Before posting, ple

sum() autoconvert null to zero

Hi thanks for answer, maybe it would be good to have a sum_null() function to deal with my case ? because logically speaking, when a value is null in an operation the result is null, this is the case for normal functions in mysql (ie not "group by" function) i think it is perfect sense that cou

installation problem

After running setup on Window professional , I tried to install using the follow command. I got error. C:\mysql\bin>mysqladmin -u root shutdown mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to MySQL server on 'localhost' Check that mysqld is running on localhost and t

: myODBC and WinXP/ Access 2000

[EMAIL PROTECTED] wrote: > Your message cannot be posted because it appears to be either spam or > simply off topic to our filter. To bypass the filter you must include > one of the following words in your message: > > sql,query I am flabbergasted! I think the list needs a better spamfilter -

Re: Error 2004 on NT 4. maschine

At 10:05 31/03/02 +0200, Gerd Huber wrote: Hi! >hi, > >i have installed on nt 4.0 sp 6 MySQL Version 3.23.43. After starting the >process with mysqld-nt --install, i wanted to start mysql and recived the >following error. > >Error 2004: Can't create TCP/IP socket <10044> Your machine has TCP/IP s