Re: Stored Procedure help

://www.pointmade.net https://www.facebook.com/pointmade.band -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql -- Anders Karlsson, Senior Sales Engineer SkySQL | t: +46 708-608-121 | Skype: drdatabase -- MySQL General Mailing

Re: Why is mySQL not respecting foreign characters as different

utf8_general_ciYES (NULL) select,insert,update,references de text utf8_general_ciYES (NULL) select,insert,update,references fr text utf8_general_ciYES (NULL) select,insert,update,references -- Anders Karlsson, Senior Sales Engineer

MyQuery 3.4.1 Released

on Windows 7. Read more on the blog here: http://karlssonondatabases.blogspot.com/2010/11/announcement-myquery-341-released.html Or just go ahead and download it from here: http://sourceforge.net/projects/myquery/ Best regards Anders Karlsson -- MySQL General Mailing List For list archives: http

Re: SQLStats 1.1 available

If you downloaded this earlier today, note that there is now a 1.2 version available, that also shows ROWS_EXAMINED in INFORMATION_SCHEMA tables. /Karlsson Claudio Nanni wrote On 2010-11-24 09:02: Cool! On Nov 24, 2010 8:46 AM, Anders Karlsson and...@recordedfuture.com mailto:and

SQLStats 1.1 available

The plugin is GPL and is downloadable from sourceforge here: https://sourceforge.net/projects/sqlstats/ Best regards Anders Karlsson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Death of MySQL popularity?

I was a MySQL Sales Engineer up til a few weeks ago. I spent 6+ year at MySQL. MySQL Classic never ever had InnoDB in it. Actually, the reason for the existence of MySQL Classic was just that: MySQL without InnoDB for OEMs. If you wanted a non-GPL MySQL, you had to pay for it. And if MySQL

MyQuery 3.2.1

a colour printer that is, and query results. Printing also, as does the editor, screen results and the database, support UTF-8 data. Best regards and happy SQLing Anders Karlsson BTW. Sorry for cross-posting, but I felt this is interesting to both groups, and I don't really overflow these mailing

MyQuery 3.2.1 released - Bad link

MyQuery, and I'll also check links before posting. Best regards Anders Karlsson After a few beers, including an Anderson Valley Double IPA, not bad! -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson (and...@mysql.com) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer

MyQuery 3.1 Beta Released

enhancement. Color syntax highlightning by using the Scintilla editor control. The MyQuery_3_1_setup.zip contains a single full-featured installer, including the documentation. Best regards Anders Karlsson -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson

Re: MyQuery 3.1 Beta Released

/ Best regards Anders Karlsson Anders Karlsson wrote: MyQuery 3.1 is now ready for download from Sourceforge: http://sourceforge.net/projects/myquery/ The features of this release includes, but is not limited to: - UTF-8 support - Events management dialog - SQL Statement profiling - Much enhanced

MyQuery 3.0 Alpha available now

what is planned. MyQuery is GPL and may be downloaded from Sourceforge here: http://sourceforge.net/projects/myquery/ Best regards /Karlsson -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson (and...@mysql.com) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer

MyQuery 2.3.2 released

it another chance now, there are some cool features in this Query tool. Available for download at: http://sourceforge.net/projects/myquery/ Best regards /Karlsson -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB

Re: MyQuery 2.3 Beta available for download

of data (To a spreadsheet for example). * More output command options. etc. /Karlsson Moon's Father wrote: It's very nice! But it's too simple. On Mon, Oct 6, 2008 at 12:26 AM, Anders Karlsson [EMAIL PROTECTED] wrote: Sorry for crossposting, but I think this is relevant both th general MySQL

MyQuery 2.3 Beta available for download

so than one might think, so input in this area is highly valued. /Karlsson -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer /_/ /_/\_, /___/\___\_\___/ Stockholm ___/ www.mysql.com

MyQuery 2.1 beta available

this. Download MySQL 2.1, inslcuding a complete windows installer (including PDF documentation), PDF documentation and sourcecode from: https://sourceforge.net/projects/myquery/ Happy SQL'ing /Karlsson -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL

MyQuery 2.0

: proper UTF-8 support. Supporting UTF-8 should be easier, now that Scintilla is in place, but more work is needed for this. Download MyQuery 2.0 from Sourceforge here: https://sourceforge.net/projects/myquery/ /Karlsson -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders

MyQuery 1.1 alpha available

/myquery/ and there is sourcecode or a complete Windows Installer or the documentation in PDF format. The latter is included with the Windows installer. Well, that's it for now, happy programming /Karlsson -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED

Re: Unicode sorting and binary comparison, please!

. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer /_/ /_/\_, /___/\___\_\___/ Stockholm ___/ www.mysql.com Cellphone: +46 708 608121 Skype: drdatabase -- MySQL General Mailing List For list archives

Re: Unicode sorting and binary comparison, please!

there might possibly be a need for this. /Karlsson Yves Goergen wrote: On 03.03.2008 10:27 CE(S)T, Anders Karlsson wrote: [a lot about why sorting unicode is complicated] If you want to accknowledge exact matching, and say any character, accented / unlauted etc, is different from any other character

Re: Need help to locate SetSRID(),Makebox2D(),Distance_Sphere()

SRID support though) is available in special version that you can read about here: http://forge.mysql.com/wiki/GIS_Functions where you can also find download links. Best regards Anders Karlsson [EMAIL PROTECTED] wrote: Hi All I looking for the stated functions. Earlier I was using postGIS

Re: What is MYSQL's equivalent to Oracle's DBMS_OUTPUT

for in it. Since I am not sure if what I want exists or what it may be called, I just may be looking in the wrong places for the answer. TIA! -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer

Re: BUG in UNION implementation?! Confimation or Explaination please

| +---++---+-+---+--+ TIA, CVH -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer /_/ /_/\_, /___/\___\_\___/ Stockholm ___/ www.mysql.com Cellphone

Re: Convertion ORACLE query to MYSQL

-- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer /_/ /_/\_, /___/\___\_\___/ Stockholm ___/ www.mysql.com Cellphone: +46 708 608121 -- MySQL General Mailing List For list archives: http

Re: Some trouble with a Join after upgrade from 3.23 to 5.0

. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer /_/ /_/\_, /___/\___\_\___/ Stockholm ___/ www.mysql.com Cellphone: +46 708 608121 -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: How to get into mysql command line?

/doc/refman/5.0/en/password-too-long.html Best regards Anders Karlsson Cornelia Menzel wrote: Am 16.10.2006 um 13:08 schrieb Dominik Klein: Unfortunately, that is not the reason, why I get this message. I have tried 'mysql', 'mysql -uroot', mysql -u root', 'mysql -uroot -p', 'mysql -uroot

Re: How to get into mysql command line?

to watch for this if the client has version 4.0 or earlier, and you have server with version 4.1 or higher, then this is surely the problem you are experiencing. Read more here: http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html Best regards Anders Karlsson Cornelia Menzel wrote: Am

Re: Stored Procedure Security Question

suggestions about how to manage users/privileges would be appreciated. Donna -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer /_/ /_/\_, /___/\___\_\___/ Stockholm ___/ www.mysql.com

Re: Mysql HA

can read more about that on the Linux HA homepage at: http://www.linux-ha.com/ There are a few different way to adopt MySQL in this type of environment. You can use DRBD (which is part of the Linux HA project) or a SAN or you can use MySQL Replication. Best regards Anders Karlsson JM wrote: Hi

Re: storing URL 2083 characters

-- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer /_/ /_/\_, /___/\___\_\___/ Stockholm ___/ www.mysql.com Cellphone: +46 708 608121 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: finding the slow query

Or try my own tool mymonitor. Available on sourceforge at https://sourceforge.net/projects/mymonitor It's still in beta, but works OK. Still work in progress, and features will be added, but in your situation, I think it could be useful. Best regards Anders Karlsson Duncan Hill wrote

MyMonitor - A novel SQL monitor tool for MySQL release 1

, and comments are welcome, I hope this tool will turn out useful -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer /_/ /_/\_, /___/\___\_\___/ Stockholm ___/ www.mysql.com Cellphone: +46 708 608121

Re: MyMonitor - A novel SQL monitor tool for MySQL release 1

into an upcoming version of the tool though. Best regards Anders Karlsson John May wrote: Is there any way with this tool, or some other tool, to monitor the amount of data (in KBytes or the likes) returned by a particular query? - John The first version of MyMonitor is now available in source

Re: MyMonitor - A novel SQL monitor tool for MySQL release 1

Also, I need to learn how to spell. The docs arn't as bad as the language in the reply below. /Karlssons spellchecker Anders Karlsson wrote: John! No, that is not within the scope of this tool. One could imaging that is was possible though, but without some No, that is not within

Re: MyMonitor - A novel SQL monitor tool for MySQL release 1

look at the project at sourceforge now and then. Best regards Anders Karlsson Gabriel Mahiques wrote: Anders I want this for Windows? how do I do it? Anders Karlsson escribió: The first version of MyMonitor is now available in source form on sourceforge and can be downloaded from: http

Re: go back machine

change of given parameter in eq_deltalist, how do I query for the valid parameters a certain date (i.e. when the lastmodified date is closest to the date in question) ?? Thankful for any good ideas. BR // Niklas -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL

Re: Conditional statement: IF

. -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer /_/ /_/\_, /___/\___\_\___/ Stockholm ___/ www.mysql.com Cellphone: +46 708 608121 -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Conditional statement: IF

execute one query. Cheers, Luke Venediger. On Fri, 22 Oct 2004 18:49:54 +0200, Anders Karlsson [EMAIL PROTECTED] wrote: I don't know why you want to do this, but looking at your sybtax, it seems like you come from a Sybase or SQL Server environment. What you are trying to achieve is the way

Re: Enforce value on select

_ Do You Yahoo!? 150??MP3 http://music.yisou.com/ ??? http://image.yisou.com 1G??1000??? http://cn.rd.yahoo.com/mail_cn/tag/1g/*http://cn.mail.yahoo.com/event/mail_1g/ -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson

Re: This thing called MOD

MOD returns the remainder of the division, assuming we use integer arithmetic. I.e.: 234 / 10 = 23 Then 4 remains (234 - (10 * 23)) Or: 23 / 6: (23 - (6 * 3)) = 5 Best ragards Anders Karlsson Thomas Nyman wrote: Hi All I'm a bit perplexed..perhaps its a language thing,,but the MYSQL reference

Re: Problems compiling NDB-Cluster mysql-4.1.2

autoconf: 2.53 automake: 1.5 libtool: 1.5 Thanks Steffen -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer /_/ /_/\_, /___/\___\_\___/ Stockholm ___/ www.mysql.com Cellphone: +46 708 608121

Re: urban myth?

in a particular way is to explicitly request it with an ORDER BY clause, as several others have pointed out. This is really a fundamental principle: It is the data in the row that matters, not how or where it is stored. Michael -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders

Re: first LIMIT then ORDER

it seems). And now I close the SQL-92 standard docs. It is saturday after all and a beautiful day outside! Anders Karlsson -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Anders Karlsson ([EMAIL PROTECTED]) / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Sales Engineer