GROUP BY vs DISTINCT - questions

appriciated... -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

p\mysql\share\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 inde

MySQL 4.1 - Full-Text using UTF-8

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

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/[

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]

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,ti

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 Ma

Full-Text with JOIN

rence 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]

Re: limit stop count

imit 200; > > -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(*) F

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: 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 > incre

Re: Full-Text on double rows

smaller tables and use UNION just makes 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]

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

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 Lis

sub-query

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://list

Re: found rows in union

union? since I don't 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]> wro

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 id>100) UNION (SELECT price FROM table2 WHERE id>150) thanks in advance, -Lorderon. -- MySQL Gene

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]

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/mys

select speed

field FROM 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

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

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

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 id>100 AND id<200; thanks in advance, -Lorderon. -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

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: 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. > >An

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

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]

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 Gene