can't start mysqld

ile=/var/run/mysqld/mysqld.pid jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Can't create interrupt-thread (error 11, errno: 0)

ended 　　　　Jack [EMAIL PROTECTED] 　　2005-05-04

Strange Command on Load Data!

Dear all I had use the Load Data Command to import my CSV file from my client side of pc to the Mysql database which located in Server side. The command i type is follow: Load Data local infile 'c:\\Doucments and Settings\\jack\\Desktop\\Web\\test\\hkd_rate.csv' into table hkd_depos

problem on Load Data!

into table hkd_deposit1 fields terminated by ',' " It said couldn't find the file! but if i put the file into the data directory of mysql, then it can find it! So what should i do if i want mysql will able to

How to Load a Database to other Server

! Jack [EMAIL PROTECTED] - 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 unsubscr

Problem on Load Data!

eld in my CSV file (hkd_rate.csv) 1. hkd_rate i want to only insert this colume of data into hkd_deposit table's hkd_rate field! the other fields data of the table will remain the same! So how i can do it? Thx a lot! Jack [EMAIL PROTECTED] --

How to retrieve the lastest update or insert record?

Dear all I had a table which containing (date/time) field, now i want to retrieve 5 most latest update / insert record from that table, what query should i use? Thx a lot! Jack [EMAIL PROTECTED] - Before posting, please check

Question on auto_increment

e the record in index 2 which is between 1 and 3, then will it leave a index gap between or it will move the record of index 3 up to index 2??? Thx Jack - Before posting, please check: http://www.mysql.com/manual.php (the m

How to remove User in Mysql

Dear all As i had granted permission to user, now i want to remove particular permission off from the user, could you pls tell me how to do so??? And what should i do if i want to remove a user? is mysql got something like "User Group"

Getting to latest 5 Records

Dear all I had a table which with Auto_increment, which means when i insert a record there will be a number insert to lead as the location of the record. here is my question. I was try to get the most last five records , but i don't know which query should i use? Thx

Security problem in Access database

ng really stuck!! Cheers Jack - 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]>

how to load data to a table's specific field

Y#rate 04USD#rate When i import the csv file, it will only replace the field C without changing any values on field A & B. Please help me with this, it is urgent!! Thx a lot Jack [EMAIL PROTECTED] - Before p

How to create a table from other tables

ice if you can provide me a simple example! Thx jack [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

LAMP Experts Needed

at [EMAIL PROTECTED] It is going to be a web interface interacting with a very large database. -- Jack Gates http://www.morningstarcom.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

ORDER by Question

return the word "The" but have it sort on whatever the second word is. Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: ORDER by Question

My thanks to all that responded. I used Mathias's suggestion to solve the problem. You can see the results here. http://www.tasteofwhatcom.com/restaurants-tow/filter.jsp?field=city&value=Blaine Thanks again for your help. Jack Mathias wrote: Selon Jack Lauman <[EMAIL PROTECT

Calculate LONG/LAT from ZIP+4

A couple of months ago these was a discussion about ZIP code plotting on this list. Does anyone know how to calculate LONG/LAT coordinates from ZIP+4? Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Query Question

RestaurantWebsites ON ( Restaurant.RestaurantID = RestaurantWebsites.RestaurantID ) WHERE RestaurantWebsites.WebsiteName = 'TOS' ORDER BY Cuisine ASC LIMIT 0 , 300 Thanks Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscrib

Query Question...

ebsiteName = 'TOW' GROUP BY w.WebsiteName, r.Cuisine Thanks. Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query Question...

Sorry... I was having a brain fart. (I use entries in the web.xml file to generate a dropdown list of cuisines). The field cuisine is part of the restaurant table. And it does not accept a null value. It should be split out into it's own table. I do need to get a SUM of all the values retu

Unknown command '\'' during load

ion rows, so it would be nice to be able to restore it if necessary :) I'm just trying to figure out if it's a data problem, version problem, or something else. -- Jack Baty Fusionary Media - http://www.fusionary.com -- MySQL General Mailing List For list archives: http://

Re: Unknown command '\'' during load

like there should be a return or two in there, but apparently it doesn't work that way. > > On 3/17/06, Jack Baty <[EMAIL PROTECTED]> wrote: > > I'm trying to restore a database from a dump as part of my > > make-sure-this-will-restore-just-in-case process and I g

Re: Unknown command '\'' during load

> I don't know for sure that this is going to be the problem but it's always > something to look at when you start dealing in larger dumpfiles. I hadn't considered that. I think I'll also be dealing with net_buffer_length, since it seems that is what actually affects the d

A Blob That's a String??

pics, where there is only one longblob in the table, it prints out a tremendous load of data which indicates to me that a binary file has indeed been loaded. What I am trying to ascertain is why is this longblob considered a string? How can I more properly test if a binary file has been loaded? TIA, Jack

RE: A Blob That's a String??

tring! However, when I change this line in my code: content = cursor.fetchall()[0][0].tostring() to this: content = cursor.fetchall()[0][0] I get this error: What's frustrating is that this code had worked before. That is why I ask, how do I test that MySQL has uploaded a binary file? TIA, Jack

SQL for Subversion update-report

ot;old.rev_id < new.rev_id" with "old.rev_id < MIN(new.rev_id)" but got a MySQL error: Invalid use of group function Can anyone recommend how best to query the database for a list of pages which changed since the current state of the working copy, and whether those pages are newly created? Much thanks, Jack signature.asc Description: Digital signature

ordered list of titles, with fallback if title is only available in another language

Or how to get the value of column b in each group which corresponds to the maximum value of column c? Much thanks, Jack signature.asc Description: This is a digitally signed message part

select timestamp + 0

Hi, i'm using the 4.1.10 version of mysql. If I do : select max(timestamp + 0 ) as timestamp from news; ++ | timestamp | ++ | 20050314194920 | ++ so i got the full timestamp(14), but if I do : select max(timestamp) + 0 as timestamp from news;

Re: select timestamp + 0

an without the max. is this a bug ? (the code rely heavily on a result as a timestamp(14), like MMDDHHmmss, so getting this work helps migrating from 4.0 to 4.1) thanks for your help On Wed, 16 Mar 2005 14:36:42 -0600, gerald_clark <[EMAIL PROTECTED]> wrote: > Mister Jack wrote: &

Re: How to add String to existing value of String

Look for concat : http://dev.mysql.com/doc/mysql/en/string-functions.html On Wed, 16 Mar 2005 15:51:34 -0500, David DeSana <[EMAIL PROTECTED]> wrote: > I need to modify the value of file names in a table. The strings represent > an image file path and are stored in a char column in the table. He

Re: select timestamp + 0

ber (which is different from adding 0 to a timestamp). MIN/MAX operating on timestamp would have been more straightforward, no ? Or is there anything to coerce a string into a timestamp ? (appart a format ) On Wed, 16 Mar 2005 15:40:26 -0600, gerald_clark <[EMAIL PROTECTED]> wrote: > Miste

BDB storage engine

Hi, There is an extensive documentation for InnoDB, but I can't find any extensive for BDB (except http://dev.mysql.com/doc/mysql/en/bdb-storage-engine.html ). Can I change the isolation level in the same way than with InnoDB ? Can I also do SELECT FOR UPDATE ? thanks -- MySQL General Maili

Re: I am stupid>>

I would suggest to take a look at the documentation http://dev.mysql.com/doc/mysql/en/index.html 1. create a DB : http://dev.mysql.com/doc/mysql/en/index.html 2. using a SQL file to create those table. on the mysql commqnd line : source db.sql; So as a whole, you'll do something like : create d

Warnings level

Hi, I've got a dump file from my main DB (MySQL 4.1.10a), when I load it with "source backup.sql" I can see some warnings around. Is there any way to log those warnings, or to stop on warnings ? (show warnings only show warnings for the _last_ query if there is any). Thanks for your help -- MySQ

Re: Warnings level

Hi ! Thanks, for your answer. Indeed, I didn't think about the verbose option. I tried it and used "tee" to log data. Well so far I haven't got anymore Warnings (strange though...) :-) On Apr 5, 2005 9:50 PM, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > >

Re: Warnings level

Hi, I got back warnings, event when started with mysql -v -v, I don't have the Warnings appearing on the console... Do I really have to insert SHOW WARNINGS; in the dump file after each statements ??? On Apr 7, 2005 6:10 PM, Mister Jack <[EMAIL PROTECTED]> wrote: > Hi ! > &

Re: Warnings level

Invalid TIMESTAMP value in column 'timestamp' at row 5407; (I still have to figure this out :) On Apr 8, 2005 6:08 PM, Mister Jack <[EMAIL PROTECTED]> wrote: > Hi, > > I got back warnings, event when started with mysql -v -v, I don't have > the Warnings appearing on

Client Side Query cache

Hi, I was wondering if there is any query cache code/lib somewhere to cache certains queries ? I'm always doing the same queries, (and the result never change, so I could spare the round-trip to the server), but caching each tine the data for it is a bit of work. Thanks, for your suggestions -- M

Re: LEFT JOIN to a table using 2 keys from different tables

only has the keys > individually in two separate tables, [...] -- "What we observe is not nature itself, but nature Jack McKinney exposed to our method of questioning. http://www.lorentz.com -Werner Karl Heisenberg

Query Question

I have a table containing information about different businesses. I want to randomly select a single row from the table using a prepared statement in a java bean. What is the most eficient way to do this? TIA Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Big Mistake Need Help, can I undo an action I did?

Hi guys, I had updated a field for all the entries in a table by mistake, I need to undo that step. I dont have the database back up to an stisfactory level. Is there a way in MySQL I can step one action back? or undo one command that I just did?? Thanks a lot guys!?

RE: Really stupid Question...

as shell prompts. Jack -Original Message- From: Ola Ogunneye [mailto:[EMAIL PROTECTED] Sent: Friday, August 01, 2003 8:28 AM To: [EMAIL PROTECTED] Subject: Really stupid Question... I am a Windows User and very used to the Dos Prompt. Can someone please tell me what the Shell Prompt is

Performance questions

ld 2GB RAM and I'm already at 1.5GMB. I've modified the RTG table structure to use different indexes and modified the Perl/PHP scripts to suit those changes and gotten significant performance boosts from that. What I really need are system tweaks and configuration changes to improve perfo

Problem with date query

all of the desired rows except those for the current date. How can I correct this? SELECT date, time, am_pm, tz, height, cond FROM cherry_point_tides WHERE TO_DAYS(date) - TO_DAYS(NOW()) <= 6 and date > NOW(); Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.my

Join syntax diff 3.23 to 4.x?

Is there something about 3.23 that makes this illegal? It is fine on 4.012. SELECT [lots of columns] FROM new_people p LEFT JOIN new_address ad ON p.address_id = ad.id JOIN list_states ls ON ad.state = ls.id WHERE p.company_id = 1 Will some minor rewording help it run on both versions OK? -- M

RE: Join syntax diff 3.23 to 4.x?

3.23 to 4.x? Try changing "JOIN list_states " to "INNER JOIN list_states " Looks like the earlier version didn't like your (synonymous) wording. > -Original Message- > From: Jack Dare [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 14, 2003 8:35 AM

Query question

= account.account_id) WHERE account.account_id = 13; One I get the query to work right I neet to write it to a file in CSV format. Any help would be appreciated. Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Delete questions and speed/safety issues

is a primary concern. If this takes a day or two to run but the application can be running at the same time then there's no problem. But if I have to shut down my application for any appreciable length I time, then I have to find another way of doing this. Thanks, Jack Jack Coxen IP Network Engineer TelCove 712 North Main Street Coudersport, PA 16915 814-260-2705

RE: Delete questions and speed/safety issues

of data) would be to add another couple of drives to the server and then split the tables among them with links back to the original database directory - sort of 'poor man's RAID'. Drives I can get...it's the RAID controller and enclosure that is the sticking point. Jack -

Newbie question about blob data types ie. Storing .xls in blob

Is it possible to store an excel file into a blob field in mysql? If so how do I go about importing the file into the blob field, and get it back out into an .xls file? Thanks in advnace Jack Taffar AOG -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Help with date query

red = 1 WHERE TO_DAYS(NOW) - TO_DAYS(RenewalDate) < 30; Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: How to turn rows into columns

sstab-1.17. Hope this helps, Jack -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 29, 2004 2:34 PM To: [EMAIL PROTECTED] Cc: MySql List Subject: Re: How to turn rows into columns What you are trying to create is called a "pivot table&q

RE: Space is filling up

If you database contains time-based data you could age out old records. I only need to keep data for 6 months so I run a nightly script to delete any records more than 6 months old. And before anyone asks...yes, I also run another script to ANALYZE/OPTIMIZE my tables. Jack -Original

RE: Space is filling up

And since hard drives are so cheap now, I'd be tempted to go that route even if he can age out data. I'm seeing ads for 200G drives for $90.00. Jack -Original Message- From: gerald_clark [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 07, 2004 5:06 PM To: 'Asif Iqbal&#

$sth->rows problem

$statement="DELETE FROM ifInUcastPkts_$rid WHERE dtime < '$deldate $deltime'"; &run_query($statement); print "$statement\n"; $statement="DELETE FROM ifOutUcastPkts_$rid WHERE dtime < '$deldate $deltime'"; &run_query($s

Trusted Solaris

Has anyone had experience with running MySQL on Trusted Solaris? Thanks, Jack -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Index not functioning

have any suggestions on what is going on and how I can fix it? Any help would be greatly appreciated. Thanks, Jack Jack Coxen IP Network Engineer TelCove 712 North Main Street Coudersport, PA 16915 814-260-2705

RE: Index not functioning

Is there a way of changing what it believes? The resultset size is only a few thousand lines. And, btw, why does it believe that a table scan is more efficient than using an index? Jack -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 24

RE: Index not functioning

sec) Is my syntax wrong? The resultset size should be around 8640 rows - 5 minute interval data for 30 days - 12 X 24 X 30 = 8640 -Original Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 1:22 PM To: Jack Coxen; MySQL List (E-mail) Subject:

RE: Re[2]: Index not functioning

;standard" system so I'm hesitant to modify the index structure. I don't want to run into problems with future revisions. Right now, I just want my existing indexes to work. Jack -Original Message- From: Richard Davey [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 24

RE: Index not functioning - update

7;ll do that if I have to but I'd prefer to fix the existing setup of a single index on dtime. Jack -----Original Message- From: Jack Coxen [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 24, 2004 1:51 PM To: '[EMAIL PROTECTED]'; MySQL List (E-mail) Subject: RE: Index not fun

RE: Index not functioning - update

No, this is a production system. I can't risk running non-production level software. I could try 4.1.1 on my development system but, even if it worked, I still couldn't put that solution into place on the production server. Jack -Original Message- From: dan [mailto:[EMAIL

Re: MySQL 5.0 - What is really available?

I prefer SQLyog. www.webyog.com Ditto that. I used to use MySQL-Front, but switched when development stopped. I don't miss it really. The structure synchronization and db job agent features are maturing rapidly and work quite well. Saves a ton of time for me. Not sure about v5.0 support yet, bu

Query in MySQL vs. PERL

would be best. I'm running MySQL 4.0.16 standard on a Sun e250 running Solaris 8. The database consists of around 650 tables ranging in size from 20 KB to 3-4 GB (approx. 12 million records). Any help and advice would be greatly appreciated. If more info is needed, please let me know. Ja

RE: export to csv or excel

fairly easy and the documentation that comes with the module is clearly written with tons of examples. Jack Jack Coxen IP Network Engineer TelCove 712 North Main Street Coudersport, PA 16915 814-260-2705 -Original Message- From: Bart De Man [mailto:[EMAIL PROTECTED] Sent: Thursday, April

RE: when 4.1.2 release

Is there a planned release date for the production version of 4.1 x? I'd love to be able to use sub-queries but I don't want to use a non-production version on a production database. Jack -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Monday, April 19, 20

RE: Case Sensitive

This isn't caused by MySQL. It's an OS issue. Linux and Unix are case sensitive operating systems so any program you run, unless it is specifically written to be NON-case sensitive, is case sensitive as well. Jack -Original Message- From: Andre MATOS [mailto:[EMAIL PROTE

Complicated query problem

AND speed!='2400' AND speed NOT BETWEEN '4000' AND '4600' AND speed!='1' AND speed!='15500' AND speed NOT BETWEEN '59900' AND '65000' AND speed!='

RE: many updates really slow

ably being killed by transmission time. Transferring the file in toto to the US server will be quicker than having the communications lag of doing sending a command from Europe to the US, having the command execute and then receiving the status back in Europe...times 5000 records. Hope this helps, Jack -

RE: many updates really slow

e file, it goes back to sleep. Jack -Original Message- From: William Wang [mailto:[EMAIL PROTECTED] Sent: Thursday, May 06, 2004 1:43 PM To: Jack Coxen; [EMAIL PROTECTED] Subject: RE: many updates really slow Thanks Jack and Jeremy. But this is part of my application and I need to do this a

ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES)

ECT USER,PASSWORD FROM USER' and have verified the password field for 'abcd' was instantiated. Can anyone inform me how to cause MySQL to use passwords? Thank you. -- Jack J. Woehr# "[F]ar in the empty sky a solitary esophagus slept http://www.well.com/~jax

Re: Problem Installing MySQL Max

Lou Olsten wrote: > I haven't figured out where to get the libstdc++ That's part of gcc usually found in /usr/local/lib or in the lib dir under the gcc installation dir. -- Jack J. Woehr# "[F]ar in the empty sky a solitary esophagus slept http://www.well.com/~jax

Re: ERROR 1045: Access denied for user: 'abcd@localhost' (Using password: YES) SOLVED

ges or to create a second account for [EMAIL PROTECTED] with a password required to supplement the [EMAIL PROTECTED] with a password required. -- Jack J. Woehr# "[F]ar in the empty sky a solitary esophagus slept http://www.well.com/~jax # upon motionless wing; ever

DISTINCT query

00' AND speed!='1000' AND speed!='1200' AND speed!='2400' AND speed NOT BETWEEN '4000' AND '4600' AND speed!='1' AND speed!='15500' AN

RE: DISTINCT query

the before and after data. Jack -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 01, 2004 1:52 PM To: Jack Coxen Cc: MySQL List (E-mail) Subject: Re: DISTINCT query Jack, I am not sure what you want your output to look like... If you want the sa

"not unique table/alias"

I have two complex subqueries that I need to join. I suspect this problem is due to using aliases instead of table names, but I don't know how to work around it (temporary tables?). Please help. SELECT col FROM (subquery-1) AS t1, (subquery-2) AS t2 JOIN t1 ON t2.col = t1.col; Not unique table/alia

how to setup mysql with Solaris 8?

: # mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) # And I get the error message shown above. What should I do to set it up? Thanks. Jack __ Do You Yahoo!? Send FREE Valentine eC

How to setup MySql on my Solaris 8?

entered /mysql/bin and tried running mysql, but get such an error message: # mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) # I don't get it. Jack __ Do You Yahoo!? Send FREE Valenti

How to setup MySql on my Solaris 8?

entered /mysql/bin and tried running mysql, but get such an error message: # mysql ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) # I don't get it. Jack __ Do You Yahoo!? Send FREE Valenti

mysqldump does not seem to work as in documentation

>Description: on red hat linux 7.2 on an intel box mysqldump --opt -u geo -pmy_pass --where="some condition" AIRDB UniversalCdrEast | mysql --compress -h some_ip -u geo -pmy_pass AIRDB yielded an error 1035: empty query >How-To-Repeat: >Fix: had to spel

Re: HP-UX 10.20 and MySQL

ines. Hope this helps. Jack Challen Technical Consultant OCSL Varvarigos Harry wrote: > > Is there some kind soul out there that can email me a > tarball og the MySQL module for an HP-UX machine? I've tried to compile the > module - but it says

Re: Hello please help me out

[EMAIL PROTECTED] wrote: > > try > > echo file.sql > mysql -u username -p password databasename > You mean: ^ cat file.sql | mysql -u username -p password databasename ^ Or, better: mysql -u username -p password databasename <

Re: Diagrams and Flowcharts on mySQL tables

Try Dezign for Databases. Works pretty well and is much cheaper than the big ones (ER/Studio and ERWin) http://www.datanamic.com/dezign/ -- Original Message -- From: Robert Goeres <[EMAIL PROTECTED]> Date: Sat, 30 Jun 2001 16:37:28 +0200 >I have a bu

Re: Easiest way to create a duplicate of a db?

x27;d check that s// expression before I used it) > You'd want to use sed, not grep. -- Jack Challen Technical Consultant OCSL http://www.ocsl.co.uk/ - Before posting, please check: http://www.mysql.com/manual.php

salvaging database

don't know the size and type of all the fields. Thanks for your help, Jack Cushman (Please CC me; I'm not on the list) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists

Re: Can anyone do this ?

during the session in which it is created (you can't find it with freemascon or any other tool that I am aware of) after the session is completed the temporary table is poofware. hope this helps. Jack :-)= - Original Message - From: "Web Depressed" <[EMAIL PROTECTED]> T

Re: HELP!!

elaine; Put the escape character in front of it (/') jack :-)= - Original Message - From: "Elaine Silva" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Wednesday, February 21, 2001 6:17 PM Subject: HELP!! > Please, >

SELECT * EXCEPT field1, field2

re an easy way to do this? thanks so much...hope this isn't to dumb of a question... Jack Dempsey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the

Re: how do you format this query?

If all you need is a count of the items why not issue Select count(distinct threads) as ctr from messages Jack ;-)= - Original Message - From: "Ed Lazor" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, February 28, 2001 11:53 PM Subject: how do you for

Re: Join syntax

tblc.* from tblb left join tblc on tblb.flda = tblc.flda hope this helps. Jack :-)= - Original Message - From: "Willie Klein" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, March 06, 2001 2:20 PM Subject: Join syntax > Hi all: > I think what I want

RE: shared library libz.a

Umm I went looking for libz.a under which subdirectory? I checked lib and gnu, and no libz.a unless I am looking in the wrong place. -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Friday, March 16, 2001 8:59 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] S

RE: can't find shr.o???

://www-1.ibm.com/servers/aix/products/aixos/linux/download.html for the packages. Enjoy, Jack -Original Message- From: Tim Tyler [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 3:55 PM To: [EMAIL PROTECTED] Subject: can't find shr.o??? Mysql experts, I downloaded the b

RE: can't find shr.o???

directory. -Original Message- From: Tim Tyler [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 22, 2001 4:28 PM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: can't find shr.o??? Jack, My AIX oslevel reports 4.3.2. The zlib package is already installed. The libz.a fi

HELP? RE: can't find shr.o???

m the link below, and then dropped the binary distro. it worked flawlessly that time (once I had the files and libs). Sorry to say this, but I am at a loss. Can any one else help? Jack -Original Message- From: Tim Tyler [mailto:[EMAIL PROTECTED]] Sent: Friday, March 23, 2001 11:13 AM

GUI

Why is the table of columns off by 1 ? The registration seems to bypass the privileges column. Thanks ~~~jci~~~ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Core dump on MySQL 3.23.36 on RedHat 7.0

$ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file --skip-locking >>$err_log 2>&1 010327 16:23:36 mysqld ended I can't find any indications of whats wrong

fairly new to Linux, very new to MySQL

word and I couldn't find a default password for the root account in the documentation. Microsoft has made me stupid but I'm trying to heal myself. If I can figure out how to get logged in I think I'll be OK. Please help. Much appreciated, Jack

using default to assign date_entered

ciate some advice from those who know better... thanks for any thoughts jack dempsey - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To re

Re: TheCasino.com: Registration Confirmation

Under the laws of the State of Washington spamming is illegal. RCW 19.190.040 Violations -- Damages. (1) Damages to the recipient of a commercial electronic mail message sent in violation of this chapter are five hundred dollars, or actual damages, whichever is greater. (2) Damages to an intera

Re: printing camera-ready mysql report

Camera ready means the a commercial printer cn go direct from the provided document(s) to negatives/plates or direct to plate without having to modify the originals in any way. Save a lot of money in make up and AA charges. Jack Andrew Gould wrote: > > Please forgive my ignorance; but w

  1   2   >