Re: MySQL Platform Migration

gt; wrote: > > > >> Am 13.09.2016 um 12:13 schrieb Johan De Meersman: >> - Original Message - >>> From: "Ryan Coleman" <ryan.cole...@cwis.biz> >>> Subject: Re: MySQL Platform Migration >>> >>> Because they want to

Re: MySQL Platform Migration

Dear sir, You do not realize that there aren’t always sys admins on these lists. Your proven track record of asshole first, kid gloves later drives people away. Your fight to change mailing lists is one which only you seem to share. Goodnight. > On Sep 12, 2016, at 7:27 AM, Reindl Harald

Re: MySQL Platform Migration

Because they want to be belittled by european jackasses online. On Sep 10, 2016, at 11:56 PM, Reindl Harald wrote: > > > Am 11.09.2016 um 06:36 schrieb Suresh Rajagopal: >> Is the mysql datafile compatible with different operation system ? I have >> not done this in

Re: a

reply-all? > > Am 18.10.2015 um 22:52 schrieb bluethu...@gmail.com: >> e >> >> Sent from my iPhone >> >>> On Oct 18, 2015, at 4:12 PM, Daevid Vincent <dae...@daevid.com> wrote: >>> >>> d >>> >>>> -Original

Re: a

b > On Oct 15, 2015, at 10:07 PM, Dennis Ruiz wrote: > > a > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe:http://lists.mysql.com/mysql > -- MySQL General Mailing List For list archives:

Re: a

c On Fri, Oct 16, 2015 at 3:01 PM, Ryan Coleman <ryan.cole...@cwis.biz> wrote: > b > > > On Oct 15, 2015, at 10:07 PM, Dennis Ruiz <darv...@gmail.com> wrote: > > > > a > > > > -- > > MySQL General Mailing List > > For list archiv

Re: Using Joins/Unions

No but there should be. If there's not my task is useless. Secondly yes. Unique name on it too. -- Ryan Coleman Publisher, d3photography.com ryan.cole...@cwis.biz m. 651.373.5015 o. 612.568.2749 On Aug 4, 2015, at 17:33, Wm Mussatto mussa...@csz.com wrote: On Tue, August 4, 2015 11:19

Using Joins/Unions

records from /images/ and thusly could be 3000+ from /files/. How on earth do I do this? — Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql

Re: mysql_secure_installation

shouldn't be taken to make MySQL more secure, instead additional steps should be taken to make it insecure if that is what is needed in certain environments. Thank you for the reply. Ryan On Tue, Dec 27, 2011 at 4:08 PM, Shawn Green (MySQL) shawn.l.gr...@oracle.com wrote: Hello Ryan, On 12

mysql_secure_installation

Hi, Does anyone know why what's done in 'mysql_secure_installation' [0] isnot part of the default mysql installation? [0] http://dev.mysql.com/doc/refman/5.0/en/mysql-secure-installation.html Thank you,Ryan Dewhurst P.S. I also asked this question on the forums:http://forums.mysql.com/read.php

One database per server architecture

Architecture question I'm having trouble finding an answer to: I run four WordPress websites. I have mysql setup in a write master/read replica slave configuration on Amazon. There is one master that all the WordPress instances write to. I'm trying to figure out how to setup the read replicas.

Re: One database per server architecture

not like to share an app server) and added memcache. So I think we're ripe for another try. Thanks again, Ryan On Oct 18, 2011, at 5:39 PM, Lydia Rowe wrote: You have answered your own question, good sir. Or so I have come to believe. Is your primary concern $? Is your organization focused

how to generate a data set then join with in on fly?

` = d ? Thanks, Ryan

Parameter(s) need to take care when setting replication over WAN

Hello, I am setting MySQL (5.0) replication over WAN for backup purpose (with SSL enabled). I have read the document: http://dev.mysql.com/doc/refman/5.0/en/replication.html, and wonder if any special tunning needed for using replication over WAN. Are there any configuration parameter(s) need

Storage of UTF-8 char in MySQL

According to this document: http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html It said MySQL support UTF-8 using one to three bytes per character. But I have created a test table: -- create table test ( c char(5) ) default charset =utf8; From the table status, the data length is alway

int(10) va int(11)

Assume MySQL int range (unsigned) is from 0 to 4294967295 There are total 10 digits. Why a lot of tutorial in the web tell you to declare, e.g. CREATE TABLE t1 (f INT(11) UNSIGNED); -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Why UTF8 need 24bit in MySQL?

Hi, On Tue, Jun 8, 2010 at 12:44 AM, Warren Young war...@etr-usa.com wrote:  The Unicode consortium has stated that Unicode will never require more than 21 bits per character[*], and 24 bits is the next even multiple of 8 up from that. Maybe off topic, but just curious...If 3 bytes is enough

Why UTF8 need 24bit in MySQL?

http://dev.mysql.com/doc/refman/5.0/en/charset-unicode.html Since MySQL only support BMP, so in fact 16 bit is needed actually? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Table level locking when inserting auto-increment PK to InnoDB

Hey. Back to few years ago, InnoDB require table level locking when inserting auto-increment PK to the table, and Heikki said there will be a fix. Is this problem still exist now? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Re: Help saving MySQL

On Sun, Dec 13, 2009 at 11:48 AM, Michael Dykman mdyk...@gmail.com wrote: I hope the only reason this thread  is so quiet is because we are all busy notifying our friends.  There are a hell of a lot more users invested in MySQL than those who read this list.  Spread the word! Let's stand up

Table size vs Memory requirements?

Hello, Is it common heard from people that if you have large table (assume MyISAM in my case), you need large memory in order to have the key/index in memory for performance, otherwise, table scan on disk is slow. But how to estimate how much memory I need? Consider a simple case, a MyISAM

Selecting a column with a regular expression applied to it?

in the where clause. Thanks, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Selecting a column with a regular expression applied to it?

the non-ascii characters removed, for example. -Ryan Darryle Steplight wrote: Hi Ryan, MySql does have regular expressions. See Link http://dev.mysql.com/doc/refman/5.0/en/regexp.html On Thu, Sep 11, 2008 at 9:52 AM, Ryan Stille [EMAIL PROTECTED] wrote: From looking at the MySQL 5 docs

Re: my.cnf optimization

: sort_buffer_size Value: 67108856 12 rows in set (0.00 sec) I'll bump innodb_buffer_pool_size to 2G and see how that goes. Thanks for the tips, if there's additional innodb tuning parameters folks tend to hit first I'd be glad to try them as well. -- Ryan Schwartz On Sep 4, 2008, at 8:16

Re: my.cnf optimization

On Sep 4, 2008, at 1:48 PM, Ranjeet Walunj wrote: Hi ryan. As pointed by Johnny, it is difficult to give optimization advise without exactly knowing the performance of your machine. I'm assuming you are using the machine as Database Server and not running application (Web/other

my.cnf optimization

indexes where the slow query log is pointing them, but any suggestions on how better to tune things up would be much appreciated. I'm not sure what else to tune here but we're getting bursts of 1200+ queries per second regularly and seeing things slow down significantly. Best, -- Ryan

Why is this delete so slow? ( 90 seconds per 100 records)

I'm trying to delete some orphaned records from a table that has about 150K records. Here is my delete: |CREATE TEMPORARY TABLE deleteids AS ( SELECT subTable.ID from subTable LEFT OUTER JOIN parentTable ON subTable.ID = parentTable.ID WHERE parentTable.ID IS NULL ); DELETE FROM subTable

Re: Why is this delete so slow? ( 90 seconds per 100 records)

. Thinking about it now... its probably the IN clause, isn't it? I've heard those are slow. Hopefully someone will have a better idea. Thanks, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Why is this delete so slow? ( 90 seconds per 100 records)

Thanks for the help, I rewrote it as a subselect and it deleted all 10K records in two seconds. DELETE subTable FROM subTable LEFT OUTER JOIN parentTable ON subTable.parentID = parentTable.ID WHERE parentTable.ID IS NULL -Ryan -- MySQL General Mailing List For list archives: http

Re: Why is this delete so slow? ( 90 seconds per 100 records)

Ryan Stille wrote: Thanks for the help, I rewrote it as a subselect and it deleted all 10K records in two seconds. DELETE subTable FROM subTable LEFT OUTER JOIN parentTable ON subTable.parentID = parentTable.ID WHERE parentTable.ID IS NULL -Ryan Whoops, I meant that I rewrote it as a JOIN

Name-based virtual servers?

to their own servers instead, and not have to remember a port number. Like: mysql -h mysql.username.domain.com -u username -p and then they'd be pointed at their appropriate instance. Anybody know how I can do that? Thanks. --Ryan -- MySQL General Mailing List For list archives: http

Re: Name-based virtual servers?

, or ... I would settle for a single shared database in which users could create databases and drop their own databases but not other users'. They'll have to live with namespace collisions. Is that possible to do with mysql's permissions? Thanks. --Ryan On Thu, 20 Dec 2007 [EMAIL PROTECTED] wrote: Hi

Problem with master/slave replication

)?Eod #master-connect-retry = 60 #replicate-do-db= mydns # -- Regards, Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Slow Subquery

CHARSET=latin1; CREATE TABLE `projects_tags` ( `project_id` int(11) default NULL, `tag_id` int(11) default NULL, KEY `tag_id` (`tag_id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; I'm using MySQL 5.0.37. Thanks in advance. Ryan -- MySQL General Mailing List For list archives: http

Re: Need script to populate data.

) VALUES\n; print ($i, 888, 'title $i', 'clean title $i', 'description $i', . 'clean description $i', 999);\n } so: perl newfile.pl test_records.sql mysql -p mydatabase test_records.sql -Ryan http://www.stillnetstudios.com SRM SRM wrote: Group, I'm an oracle dba and new to mysql. I've just

Re: [X-POST] Fastest way to dump this huge table

-Saturday.zip etc. Modify to suit your needs. -Ryan Brian Dunning wrote: I have a huge MySQL table, 2.1 million records, 200MB. Once a week I need to dump it in CSV format and zip the file. This is not on my server, and it's in production, so I don't want to risk testing different methods

Re: import rss feed into mysql

Perl would be my language of choice to do something like this. -Ryan Thufir wrote: what would be the quickest, easiest way to import, for example, the rss feed http://rss.gmane.org/gmane.comp.db.mysql.general into mysql? what would be some different approaches, pls? I'm more interested

Re: MySQL Daylight Savings Time Patch - easy check

I am on 4.1.20-1. Maybe your OS isn't patched? Try this: SELECT @@global.time_zone; If you get back SYSTEM, then MySQL is looking to the OS for timezone data. And its only loaded when MySQL starts, so if you haven't restarted MySQL since you patched your OS, you need to do that. -Ryan

Re: MySQL Daylight Savings Time Patch - easy check

Is MySQL on each one set to the same time zone? SELECT@@global.time_zone; -Ryan Néstor wrote: That was interesting. I have 2 rhel 3 servers and they both have been update to handle the DST. They both yield different results when I ran the command: SERVER=RALPH

Re: backup stratergy

Whats wrong with using the --single-transaction switch for backing up InnoDB tables? What does the Hot Backup product do that this doesn't? Thanks, -Ryan Juan Eduardo Moreno wrote: Ananda, For Innodb the best is Innodb Hot Backup ( www.innodb.com (US$) ) For MyISAM you can use a simple

Re: MySQL Daylight Savings Time Patch - easy check

Ryan Stille wrote: Paul DuBois wrote: At 4:40 PM -0600 2/20/07, Ryan Stille wrote: Is there an easy way to test to see if MySQL already has the proper tables loaded? -Ryan Yes, reload them. :-) After that, they're current! ... After digging around on the net for a while I found

Re: MySQL Daylight Savings Time Patch - easy check

. -Ryan Mike Blezien wrote: Out of curiousity, what should be done if they results are different. We checked on one of boxes and got two different results: SELECT UNIX_TIMESTAMP('2007-03-11 02:00:00'), - UNIX_TIMESTAMP('2007-03-11 03:00:00

Re: MySQL Daylight Savings Time Patch

Paul DuBois wrote: At 4:40 PM -0600 2/20/07, Ryan Stille wrote: Is there an easy way to test to see if MySQL already has the proper tables loaded? -Ryan Yes, reload them. :-) After that, they're current! ... My timezone tables appear to be empty. At least the time_zone_name

Re: MySQL Daylight Savings Time Patch

Ryan Stille wrote: Paul DuBois wrote: At 4:40 PM -0600 2/20/07, Ryan Stille wrote: Is there an easy way to test to see if MySQL already has the proper tables loaded? -Ryan Yes, reload them. :-) After that, they're current! ... My timezone tables appear to be empty. At least

Re: MySQL Daylight Savings Time Patch

Is there an easy way to test to see if MySQL already has the proper tables loaded? -Ryan Paul DuBois wrote: At 4:17 PM -0600 2/20/07, Paul DuBois wrote: At 4:36 PM -0500 2/20/07, Sun, Jennifer wrote: Any answers for the question below ? Is there a DST patch for MySql 4.0.20? Thanks

Re: select on multiple fields in several tables?

in your example). You can programmatically get a list of columns in a table, then when you are using Perl or PHP or whatever to build your query string, you can loop through the columns to list them. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: making graphs with MySQL data

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

Re: question on create_tmp_table_priv

the docs about this the other day. It said temp tables are always created in memory, but can be moved to disk if they get too large, or will be created on disk initially if the table contains a certain type of field (maybe text or binary, can't remember). -Ryan -- MySQL General Mailing List

Re: InnoDB does not preserve AUTO_INCREMENT -- WTF!?

auto increment id. Hope this helps. -Ryan Daevid Vincent wrote: http://dev.mysql.com/doc/refman/5.0/en/innodb-auto-increment-column.html We have recently switched several database tables from MYISM to INNODB, only to find out this colossal design flaw in InnoDB tables. We ship out mySQL on our

MySQL on a ram disk?

running on MSSQL, and we are wondering if we could find any speed improvements by moving to MySQL, possibly running on a ram disk. Any input appreciated. Thanks, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: MySQL on a ram disk?

Maybe I should just be looking at using a HEAP table? -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: See how far the slave has replicated from master

(s) is/are doing. The master only writes stuff to the binary log and leaves it at that. Anyway, that's my understanding. Cheers, Ryan -- Ryan Tracey Citizen: The World -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

RE: Very large from

the listings. So I don't think it would be a problem to build up all the data in a session and then write it all at once at the end. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: How to Log Warnings and Errors from queries

Hi Rithish, Thank you all for your suggestion, I would definitely give it a shot. Regards, Ryan. On 3/13/06, Rithish Saralaya [EMAIL PROTECTED] wrote: Hello Ryan. I am more of a developer than a MySQL administrator. Hence, I would always favour applications logging query errors rather than

Re: How to Log Warnings and Errors from queries

Hi Dan, Noted with thanks. As such, is there a workaround to log problematic sql queries ran against the mysqld server ? Do I need to write separate script to do this ? Regards, Ryan. On 3/10/06, Dan Nelson [EMAIL PROTECTED] wrote: In the last episode (Mar 08), ryan lwf said: I

RE: Charset questions

Are my emails not coming through? Or is this question way too 'newbie' and no one wants to touch it? -Ryan Ryan Stille wrote: I'm still hoping someone can else can share their input on this. What do other people usually do as far as the collation setting? Thanks, -Ryan Ryan Stille

How to Log Warnings and Errors from queries

with mysqld-4.0.25 binary version. Any inputs are appreciated. Thanks, Ryan.

RE: Charset questions

I'm still hoping someone can else can share their input on this. What do other people usually do as far as the collation setting? Thanks, -Ryan Ryan Stille wrote: When we migrated to MySQL from MS SQL, I left everything set to the default as far as collations - latin1_swedish_ci

RE: How can I observe mysqld?

What else can I do to observe myslqd? mytop may be of some use: http://jeremy.zawodny.com/mysql/mytop/ -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: manual deletion of binary log files

Yes, look at the PURGE LOGS command. Rithish Saralaya wrote: Hello. Can I delete off the binary log files manually? I do not want to 'RESET MASTER', as it will clear all the binary logs, and that's not what I want to do. The database is backed up every midnight, and I wouldn't want to keep

RE: Deleted sock file, how can I recover

from the local machine, depending on what address you use to connect to. (local IP, local host, actual hostname, etc). -Ryan Scott Haneda wrote: ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.sock' I accidentally deleted the above file, I can not connect any

Charset questions

on some ColdFusion functions. I am wondering if my database charset has anything to do with it. What do other people usually do as far as the collation setting? We are in the US, but do have a few sites that make use of German and Spanish characters. Thanks, -Ryan -- MySQL General Mailing List

Want mysql to return tablename.fieldname format

they show up as ads.id, track.id, etc? -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: create/restore database without binary logging

Put SET SQL_LOG_BIN=0 at the top of your dump file. That will turn off logging just for your session. -Ryan -Original Message- From: sheeri kritzer [mailto:[EMAIL PROTECTED] Sent: Thursday, March 02, 2006 11:56 AM To: Rithish Saralaya Cc: MySQL general mailing list Subject: Re

RE: Want mysql to return tablename.fieldname format

(ads.id as adid). Thanks, -Ryan Rhino wrote: I don't understand what you want. If you have the original query, it should be apparent from it where each 'id' column originated. If you're not sure how to read the query, post it and we can help you figure out which table provided each 'id

RE: User is rejected because of IP, but hostname is allowed

did u start mysql with --skip-name-resolve ??? Kishore Jalleda Kim Christensen wrote: On 2/16/06, Ryan Stille [EMAIL PROTECTED] wrote: Nope. Well, have you tried it? Did it solve your problem? Sorry, I misunderstood. I thought Kishore was saying that if I had started the server

User is rejected because of IP, but hostname is allowed

trying to connect from is named dbdev.willcomminc.com. I did a reverse lookup from the database server and the IP 192.168.2.56 does indeed lookup to dbdev.willcomminc.com. Why is MySQL ignoring the hostname and using the IP? I did google for this first but didn't come up with anything. -Ryan

RE: User is rejected because of IP, but hostname is allowed

Nope. _ From: Kishore Jalleda [mailto:[EMAIL PROTECTED] Sent: Thursday, February 16, 2006 4:32 PM To: Ryan Stille Cc: mysql@lists.mysql.com Subject: Re: User is rejected because of IP, but hostname is allowed did u start

RE: data entry GUI

You can also install MyODBC and then hook an Excel spreadsheet into your database. Editing the spreadsheet will update data in your database. This isn't a good solution if you are going to be creating new tables often. But for manipulating data in a known set of tables it's great. -Ryan

RE: Backups

Furthermore, would it make more sense to have the data dump locally, and then use a script to move the contents of the dump to a machine on the network, perhaps even to a machine located on an alternate network accessed via a second ethernet card? This would be the simplest approach. That is

Converting a date/time field to UTC

that to the field value. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

4.1.16-1 RPM's

': : multiple definition of `compress2' /usr/lib/mysql/libz.a(compress.o)(.text+0x0): first defined here ... Did something change in the 4.1.16-1 RPM's in regards to zlib? As I mentioned above, 4.1.16-0 worked fine. Thanks, Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com

Unable to reference right join table in left join statement under windows...but works under linux

I am using MySQL 5.0.15 on windows and cannot run this query: SELECT a.*,b.name, c.fullname,d.fullname FROM access_authorization a, building b LEFT JOIN users c ON a.createdby=c.id LEFT JOIN users d ON a.modifiedby=d.id WHERE a.sortcode=b.sortcode AND a.sortcode like '1,2,1,6%' LIMIT 0, 25 I

Mysql compile error

\ --exec-prefix=/usr/local/mysql \ --with-named-curses-libs=/usr/lib/libncurses.so.4 \ --enable-thread-safe-client \ --with-extra-character-sets=complex Any ideas on what's wrong? I am installing verion 4.1.14, and the server is running RedHat 6.2. Thanks, -Ryan

RE: Mysql compile error - more info

and my pasted error messages. I hate Outlook with a passion but am forced to use it. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Mysql compile error - fixed

I fixed the whole problem by typing this one line: `ln -s libz.so.1.1.3 /usr/lib/libz.so` Linux is such a pain sometimes. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

UNIX timestamp with microseconds

is possible to get UNIX timestamp with microseconds when i try the following it just give 10 digits mysqlSELECT unix_timestamp('20051114095641'+ INTERVAL 0 HOUR) as ts; output : 1131933401 --- 10 digits any tips? tia! -- MySQL General Mailing List For list archives:

timestamp

is it possible to get the the given (unix)timestamp in milliseconds since the epoch? tia! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Terrible MySQL Administrator

you further. hth -- Ryan Escarez CEBB F1E4 1E39 EC48 F05D 6B72 9C11 DD88 5E39 E471 $ gpg --keyserver pgp.mit.edu --recv-keys 0x5E39E471 main(k){float i,j,r,x,y=-16;while(puts(),y++15) for(x=0;x++84;putchar( .:-;!/)|IH%*#[k15])) for(i=k=r=0;j=r*r-i*i-2+x/25,i=2*r*i+y/10,j*j+i*i11k++111;r=j

Problem compiling MyODBC - looking for sql.h file

. I don't know how it got there. By looking inside the file it appears to be related to MyODBC 3.5.11. Just for kicks I copied this file to the second system, but got the same error when trying to run ./configure. Any ideas? -Ryan -- MySQL General Mailing List For list archives: http

Detect if table exists from within MySQL?

SELECT notifyto FROM cfgbiz ELSE SELECT '' as notifyto Is there something similar in MySQL? I am running version 4.1.x. Thanks, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Detect if table exists from within MySQL?

was hoping for a more elegant way to do it, within the single query. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Detect if table exists from within MySQL?

,'') FROM cfgbiz; But it looks like the SHOW TABLES statement just doesn't return like a regular SELECT statement does, because the above works if I use it like this: select IF(1,notifyto,'') FROM cfgbiz; -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

RE: Intelligent Converters product: MSSQL-to-MySQL

Josh Chamas wrote: Ryan Stille wrote: Has anyone ever used this MSSQL-to-MySQL converter? It's pretty reasonable at $40, and the demo output I got looked pretty good. But I wanted to see if there is anything I should be weary about. http://www.convert-in.com/mss2sql.htm I have done

RE: Intelligent Converters product: MSSQL-to-MySQL

data than VARCHAR(16) ? I'm not sure how the (16) is used on a TEXT field. MS SQL has TEXT fields and VARCHAR fields. A VARCHAR(16) in MSSQL would be the same as a VARCHAR(16) in MySQL. But in my MSSQL database I have data with thousands of characters in a TEXT(16) field. -Ryan -- MySQL

Questions about last_insert_id() instead of @@IDENTITY

SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO rps_names (nameid, name) VALUES (NULL, Ryan Smithland) SELECT LA' at line 2 With MSSQL the trick was the NO COUNT. That told the database server not to return a count

RE: Questions about last_insert_id() instead of @@IDENTITY

autocommit = 0 at the beginning also. I will ask on a CF list, because they may have run into this issue. But really I think it's a MySQL question. Thanks, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Connecting using MyODBC

(Specified driver could not be loaded) Thanks for any help. -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Intelligent Converters product: MSSQL-to-MySQL

Has anyone ever used this MSSQL-to-MySQL converter? It's pretty reasonable at $40, and the demo output I got looked pretty good. But I wanted to see if there is anything I should be weary about. http://www.convert-in.com/mss2sql.htm Thanks, -Ryan -- MySQL General Mailing List For list

RE: Mysqldump Problem

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

Backups on high-availability servers

it! Thanks for any input, -Ryan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Questions about backups, InnoDB tables, etc.

. The mysqldump is still running. How is this record getting inserted into the database? I thought it was locked while the dump was happening? I thought it would get queued up and inserted when the mysqldump is finished. The record was NOT in the dump, this part made sense. Thanks for any help. -Ryan

Re: Migrating Database

server. -- Ryan Cavicchioni GPG ID: C271BCA8 GPG Public Key: http://confabulator.net/gpg/ryan.asc GPG Fingerprint: 83E4 2495 6194 0F66 ED85 22B4 4CC0 DA01 C271 BCA8 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Bug or query problem?

for from_cno should be r.jpg but its somehow cacheing the above. Please advise. Thanks, Ryan A -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.11.0 - Release Date: 4/29/2005 -- MySQL General Mailing List For list archives: http

Re: Equivalent syntax similiar to dir /w /s in Windows command prompt

Is 'find' what you're looking for? find ${path} -type f -iname '*.doc' -print find ${path} -type f -iname '*.doc' -exec /some/import/script {} \; Thanks, Ryan Yagatich ,__, / Ryan Yagatich Pantek Incorporated | \ http

Help with query

Best regards, Ryan

query performance

Can I post a query to this list and ask for help optimizing it? -- Ryan McCullough mailto:[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Data in different tables or is one big table just as fast?

with no archiving/compression/purges. What if we use COMPRESS() for the text in old rows? Jacob -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Ryan McCullough mailto:[EMAIL PROTECTED] -- MySQL

Re: queries slower on InnoDB

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

Subquery Oddity? Or where is the error I'm missing?

LIKE CONCAT((SELECT parent_path FROM category WHERE id=2), ,2); Empty set (0.00 sec) mysql SELECT VERSION(); +-+ | VERSION() | +-+ | 4.1.5-gamma | +-+ 1 row in set (0.00 sec) -- Ryan Sommers [EMAIL PROTECTED] -- MySQL General Mailing List For list archives

  1   2   3   4   >