GROUP BY vs DISTINCT - questions

be appriciated... -thanks, Lorderon. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MySQL 4.1 - Full-Text using UTF-8

% treshold).. -thanks, Lorderon. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: MySQL 4.1 - Full-Text using UTF-8

\charsets/ | +--+ -+ 7 rows in set (0.01 sec) -thanks, Lorderon. Lorderon [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, How do I search and index a TEXT column to use the UTF-8 charset? Do I need

select query that uses a temporary table

, the last row will be dropped out (in case the table is on limit), and the new matched row will be inserted into the right place in the temporary table... -thanks, Lorderon. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

MyISAM transactions

Will MyISAM support transactions in the future versions? Is it possible? -thaks, Lorderon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Full-Text

Hi.. When doing the next query, the rows are not ordered automatically by the coefficient of the full-text.. Why??? SELECT id,update_time FROM table1 INNER JOIN ft_table USING (id) WHERE MATCH (title,content) AGAINST ('class') LIMIT 0,50; thanks, -Lorderon. -- MySQL General Mailing List

Re: Full-Text with JOIN

Hi, Sergei Golubchik [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi! On Mar 20, Lorderon wrote: I have 3 tables to join when the last one is a Full-Text table (ft_table).. I do the next join: SELECT id,title FROM table1 LEFT JOIN table2 USING (id) INNER JOIN ft_table

Full-Text with JOIN

between making INNER JOIN or by making list of tables seperated by comma (table1,table2,..) with using WHERE clause? thanks a lot in advance, -Lorderon. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

limit stop count

How can I limit a count to stop when he reaches 200 rows? SELECT COUNT(*) FROM tbl WHERE where_clause;= returns 3500 I want to stop the counting when it reaches to 200, so MySQL will not search further to count all the 3500 rows.. thanks, -Lorderon. -- MySQL General Mailing List

Re: limit stop count

; -Original Message- From: Lorderon [mailto:[EMAIL PROTECTED] Sent: Wednesday, March 17, 2004 6:45 PM To: [EMAIL PROTECTED] Subject: limit stop count How can I limit a count to stop when he reaches 200 rows? SELECT COUNT(*) FROM tbl WHERE where_clause;= returns 3500 I want

BLOB 1024

Hi All, How can I define a column of BLOB (or TEXT) with exact length of 1024 bytes? Can I index it? I want to run a select query using FIND_IN_SET function on that column.. but I'm afraid it will be slow.. any suggestions? thanks in advance, -Lorderon. -- MySQL General Mailing List

Full-Text on double rows

If I got a full-text table with X rows, and some search takes 5 sec.. Now if I got a full-text table with 2X rows, how much time will take the same search on twice amount of rows? Is the difference linear??? thanks in advance, -Lorderon -- MySQL General Mailing List For list archives: http

Re: Full-Text on double rows

the situation worse... thanks -Lorderon. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: PHP and using mysql_last_id()

It is better run a query with: SELECT LAST_INSERT_ID(); immediately after making the insert query. that way you'll get the exact ID.. Elly Wisata [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Does php have a function like mysql_insert_id but support a zerofill auto increment

found rows in union

How can I find the number of rows a query returns when I'm using UNION ? for example, how can I know how much rows the next query returns: (SELECT price FROM table1 WHERE id100) UNION (SELECT price FROM table2 WHERE id150) thanks in advance, -Lorderon. -- MySQL General Mailing List

Re: found rows in union

want to run the query twice Also... if I run the same query twice.. first run and selecting columns.. then I run the same query but selecting COUNT(*).. does the second time will run using MySQL's cache? Lorderon [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] How can I find the number

sub-query

there.. the reason I used it as sub-query is that I want to count the rows, and then use: SELECT FOUND_ROWS(); to get the number of rows supposed to be retuned without using the LIMIT.. Is all above correct? thanks, -Lorderon. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

UNION

have more than 2 tables to sum, and I sum different tables every time, so I can't define merge tables on every combination.. Is there a way to sum the column from all tables together? thanks in advance, -Lorderon. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: UNION

the only why i know how to do this is to write the ind sums to a new table and then sum that table.. How you do it with a new table? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

select speed

B_table WHERE prim_field='val'; If I split A_table into some tables, and define C_table to be MERGE on the A_table pieces. Is the time difference between selecting from A_table or C_table is meaningful? thanks in advance, -Lorderon. -- MySQL General Mailing List For list archives: http

Full-Text Search on MERGE Tables

Hello All, Is it possible to define MERGE table on several tables with full-text indexes? And to make a select on the MERGE table with MATCH AGAINST? thanks, -Lorderon. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Table Joins

You might want to append table to table.. in this case you should use UNION (not JOIN).. but if you got 2 identical tables of type MyISAM, then you can define a MERGE table like this: CREATE TABLE new_table (*table definition of the original tables*) type=MERGE union=(all_by_Payroll,payinc);

mysqldump

Hello All, How can I dump selected rows into a file (using a query or mysqldump)? i.e, I want to dump only the rows of this query: SELECT * FROM tbl WHERE id100 AND id200; thanks in advance, -Lorderon. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Union EXACT Tables

Hello All, Is there a way to make concat 2 tables together without using UNION ? The tables are EXACTLY SAME, but they sit on 2 different DBs. And I want to run the SAME where clause on both tables... Thanks in advance, -Lorderon. -- MySQL General Mailing List For list archives: http

Re: Union EXACT Tables

Paul DuBois [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] At 19:04 +0200 2/24/04, Lorderon wrote: Is there a way to make concat 2 tables together without using UNION ? The tables are EXACTLY SAME, but they sit on 2 different DBs. And I want to run the SAME where clause on both

Re: Union EXACT Tables

Thanks for your help... appreciate it... MERGE table type is what I searched for :-) Thanks -Lorderon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Fulltext search

Santino [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Is it possible to create a InnoDB table and a MyIsam table with fulltext indexes and use a join to search in fulltext indexes? Santino Yup.. you can.. create the tables on the same DB and make a JOIN.. -- MySQL General

auto sorting

records will not use auto sort, but without doing an ORDER BY clause or making an auto_increment primary key? thanks in advance, -Lorderon -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]