Re: update command

2005-03-20 Thread David Dick
Presumably you remembered to include Eko Budiharto wrote: Hi, I am having problem with update command. I run it directy in the mysql console, it works. But when I run it from perl, it does not work. here is the perl script my $server2 = 'localhost'; my $db2 = ''; my $username2 = ''; my $pass

Re: Secure Database Systems

2004-07-09 Thread David Dick
can handle such function? Thanks "David Dick" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] afaik the term "translucent database" applies to a regular database that has encrypted data in it. The main differences is in whether the encryption is one way only

Re: Secure Database Systems

2004-07-09 Thread David Dick
afaik the term "translucent database" applies to a regular database that has encrypted data in it. The main differences is in whether the encryption is one way only (ie. using a md5 hash of a name instead of the actual name) or reversible (using 3des to encrypt and decrypt the name). a good

Re: Secure Database Systems

2004-07-08 Thread David Dick
G'day Sarah, Pater Wayner has apparently written a book on the subject of how to store and use information in a database that will be of limited use to attackers. His website is below, with an oreilly article describing the book. Haven't read it myself yet. http://www.wayner.org/books/td/ htt

default encrypt for PASSWORD

2004-02-25 Thread Colleen Dick
on type for PASSWORD? cuz I told PEAR::Auth that the encryption type is md5 and if that is wrong that could be the reason why it is not working. Thanks, Tom Dick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 3.23 JOIN describe to another query

2004-02-20 Thread Colleen Dick
Egor Egorov wrote: Colleen Dick <[EMAIL PROTECTED]> wrote: Is it possible to JOIN the results of a DESCRIBE TABLE to some other query? The semantics of what I would like to do is the following: SELECT d_fldcomment from desc LEFT JOIN DESCRIBE footable ON desc.d_table = 'fo

3.23 JOIN describe to another query

2004-02-19 Thread Colleen Dick
Is it possible to JOIN the results of a DESCRIBE TABLE to some other query? The semantics of what I would like to do is the following: SELECT d_fldcomment from desc LEFT JOIN DESCRIBE footable ON desc.d_table = 'footable' AND desc.d_field = Field; so the resultset would look like a regular DE

Re: Just simple question...

2004-02-06 Thread Colleen Dick
Hello Dusan: MS Access is actually a user front end and not a database engine at all. Many people don't understand this. A front end talks to a database engine, known as a data source in the lingo. MS Access defaults to using one of Microsoft's databases, I believe it is called jet or someth

Re: where is mysql.server???

2003-12-21 Thread Colleen Dick
try find / -name mysqld landon kelsey wrote: landon (root) /usr [632]>find / -name mysql.server -print find: /proc/1437/fd: No such file or directory _ Working moms: Find helpful tips here on managing kids, home, work ? and

Re: Problem with sql sintax

2003-12-20 Thread Colleen Dick
What version you using? Subselects are not supported in any except the latest Nuno Mendes wrote: The sql bellow is giving a sql sintax error: select cities.id, cities.name, ( select count(*) from images where ( images.city_id = cities.id ) ) as number_of_images from cities Can you point me

Re: administering database on server

2003-12-02 Thread Colleen Dick
phpmyadmin is not reliable enough? joffrey leevy wrote: Hi all: Anyone know a RELIABLE software program for administering to a mysql database on a webhosting unix server? Thanks __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ --

Re: Send someone a database

2003-11-28 Thread Colleen Dick
I would mysqldump it, tar it up and send it as an attachment (hope it isn't too big.) Make sure to tell him to delete the illegal line of --- before he tries to import it. michael johnson wrote: Dear All I want to send a MySQL database to a client by email. Which is the best way to do it?

Re: web data entry problem

2003-11-24 Thread Colleen Dick
There could be a number of things going on. It would help troubleshoot your problem if your script check for errors and print them if there are any. You cant just assume a connection is being made just because phpmyadmin connects. Your web app has to make its own connection. So how about showing

Re: RANDOM in GROUP BY

2003-11-14 Thread Colleen Dick
to do this rather than using php to do essentially the same thing afterwards (which is what I did). Roger Baklund wrote: * Colleen Dick This stumped them in PHPbuilder... I have a table lets call it moms each row in the moms table can have many kids, and some "kids" have >1 "m

Hello Paul DuBois?

2003-11-08 Thread Colleen Dick
if it just can't be done with a query please somebody like Paul DuBois say so... Colleen Dick wrote: This stumped them in PHPbuilder... I have a table lets call it moms each row in the moms table can have many kids, and some "kids" have >1 "mom". I have a kid table a

RANDOM in GROUP BY

2003-11-08 Thread Colleen Dick
This stumped them in PHPbuilder... I have a table lets call it moms each row in the moms table can have many kids, and some "kids" have >1 "mom". I have a kid table and I have a mxk map table to relate them. what I want to do is select all the moms and for each mom I want a random one of its kids

msaccess frontend

2003-10-18 Thread Colleen Dick
Have anybody ever set up MS Access as a frontend to mysql? the dB is an already established mysql db running on linux I don't want to convert it, just use access to get to it. I have followed the recipe at http://www.washington.edu/computing/web/publishing/mysql-access.html I can see the tables so

Re: OR in MySQL statement?

2003-10-15 Thread Colleen Dick
Mike At Spy wrote: How could I write a statement that uses something like 'OR' as a case. Like this: SELECT * FROM list WHERE name = '$this1' OR name = '$this2' OR name = '$that1' ? Thanks for any help, -Mike u just like that looks good to me. -- MySQL General Mailing List For list a

Re: Shell Script to Insert Data

2003-10-10 Thread Colleen Dick
Mike Tuller wrote: I am trying to create a script that will insert data. Right now I am just using something simple to test this out, but I can't get it to work. Here is what I have. mysql --user=root --password= Database_Name; INSERT INTO table_name (column_name) VALUES ("value"); After I

tricky query

2003-10-10 Thread Colleen Dick
I am building a SELECT using a left join and I almost have what I want. One of the fields that gets sucked in from the left join is either null or has a value in it. if it is null I only want to include the rows from the main table where the field isdemo=1 if that field has a value in it I wan

moving a column to new table

2003-10-08 Thread Colleen Dick
I have a table let's call it (old) containing items of interest index field (id) another field (data) I want the data colum to move to a normalized table (normal) that uses id as part of a multifield primary key. So I created a data column in the normalized table. How can I now ELEGANT

forget root password

2002-02-12 Thread dick idod
Hi, I have installed mysql-3.22.22 on Linux RedHat, but now I have problem because I forget the root password. How do I solve this problem ? TIA, dick# __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http

forget root password

2002-02-11 Thread dick idod
Hi, I have installed mysql-3.22.22 on Linux RedHat, but now I have problem because I forget the root password. How do I solve this problem ? TIA, dick# __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http

Re: Cannot build with C++

2001-09-24 Thread Dick Doornbos
ent it out! Greetings, Dick Doornbos > > From: ARAKON <[EMAIL PROTECTED]> > Sent: Tue Aug 21 11:50:14 GMT+02:00 2001 > To: <[EMAIL PROTECTED]> > Subject: Cannot build with C++ > > > i'm using mysql 3.23.40 for windows,

Unix - Windows migration

2001-07-27 Thread Dick Davis
on W98 machine. The Sun data was deliverd on a CD, and the box is out of service. The queation is: How do I get the PC version of MySQL to talk to the Solaris version. All help will be greatly appreciated. Dick Davis Skyline Data Systems [EMAIL PROTECTED]

Mysql Error

2001-07-27 Thread Greg Dick
Hi, I am trying to use the precompiled version of mysql-3.23.37-ibm-4.3.3.0-rs6000. ANd when trying to start the mysqld i get the following error: exec(): 0509-036 Cannot load program ./mysqld because of the following errors: 0509-150 Dependent module /usr/local/lib/libz.a(shr.o) could not be l

fail to invoke mysqld

2001-02-04 Thread Dick
Dear all. it's a little hard to tell you what we encountered, but I would try it. we invoke a script 'do_all' to do something, but after that, safe_mysqld can't work. do you have any idea abou that ? -- Di