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
shell instead, I have no further suggestions.
--Cindy
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
-
Before posting, please check
and
Society','Uses of Geography','Issues-Analysis, Decision-Making, Planning and
Problem Solving') NOT NULL default 'Historical Knowledge',
What I'm trying to add is:
'Chronological Thinking','Comprehension, Analysis, and Interpretation'
Can you tell me why this is happening?
Cindy
[EMAIL PROTECTED
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 what am I missing?
Thanks,
--Cindy
--
[EMAIL PROTECTED
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:
I wrote
, 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 spam or
simply off topic to our filter
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 I can do to fine tune this?
Thanks,
--Cindy
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 is happening?
--Cindy
--
[EMAIL PROTECTED
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
-
Before posting, please check:
http://www.mysql.com
it to work. 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 PROTECTED]
Sent: Saturday, June 08, 2002 1:47 PM
Subject: Re
. This is 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 Jimmie Nelson Rd SW
HAVE a
var directory. (I think the source code dist creates that, but not
the binary code dist.)
Thanks,
--Cindy
--
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
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 most of it for now, but this one
has
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 most of it for now, but this one
has
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 check:
http
month value and hence invalid). Seems to me you ahve to
reformat your date from jsp before you put it into the mysql database.
--Cindy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
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.
RLIKE on the other hand...sigh.
sigh, what? RLIKE works. It's the same
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; error: 'You must have
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...sigh.
--Cindy
-
Before posting, please
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...sigh.
--Cindy
-
Before posting, please
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.
RLIKE on the other hand...sigh.
sigh, what? RLIKE works. It's the same
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 change LF's into CRLF's (I remotely
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 decided
to change LF's
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/11 11:25 AM
* Cindy Yu
I am new
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, 4:08, 1 user, load average: 0.08, 0.04, 0.01
[root@willyjr
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 Green [EMAIL
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:[EMAIL PROTECTED]]
Sent: Tuesday
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 thread, e-mail [EMAIL
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 tables.
See on line manual and don't know password
= 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://lists.mysql.com/ (the list
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, suggestions...all welcomed.
Thanks,
--Cindy
--
[EMAIL PROTECTED
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 avoid that problem.
--
Cindy
[EMAIL PROTECTED
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' into table wor
dindex (aid, wid, wordform, start, length);
ERROR 1030
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 PROTECTED
havne't had any
spurious refusals so far.
--Cindy
-
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
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:
http://www.mysql.com/manual.php (the manual
statement (an insert statement) and call:
$db_handle-do($db_input);
Thanks,
--Cindy
--
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list
case the -u is probably optional. My version prompts for the
password.
--Cindy
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
queries, rather
than for rowXcolumns 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
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 request this thread
ight 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/ (the list archive)
To request this thre
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 posting, please check
'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
-
Before posting, please check:
http:
"a,b,c,d". The type is already defined as
setval SET ('a', 'b', 'c', 'd', 'e', 'f')
Thanks,
--Cindy
--
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.
our 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 illustrate my problem so that people didn't thi
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.php (the manual)
ht
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 single select?
--Cindy
[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 name, %d might stand for day number
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 archive)
To requ
49 matches
Mail list logo