On 3 Jan 2003, bruno peracchio wrote:
> I use MySQL 3.23.52/linux Mandrake 9.0
> Installing SQLEditor-2.1.3 (CBD-Common-2.1.3-3.i386.rpm)
> error:failed dependencies:
> unixODBC is needed by CBC-Common-2.1.3-3
>
> Installing UnixODBC-mysql-2.2.3-1.i386.rpm
> error: failed dependencies
> odbc is ne
I need to store SSN's in a MySQL DB. I see a variety of encyption functions:
ENCRYPT(), MD5(), SHA1(), DES_ENCRYPT() and have read the basiscs of how they
work. Is there are "standard way" of storing SSN's in MySQL.
thanks,
John
I have to port a DB from a system with mysql_3.23.33 to a system
with mysql_3.22.32. The older system does not seem to have the
source command. root is too busy to talk to me. Do any of you
know if disabling source is an option he could have used to keep
his system more secure or is it a ver
using wildcards?
>
> mysql> select * from application where availability = '%mornings%';
>
> Crude, but it should work.
> Neil
>
>
>
> -Original Message-
> From: John Fulton [mailto:[EMAIL PROTECTED]]
> Sent: Friday, 22 February 2002 7:49 AM
&g
If I have a table with a set such as this:
CREATE TABLE application (
application_num int(6) NOT NULL auto_increment,
availability set('weekdays','weekends','mornings','afternoons')
default NULL, PRIMARY KEY (application_num)
) TYPE=MyISAM;
is it possible to search based on members of the s
Would someone please tell me how to insert sets into a MySQL DB?
e.g. insert into table_name (x) values ("'a', 'b', 'c', 'd'"); ,
where x is a set. I am unsure on what should be inside of the second
set of parentheses.
Sorry to be posting a syntax question to the list, but I don't see it
s
