Re: Can Expect scripts interact with mysql ?

> Expect is not getting the feedback from mysql output.It keep waiting for "my >sql>" but did not find it. Ah, er. All my mysql+expect experience is on *nix platforms. Sorry, didn't spot that. If it doesn't work to simply call it from a spawned

Re: Can Expect scripts interact with mysql ?

n't spawn directly. I spawn a regular shell and then just send out the command to start it, eg # start up command line interface to mysql send "/usr/local/mysql/bin/mysql -u root -p $dbname\r" and go on from there. Works just fine. --Cindy ---

adding a string to enum

ations','The World in Spatial Terms','Places and Regions','Physical Systems','Human Systems','Environment and Society','Uses of Geography','Issues-Analysis, Decision-Making, Planning and Problem Solving') NOT NULL default '

password stuff

t insecure server & restart normally with --user] But when I do the latter (since that is the situation I have), it's still asking for a password when I start up mysqladmin and doesn't accept anything I give it. So

Re: (fwd) sorting question

, an 1800M file output, 79,603,007 entries to be exact). I would have thought it would be best to have mysql do the sorting before writing out the file, instead of letting it write it out unsorted and using an external sort to sort later? Yes? No? Any comments at all? Hello? Cindy writes: &

Re: (fwd) sorting question

1 1 93 8 (etc) that output takes about three - four hours to create, and its finished size is -rw-r--r-- 1 ctmoore staff1831793634 Jun 22 22:29 newindex.b.txt Is mysql unable to handle something this large when it has to sort as well? Or are there some whizbit things

(fwd) sorting question

. So to add to this question, is there some way of optimizing this? --- Forwarded Message Date:Sun, 23 Jun 2002 10:20:22 +0200 From: [EMAIL PROTECTED] To: Cindy <[EMAIL PROTECTED]> Subject: Re: sorting output Your message cannot be posted because it appears to be either spa

Re: here we go again

"kool", being of course just used illustratively :-) I dunno, it seems like I just wind up reinstalling. So if any of you see something I'm missing here, please feel free to pipe up... Thanks, --Cindy -

here we go again

ap, try to restart mysqld, have a hell of a time doing so, and end up reinstalling the whole damn thing, only to start over again next time. Well this time, I'm yapping for help before touching a single thing, because I don't want to do this *again*. What

Re: mysql.sock

k. I use SuSE 7.0. Good Luck. Cindy At 01:59 PM 6/8/2002 -0500, you wrote: >is not in /etc >how do I put that soft link? > >- Original Message - >From: "adam" <[EMAIL PROTECTED]> >To: "Oscar Mena" <[EMAIL PROTECTED]> >Cc: <[EMAIL

Permissions for mysqladmin

a stand alone Linux server at my house that is rarely connected to anything. I just want to practice my SQL skills. Any ideas. ****** Cindy Nelson(404) 213-9498 cell 202

Re: start up problem

Cindy writes: > >OK, it seems like every time I install mysql, I run smack dab into >some type of access problem -- if it isn't a password hangup, it's a >mysql.sock problem or (at the moment) a refusal to allow me to create >databases. I've puzzled through mo

Re: start up problem

Cindy writes: > >OK, it seems like every time I install mysql, I run smack dab into >some type of access problem -- if it isn't a password hangup, it's a >mysql.sock problem or (at the moment) a refusal to allow me to create >databases. I've puzzled through mo

start up problem

e about once a quarter, it can't find things in the var directory, but I don't HAVE a var directory. (I think the source code dist creates that, but not the binary code dist.) Thanks, --Cindy -- [EMAIL PROTECTED] - Befor

triggers

What's the status of triggers in MySQL? Acording to the book, it's on the to-do list, but has anything been done with it since publication? --Cindy -- [EMAIL PROTECTED] - Before posting, please chec

Re: date comes out as '0000-00-00'

oesn't. If you're trying to insert a date of the format mm/dd/yy into something that's expecting [yy]yy/mm/dd, you're going to run into that kind of "random" problem, most likely on days > 12 (which would not be a reasonable month value and hence invalid). Seems t

binary installation questions

o run mysqladmin -u root password to fix this. BUT!! Everytime I try to do this, whether as myself, as the mysql_st user, or even as root, I get this: [4:17pm] cindy@steph> /usr/local/mysql/bin/mysqladmin -u root password "kool" /usr/local/mysql/bin/mysqladmin: unable to change password; err

Re: LIKE work around??

Paul DuBois writes: >At 12:50 -0800 2/7/02, Cindy wrote: >>"Rutledge, Aaron" writes: >> >MySQL doesn't support LIKE does it? I got an error when I tried. >> >>I use it all the time. Maybe post the error message you got. >> >>

Re: LIKE work around??

"Rutledge, Aaron" writes: >MySQL doesn't support LIKE does it? I got an error when I tried. I use it all the time. Maybe post the error message you got. RLIKE on the other hand --Cindy - Before pos

Re: LIKE work around??

Paul DuBois writes: >At 12:50 -0800 2/7/02, Cindy wrote: >>"Rutledge, Aaron" writes: >> >MySQL doesn't support LIKE does it? I got an error when I tried. >> >>I use it all the time. Maybe post the error message you got. >> >>

Re: LIKE work around??

"Rutledge, Aaron" writes: >MySQL doesn't support LIKE does it? I got an error when I tried. I use it all the time. Maybe post the error message you got. RLIKE on the other hand --Cindy - Before pos

mysql.sock

pretty sure the problem is that the file has been deleted, probably a cron job, but I can't remember the fix. Tried touching it to make it exist again, but of course no go. (And a pointer to the documentation would be welcomed, too...) Thanks, --Cindy

How to load data into non-empty tables

Hello, On Sun Saloris box, can anyone tell me how to load data into non-empty tables? Can you give me an example? Any help appreciates! Cindy >>> Bogdan Stancescu <[EMAIL PROTECTED]> 01/24 4:22 PM >>> Just for the record, found the glitch: somehow, somebody on the way

How to load data into non-empty tables

Hello, Can anyone tell me how to load data into non-empty tables? Can you give me an example? Any help appreciates! Cindy >>> Bogdan Stancescu <[EMAIL PROTECTED]> 01/24 4:22 PM >>> Just for the record, found the glitch: somehow, somebody on the way decided to ch

Re: RE: How to spool a file to your server from mysql

Hi Roger, When I use this on Sun saloris, it does work. mysql> use mysql Database changed mysql> tee /usr/local/var/ub_store it shows syntax error with tee. Can you tell me how to do it on Sun saloris? Thanks! Cindy >>> "Roger Baklund" <[EMAIL PROTECTED]> 01

How to spool a file to your server from mysql

This will create a file on the server. Cindy >>> "Ryan Fox" <[EMAIL PROTECTED]> 01/11 10:10 AM >>> I'm running ok on my Dual PII machine, if this helps anyone. Redhat 7.1, 2.4.2-SGI_XFS kernel, MySQL 3.23.43. [root@willyjr /root]# uptime 1:07pm up 95 days,

Re: RE: RE: RE: Mysql connection problem

Hi Gary, Finally I can access the server. You are my hero. I am new to mysql. It takes me a month to try it. Thank you very very much! Cindy >>> <[EMAIL PROTECTED]> 01/08 11:14 AM >>> from your bindir type: ./mysql -Original Message- From: Cindy Yu [mailto:

Re: RE: RE: Mysql connection problem

much much more experience than me. I am frustrated and can not figure it out. mysql.server file shows: path=/sbin: /usr/sbin:/usr/bin basedir=/usr/local bindir=/usr/local/bin datadir=/usr/local/var pid-file=/usr/local/var/mysqld.pid log-file=/usr/local/var/mysqld.log Cindy >>> Simon Gree

Re: RE: Mysql connection problem

Hi Simon, Thanks for your reply. Can you tell me how to do it? I tried, but it shows me the error: "mysql not found". How can I find mysql server? Cindy >>> Simon Green <[EMAIL PROTECTED]> 01/07 10:05 AM >>> No but you can start MySQL with out grant ta

Mysql connection problem

password? How can I do it? Your answer will be appreciated! Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

question on selects in multiple tables

tried WHERE Inventory.PurchasedBy = Customer.ID OR Inventory.PurchasedBy = 0, but that does not help. Thanks... --Cindy -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://li

question on regexp/rlike -- bugs?

sensitive searches. It makes no difference if I use REGEXP instead of RLIKE. Also, I couldn't find any indication that mysql's regexp understood [0-9] as opposed to [0123456789], am I correct? Again, it makes no difference if I try that notation. Thanks, --Cindy -- [EMAIL PRO

Re: error codes question

Bill Adams writes: >Cindy wrote: > >> I tried checking for error codes in the documentation, but didn't find >> anything particularly useful. >> >> I'm getting this: >> mysql> load data infile '/export/home/Scratch/WordIndex.txt'

Re: Error on new connection socket: Invalid argument

e above in the documentation. Has anyone run into this problem >and found out what is causing it, and how to correct it? Sometimes the file /tmp/mysql.sock is removed by a cron job clearing out /tmp. In which case you may want to redefine socket=/usr/local/mysql/mysql.sock or whatever to avoi

error codes question

gured the mysql installation here (or to the installation of the new machine [sun ultra 450] I'm migrating to, tho that's supposed to have oodles more -- the *reason* for moving in the first place...). Tips, pointers

expect and mysql?

I'm curious -- is there an interface from expect to mysql? I suppose I could just write a small perl script and exec it from expect, but it would be kind of need if I could do the requisite commands directly. --Cindy -- [EMAIL PROT

Re: MySQL with perl

py of the record/element values to myself when I refuse to add it in, but I havne't had any spurious refusals so far. --Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.m

Re: events that i can trigger on intervals.

won't release them AT the time the expiry occurs, but if you check for expiry (and release) before each time you select and display available rooms, you'll get the same effect. --Cindy - Before posting, please check:

handling failed sql requests in perl

AutoCommit => 1}); I then construct the mysql statement (an insert statement) and call: $db_handle->do($db_input); Thanks, --Cindy -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/

Re: Restoring data to a database

mysql -h mysql.io.com -u "user" -p "database" < backup-file.sql In your case the -u is probably optional. My version prompts for the password. --Cindy - Before posting, please check: http://www.mys

count(*) questions

columns queries. I'm thinking I might be able to do this with some form of aliasing, but I'm kind of stumped on how to specify which set of conditions goes to which count. --Cindy -- [EMAIL PROTECTED] - Before posti

mysqldump question

rrent one? Some kind of Merge function? Help! Thanks, --Cindy -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To req

Re: date comparison?

nd cannot be compared to just date. I'll try that, but it was my understanding from the manual that the date functions were able to adapt between date, datetime, & timestamp automagically? -- Cindy [EMAIL PROTECTED] - Before

date comparison?

calculations.html and it looks right to me. date_resolved is of type DATE. --Cindy -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (th

Re: how to add to a set

setval SET ('a', 'b', 'c', 'd', 'e', 'f') >Ma'am, by variable, do you mean a column in a row? Try >UPDATE table_name SET column_name = Concat(column_name, ",d") WHERE ... This worked perfectly, thanks! --Cindy --

Re: SET question

e "d" in your set) > >does it make any sense? Yes, but it doesn't solve my problem because in actuality I don't know what the current value of the set is, I just want to add something to it. I was trying to illustrat

how to add to a set

alue is now "a,b,c,d". The type is already defined as setval SET ('a', 'b', 'c', 'd', 'e', 'f') Thanks, --Cindy -- [EMAIL PROTECTED] - Before posting, pleas

slicing strings for comparison?

#x27;t find anything in the online documentation, though it's possibly not called "slicing" or "string range"... --Cindy -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual

question on select

that? Becasue Inventory.returned_to would also need to pull out from the People table, but this could be a different person, and I don't see how to assign that. Would I have to create a temporary table to do this or can it be done with a sin

Re: date_format

[EMAIL PROTECTED] writes: >It's (sort of) obvious what Cindy is looking for... > >In slightly clearer terms, is it possible to format a selected date using >a >format string similar to that available in C's strftime() function - >where %M might stand for month

date_format

dn't yield any other info on DATE_FORMAT. 20 minutes later, I surrender. Where would I find out the info on DATE_FORMAT I'm looking for? --Cindy -- [EMAIL PROTECTED] - Before posting, please check: http://www.mysq

Re: SQL HELP

Cindy writes: >SELECT *.DATE_FORMAT(datefield, "%M %d, %Y") FROM table; Agh. *,DATE of course. Comma, not dot. --Cindy - Before posting, please check: http://www.mysql.com/manual.php (the ma

Re: SQL HELP

FROM table; ? That gives him one extra field, and he can just ignore the first datefield. --Cindy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list ar