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) -

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 can do

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: 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 null,

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 expect

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

INSERT question

into 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 - Before posting

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