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 needed by
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
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
= '%mornings%';
Crude, but it should work.
Neil
-Original Message-
From: John Fulton [mailto:[EMAIL PROTECTED]]
Sent: Friday, 22 February 2002 7:49 AM
To: [EMAIL PROTECTED]
Subject: Selecting set members
If I have a table with a set such as this:
CREATE TABLE application
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