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 PROTECT
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,
>
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.
> -Or
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 s
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]
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 t
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, Ap
> 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
(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
ge-
> 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
>
> --- Gr
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 <[EMAI
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 Lo
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
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 ver
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, 20
have you tried running the server in standalone from the command prompt,
to get some more output from the startup sequence?
> -Original Message-
> From: Simon Tienery [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, March 21, 2002 4:40 PM
> To: [EMAIL PROTECTED]
> Subject: Error 1067: the pro
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.
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q29416
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
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 database
>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:
http://support.microsoft.com/default.aspx
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]
>
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. Aze
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]
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 su
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 SQL
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, Feb
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]>
- 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 t
28 matches
Mail list logo
