RE: Encrpt/Decrypt

and it's all-around better to encrypt the password BEFORE you transmit it over an unsecure connection, or even between processes on a potentially unsecure machine. This means using, for example, the MD5() function in PHP... -Original Message- From: Matthew Smith [mailto:[EMAIL

RE: is there a MySQL 'field contains' function

SELECT * FROM table1 WHERE computer_description LIKE '%blue%' HTH Greg -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, April 12, 2002 11:10 AM To: [EMAIL PROTECTED] Subject: is there a MySQL 'field contains' function Hello Everyone,

RE: MySQL concept question

if you are interested in selecting records in the order in which they were inserted, apply an auto-increment/identity field to your table schema and when you select, use ORDER BY on that field. This is the only guaranteed way to retrieve records in the order in which they were inserted.

RE: - character in table name

Have you tried delimiting the table name with some form of quotes? -Original Message- From: David Chen [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 10, 2002 4:05 PM To: [EMAIL PROTECTED] Subject: - character in table name Hello, I probably installed a PHP script that

RE: mysql

sometimes, all you can say is LOL and walk away shaking your head...thinking... *...the poor guy actually went to the trouble of defeating the filter, only later to invite the flames of hell upon his head* -Original Message- From: va ku [mailto:[EMAIL PROTECTED]] Sent: Monday,

RE: mysql and java

this is actually OT, btw, but I'll try to answer... need to make it smaller. Is it possible to somehow store these descriptions in a mysql table or on another page and then have them linked to when you put your mouse over the link? No. There are methods of accessing databases from the

RE: Reg MYSQL and JAVA

still OT, but here goes anyway... you can in fact use PHP or ASP or whatever to generate PDFs. See http://www.pdflib.com/pdflib/index.html -Original Message- From: va ku [mailto:[EMAIL PROTECTED]] Sent: Monday, April 08, 2002 5:04 PM To: Christopher Thompson; [EMAIL PROTECTED]

RE: microsoft uses MySQL too?

Cute story...but I have to agree with the Register when they state also in the article, For the record, can we just add that few subjects are as tedious or overrated as ideological purity? -Original Message- From: Robert Cross [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002

RE: MySQL Power ?

Actually, according to the objective eWeek test results at the link provided in another reply, the gap between Oracle 9i and MySQL 4.x is rather slim... I will look forward to hearing the response of the well-informed to this. However, my impression is that while the answer, for the very

RE: MySQL Power ?

Agreed. As soon as subselects and the Stored Procedure support is complete I can almost ditch MSSQL entirely... BUT: the sql-set is too limited for most of the real use cases out there. just think of the missing sub-selects or multitable-updates/deletes or stored procedures. i worked with

RE: Insert ?'s

no, you need to follow the list rules when posting. That's why you see a lot of posts that have a line at the end that just says mysql,sql,query or something similar. And to answer your question, it appears that you are actually attempting an UPDATE, not an INSERT? i.e. UPDATE Sellers SET

RE: Insert ?'s

[mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 1:15 PM To: Gregory Junker; [EMAIL PROTECTED] Subject: RE: Insert ?'s do not send me mail I am not your friend. Thank you --- Gregory Junker [EMAIL PROTECTED] a écrit : no, you need to follow the list rules when posting

RE: Insert ?'s

(and I say again...) -Original Message- From: de Chateau Thierry Axel [mailto:[EMAIL PROTECTED]] Sent: Friday, April 05, 2002 1:15 PM To: Gregory Junker; [EMAIL PROTECTED] Subject: RE: Insert ?'s do not send me mail I am not your friend. Thank you --- Gregory Junker

RE: MySQL Power ?

At 10:16 AM 4/5/2002, you wrote: Actually, according to the objective eWeek test results at the link provided in another reply, the gap between Oracle 9i and MySQL 4.x is rather slim... Gregory, A point that was sadly missing from that article was what was the cost to create

RE: ADO API ODBC Alternative help

From your point of view it's off-topic (and it is), but from his the problem could be anything, including MySQL. You did, however, produce the proper answer, since this is an ADO issue, and I further provide a link to the relevant Knowledge Base article:

RE: Selecting across servers

SELECT * FROM database1.table1 ... database2.table2 ... WHERE -Original Message- From: David Buerer [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 6:14 PM To: [EMAIL PROTECTED] Subject: RE: Selecting across servers How do you do it from different databases on

RE: mysqlbug

error 2 says the file cannot be found...did you run the mysql_install_db script? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Wednesday, March 13, 2002 7:05 PM To: [EMAIL PROTECTED] Subject: mysqlbug Good afternoon Please, i'll need some

RE: ADO API ODBC Alternative help

the problem is doing an Update after you've done one Update without doing a MoveForward or MovePrevious. It's an ADO issue, check the KB article I posted earlier on this topic, it explains the causes and the API versions that have it.

RE: mysql

Section 6.1.6 of the Manual: (http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.htm l#Reference) WHEN is a reserved word. HTH Greg -Original Message- From: Jonathan Farrow [mailto:[EMAIL PROTECTED]] Sent: Monday, March 04, 2002 6:45 PM To: [EMAIL PROTECTED]

RE: Bugs and more Bugs.

did you follow the instructions in the link below? http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.htm l#Post-installation -Original Message- From: Joedilson B. Azevedo [mailto:[EMAIL PROTECTED]] Sent: Friday, February 22, 2002 6:08 PM To: [EMAIL PROTECTED]

RE: Bugs and more Bugs.

apologies for the sorry mail formatting...the whole link should be http://www.mysql.com/documentation/mysql/bychapter/manual_Installing.htm l#Post-installation -Original Message- From: Gregory Junker Sent: Friday, February 22, 2002 6:22 PM To: Joedilson B. Azevedo; [EMAIL PROTECTED

RE: How can i acheive 'Triggers' in MySQL

Triggers are evil incarnate, and notoriously har to debug. Skip triggers entirely and use a stored procedure to do everything you need the trigger to do (again, when SP's are available :\ ) greg -Original Message- From: Carsten Gehling [mailto:[EMAIL PROTECTED]] Sent: Tuesday,

RE: Could you help me?

you can find a list of what MySQL does not yet support in the table near the bottom of this page: http://www.mysql.com/documentation/mysql/bychapter/manual_Introduction.h tml#Comparisons Note that the latest stable/release version of MySQL is 3.x. Oracle is going to support a lot more of the

RE: row level privilages - thoughts on how to do

For reasons of the end-arounds you note it really has to be in the server. As mentioned views are a possibility, but could end up being just as messy as a middle tier. It sounds like what you want is integrated (with the OS) security (as in MS SQL); I don't know if this is on the plate, but I'm

Re: A password column

- Original Message - From: Philip Mak [EMAIL PROTECTED] To: Tom Jones [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, December 29, 2001 11:56 PM Subject: Re: A password column On Sat, 29 Dec 2001, Tom Jones wrote: I'm fairly new to MySQL and I was wonder if there was a

Re: A password column

If you are using PHP and do not want to pass clear-text passwords over a network to a remote MySQL server, you can use the crypto libs in PHP for one-way hashing too (I use MD5, for example). - Original Message - From: Philip Mak [EMAIL PROTECTED] To: Tom Jones [EMAIL PROTECTED] Cc: