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

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

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

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

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]

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

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

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: 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

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]

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

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

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

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]

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

ended 　　　　Jack [EMAIL PROTECTED] 　　2005-05-04

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]

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: 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

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

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: > >

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: 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

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: 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

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

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: &

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;

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]

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

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&#

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: 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

"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

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

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: 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

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

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: 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

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

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 -

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: 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: 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

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: 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

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: 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: 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

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: 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

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

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]

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

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

Mysql-standard-4.0.15 Library problem

rsion of mysql when I've already insalled 4.0.15? Please advise. Thank you, -- Jack Gorski Parallel Software (630) 420-9929x12 mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

$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

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 -

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

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]

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

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

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

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

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

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!?

why it run so slowly

: WIN98 SE Jack __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php

Re: mysqld refuse to die

ed the job for almost 10 hours and now it is in *wait 4* state. Anything I can do about this? Should I wait till it is done or there is no hope and I just need to stop it and ran again? Thanks, Jack ++++ Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bun

Re: mysqld refuse to die

I have just figured out: kill -9 xxx (process number) Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED

mysqld refuse to die

Hi All, Please help me with this problem: For some reason, I could not bring down my mysqld by running mysqld stop An error message indicate: fail What's going on? Thanks, Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown

Re: access denied for user: root@localhost

Thanks, but I still got complains that can't access server: 'Access denied for user: 'root@localhost' (Using password: YES) Is it possible that for some reason the password is wrong? You input is greatly appreaciated, Puzzled newbie, Jack +

Re: access denied for user: root@localhost

version information and exit -w, --wait[=retries] Wait and retry if connection is down ++++ Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 36769

access denied for user: root@localhost

Dear all, When I ran the follwing command: >$ mysqladmin -u root password PASSWORD mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: 'root@localhost' (Using password: NO)' Could

mysql: access denied for what?

Dear all, After I made mysqld running, I then tried: >mysql -u root ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO) What does this mean? Thanks Jack Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungto

Startup question: MySQL comes with RedHat 7.3

Hi All, I just installed full RedHat7.3, which comes with a MySQL package. I am wondering whether it is only a client or both client and server. I could not find that mysql.server command. How should I start the server if there is a server? Thank you for your attention. Jack

re: Can't run mysql after installation

Thanks Victoria, You are right. Thanks! But right now, I am stuck with the installation of Msql-Mysql-module. I know that I have to let the server run in order to do the "make test" part, but still 87% of the tests failed. Do you or anybody else have any suggesti

Can't run mysql after installation

Dear All, I met with this problem when I tried to run mysql: ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) I have already installed server, client, devel, and need to install bench. Thank you for sug

Problem: install Data-Dumper

rst use in this function) Dumper.xs: In function `XS_Data__Dumper_Dumpxs': Dumper.xs:643: `sv_undef' undeclared (first use in this function) make: *** [Dumper.o] Error 1 Could anybody advise me what's going on? Thanks, jack ++++ Jack C

how to make a MySQL server run and how to check

if the server is running? I tried to use: top | grep mysql - but not working. Any suggestions? Thanks! Jack Chen, Stein Lab, Cold Spring Harbor Labs 1 Bungtown Road, Cold Spring Harbor, NY, 11724 Tel: 1 516 3676904; e-mail: [EMAIL PROTECTED

rpm -i MySQL: exist or not?

The strange thing I met with is that when I ran rpm -e XXX.rpm It said that the package in not installed. But when I ran rpm -i XXX.rpm It said that the package already exist. I am new to MySQL. Any idea is greatly appreciated. Jack Jack

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

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 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

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 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!

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

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

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

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

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

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

PCAnywhere like linux client - mysql data files administration

subject: PCAnywhere like linux client - mysql data files administration Hi, I remember seeing a program awhile back that acts like pcanywhere or terminal services, to connect to a linux or windows box. Anyone remember the name? Thanks, Jack

Browser caching problem OR mysql/perl code?

eries I am using in perl. Any ideas how I can write my queries in a select so that it is sure to pick up any recently changed data from the database that might have just been written? Thanks, - Jack p.s. please cc: to [EMAIL PROT

MyODBC Problem with SQL2000 -> MySQL Data Transformation

of population, each failing with this error code. I'm beginning to think it is the MyODBC driver. I connect to SQL2k with OLD DB and use MyODBC to connect to MySQL. Have any of you tried doing this yet? Just curious that maybe you have run into this before. Thanks

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]>

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

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"

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

samp_db?

The www.mysql.com/Contrib/Examples Webpages doesn't exit anymore, please tell me where I can get samp_db, or another sample for me learn mySQL. -- Best regards Jack Su - Before posting, please check: http://www.mysq

  1   2   >