Re: compiling mysql 4.2.1 with linux

Hi, You're not using the correct version. The right one to compile is under "Source and other files" downloads section at the bottom of the page. Regards, Deckard abraham c wrote: > Hello, > > We are trying to build from source MySQL standard ver. 4.2.1 on an >

Re: How to not repeat fields

Hi, Now it's working :) CREATE TABLE wl_users(wl_user_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, email VARCHAR(50) NOT NULL, password VARCHAR(40) NOT NULL, UNIQUE (name, email, password)) TYPE=MyISAM; Thank you all. Warm Regards, Deckard Martijn Tonies

Re: How to not repeat fields

Hi Paul, Now, i have this: CREATE TABLE wl_users(wl_user_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(255) NOT NULL, email VARCHAR(50) NOT NULL, password VARCHAR(40) NOT NULL, UNIQUE (wl_user_id, email)) TYPE=MyISAM; and the issue persists :( Best Regards, Deckard Paul DuBois

Re: How to not repeat fields

Hi, Yes, it still allows duplicate (equal) rows to be inserted :( Best Regards, Deckard Paul DuBois wrote: > At 22:21 +0100 10/8/06, Deckard wrote: >> Hi, >> >> Ok, naow i have this: >> >> CREATE TABLE wl_users(wl_user_id INT NOT NULL AUTO_INCREMENT, name >&g

Re: How to not repeat fields

rows ? Best Regards, Deckard Paul DuBois wrote: > At 22:11 +0100 10/8/06, Deckard wrote: >> Hi, >> >> How do i dreate a table, let's say: >> >> CREATE TABLE wl_articles(wl_articles_id INT NOT NULL AUTO_INCREMENT >> PRIMARY KEY, title TEXT NOT NULL, >&

How to not repeat fields

tatus INTEGER NOT NULL, password VARCHAR(32) NOT NULL) TYPE=MyISAM; without allowing INSERTs to repeat rows based on certain fields, for example, "main" and "status" ? Any help would be appreciated. Warm Regards, Deckard -- MySQL General Mailing Lis

Selecting last item

Hello, What is the best approach to select the last row of a table ? Thank you. Warm regards, Deckard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Returning value after insert

Hi, Is there a way of after a select statement having a return value for a determined field ? For example, after this: INSERT INTO wl_users(name, email, password) VALUES('Deckard', '[EMAIL PROTECTED]', 'blabla') having the name returning without having to make

Can't set password for user

re that he user exists. I'm using MySQl version 4.1.20 Any help would be appreciated. Best Regards, Deckard -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]