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 resp

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

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

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 a

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 ex

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

e can 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); > J

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

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

Re: timing queries?

set (0.00 sec) Bye C:> You can combine with --skip-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

*** id: 8002 GeoQuality: 2a 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: htt

Re: 1064 error

del Challenge", "SA Pro Model" and so on, and you 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` + ... http://d

Re: Yet another null question

/mysql/en/problems-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: Unable to Edit Table Data

on't have to use "MySQL Administrator". phpMyAdmin and SQLYog are two web-based alternatives. Or you could use your favourite programming language. Download an API from http://dev.mysql.com/downloads/ > and write a program that edits your table data. -- Roger -- MySQL Genera

Re: HTML in MySQL?

tml output. Many web pages have a variable width... there is a reason for why whitespace usually is not significant in html. The problem you describe above is not related to mysql, and you could probably solve it another way. You should take a look at the html element. -- Roger -- MySQL Gene

Re: need help with foreign keys, new to mysql

ot the reason for the error message. :) -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: getting started with mysql:

fter you know what 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

Re: Question on Join

I am 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/m

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." http://dev.mysql.com/doc/mysql/en/silent-column-changes.html > -- Roger -- MySQL Ge

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 emp

Re: alter table - add a column

NULL, DROP PRIMARY KEY, ADD PRIMARY KEY(USERID); This would 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 ot

Re: Inner workings of a JOIN

with the two tables (resulting 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. http://dev.mysql.com/doc/mysql/en/

Re: Query performance...two table design options

LECT TABLE_A.First_Name, TABLE_A.Last_Name, TABLE_B.Data FROM TABLE_A, TABLE_B WHERE Activity = 'draw' AND Age > 24 AND TABLE_A.Data_ID = 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 correspondi

Re: Remove 1st 3 Chars

27;,'B4076','B4069','B4041', 'A4710','58282','58220','56751','56728', '45003','09234','04200','04035','04026') order by FIELD(fieldname,'B4079','B

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 ta

Re: Solution to slow queries

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

Re: Solution to slow queries

shell 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: Sorting by relevance?

ea. Each expression in the ORDER BY clause returns 0 (false) or 1 (true). Because 0 is smaller than 1, 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 ex

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

c/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 PROTECTED]

Re: Simple query? Is it possible?

At this stage, 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: SELECT DISTINCT ROW(A,B) ?

rom a; DISTINCTROW and DISTINCT are synonyms: 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

RE clause dictates which columns are related, not the name of the columns. I 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

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 in

Re: Query Problem

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

Re: Query problem

ead t1/t2 first, then i1/i2 and finally productos. http://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: SQL_BIG_RESULT

y in memory, when failing it would build the disk-based temporary table anyway, thus it would take more time. 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.m

Re: Index table query structure

x27;,'unknown') NOT NULL DEFAULT 'unknown' ); # unique name, relates to other tables (using id) CREATE TABLE names ( id integer NOT NULL PRIMARY KEY, name varchar(30) NOT NULL, age tinyint NOT NULL, sex enum('f','m','unknown') NOT NULL DEFAUL

Re: LEFT JOINS same data twice?

tion" column is aliased to "Destination". This is necessary to avoid 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

he value 'FOOBAR' 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&#x

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

after 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: http://dev.mysql.com/doc/mysql/en/old-client.html > -- Roger -- MySQL General Mailing List For list ar

Re: # Seconds between two datetime fields

ts of date/time functions 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.mys

Re: nested aliases in select

lastname) contact_name, COUNT(*) as count FROM Contacts GROUP 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: xml import

ur data in separate columns 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 "%2005-02-26%". -- Roger

Re: Regular Expression Query

rd'", -1, PREG_SPLIT_NO_EMPTY)); The result 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 F

Re: Date Functions in MySQL

k and month. They don't seem to match up. 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: Selecting with a list of keys

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

Re: compare dates

mysql> select 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/mysq

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

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

value is 0, which is never > 0. BTW, 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: compare dates

e computation on the act_date 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.mysq

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 tabl

Re: Subquery problems

ROUP BY ID,NAME -- 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

other date/time functions are documented here: 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: Tricky Join with Animal-DB

al,pic.pic FROM animal_pic LEFT JOIN animal ON animal.id = animal_pic.animalid LEFT JOIN pic ON pic.id = animal_pic.picid 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: Comparing bug in 4.1.7

m not mistaken, ALL combinations are now tested 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?

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

Re: Best way to store numeric data?

--+ 2 rows in set (0.00 sec) 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?

underlaying c library used 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: SQL syntax error: help a noob

us what error message you 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

t you wanted: mysql> select a.address ->from a ->left join b on b.iid=a.id and message="y" ->where b.iid is null; +-+ | address | +-+ | 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: 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='

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

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

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: 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: get field name

'STAT3' FROM tab WHERE Stat3=1 and Time='0906' can someone help me? You should normalize your data. 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

Re: SHOW COLUMNS Syntax Using 3.23.54 Please!

"Y%"; http://dev.mysql.com/doc/mysql/en/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%"; http://dev.mysql.com/doc/mysql/en/DESCRIBE.html >

Re: select & count

) from account where 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: h

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

goes down, a ROLLBACK is effectively executed 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 Schroe

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]

Re: adding automatic alert

nutes until you stop the script or increase 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: Query Help, Two Tables...

T ID, SUBITEM 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?

--+ 1 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

del=specs.ProdModel where vendor.Vendor='#URL.Vendor#' 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. You are joining the specs table on model.Model=specs.ProdModel, neither is a primary ke

Re: Epoch seconds

ev.mysql.com/doc/mysql/en/Date_and_time_types.html > 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: 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); http://dev.mysql.com/doc/mysql/en/ALTER_TABLE.html > -- Roger -- MySQL General Mailing List For list archives: h

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

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

7;United States'. If you want to match a part of a column, you can use the LIKE operator and a % character, 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

Re: Truncating trailing blanks of a constant

should not happen in this case...? -- 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

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

Re: Use of limit with IN on subquery

is case. In my case the groups 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

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 d

Re: sum queries

) from mytable group by period; 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: Use of limit with IN on subquery

second | third | ++---++---+ | a | 412 |312 | 142 | | b | 441 |421 | 331 | ++---++---+ 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: Use of limit with IN on subquery

ant to create 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

Re: Column type question ?

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: Comparing bug in 4.1.7

tion of logical operator OR), or if I am just overthinking again... :) -- 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 op

Re: Comparing bug in 4.1.7

someone can suggest 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: Indices and Constraints.

://dev.mysql.com/doc/mysql/en/SHOW_INDEX.html > 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: 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: Weird query behaviour

rd" at the same time. You should use OR instead of AND. -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Need help figuring out indexes for faster SELECT queries

..consumed MORE index space compared to indexing like this: name varchar(32) not null, INDEX (name) The manual has a lot on optimization: http://dev.mysql.com/doc/mysql/en/MySQL_Optimization.html > -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Question: Limit search on string

gits equal to 4? For the first case, area code 444: SELECT Telephone FROM SignUp WHERE Telephone LIKE '444%'; ... and for the second case, finding the digit 4: SELECT Telephone FROM SignUp WHERE LEFT(Telephone,3) LIKE '%4%'; -- Roger -- MySQL General Mailing List For l

Re: multi period sum() selects

d timestamp ... FROM table; -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: converting to Innodb.

: "FULLTEXT indexes are used with MyISAM tables only" http://dev.mysql.com/doc/mysql/en/Fulltext_Search.html > 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:/

  1   2   3   4   5   6   7   8   9   10   >