Re: Equivalent Query in MySQL

psm 996 -- The real question is: Does MySQL support "sub query", the short answer is 3.x.x does not, 4.x.x is supposed to. The longer answer(and work arounds) to the 3.x.x question can be found here: http://www.mysql.com/doc/A/N/ANSI_diff_Sub-selects.html David *

Re: where

Julian -- There is the generic WHERE keyords ='%string%', but more to the point here the link to the docs for regrex goodies: http://www.mysql.com/doc/manual.php?search_query=regular+expression&submit=S earch&depth=0 David > Hi, > > I have recently gained access to mysql (new isp), and am co

Re: mysql start

Richard -- Did you set the --prefix=/usr/local/mysql when you ran config? If not Your bin are located in /usr/local/bin maybe /usr/local/sbin? The start script is saying the either the programs not ther or you have a permissions problem? Did you create user and group mysql, Install as above

Append queries

Is there a why to append a feild in mysql as apposed to updating? For event log table for a datacenter. Or is this something that would be better handled at the script level? Thanks David - Before posting, please check: htt

List BUG? Unsuscribe info appaears in replies

database,mysql,sql ALL -- For reason unknown I seeing the unsubscribe information, for any email I read or reply, here's what I'm talking about: NOTE: I don't have this problem on the other list I subscribe to? Thanks, David > Before posting, please check: > http://www.mysql.com/manual.ph

Re: Perl problem

Here's what I use (a little different): use DBI; use diagnostics; use strict; my ($dbh,$sth); my ($dbname)="pickle"; my ($login)="picklesql"; my ($password) ="pi56fb"; my (@ary); # $dbh = DBI->connect("DBI:mysql:$dbname",$login,$password) or die "Can't connect to $dbh: $dbh->errstr\n"; $s

Re: (WOT) Re: Perl problem

Here's what I use: use DBI; use diagnostics; use strict; my ($dbh,$sth); my ($dbname)="pickle"; my ($login)="picklesql"; my ($password) ="pi56fb"; my (@ary); # $dbh = DBI->connect("DBI:mysql:$dbname",$login,$password) or die "Can't connect to $dbh: $dbh->errstr\n"; $sth = $dbh->prepare("SE

Re: unable call database

Here's what I use it should tell you exactly what your problem is: Also check out tutorial on http://www.porlmonks.org. -- David Jackson use DBI; use diagnostics; use strict; my ($dbh,$sth); my ($dbname)="dataase_name"; my ($login)="login_name"; my ($password) ="your_pasword"; my (@ary); # $d

MySQL,sql my unscribe info appears in mail

database,sql,query,table > 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: > > database,sql,query,table > > If you just reply to this message, and include

Re: Backup Question.

Richard -- You could do both, I would be a lot quicker to import data than restore from tape. Say do an incremental dump back to your last level 0. Which would be helpfull to developers as well as youself. You could also use a seperate partition for the data directory and back that up. The subj

Re: Access Denied

Clinton -- It's saying you password is incorrect or wasn't entered. I believe. Did you set username and password in script? Also http://www.perlmonks.org have some tutorials on DBI/DBD, you would find helpfull. -- david > I get this error when trying to connect to a mysql database > > DBI->co

Re: Problem with LOAD DATA INFILE

Are you using mysqlimport utility? If not that may be you answer? If so what flags are you setting? david > HI ALL: Happy New Year ;) > I have a text file generated from MSAccess database, one of the > fields (Long Text) have Carriage returns within the text, So > the data of some records f

Re: Somewhat simple question on tables.

James -- You haven't done enough "book work" this is basic db design stuff, covered in Dubois book and evey other, the short answer is: Primary Key -> foriegn Keys i.e People table: person_id, # Primary key, unique and auto increment fname lname ... Food person_id # pulled from People table vi

Re: --- query to find records related tables with no match?

>From page 165 MySQL (New Riders): LEFT JOIN: SELECT t1.* FROM t1 LEFT JOIN t2 ON t1.i1 = t2.i2 WHERE t2.i2 IS NULL -- david > Ack - sorry - can someone remind me the SQL format for this? > > if you have a linked CLIENTS and INVOICES table... > > ...what's the query to find CLIENTS with NO

Re: DBD::mysql HElp

Did you do install "mysql" or install "DBD-mysql"? Here's what the activestate page has to say: ActivePerl offers a PPM archive of DBD::mysql. All you need to do is typing ppm install DBI install DBD-mysql This will fetch the modules via HTTP and install them. If you need to use a WWW p

Re: php/mysql download

If you're looking for php. suft on over to the PHP homeworld: http://php.net current version is 4.1.1 David > Does anyone have the location of a php-mysql-4.0.3 version that I could > download? > > Tobe > > > - > Before posti