Hi Dave,
1st: Never, never, never store passwords in plain text!! Just don't do
it. Store a hash of the password (ie md5 or something else).
2nd: Never pass any input from the Internet directly into a query
without first checking it for sql injection.
Take a look at Wikipedia article for a
My God!
Rhino, that was a very long and very good answer!!
Impressive!!
/Johan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
First I would advice you to take a closer look at:
http://dev.mysql.com/doc/refman/5.0/en/join.html
It will answer your question.
/Johan
??? wrote:
Hi
There is a schema example below: (From "A first course in database system")
Product (maker, model,type)
Pc (model, speed, ram, hd, rd, price
Hi Cor,
Don't know if that function exists in MySQL...
If you by any chance is using PHP you can do it by using ucfirst(str)
But I quote the User Comment at
http://dev.mysql.com/doc/refman/5.0/en/string-functions.html from Tom
O'Malley:
Posted by Tom O'Malley on April 18 2006 1:16am
An exa
mport your data .
eg ;
In mysql prompt run the file as
*use database \. /tmp/filename.txt
*
Johan Lundqvist wrote:
Hi,
I need to extract some data to a textfile from a big database.
If I try to do like this:
mysql < queryfile.sql > outfile.txt
"outfile.txt" it looks som
ng this incrementally?
ie - 25% at a time x 4
to show something for NULL, you can use the
COALESCE function.
ie - COALESCE(column,'nothing')
--
George Law
VoIP Network Developer
864-678-3161
[EMAIL PROTECTED]
MSN: [EMAIL PROTECTED]
-----Original Message-
From: Johan Lundqv
the column names, and
any NULL values are exported as "\N".
This is a big problem, cause the import function that exist where I send
the data only accept the format I get using "mysql < queryfile.sql >
outfile.txt".
Any help??! Ideas??
Can I in any way format my
all copies
of this transmission.
-Original Message-----
From: Johan Lundqvist [mailto:[EMAIL PROTECTED]
Sent: Friday, March 31, 2006 2:07 PM
To: mysql@lists.mysql.com
Subject: Re: How to merge my tables?
No, I don't have that. There's about 5-10% change in employees ids
from
ev
rmation is prohibited. If you have received this transmission in
error, please notify the sender by reply e-mail and destroy all copies
of this transmission.
-Original Message-----
From: Johan Lundqvist [mailto:[EMAIL PROTECTED]
Sent: Friday, March 31, 2006 1:13 PM
To: mysql@lists.mysql.com
Subje
Hi,
I hope this is the right forum for this question. If not, I'm happy to
get some tip on where to post this.
My problem:
I have like 20 tables of data and need to merge these, making a
selection, (and dump it into a text file) to import into a reporting
tool. The tables is like salesrep, va
In Windows, you have 3 alternatives:
1 - wait untill it stops the service (can take very long time).
2 - restart the server (your users might cry a bit).
3 - Try to kill the task using Task Manager (this might not work,
depending on the service).
/Johan
Sara Woglom wrote:
Please help, I can't
11 matches
Mail list logo
