Hello,
sorry if this is not the right mailing list to ask this question, hope someone
can point me to a better list in the case.
My problem is that I'd like to use mysql as database for storing user accounts
for different services, and I started using vsftpd. Now, following the
instruction here
Hi all,
I've got an account table with password encrypted thru the encrypt() function,
and I should transfer them to a table with password() function. I don't want
to decrypt the password, and I'd like to know if there's a way to build the
password hash from the encrypt one.
Any suggestion?
Th
Hi,
I have to install a mysql server for managing several database, from small to
quite big (tables with about 2M rows). I've got a SAS disk array and I was
wondering what the best configuration could be:
1) raid 10
2) raid 5
3) a combination (e.g., raid10 for the data and raid 5 for the logs).
Hi all,
I'm new to MySQL coming from PostgreSQL backgroud. I'd like to know how to
obtain the same effect of a sequence + concat as default value of a table in
mysql. For example, consider the following table definition:
CREATE TABLE competenza
(
id_competenza character varying(30) NOT NULL DE
On Tuesday 02 January 2007 16:51 Brent Baisley's cat, walking on the keyboard,
wrote:
> CREATE TABLE competenza (
> competenza varchar(30) NOT NULL default 'comp-06-',
> id_competenza int unsigned not null auto_increment,
> descrizione varchar(100),
> PRIMARY KEY (competenza, id_competenza)
> )
>
On Thursday 26 July 2007 Rajesh Mehrotra's cat, walking on the keyboard,
wrote:
> Check out
> http://www-css.fnal.gov/dsg/external/freeware/mysql-vs-pgsql.html
>
Please note that PostgreSQL provides a gateway to other databases thanks to
the DBI-Link extension, as well as it support more than o
