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

Re: How to use SSL? (SSL is enabled but not used)

page but a few lines above the line he quoted ## This option is not sufficient in itself to cause an SSL connection to be used. You must also specify the --ssl-ca option, and possibly the --ssl-cert and --ssl-key options. ## This documentation appears to be wrong. Anders -- MySQL General

Re: How to use SSL? (SSL is enabled but not used)

this is a serious security problem that demands more attention than dismissal as documented behavior. To solve it, there needs to be a way to force the use of SSL from the client side. Anders -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: How to use SSL? (SSL is enabled but not used)

On Wed, 18 Aug 2010, Yves Goergen wrote: Since MySQL is now Oracle […] Yves, I think we should be treating this security issue seriously, and working with Shawn and the MySQL team towards solving it constructively, instead of just taking potshots at their new company. Anders -- MySQL General

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: Another cry for help..

Anders Norrbring skrev: Brent, you put me on the right track.. ;) Reading up a bit on syntax for variables, I came up with the following, which seems to work. SET @tid:=(SELECT tid FROM objects WHERE shortname = %s); SET @vid:=(SELECT vid FROM itemtypes WHERE itemtype LIKE %s); SELECT (count

Another cry for help..

Hi.. I'm struggling with a query that I'm trying to simplify as much as possible, but I can't seem to get rid of using the very same subqueries several times. Would there be a way to optimize the following so I get rid of subqueries that do the exact same thing more than once? SELECT

Re: Another cry for help..

, I am escaping the strings in sprintf in PHP, so the %s isn't an issue. Can't it be done without temporary tables? On Dec 20, 2007 4:23 PM, Anders Norrbring [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] wrote: Hi.. I'm struggling with a query that I'm trying to simplify as much

Re: Another cry for help..

glance, it doesn't work at all, I get NULL results from it, but I haven't spent any time trying to locate the problem yet.. So, I'm still open for ideas! On 12/20/07, Anders Norrbring [EMAIL PROTECTED] wrote: Hi.. I'm struggling with a query that I'm trying to simplify as much as possible

Re: Another cry for help..

seems to do it.. Anders Anders Norrbring skrev: Brent Baisley skrev: You might be able to use variables to store the result of the query. Although I've never tried assigning the result of a query to a variable, only field values. SELECT (count(*)+)/(SELECT COUNT(*) FROM score AS s2 WHERE s2.tid

Re: Another cry for help..

better, or at least put you on a better track. I haven't checked this yet, but would it be better/smoother than putting the variables assignments in separate SET statements in front of the SELECT as I mentioned? Anders On 12/20/07, Anders Norrbring [EMAIL PROTECTED] wrote: Brent Baisley

Query help, please..

I'm looking at a situation I haven't run into before, and I'm a bit puzzled by it. I have this table structure: Table USERS: userid, class Table OBJECT: userid, class, result Now I want to query the database for a certain user's result in a specified class, which is very, very easy. No

Help with query...

. AND p1.validdate is either not populated, or the timestamp is before NOW. Everything seems to work except for the passed time check. If I set p1.validdate to a timestamp for something next week, the username is still returned in the result. Grateful for any hints... Anders. -- MySQL General

SV: Help with query...

.. ;) Anders. - Original Message - From: Anders Norrbring [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, October 14, 2007 7:13 AM Subject: Help with query... I'm trying to set up a query, but I don't really get the result I expected, so can someone please help me out here

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: Date v. DateTime index performance

OK, thank you. How is the speed of this index compared with an indexed date column if I do: year_number='x' and month_number='y' and day_number='z'; They should have about the same cardinality, right? Thanks, Anders Chris wrote: Anders Lundgren wrote: One potential solution might

Re: Date v. DateTime index performance

Yes, of course. Thank you! - Anders Brent Baisley wrote: Splitting out your values will cause problems where doing greater than/less than searching. If you search on year_number=2000 and month_number=6, that's not going to give you everything from 6/2000 on. It will return really only

Re: Date v. DateTime index performance

, Anders Dan Buettner wrote: Thomas, I do not think in this case that one is better than the other, for the most part, because both require using a value computed from the column. Computing month from a DATE field should be just as fast as computing from a DATETIME column I would think. Also splitting

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: Grant privs to multiple tables at once?

I think you should try % that is used as wildcard instead for one or many characters. Granting on 'foo_%' might work. Regards, Anders -- Anders Lundgren Master Software Engineer Viba IT Handelsbolag Web: http://www.vibait.se David Felio wrote: Assume database 'biggie' with 15 tables, 10

Re: moving to other web server

'f.id' in 'on clause' The alias seem not working? What should I do, I dont want to rewrite all my sql statement Thanks. Jason -- Anders Lundgren Master Software Engineer Viba IT Handelsbolag Web: http://www.vibait.se [EMAIL PROTECTED] wrote: hi, currently using mysql 4.0.18. want

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: debian installation

Hello, You can get MySQL 5 either by a backport (www.backports.org) or by changing to Etch that will be the new stable release in december. See www.debian.org for more information. Greetings, Anders Jangita @ FSA wrote: hello all i installed debian linux netinst which installed well

Re: Query to get count of ages

; Regards, Anders c nelson wrote: I'm working on MySQL v5.0 and I have a table with dateOfBirth and I want a histogram of ages at a point in time. I tried something like: select round(datediff(curdate(), dateofbirth)/365) as age, count(age) from myTable group by age; but MySQL Query Browser

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

myisamchk -r hanging for a long time after fixing indexes

configuration: Dual opteron 250, 4 GB RAM Debian stable, with MySQL 4.0.21 from backports.org -- mvh. / Sincerely, Anders Schau Knatten Teknisk sjef / CTO Hardware.no email: [EMAIL PROTECTED] phone: (+47) 22 82 32 35 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: 4.1.7 serious problems

There are differences, starting with 4.1.5, with the user/schema administration, that need to be updated/massaged. Perhaps that is your problem? Maybe. :) Anders +===+ |Anders Green Email: [EMAIL PROTECTED

.MYD, .MYI files don't exist... but queries WORK??????

, Anders +===+ |Anders Green Email: [EMAIL PROTECTED] | | Home: 919.303.0218 | |Off Road Rally Racing Team: http://LinaRacing.com

Re: .MYD, .MYI files don't exist... but queries WORK??????

Tobias Asplund wrote: If you installed MySQL 4.1.7 on Windows with the new installer Yes I did. it will automatically use InnoDB tables as the default Ah ha. Thanks. :) That just leaves this: So now my question Where does InnoDB data get stored? Cheers, Anders

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

, and the performance gains from those days or doing things this way are way less now. In some cases, cleaver SQL constructs can be used for simple conditional processing, but it's not generally applicable. Good luck to you /Karlsson Luke Venediger wrote: Hi Anders, Thanks for that. Yes, I have

4.1-Schema won't assign, snaps back

makes a pattern! (Well, that's a little bit of a stretch...) so I wondered if others had seen this, and (here's the kicker!) knew how to fix it. :) Anyone? Cheers, Anders +===+ |Anders Green Email: [EMAIL PROTECTED

Re: strange user permissions error

At 09:52 AM 10/15/2004, Crouch, Luke H. wrote: user permission trouble MySQL version? I've been having some trouble with 4.1.5. Anders +===+ |Anders Green Email: [EMAIL PROTECTED] | | Home

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

Mysqld segfaults irregulary on debian/opteron platform

in this matter. Should we file a mysql bug-report? Please advise. I am happy to provide any additional information that you should find necesarry to resolve the issue. Sincerely, Anders Schau Knatten Norway OS: Debian GNU/Linux Kernel: Linux 2.6.8-rc1 #4 SMP Fri Jul 16 18:03:51 CEST 2004 x86_64 unknown CPU

bug?

not work, mysql automatically changed the value to 1, and that created some trouble fore me. Why is that? Is this a bug or Is it something I did wrong? - anders

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

need help with a query

has voted or not. I have tried many different queries, but I haven't managed to get it to work. Can someone help me. My poll_votes table has this structure: Poll_id User_id Time I hope someone can help me. - Anders Gjermshus

User quotas, how?

Hiya all! I'm curious about if there's a simple way to manage user quotas in a MySQL database? F.x. user one can have 10MB data in the database and user two can have a maximum of 5MB? Anders Norrbring -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

User quotas, how?

Hiya all! I'm curious about if there's a simple way to manage user quotas in a MySQL database? F.x. user one can have 10MB data in the database and user two can have a maximum of 5MB? Anders Norrbring -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

mysql config

The load average on the server is between 0.5 and 5. Can someone give me some tips about what I should alter to get the performence better? Anders Gjermshus

RE: Send someone a database

HOST.DOMAIN.XXX -p DATABASE_TABLE the_database.sql Anders Norrbring Norrbring Consulting -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Cronjob / rights problem.

here? If the /usr/bin/mysqladmin tries to use a user from localhost (any) then it fails, because localhost doesn't have access to the SQL server... What user should be granted access (and from where) to make this job work correctly? Anders Norrbring Norrbring Consulting Halmvägen 42 SE-691 48

Cronjob / rights problem - 2:nd try.

correctly? Anders Norrbring Norrbring Consulting Halmvägen 42 SE-691 48  Karlskoga SWEDEN -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com

Re: Failed connectionattempts

the correct message to the list. -- Anders -BEGIN GEEK CODE BLOCK- Version: 3.12 GCS/O d--@ s:+ a-- C++ UL+++$ P++ L+++ E- W+ N(+) o K? w O-- M- V PS+ PE@ Y+ PGP+ t 5 X R+ tv+ b++ DI+++ D+ G e- h !r y? --END GEEK CODE BLOCK-- PGPKey: http://pgp.mit.edu:11371/pks/lookup?op=getsearch

Failed connectionattempts

connection attempts. No other services malfunctions in this way, or indeed at all on the server. I have run out of ideas on how to debug this problem, can anybody here help me? -- Anders -BEGIN GEEK CODE BLOCK- Version: 3.12 GCS/O d--@ s:+ a-- C++ UL+++$ P++ L+++ E- W+ N(+) o K? w O-- M- V PS

hard sort table order

Is it possible to resort the rows in a table like in a query where using ORDER BY, but have to new sort order stored in the table structure? -- anders thoresson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

is this proper use of mysql BACKUP?

they have to be restored to a database with the very same name, or could they be restored to another database? Are there any differences between backing up this way, and using mysqldump? And finally: Does mysqldump have a counterpart for use in querystrings like those above? Best regards, Anders

is this proper use of BACKUP command?

they have to be restored to a database with the very same name, or could they be restored to another database? Are there any differences between backing up this way, and using mysqldump? And finally: Does mysqldump have a counterpart for use in querystrings like those above? Best regards, Anders

query help needed.

, un_article.a_header ASC Help appreciated! :) -- anders thoresson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

need help combining these two queries to one.

un_section.s_id = un_article.a_section AND un_article.a_deadline = '-00-00' AND un_article.a_issue = '-00-00' ORDER BY un_section.s_name ASC, un_article.a_header ASC How are they combined to one? -- anders thoresson -- MySQL General Mailing List For list archives: http://lists.mysql.com

table creation problems

, i_number INT NOT NULL, i_editor INT, UNIQUE (i_date, i_number) ); For local development I'm using MySQL 3.23.55-NT on a Windows 2000 server. My ISP uses 3.22.25 on a SunOS 5.7 server. Any suggestions? -- anders thoresson -- MySQL General Mailing List For list archives: http

Parser seems to have problems with '-' (dash).

is specified. antispam device: sql, query, queries, smallint Merry Christmas/Happy Hannuka/Happy holidays A Happy New Year -- ers - Anders Nygård - Before posting, please check: http

re: autoextend on innoDB tables RESOLVED

What version of MySQL do you use? autoextend is supported since 3.23.50 and 4.0.2 Ahaa, I am using 3.23.49 (came with rh7.3). Close but no cigar :) -- ers - Anders Nygård - Before

problems with host globbing

in the mysql database. I have read the docs, I have tried examples but to no avail, any and all help is apriecieted -- ers - Anders Nygård Västertorpsvägen 135 129 44 Hägersten Sweden Phone 46-8-5222 35 00 Direct 46-8-5222 35 86 Mobile 46-73-988 65 86 www.x

autoextend on innoDB tables

help is appreciated. -- ers - Anders Nygård Västertorpsvägen 135 129 44 Hägersten Sweden Phone 46-8-5222 35 00 Direct 46-8-5222 35 86 Mobile 46-73-988 65 86 www.x-source.se - Before posting

Re: HELP - Having serious trouble here...

after upgrading glibc). After I downgraded glibc back to glibc-2.2.4-29 on the server I could once again connect to mysql over network. -- Anders Nielsen [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com

Re: HELP - Having serious trouble here...

On Mon, 2002-10-14 at 17:29, Anders Nielsen wrote: On Mon, 2002-10-14 at 16:51, John Hinton wrote: I'm having the same problems. I'm on a RedHat machine... 7.2 running MySQL ver. 3.23.41. I've been told to upgrade my package. Me too. After reading your posting I realized that glibc

Re: Transparent Encryption [was: encrypt myisam?]

way of making oneself just feel secure when infact it almost doesn't buy you anything. PS. Please CC replies on the internals list to me, as I'm only on the general discussion list Okidoki.. -- //anders/g - Before posting

SELECT DISTINCT - bug?

DISTINCTROW. Mvh Anders Bjarby, Infomaker Scandinavia AB - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail

mysqldump fails when using --lock-tables with thousands of tables

backup with --opt --relaxed. Who strictly wants the complete database-integrity offered by --lock-tables can use --opt as before, but also receives a much more detailed error description. Submitter-Id: submitter ID Originator:Anders Henke, [EMAIL PROTECTED

Size of blobs?!

Hello! How do I get the size of a blob? I want to do something like this: SELECT * FROM blob_table WHERE size(blob_column) 1024; Best regards Sven -- --- ANDURAS AG - solutions for the NET

Re: Sub select.

Den 01-08-07 14.57, skrev Anders Alstrin [EMAIL PROTECTED]: Does anyone know how to do this sub select in MySQL. I know how to do it in Oracle! table media +--+---+--+ | media_id | price |filename | +--+---+--+ |3 | 0 | cal.jpg

Performance tweaking

considered placing the data in memory, since speed is of more concern than data integrety. Have anybody tried that? I am very open to suggestions. Best regards Anders Johannsen Denmark - Before posting, please check: http

Online mysql db design tool (alpha)

Hi I'm making a db design tool for the web, and would like some feedback. Please try it out at http://dbd.aktieprat.nu/ (this domain will probably change later on). TIA /ah - Before posting, please check: