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 Intel-based machine running LINUX

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, 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 wrote: Now

How to not repeat fields

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 List For list archives: http

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, main TEXT NOT NULL, extended TEXT NOT NULL, permalink

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 VARCHAR(255) NOT NULL, email VARCHAR(50) NOT NULL

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 a subsequent select. Any help

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]

Can't set password for user

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]