speed optimization on awkward self join

2002-05-03 Thread Colin Anderson
table, combining char_data and char_data.type -- I don't know how much that would help, anyway. And because the characteristic types need to be dynamically addable and removable, I can't just make extra columns in the characters table. Any suggestions? - Colin

Re: Poor Manual [Was: Why using filesort here?]

2002-04-21 Thread Colin Faber
] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 736-5160 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php

Re: MySQL counter for HIGH traffic site

2002-04-14 Thread Colin Faber
PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: regarding libmysqlclient and libmysqlclient_r

2002-04-10 Thread Colin Faber
/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc

Re: MySql/Perl installation problem

2002-04-07 Thread Colin Faber
, 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 unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin

RE: printing the database

2002-04-06 Thread colin o
Hi Gurhan, The tee command printed out the table perfectly to a file, Cheers, Colin tee /dir/table.txt; select * from table; --- Gurhan Ozen [EMAIL PROTECTED] wrote: Hi, Try to use tee command to log all the output into a file. It will have the column names and everything you see

printing the database

2002-04-05 Thread colin o
, but this isn't free. Is it possible? Thanks in advance, Colin __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ - Before posting, please

Re: Not null not working??

2002-04-04 Thread Colin Faber
unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list

Re: PERL/SQL, again? - Re: Procedures

2002-04-03 Thread Colin Faber
unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: funny thing with versions

2002-04-03 Thread Colin Faber
://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc

Re: Load Data Problem

2002-04-03 Thread Colin Faber
://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc

Re: access sql statement

2002-04-03 Thread Colin Faber
] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: access sql statement

2002-04-03 Thread Colin Faber
I agree but this one one of those things which _SHOULD_ have been researched. denonymous wrote: From: Colin Faber [EMAIL PROTECTED] Rw wrote: Is it possible to access a sql statement to mysql database through Internet explorer ? such as : No, MySQL is not a web server

Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2002-04-02 Thread colin o
Hi Kathy, I don't have that file in my folder, but it still starts. Colin. To fix this i checked the hostname.err file in mysql/data. From looking at this i found the lines that gave me errors, i played around with these and ended up getting an error like 'the socket is already binded

PigeonRank™

2002-04-01 Thread Colin Faber
Is it true that mysql is planing to implement google's famous PigeonRank™ system in it's FTS word weighting schema??? *drool* :-) -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http

Re: PigeonRank

2002-04-01 Thread Colin Faber
] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: Very large BLOBS in MySQL 4.0.1

2002-03-29 Thread Colin Faber
) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please

Re: hits

2002-03-28 Thread Colin Faber
] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

2002-03-26 Thread colin o
Same thing happens to me, i just use bin/safe_mysqld --user=root to start to server so that i can use mysql. I don't know exactly why it happens though. Possibly permissions?? Colin --- Mike Yrabedra [EMAIL PROTECTED] wrote: What would cause this error to occur all of a sudden? ERROR

Re: Access denied on use mysql;

2002-03-21 Thread Colin Faber
network. alan4100 wrote: mysql kathy, What would happen if you type in mysql -u root -p then type in use mysql -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com

Re: Cannot access the Database on same Machine

2002-03-20 Thread colin o
suddenly wasn't able to use the database, even though i am the only one using it. Anyway thanks for the reply. Colin --- sascha mantscheff [EMAIL PROTECTED] wrote: probably something wrong with the permissions in the mysql database. as a workaround, try to connect not via the local socket

Re: Adding Columns to table

2002-03-20 Thread Colin Faber
), City VARCHAR(20), State VARCHAR(2), Zip VARCHAR(20), E_Mail VARCHAR(20 ), Age INT); -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Error message

2002-03-20 Thread Colin Faber
://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc

Re: all databases deneid

2002-03-19 Thread Colin Faber
because it includes UNIX and Windows. I am using Windows XP. == shell mysql -h host -u user -p Enter password: -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before

Cannot access the Database on same Machine

2002-03-19 Thread colin o
and the lists, all the searches for this type of ERROR, but to no avail. I have used the database before and have tables in there but for some reason i cannot get in. I don't want to reinstall it as i have tables that i need, I am really stuck so any help will be very much appreciated, Thanks Colin

Re: MySQL, FreeBSD problem

2002-03-19 Thread Colin Faber
/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - 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

Re: INSERT ... SELECT not supported?

2002-03-18 Thread Colin Faber
[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Re: Finding overlapping intervals efficiently

2002-02-25 Thread Colin Dewey
be able to use an index for this type of query that could make it more efficient, so that larger data sets could be compared. Thanks for all the help, Colin Hi, On Sat, 2002-02-23 at 01:14, Tod Harter wrote: This is an example of a class of problem that crops up in a lot of applications, like

Finding overlapping intervals efficiently

2002-02-21 Thread Colin Dewey
give me, Colin _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. - Before posting, please check: http://www.mysql.com/manual.php

Re: Faxing from MySQL

2002-02-18 Thread Colin Faber
(the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc

Re: Perl core API

2002-02-18 Thread Colin Faber
://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491

Re: Perl core API

2002-02-18 Thread Colin Faber
the libmysqld api is part of the 4.x development branch at the moment, I suggest checking that out. If you're interested in the development branch I suggest hopping on to the internals list. Rodney Broom wrote: From: Colin Faber [EMAIL PROTECTED] With the up and coming libmysqld library

Re: 1 billion row

2002-02-12 Thread Colin Faber
-- Colin Faber (303) 859-1491 fpsn.net, Inc. - 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

Re: 1 billion row

2002-02-06 Thread Colin Faber
-- Colin Faber (303) 859-1491 fpsn.net, Inc. - 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

(WWOT) Re: PHP with TTF fonts

2002-02-04 Thread Colin Faber
/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - 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

Re: setup/DBI issues...

2002-02-01 Thread Colin Faber
PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

installation directories and non-root execution

2002-01-31 Thread Colin Boyan
I am an experienced database developer (Sybase on Solaris mostly) but new to MySQL on Linux (so please feel free to redirect me to a more suitable forum if that is appropriate). Question 1: I have just downloaded and installed the RPM version of MySQL 4.0 on a RH7.1 system. In reading the

Re: 'Automating Mailing Facility'

2002-01-31 Thread Colin Faber
/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - 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

Re: How to get connected with mysql using perl scripts

2002-01-30 Thread Colin Faber
/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc

Re: MySQL on the Playstation2?

2002-01-30 Thread Colin Faber
-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http

Re: MySQL gurus - easy one.

2002-01-28 Thread Colin Faber
) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc

Re: MySQL undo?

2002-01-27 Thread Colin Faber
/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc

Re: how do I search for a substring of a field? sql

2002-01-09 Thread Colin Faber
://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc

Re: 4416 Great Growth Potential 185528

2002-01-09 Thread Colin Faber
://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Re: 3.23.47 compile problems with sun's forte compiler

2002-01-03 Thread Colin Faber
[EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http

(WOT) Re: Perl problem

2001-12-31 Thread Colin Faber
unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Re: UNIX_TIMESTAMP() INT unsigned problems

2001-12-21 Thread Colin Faber
Michael Widenius wrote: Hi! Colin == Colin Faber [EMAIL PROTECTED] writes: Description: Colin When attempting to select a result set by subtracting the value Colin of an unsigned INT column against UNIX_TIMESTAMP() the result set Colin is invalid. How-To-Repeat: Colin

UNIX_TIMESTAMP() INT unsigned problems

2001-12-20 Thread Colin Faber
the result set as a signed int. This problem first appeared in 4.0.0-alpha and has been verified by multiple people. Submitter-Id: Originator:Colin Faber Organization: fpsn.net, Inc. MySQL support: none Synopsis: subtraction on an unsigned INT column against UNIX_TIMESTAMP

(WOT) Re: SOFTWARE TESTERS DEVELOPERS CONTRACT TO HIRE

2001-12-17 Thread Colin Faber
PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com

Re: MySQL Searchable Mailing List Archive now up.

2001-12-14 Thread Colin Faber
) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting

Re: mysqlclient.lib compiling problem

2001-12-14 Thread Colin Faber
) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please

Re: mysqlclient.lib compiling problem

2001-12-14 Thread Colin Faber
no, I haven't fixed it yet ;-) Devore, Jacob wrote: How did you fix it, just use the dll? Thanks, jake -Original Message- From: Colin Faber [mailto:[EMAIL PROTECTED]] Sent: Friday, December 14, 2001 5:07 PM To: Devore, Jacob Cc: '[EMAIL PROTECTED]' Subject: Re

How do I get version information from a MySQL server?

2001-12-13 Thread Colin Hill
work too, but I'm not sure what that error code might be since I don't have the extra hardware available to install an earlier version of mySQL for testing. Regards, Colin Hill - Before posting, please check: http://www.mysql.com

Feature request

2001-12-12 Thread Colin Faber
.. 'words' etc. -- Colin Faber (303) 859-1491 fpsn.net, Inc. - 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

libmysqlclient documentation project

2001-12-08 Thread Colin Faber
Is anyone else interested in documenting libmysqlclient? Just a basic set of function guidelines would be nice. -- Colin Faber (303) 859-1491 fpsn.net, Inc. - Before posting, please check: http://www.mysql.com/manual.php

Re: Please redo this horrible web page

2001-11-28 Thread Colin Faber
Hi guys, Locally I've already redone that for mysqldeveloper.com, Give it a look-see http://www.mysqldeveloper.com/lists/ Alexander Skwar wrote: So sprach »Keith C. Ivey« am 2001-11-28 um 16:27:46 -0500 : Does that work for you? The MySQL button on the side links to a Yep, it does.

Re: Annoying DBD-mySQL error wont go away

2001-11-26 Thread Colin Faber
You've failed to close your prepare() statements with finish() See the perldoc on DBI again. Jaime Teng wrote: Hi, I have been pulling my hair due to this annoying error. x(

Re: No curses/termcap library found

2001-11-19 Thread Colin Faber
-Original Message- From: Colin Faber [mailto:[EMAIL PROTECTED]] Sent: Monday, November 19, 2001 12:45 PM To: Gabriel Richards; [EMAIL PROTECTED] Subject: Re: No curses/termcap library found Make sure you have an ncurses library installed and is in your ld path ldconfig -r | grep curses

Re: Dictionary

2001-11-15 Thread Colin Faber
Hi, load your dict file with LOAD DATA INFILE very easy; pretty quick ;-) If you don't want to mess with that, I just dumped my dictionary database. Here is the link to where you can download that dump file: http://brimstone.fpsn.net/~cfaber/mysql/dict.sql.gz Michael wrote: Does anyone

(WOT) Re: taiwan.com

2001-11-10 Thread Colin Faber
Um. I block every domain I catch spamming and my users don't seem to have problems. kronos wrote: Guys... this is the internet just delete the spam... and dont complain like a school girl with a skinned knee... I am a system admin and if i blocked every domain that sent spam mail

Re: How to turn beeping off

2001-10-30 Thread Colin Faber
Hey now, why would you want to turn it off, After all its a `feature' [EMAIL PROTECTED] wrote: Back a few years there was a nasty little virus that played Chops on your WinDoDie box's and we had to unplug the PC Speakers on a couple dozen becuase there was not fix for it at the time. Or

Re: Newsgroups

2001-10-29 Thread Colin Faber
In the next version of my mysqldeveloper site (which I hope to release here pretty quick) it will support a feature to show you which messages are new and which you've already read. Hope this helps ;-) BD wrote: PMFJI, Do any of the public web archives of the list suit your needs?

Re: Yes or No

2001-10-04 Thread Colin Faber
I fail to see why ENUM() isn't used in this case, This is exacly what its for. Carl Troein wrote: Benjamin Pflugmann writes: Hi. On Tue, Oct 02, 2001 at 09:33:53AM +, [EMAIL PROTECTED] wrote: [...] I've seen rumors about bool being an alias for tinyint(1), but it's not

Re: repost: Too many open files

2001-10-02 Thread Colin Faber
it sounds like you've run out of file descriptors, I suggest rebuilding your kernel to handle more. In a bsd kernel you can do this simply by upping the maximum number of users allowed to access the machine at any given time. Robin Keech wrote: Hi, Any help would be greatly appreciated

Re: strange error message

2001-09-30 Thread Colin Faber
run the perror app provided with your distrobution perror 13 Casey Tourangeau wrote: Hi, I'm using MySQL v3.23.42 with Mac OS 10.1, and whenever I try to create a database (logged in as root), i get the error create database 'name'. (errno: 13). Does anyone have any

Re: Mysql List Bounce Message?

2001-09-21 Thread Colin Faber
As near as I can figure there are a few people out there that have yet to setup their MTA's correctly, so they think they're receiving messages for any addresses in the headers of the email. Jason Frisvold wrote: Can anyone explain why I'm getting a Mail account is disabled message from

Re: Mysql List Bounce Message?

2001-09-21 Thread Colin Faber
Also, a simple fix for you sendmail guru's HFrom: tab $check_from Scheck_from [EMAIL PROTECTED] tab $#error $@ 5.5.5 $: Broken MTA, Message ignored Cheers. Colin Faber wrote: As near as I can figure there are a few people out there that have yet to setup their MTA's correctly, so

Re: Illegal table names

2001-09-20 Thread Colin Faber
you can try DROP TABLE `table name`; Håkan Elmqvist wrote: By accident, I don't know how (perhaps microsoft played me a trick), I managed to create a table with a name containing spaces i. e. a useless table with an illegal name. Now would like to drop that table. Is there anyone who

Re: Illegal table names

2001-09-20 Thread Colin Faber
forward ticks Håkan Elmqvist wrote: Thanks for your very rapid response but: mysql show tables; +--+ | Tables_in_test | +--+ | personer | | resultat impl VT2001 | | tentamen_impl_vt2001 | +--+ 3 rows in

Re: Illegal table names

2001-09-20 Thread Colin Faber
if all else fails shut the db down and go in your db directory and just delete the data files ;-) Håkan Elmqvist wrote: mysql drop `resultat impl VT2001`; ERROR 1064: You have an error in your SQL syntax near 'resultat impl VT2001`' at line 1 I don't seem to have the proper character `.

Re: PHP variable conversion problem.

2001-09-20 Thread Colin Faber
This really isn't a MySQL question and should be handled by another list, But to answer your question (logically). You need to have the whole string `productcategory.ID=\$cat\' optional, so that if your variable `$cat' isn't populated the string `productcategory.ID=\$cat\' isn't included, Also

Re: Error From Web Site

2001-09-18 Thread Colin Faber
Try the PHP list, This is not a MySQL error. System Administrator a.k.a. The Root of the Problem wrote: I am getting a Warning: Supplied argument is not a valid MySQL result resource in /usr/home/tsguide/html/ssi/phpfunctions.php on line 48 No results were found ... Pointers

Re: EMS MySQL Manager 0.92 released

2001-09-17 Thread Colin Faber
No problems here, Possibly mailing list issues? Peter Harvey wrote: Ok... this is getting out of hand. Is it just me or are we getting a posting every week on this? Please keep these postings to majour releases (1.0, 2.0, etc)... at most. Post your minor releases to your own mailing

RE: surely an easy quick one

2001-09-14 Thread Colin Partridge
select count(*) from table where team='support' group by team I think that should be a group by name not by team. -- Colin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

RE: surely an easy quick one

2001-09-14 Thread Colin Partridge
GROUP BY name; replacing bob with whover you wish to count -- Colin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

RE: surely an easy quick one

2001-09-14 Thread Colin Partridge
Please ignore my last post. I had lost track of what you were trying to achieve with your query. -- Colin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

RE: surely an easy quick one

2001-09-14 Thread Colin Partridge
O.k, how about this query. SELECT DISTINCT name,count(1) AS numPeople FROM tester Where team ='support' GROUP BY team Its a bit dirty and it returns an extra column, but this could be ignored -- Colin - Before posting

Re: DBI-1.18.tar.gz Can't gzip -cd

2001-09-14 Thread Colin Faber
I would even suggest not using zcat given the solaris version only examins .Z files. try: cat DBI-1.18.tar.gz | gunzip - | tar xvf - this should work on all versions of solaris any just about any other unix (assuming gzip is installed with a working tar) Adams, Bill TQO wrote: rjtalbo

LAST_INSERT_ID() does not return anything

2001-09-11 Thread Colin
since the same script works on one machine and not on the other, the problem lies with the set up. Unfortunately I don't know much of the details of the set up, so can anyone make a guess as to what might be the problem. Thanks Colin

Re: MySQL and Perl (STOP)

2001-09-11 Thread Colin Faber
STOP PLEASE. Not again. See mailing list archives. [EMAIL PROTECTED] wrote: PHP's mysql_fetch_array() fetches an associative as well as indexed array...or you can specify which. (I'm a huge fan of perl, btw, and have used it to talk to mysql when PHP was just a baby language so no

Re: problem with using mysqladmin

2001-09-08 Thread Colin Faber
if(redhat){ Fear RPM install's } else { ./mysqladmin -uroot -hlocalhost password } Farzad Faramarzi wrote: Hi I tried to set the password to mysql by using mysqladmin and I received the following error message -

Re: output to csv

2001-09-04 Thread Colin Faber
Yes, the same way you would with the INFILE syntax Steve Doig wrote: Hi Folks, I'm running a batch command in win2K: cmd mysql batch-file output.txt In the batch file, can I specify that values are separated by commas instead of tabs? Cheers, Steve

Re: MAILER-DAEMON@123box.co.uk: 123box.co.uk mail delivery system

2001-08-31 Thread Colin Faber
Yes. s . keeling wrote: Is anyone else getting these goofy bounces from 123box.co.uk besides me? Should I report them to Spamcop? :-) database, sql, ... -- Any technology distinguishable from magic is insufficiently advanced. [EMAIL PROTECTED] TopQuark Software Serv.

Re: FW: sql

2001-08-27 Thread Colin Faber
With out knowing the exact error im guess its because you're trying to start the server as root. Sheena Sidhu wrote: Hi All, I have installed mysql-max. Previously I had the mysql verion 3.23.40 without max libraries on the same machine. When I start the server , I get the

Re: ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë

2001-08-22 Thread Colin Faber
Sasha, Are you sure its working? Zusky wrote: Part 1.1Type: Plain Text (text/plain) Encoding: quoted-printable Name: ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë.doc.com ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë.doc.comType: MS-DOS Application

Re: ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë

2001-08-22 Thread Colin Faber
sendmail++ Van wrote: Colin Faber wrote: Sasha, Are you sure its working? Zusky wrote: Part 1.1Type: Plain Text (text/plain) Encoding: quoted-printable Name: ´óÇ°ÖÃÖ÷ÒªÉè¼Æ˼Ïë.doc.com ´óÇ°ÖÃÖ÷ÒªÉè¼ÆË

Re: ???œ???Ÿ??????????

2001-08-22 Thread Colin Faber
Sasha, Hey that works for me. I'm personally not to fond of HTML email any ways ;-) Sasha Pachev wrote: On Wednesday 22 August 2001 01:53, Colin Faber wrote: Sasha, Are you sure its working? That is a bug in the filter, or rather a lack of feature. It is currently treats

Re: password()

2001-08-22 Thread Colin Faber
Are you sure its not the full page ads and embedded ad-spam in cnet articles? s. keeling wrote: On Wed, Aug 22, 2001 at 03:19:43PM -0600, Sasha Pachev wrote: Just to make it difficult for people to migrate to Oracle, the only documentation that we provide for the PASSWORD() function

Re: Got an error reading communication packets

2001-08-07 Thread Colin Faber
Before posting, please check: http://www.mysql.com/manual.php (the manual) -- http://lists.mysql.com/ (the list archive) DS wrote: Anyone seen this in your log file before? It's perlscripts on the same host, so before the DBI routine all the data needed for an insert is

Re: WANTED: Utility to reverse engineer existing database

2001-08-06 Thread Colin Faber
For mysql you can use mysqldump Kevin wrote: I need a utility that will probe my existing mysql database, analyze the 90+ tables and spit out the data definition language (create table, create index, etc.) needed to recreate the database. Does such a utility exist? Kevin

Re: Fwd: This Ad Really Works!!!

2001-08-02 Thread Colin Faber
Is the filter no longer working? snip bullshit spam PS database - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

Re: Storing passwords

2001-07-29 Thread Colin Faber
char(16) or char(32) with PASSWORD() function or your own crypt ;-) Hamid Mukhtar wrote: Hi, Is there any data type for storing passwords in tables so that they cannot be viewable by anyone. - Before posting,

Re: subqueries?

2001-07-27 Thread Colin Faber
No that's a 4.1 TODO. Bryan Capitano wrote: Do any of the newer versions of MySQL support sub-queries yet? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: SUSAN

2001-07-27 Thread Colin Faber
Steve, They're both messages sent from windows machines infected with the SirCam worm, Just discard them. Steve Brazill wrote: Here's another one that appears to be a 'carrier' for something devious... (though I didn't see any attachments) How did it get thru the list without any of

Re: Is last_insert_id reliable?

2001-07-20 Thread Colin Faber
Adding, For that thread. selecting LAST_INSERT_ID() for a pseudo-foreign keys system is reliable. The only case I can possibly think of, Of this being a problem is when you're dealing with a persistent connection to the database which is shared among multiple applications. Jonothan Farr

Re: unsuported function

2001-07-18 Thread Colin Faber
Try a PHP mailing list, This is off topic. axel yson wrote: Fatal error: Call to unsupported or undefined function mysql() in /usr/local/share/apache/htdocs/test.php3 on line 13 - Before posting, please check:

create new user in mySQL

2001-07-17 Thread Colin TMC
I am moving from MS SQL to mySQL, Can anybody know how to create and grant rights for a new user except of root? Thanks! - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Problems installing under solaris 2.5.1 ... Fixed

2001-07-16 Thread Colin Faber
: Hi Colin: I once again want to thank you for the info. I had indeed installed a 'package' gcc compiler from sunfreeware. I followed your advice and I downloaded gcc 2.95.3 source and compiled it on the machine that I was trying to install mysql and sure enough I got it compiled. This would

Re: problems untarring mysql under solaris

2001-07-15 Thread Colin Faber
Hi, This is a known problem with solaris tar, I suggest you use gnu tar for solaris, This should solve your current problem. You can get a pre-build package of gnu tar at www.sunfreeware.com [EMAIL PROTECTED] wrote: Hi all: I am running solaris 2.5.1 and I am having difficulties

Re: Problems installing under solaris 2.5.1

2001-07-15 Thread Colin Faber
You need to make sure that the gcc on your box is build on that box, Using a package won't do it, most of them where compiled on greater or lesser hardware versions than you might be running, This in turn causes the compiler it self to think that its running in cross-compile mode and mysql

<    1   2   3   >