Re: How to get the MySQL Command-Line Tool to display Unicode properly?

On 03/15/2018 02:06 PM, Roger House wrote: On 03/15/2018 11:30 AM, shawn l.green wrote: Hi Roger, (please note, this is a bottom-post forum) On 3/13/2018 7:54 PM, Roger House wrote: > > On 03/13/2018 03:11 PM, Reindl Harald wrote: >> >> >> Am 13.03.2018 um 2

Re: How to get the MySQL Command-Line Tool to display Unicode properly?

On 03/15/2018 11:30 AM, shawn l.green wrote: Hi Roger, (please note, this is a bottom-post forum) On 3/13/2018 7:54 PM, Roger House wrote: > > On 03/13/2018 03:11 PM, Reindl Harald wrote: >> >> >> Am 13.03.2018 um 22:59 schrieb Roger House: >>> In all r

Re: How to get the MySQL Command-Line Tool to display Unicode properly?

.  It is only when I am running mysql and I issue a SELECT command to see what is in a row.  Then the UTF-8 is not rendered properly.  I believe the problem is with mysql. Roger On 03/13/2018 03:11 PM, Reindl Harald wrote: Am 13.03.2018 um 22:59 schrieb Roger House: In all respects except one

How to get the MySQL Command-Line Tool to display Unicode properly?

Five months ago I posted the query shown below on StackOverflow.  I got one reply which was not of much help.  So I am trying again, hoping a more MySQL-centric forum might be able to solve my problem. Roger House How to get the MySQL Command-Line Tool to display Unicode properly? I use

How to get the MySQL Command-Line Tool to display Unicode properly

I use a Python program to write text containing Unicode characters to a MySQL database.  As an example, two of the characters are     u'\u2640' a symbol for Venus or female     u'\u2642' a symbol for Mars or male I use utf8mb4 for virtually all character sets involved with MySQL.  Here is an

How to Calculate the amount of a single query to read and write from disk temporary file

help me? thank a lot. -- Best Regard * Roger chen Mail: jirong1...@gmail.com*

New-be: problem installing on Mac SO10.6

I installed Mysql using the .dmg package. I can use System Preferences to start and stop the program. When I open a terminal window, I think this is the way to us the program, any Mysql command I inter is not recognized. Thanks Roger -- MySQL General Mailing List For list archives: http

dump stored procedure

Hi, I would like to make a dump of my database. however, i have some stored procedure and they are not exported to the *.txt file i've created via mysqldump. So, how can i dump stored procedure ? thanks a lot, Alain

Re: How to get result set from stored procedure?

yes it is true, you have to check if the constant CLIENT_MULTI_STATEMENT is set or not. basically this constant has for value 65536. HTH Alain On 4/25/06, Juri Shimon [EMAIL PROTECTED] wrote: Hello Juri, Tuesday, April 25, 2006, 5:49:25 PM, you wrote: JS mysql=mysql_init(NULL); JS

MYSQL 4.1 Collation

Is there any way to turn off collation in mysql 4.1? PHPadmin is showing a new colation dropdown menu which I need to get rid of. Thanks, Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Joins on tables with funky data?

. Simpler put: it would seem to work until you inserted a customer without a note, and additional customers with notes after that. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: dynamic fieldname to assign to

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

Re: timing queries?

-column-names and --batch to change the output. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: possible MySQL bug - insert into 'double' column problem with mysql 4.1

lon: -0.361080 lat: 9.99 You have created your columns with a max width of 7, out of which 6 are decimals, but you are trying to insert a number with 8 digits. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Yet another null question

-with-null.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: 1064 error

want to add the numeric value of all these columns into one column named total_points, you must use `backticks` because of the spaces in the names: joining_points + `E-Model Challenge` + `SA Pro Model` + ... URL: http://dev.mysql.com/doc/mysql/en/legal-names.html -- Roger -- MySQL General

Re: HTML in MySQL?

element. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Unable to Edit Table Data

. phpMyAdmin and SQLYog are two web-based alternatives. Or you could use your favourite programming language. Download an API from URL: http://dev.mysql.com/downloads/ and write a program that edits your table data. -- Roger -- MySQL General Mailing List For list archives: http

Re: getting started with mysql:

problem you want to solve, you can start solving it. Even if you are doing this just for fun, or for learning, you should come up with a specification or at least a description of what you want your database-enabled information system to do. -- Roger -- MySQL General Mailing List For list archives

Re: need help with foreign keys, new to mysql

. :) -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Question on Join

pretty sure that I can solve this using left outer join but am not able to get it working hence any help would be appreciated! Try something like this: SELECT A.date,B.date FROM A LEFT JOIN B ON B.date=A.date -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: convert varchar to char

Pooly wrote: Hi, I try to convert a varchar to a char, but it doesn't seems to work. From the manual: ...all CHAR columns longer than three characters are changed to VARCHAR columns. URL: http://dev.mysql.com/doc/mysql/en/silent-column-changes.html -- Roger -- MySQL General Mailing

Re: OR in Query String

Justin Palmer wrote: Hi List, I have the following query where I am trying to locate a single students record. I only know that the students record has an id of 3690 and an employer_id of 3 possibles. So I thought that OR would work great. The problem is that it returns all students with

Re: alter table - add a column

only work on an empty or a single-row table, or you would get duplicate key errors. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Seriously.. When are we going to get subqueries?!

George L. Sexton wrote: You obviously don't understand the limitations of timestamps. You obviously don't understand how ineffective leading with an insult is. If you're the first person this has bothered, and if the limitations don't provide inconsistency with a standard -- just with

Re: Query performance...two table design options

= TABLE_B.Data_ID; (Aside: Would this query give me the same results as the above query?) Yes, I think so, if all rows in TABLE_A have a corresponding row in TABLE_B. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: Inner workings of a JOIN

in a 5,000,000,000 row table) and then finding the matching rows based on the WHERE clause? If there is no index on A.lastname and B.id, probably yes... Use the EXPLAIN SELECT command to see how MySQL plan to solve the query. URL: http://dev.mysql.com/doc/mysql/en/explain.html -- Roger

Re: Solution to slow queries

) mysql select inet_ntoa(2130706433); +---+ | inet_ntoa(2130706433) | +---+ | 127.0.0.1 | +---+ 1 row in set (0.00 sec) URL: http://dev.mysql.com/doc/mysql/en/miscellaneous-functions.html -- Roger -- MySQL General Mailing List

Re: 1 table or 2?

this is a blob. I suggest you don't discuss this 3rd column with PHP at all...? ;) $res = mysql_query(select col1,col2 from table); Should I be using 1 or 2 tables? There is no reason to use two tables to solve this problem. There could be other reasons why you should use two tables. -- Roger

Re: Remove 1st 3 Chars

','B4069','B4041', 'A4710','58282','58220','56751','56728', '45003','09234','04200','04035','04026'); URL: http://dev.mysql.com/doc/mysql/en/string-functions.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Solution to slow queries

script and cron or the equivalent if you are on a non-unix platform. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Simple query? Is it possible?

, when you create the link, you allready know what page you are on. Why waste time and try to calculate it again? -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to extract only the first few lines from a longtext field

/en/string-functions.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Sorting by relevance?

, and ASC is the default sorting order, we want each expression to be FALSE, so that it is sorted first. That's why I negated all expressions. An alternative would be to use DESC after each expression. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: SELECT DISTINCT ROW(A,B) ?

a; DISTINCTROW and DISTINCT are synonyms: URL: http://dev.mysql.com/doc/mysql/en/select.html#id2828077 -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query Problem

Dto. Sistemas de Unitel wrote: Hi Roger, You are ok, there was an index problem in one table, they name of the rows wasn't equal and MySQL didn't recognize they as the same index. I have changed the row name and now is working fine, but I have a little question, How can I use indexes

Re: Query Problem

don't know why your index did not work at first. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query problem

://dev.mysql.com/doc/mysql/en/explain.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Query Problem

Dto. Sistemas de Unitel wrote: Hi Roger, That was just I need. The order isnt like you say: ++-+---++---+-+- ++---+-+ | id | select_type | table | type

Re: Index table query structure

'unknown', UNIQUE (name) ); Further reading: URL: http://dev.mysql.com/doc/mysql/en/select.html URL: http://dev.mysql.com/doc/mysql/en/create-table.html URL: http://dev.mysql.com/doc/mysql/en/alter-table.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: SQL_BIG_RESULT

in memory, when failing it would build the disk-based temporary table anyway, thus it would take more time. URL: http://dev.mysql.com/doc/mysql/en/select.html#id2674115 -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: LEFT JOINS same data twice?

two columns from having the same name, in this case both columns would have been named Location. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Weird Query Result

' but still I receive these results. Anyone have a clue what is causing this? iImo is a numeric field, mysql knows it, and automagically converts the string 'FOOBAR' to a numeric value: 0. You are actually querying for iImo=0. Try this: SELECT 'FOOBAR'+0,'FOOBAR'=0; -- Roger -- MySQL General Mailing

Re: How to add 2 columns to a table with After ColName???

col3; You must separate each action with a comma. Try this: alter table MyTable add newcol1 float after col3, add newcol2 float after col3; -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: insert data

Gerald Preston wrote: [...] I get DBI connect'club','gjwpp88',.. failed; Client does not support authentication protocol requested by server Check this: URL: http://dev.mysql.com/doc/mysql/en/old-client.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: # Seconds between two datetime fields

available in version 3.23, for example unix_timestamp(): SELECT start_time, end_time, unix_timestamp(end_time) - unix_timestamp(start_time) AS seconds FROM mailings_sendstats order by start_time desc; -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Regular Expression Query

should be: SELECT * FROM TAB1 WHERE searchword REGEXP '[^a-z0-9]*a[^a-z0-9]*p[^a-z0-9]*p[^a-z0-9]*l[^a-z0-9]*e[^a-z0-9]*' Any index on 'searchword' will of course not be used. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: xml import

and in separate tables. You can search in the XML column too, but it is harder/slower: By using the LIKE operator and your knowledge of the XML structure, you could search for a date within an XML column with something like this: ... LIKE %date2005-02-26/date%. -- Roger -- MySQL General Mailing

Re: nested aliases in select

BY contact_name HAVING count 1 It's hard to give better examples as I don't know exactly what you are trying to achieve... :) -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Selecting with a list of keys

,Lkeys -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Date Functions in MySQL

. The TIMESTAMP column type is NOT a UNIX timestamp...! It is a 'normal' datetime column, you should use just WEEK(cdate), MONTHNAME(cdate) and so on. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: compare dates

column which must be executed for each row: SELECT * FROM activities WHERE (act_date + interval 1 day) = NOW() SELECT * FROM activities WHERE left(act_date,10) = CURDATE() -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com

Re: select case consider the first field only, MySQL 4.18

, there is no version 4.18, you probably meant 4.0.18. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: select case consider the first field only, MySQL 4.0.18

Jan Bartholdy wrote: Thanks Roger, but it does not work: SELECT CASE when Species_1_e 0 THEN 'extern' when Species_3_e 0 THEN 'intern' ELSE '' END AS `species_1_l` from species where statsample=1820; --Gives at a result 'extern' What is the value

Re: compare dates

from_unixtime(1108738332); +---+ | from_unixtime(1108738332) | +---+ | 2005-02-18 15:52:12 | +---+ 1 row in set (0.00 sec) -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Subquery problems

from my question should be something like this: 01 boat 0 02 car 1 03 mc 1 04 bike 2 Would be greatful if somebody could help! Try something like this: SELECT ID,NAME,COUNT(*) FROM tableA LEFT JOIN tableB ON tableA.ID = tableB.ID GROUP BY ID,NAME -- Roger

Re: Subquery problems

Roger Baklund wrote: Try something like this: SELECT ID,NAME,COUNT(*) FROM tableA LEFT JOIN tableB ON tableA.ID = tableB.ID GROUP BY ID,NAME Nope, sorry, that won't work, ID exists in both tables thus it must be prefixed with table name or alias: SELECT tableA.ID,... GROUP BY tableA.ID

Re: Tricky Join with Animal-DB

animal ON animal.id = animal_pic.animalid LEFT JOIN pic ON pic.id = animal_pic.picid URL: http://dev.mysql.com/doc/mysql/en/join.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how to make question that check the last hour

-and-time-functions.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Comparing bug in 4.1.7

in the standard test suite so any bug would block a release going out. Sounds good. :) -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Best way to store numeric data?

by mysql, which again is plattform dependant. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Best way to store numeric data?

) This is no error, it is the approximate data type at work... it simply can not store the exact value. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Best way to store numeric data?

Keith Ivey wrote: Roger Baklund wrote: Galen wrote: I've got a huge table going, and it's storing a load of numeric data. Basically, a percentage or single digit rank, one or two digits before the decimal and fifteen after, like this: 6.984789027653891 39.484789039053891 [snip] You should

Re: Need a query to get the difference of two tables

Michael Stassen wrote: Roger Baklund wrote: [...] select a.address from a left join b on b.iid=a.id where b.iid is null; That's not equivalent, because it leaves out a condition. I think it should be SELECT a.address FROM a LEFT JOIN b ON a.id = b.iid AND b.message='y' WHERE

Re: Need a query to get the difference of two tables

| +-+ | addr 2 | | addr 4 | | addr 5 | +-+ 3 rows in set (0.02 sec) -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SQL syntax error: help a noob

got, and what version of MySQL you are using. The only obvious error I can spot is GETDATE(), this is not a standard MySQL function. Try CURDATE(). -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Need a query to get the difference of two tables

is null; -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: SHOW COLUMNS Syntax Using 3.23.54 Please!

/SHOW_COLUMNS.html You didn't ask, but a shorter way to write this is using the DESCRIBE command, which can be abbreviated to DESC: DESC tbl_name X%; DESC tbl_name Y%; URL: http://dev.mysql.com/doc/mysql/en/DESCRIBE.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: get field name

help me? You should normalize your data. URL: http://dev.mysql.com/tech-resources/articles/intro-to-normalization.html Maybe if you explain what task you are trying to solve, someone could suggest a solution? -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Listing all connected users?

sol beach wrote: How do I see who is currently connected to MYSQL from where they originate? Use the SHOW PROCESSLIST command: URL: http://dev.mysql.com/doc/mysql/en/SHOW_PROCESSLIST.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: select count

status='cancelled'; Is it possible to get count of each status in one query instead of 3? This looks like it could be solved with a basic GROUP BY query: SELECT status,count(*) FROM account GROUP BY status -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: adding automatic alert

the registered stock above the limit... ) -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Update log

/mysql/en/Binary_log.html I don't think you should use the update log, you should use the binary log, even if you use version 3.23.x. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

BEGIN...nothing? (Re: Update log)

serverside, all changes are ignored by the server. If the server is still up, and the client is still connected, well, then the transaction is still active, and it is not yet defined if the changes will be commited or not... this is a bit like Schroedingers cat... ;) -- Roger -- MySQL General

Re: Query Help, Two Tables...

as ITEM FROM tbl_SubItems; SELECT * FROM tmp1 ORDER BY ID; -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Quick Question: Year() function result?

row in set (0.02 sec) -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Strange results - Part 2

Roger Baklund wrote: [...] You are joining the model table on vendor.PID=model.VendorID, and model.VendorID is not a primary or unique key, it could contain duplicates. ... probably the four rows you want. This is ok. It's probably the other join that causes the problem. -- Roger -- MySQL

Re: Deleting redundant rows

. Is there a solution for that? I tried it with distinct, but that does not work, with subselects but this seems not to be supported. ALTER IGNORE TABLE yourtable ADD UNIQUE (city,cc); URL: http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html -- Roger -- MySQL General Mailing List For list archives

Re: Epoch seconds

/Date_and_time_types.html URL: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Strange results - Part 2

are joining the model table on vendor.PID=model.VendorID, and model.VendorID is not a primary or unique key, it could contain duplicates. You are joining the specs table on model.Model=specs.ProdModel, neither is a primary key or unique, both could containt duplicates. -- Roger -- MySQL

Re: Truncating trailing blanks of a constant

...? -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: selection

, like in your last example. Just remove and code='US'. If the value of the column actually is United States, try this to prove it: SELECT concat('',country,'') country,length(country) FROM table WHERE code='US'; -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: copy2diffdatabase

/mysqldump.html There are other options, but mysqldump covers most demands. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Column type question ?

for the file chunk and looks like 0x2e04b273 The equivalent column type in MySQL would be an UNSIGNED INTEGER for both of these. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Use of limit with IN on subquery

a report that lists the the top 10 total_amt for each k1. Sounds like a group-wise maximum type of question, take a look at this: http://dev.mysql.com/doc/mysql/en/example-Maximum-column-group-row.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Use of limit with IN on subquery

| ++---++---+ 2 rows in set (0.05 sec) -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: sum queries

: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: sum queries

James Nunnerley wrote: * Roger Baklund: select date_format(ts,%Y-%m-%d %H) period,sum(rcvd),sum(sent) from mytable group by period; So the below query above will allow me to group by hour - which is quite useful - is there anyway of grouping by say 3 hour periods? Not using the date_format

Re: Use of limit with IN on subquery

was typically 1-5 in size, sometimes 10 or even 100, but mostly (99%) small groups. top 50 and definitely top 100 would never work with this approach, as MySQL can only join 31 (or 63 on 64 bit platform) tables. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Use of limit with IN on subquery

[EMAIL PROTECTED] wrote: What if we used the MySQL-specific feature group-wise auto_increment ? I was thinking of a similar idea, with user variables, also MySQL-specific. What do y'all think? I think it should work, but only Rick can tell... :) -- Roger -- MySQL General Mailing List For list

Re: Reg SubQuery

1 ...and to get the last row: select * from table order by col1 DESC limit 1 DESC in this case means descending, the default for ORDER BY is ASC, wich is short for ascending. LIMIT 1 is used to limit the result to only one row. -- Roger -- MySQL General Mailing List For list archives: http

Re: Indices and Constraints.

: http://dev.mysql.com/doc/mysql/en/SHOW_INDEX.html URL: http://dev.mysql.com/doc/mysql/en/SHOW_CREATE_TABLE.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Comparing bug in 4.1.7

a workaround or a different solution? -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Comparing bug in 4.1.7

Vlad Shalnev wrote: * from the manual: Logical OR. Evaluates to 1 if any operand is non-zero, to NULL if any operand is NULL, otherwise 0 is returned. * Roger Baklund: This definition (from the manual) is self-contradicting: 1 OR NULL should evaluate to 1 because any operand is non-zero

Re: Comparing bug in 4.1.7

again... :) -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Reg SubQuery

There is no need for a subquery in this case: select * from emp order by id limit 1; -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Reg SubQuery

the subquery (select min(id) from emp), but accurding to the question it probably should have been (select min(salary) from emp). That leaves us with the answer from Gleb Paharenko, except the insert query should be insert into memp select min(salary) from emp; -- Roger -- MySQL General Mailing

Re: Reg SubQuery

Roger Baklund wrote: That leaves us with the answer from Gleb Paharenko, except the insert query should be insert into memp select min(salary) from emp; ... and the select should be: select emp.* from emp,memp where salary=m; He would get all employes with the lowest salary, as opposed to: select

Re: converting to Innodb.

: FULLTEXT indexes are used with MyISAM tables only URL: http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html URL: http://dev.mysql.com/doc/mysql/en/Fulltext_Restrictions.html -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: multi period sum() selects

,count,0)) P1-P2, sum(if(timestampP2 and timestampP3,count,0)) P2-P3, sum(if(timestampP3 and timestampP4,count,0)) P3-P4, ... FROM table; -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

  1   2   3   4   5   6   7   8   9   >