Re: AW: Order By & Limit; Count

it's not true, order by is performed before limit. if it was the other way round , limit would be almost useless > Hadn't thought about this before, but what it means (I guess) is that LIMIT > works on the selection, not on the presentation. > > What I'm trying to say is that when you consider

Re: Confusing SELECT statement

you can use select addresses.id from addresses LEFT JOIN mlist ON addresses.id=mlist.addr_id AND mlist.mlist_id=$mlist_id WHERE mlist.mlist_id IS NULL On Thu 27. September 2001 08:09, Adam Gintis wrote: > I have the following table mlist: > > +--+-+ > > | mlist_id | addr_id |

Re: Dates: To Slash or to Hyphen. That is the question

hi, first - using php wouldn't it be much easier to use an integer to store datetime in the database? - i think it's faster and it allows you to manipulate the date much more easily. you could just tokenize the date string (using space,'/' and '-' or any ohter characters as the separators) - yo

Re: installation of mysql on redhat7

look at the access privileges to the file '/var/lib/mysql/mysql.sock' and change them so that you can write to it On Wed 1. August 2001 11:44, Lars Freymark wrote: > Hi everyone! > > I have installed mysql 3.23.22. The Distribution is from the redhat cd. My > problem is the following: > > I ca

number of records in a ResultSet

hi, please is there a way to get the number of records in a JDBC ResultSet ? something like mysql_num_rows in PHP. thanks karel pitra - Before posting, please check: http://www.mysql.com/manual.php (the manual

Re: Type Mismatch issue when Deleting from table

why do you use Replace if deleteheadline is an integer? On Fri 6. July 2001 14:26, you wrote: > Platform: W2k/Advanced Server > DB: mySQL 3.23.33 > Language: ASP/VBScript > > Issue: I'm creating a backend administration program that will allow > updates, deletes, additions, etc. All is well exp

Re: primary keys with several parameters

the combination is unique so iyou dont get an error On Fri 6. July 2001 14:04, you wrote: > Hi all! > > Sorry for the dumb question, but am I right in the following suggestion: > > I have the following table: > > create table tab_1 ( > field_1 integer not null, > field_2 integer not

size of a table

please, is there a way to get the size of a mysql table through an SQL query ? thank you karel pitra - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

mysql + unicode

please, does mysql support unicode? thanks in advance - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail

Tree

hello, does mysql allow for recursive SELECTS? is there a way to select a 'path in a tree' in one query ? (the tree is stored in the following form: parent_id int id int ) i know the ID of an element in n-th level of the tree, and i need to get all its parent elements -

INSERT question

o the database? i'm hesitating whether to use a new thread to do inserts with lower priority which would be necessary if executeUpdate() waits or whether to do them in the main thread. thank you karel pitra - Befo