Re: filename-safe conversion of database-/tablenames

- Original Message - > From: "Simon Fromme" > Subject: filename-safe conversion of database-/tablenames > > I need to convert both the names of databases and tables in a > filename-safe way (escaping "/" and other characters as in [1]). The I don

filename-safe conversion of database-/tablenames

t didn't find a way in which it exposes this conversion function to the outside. Did I overlook some way this could be done? If not, would this be a feature that a future version of MySQL should provide? Best regards Simon Fromme [1]: https://dev.mysql.com/doc/refman/5.7/en/identi

Re: Wrong conversion to timestamp from character string

t;SELECT" may have any type: the result context does not require anything. Now, your expression IF( DATE(d) = "some-date", TIME(d), d ) is an operand to "SELECT", and no type is required of it--but the types are not the same, wherefore there is at least one conversion, surely

Re: Is conversion required?

On Sep 29, 2010, at 5:15 PM, Paul Halliday wrote: > I just converted (reinstalled) a FreeBSD system from i386 to amd64. Of > course; I missed the memo. I have been struggling to get everything back > online. I just finished exporting a few Gigs of RRD's to XML so that I could > use them :| > > M

Is conversion required?

I just converted (reinstalled) a FreeBSD system from i386 to amd64. Of course; I missed the memo. I have been struggling to get everything back online. I just finished exporting a few Gigs of RRD's to XML so that I could use them :| My question: I was s/rushing/stupid so I just moved /var/mysql to

Re: Speeding up character set conversion

Hi Morten, You might want to read this post on MySQL Performance Blog that was posted a few days ago: http://www.mysqlperformanceblog.com/2009/03/17/converting-character-sets/ Have a nice day, - Martijn On Wed, Mar 18, 2009 at 11:50, Morten wrote: > > Hi, I just tried this on a local copy of t

Speeding up character set conversion

Hi, I just tried this on a local copy of the table with ~500.000 rows: execute 'ALTER TABLE users MODIFY email VARCHAR(255) CHARACTER SET latin1 NOT NULL' The old character set was UTF8. We're doing this to make the index smaller. This took around 45 minutes to complete. In production,

Re: mysql to mysql conversion tool

t;Sharique uddin Ahmed Farooqui" <[EMAIL PROTECTED]> To: Sent: Tuesday, January 29, 2008 1:16 PM Subject: mysql to mysql conversion tool > Hi, > I'm looking an application which let me convert one mysql to another db. I > need this to port my website from

RE: mysql to mysql conversion tool

Check out DBConvert variants.. http://www.dbconvert.com/ -Original Message- From: Sharique uddin Ahmed Farooqui [mailto:[EMAIL PROTECTED] Sent: 29 January 2008 18:16 To: mysql@lists.mysql.com Subject: mysql to mysql conversion tool Hi, I'm looking an application which let me co

mysql to mysql conversion tool

Hi, I'm looking an application which let me convert one mysql to another db. I need this to port my website from one cms (Vivvo) to another (Drupal). -- Sharique uddin Ahmed Farooqui (C++/C# Developer, IT Consultant) A revolution is about to begin. A world is about to change. And you and I are "

Re: datetime type conversion problem

Ah ok I rechecked the documentation for BETWEEN which includes additional information not mentioned on the type conversion page: For best results when using BETWEEN with date or time values, you should use CAST() to explicitly convert the values to the desired data type. Examples: If you

Re: datetime type conversion problem

o fine for me if I change the two 2007-3-23 to 2007-03-23. Fred -Original Message- From: Rob Desbois [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 5:02 AM To: mysql@lists.mysql.com Subject: datetime type conversion problem I am having issues with type conversion not working as ex

RE: datetime type conversion problem

Everything seems to go fine for me if I change the two 2007-3-23 to 2007-03-23. Fred -Original Message- From: Rob Desbois [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 29, 2007 5:02 AM To: mysql@lists.mysql.com Subject: datetime type conversion problem I am having issues with type

Re: datetime type conversion problem

Hi Rob, Rob Desbois wrote: I am having issues with type conversion not working as expected per the documentation. I am using in MySQL 5.0.27 for x86/Windows. The documentation at http://dev.mysql.com/doc/refman/5.0/en/type-conversion.html states that for comparison operators "If one o

Re: datetime type conversion problem

('2007-03-23' - INTERVAL 24 HOUR) AND '2007-03-23 23:59:59'; Chris Rob Desbois wrote: I am having issues with type conversion not working as expected per the documentation. I am using in MySQL 5.0.27 for x86/Windows. The documentation at http://dev.mysql.com/doc/refman

datetime type conversion problem

I am having issues with type conversion not working as expected per the documentation. I am using in MySQL 5.0.27 for x86/Windows. The documentation at http://dev.mysql.com/doc/refman/5.0/en/type-conversion.html states that for comparison operators "If one of the arguments is a TIMESTA

Re: string to timestamp conversion

From: "Bryan Cantwell" <[EMAIL PROTECTED]> > Date: Mon, 21 May 2007 12:08:11 > To:"MySQL General" > Subject: string to timestamp conversion > > I have a table with a varchar column that contains a timestamp like > this: 'Thu May 17 09:15:47 2007

RE: string to timestamp conversion

: MySQL General Subject: RE: string to timestamp conversion I see no string to date function that does this conversion... -Original Message- From: Bryan Cantwell Sent: Monday, May 21, 2007 2:08 PM To: MySQL General Subject: string to timestamp conversion I have a table with a varchar column

RE: string to timestamp conversion

I see no string to date function that does this conversion... -Original Message- From: Bryan Cantwell Sent: Monday, May 21, 2007 2:08 PM To: MySQL General Subject: string to timestamp conversion I have a table with a varchar column that contains a timestamp like this: 'Thu May

Re: string to timestamp conversion

Have you considered using the string to time function? Sent via BlackBerry from T-Mobile -Original Message- From: "Bryan Cantwell" <[EMAIL PROTECTED]> Date: Mon, 21 May 2007 12:08:11 To:"MySQL General" Subject: string to timestamp conversion I have a t

string to timestamp conversion

I have a table with a varchar column that contains a timestamp like this: 'Thu May 17 09:15:47 2007' I need to grab this and include it in an insert sql that puts that value in a table as a timestamp... -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

Character Set Conversion Scenarios / Detection

/bug.php?id=22719. According to the documentation, there are 3 different scenarios: Case A: "old tables from MySQL 4.0 or earlier where a non-binary column contains values that actually are encoded in a character set different from the server's default character set." -> Upgrade /

RE: MyISAM to InnoDB conversion help

Great, Thank you for your help Rolando, Mikhail Berman -Original Message- From: Rolando Edwards [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 01, 2006 11:41 AM Cc: mysql@lists.mysql.com; Mikhail Berman Subject: Re: MyISAM to InnoDB conversion help I just noticed your

Re: MyISAM to InnoDB conversion help

m: Rolando Edwards <[EMAIL PROTECTED]> To: Mikhail Berman <[EMAIL PROTECTED]> Cc: mysql@lists.mysql.com Sent: Wednesday, November 1, 2006 11:24:00 AM GMT-0500 US/Eastern Subject: Re: MyISAM to InnoDB conversion help Check these variable bulk_insert_buffer_size (Default usually 8M) innodb_buf

Re: MyISAM to InnoDB conversion help

11:13:44 AM GMT-0500 US/Eastern Subject: RE: MyISAM to InnoDB conversion help Hi Rolando, Thank you for your help. I am on MySQL 5, and I have tried to do the conversion using ALTER TABLE command. With the same very slow result. Do you by any chance have specific suggestions how to tweak varia

RE: MyISAM to InnoDB conversion help

Hi Rolando, Thank you for your help. I am on MySQL 5, and I have tried to do the conversion using ALTER TABLE command. With the same very slow result. Do you by any chance have specific suggestions how to tweak variables related to this? Here is what I got

Re: MyISAM to InnoDB conversion help

If you are do this in MySQL 5, try this: ALTER TABLE ENGINE = InnoDB; That's all. Let MySQL worry about conversion. You may also want to tweek the innodb system variables (show variables like 'innodb%) for better InnoDB performance prior to trying this. - Original Message

MyISAM to InnoDB conversion help

Hi everyone, I am hoping to get help with extremely slow performance of MyISAM to InnoDB conversion. Or find out if this type of performance is usual I have MyISAM table that contains - 3,299,509 rows and I am trying to convert it to InnoDB for the use with row-level locking, and I am getting

Re: Data truncated during character set conversion

On Tue, Jul 04, 2006 at 01:55:30PM +0400, Timur Izhbulatov wrote: > After some additional investigations I found the cause. It was some "exotic" > non-ASCII characters like '–' (long dash). At the same time Russian letters > don't cause any problems. Sorry, I was wrong concerning Russian letters.

Re: Data truncated during character set conversion

On Mon, Jul 03, 2006 at 01:55:26PM +0400, Timur Izhbulatov wrote: > I'm following the instructions [1] to convert character set. Unfortunately I > get > warnings about truncated data for some rows in several columns. All the > truncated columns are text type. > > Assuming the `col' column is text

Data truncated during character set conversion

Hi all, I'm following the instructions [1] to convert character set. Unfortunately I get warnings about truncated data for some rows in several columns. All the truncated columns are text type. Assuming the `col' column is text type and actually contains correct utf8 data but has wrong character

RE: XML -> DB Conversion

[snip] I'm currently looking for a tool that will take XML and produce a database from it. Not really looking for anything in particular at this point, just sort of scoping around. Anyone know of such a tool? [/snip] MySQL kinda' has a built-in tool http://dev.mysql.com/tech-resources/arti

XML -> DB Conversion

Hi all, I'm currently looking for a tool that will take XML and produce a database from it. Not really looking for anything in particular at this point, just sort of scoping around. Anyone know of such a tool? -- Chris White PHP Programmer/DB Sloth Interfuel -- MySQL General Mailing List Fo

UTF8 conversion

Having done my upgrade from version 3 to 5, I'm looking forward to the benefits of language support beyond the confines of Western Europe. However, it seems I need to convert the database I have now. We have material in the database at the moment in English, Dutch, Italian, Portuguese and Span

Re: Bulk conversion of 3.23 latin1 to 4.1 utf-8

unicode in the new setup. > -Original Message- > From: [EMAIL PROTECTED] > Sent: Mon, 20 Feb 2006 13:01:20 -0500 > To: [EMAIL PROTECTED] > Subject: Re: Bulk conversion of 3.23 latin1 to 4.1 utf-8 > > I also had problems converting latin1 to utf-8. For whatever reas

Re: Bulk conversion of 3.23 latin1 to 4.1 utf-8

're not running --compatible=[something not mysql]). Hope this helps! -Sheeri On 2/18/06, David Spidley <[EMAIL PROTECTED]> wrote: > > -Original Message- > > From: [EMAIL PROTECTED] > > Sent: Sat, 18 Feb 2006 00:12:19 +0100 > > To: [EMAIL PROTECTED] > >

Re: Bulk conversion of 3.23 latin1 to 4.1 utf-8

> -Original Message- > From: [EMAIL PROTECTED] > Sent: Sat, 18 Feb 2006 00:12:19 +0100 > To: [EMAIL PROTECTED] > Subject: Re: Bulk conversion of 3.23 latin1 to 4.1 utf-8 > > On 17.02.2006 15:34 (+0100), David Spidley wrote: >> What is the official way to tak

Re: Bulk conversion of 3.23 latin1 to 4.1 utf-8

On 17.02.2006 15:34 (+0100), David Spidley wrote: > What is the official way to take this latin1 3.23 dump and load it > into the brand new 4.1 utf-8 database, with the characters being > converted during the load? I'm not sure if the official way will help you. I've tried to copy a 4.0 database (

Bulk conversion of 3.23 latin1 to 4.1 utf-8

Hello, I have a few hundred databases, with lots of tables and data, German and English characters. I'd like to upgrade to 4.1, but am concerned at losing or corrupting data in the process. What is the official way to take this latin1 3.23 dump and load it into the brand new 4.1 utf-8 database

Re: latin1 ->utf8 conversion

Hello. Start from reading this part of the manual: http://dev.mysql.com/doc/refman/5.0/en/charset.html > From my understanding, the database itself never do any conversion, > meaning if you insert utf8 data into tables declared as latin1 it > doesn't really matter if you retrie

latin1 ->utf8 conversion

c" characters, and a few names with accents. I saw somewhere that you can convert to binary before to be sure of keeping things right. From my understanding, the database itself never do any conversion, meaning if you insert utf8 data into tables declared as latin1 it doesn't really matt

Re: Type conversion from Mysql to Oracle

Hi, > First thank all you who replied to my question. I should be more specific > with my question. > > In mysql database table, there is some thing like in the 'create table > syntax': > > fieldname enum('yes','no') default null > > and > > fieldname datetime default null > > I have no idea abo

Re: Type conversion from Mysql to Oracle

Hi, folks First thank all you who replied to my question. I should be more specific with my question. In mysql database table, there is some thing like in the 'create table syntax': fieldname enum('yes','no') default null and fieldname datetime default null I have no idea about the first on

Re: Type conversion from Mysql to Oracle

Hello. In case you want to automate the process of migration have a look here: http://dev.mysql.com/doc/migration-toolkit/en/index.html There is a specific forum as well: http://forums.mysql.com/list.php?61 Xiaobo Chen wrote: > Hi, folks > > I am trying to convert some Mysql database into

Re: Type conversion from Mysql to Oracle

"Xiaobo Chen" <[EMAIL PROTECTED]> wrote on 01/31/2006 09:45:00 AM: > Hi, folks > > I am trying to convert some Mysql database into Oracle. But their types > are not exactly match. Could any one give a hint? > > Thanks in advance! > > Xiaobo > > > -- > Faculty of Computer Science > Dalhousie

Re: Type conversion from Mysql to Oracle

Hi, > I am trying to convert some Mysql database into Oracle. But their types > are not exactly match. Could any one give a hint? What types do you need to convert? Martijn Tonies Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL Server Upscene Productions http://www.upsc

Type conversion from Mysql to Oracle

Hi, folks I am trying to convert some Mysql database into Oracle. But their types are not exactly match. Could any one give a hint? Thanks in advance! Xiaobo -- Faculty of Computer Science Dalhousie University Halifax, Nova Scotia Canada -- MySQL General Mailing List For list archives: htt

Re: Stored Procedure Conversion

Jesse, >VALUES (cFirstName, cLastName, cUserName, cPassword) // error on this line. >return LAST_INSERT_ID() /*@@Identity*/ >END >When I execute this, It bombs on the indicated line stating that there is a >syntax error. A stored procedure cannot return a value. PB - Jesse Castleberry

RE: SQL Statement Conversion

and add "AS CO" following the END of the case statement. -Original Message- From: Jesse Castleberry [mailto:[EMAIL PROTECTED] Sent: Friday, November 04, 2005 3:54 PM To: MySQL List Subject: SQL Statement Conversion I'm converting an application from SQL Server to MySQL. I ha

SQL Statement Conversion

I'm converting an application from SQL Server to MySQL. I have the following query that I need to convert: SELECT A.*, CO = CASE CounselorOnly WHEN 1 THEN 'Yes' WHEN 0 THEN 'No' END FROM Activities a ORDER BY Activity What is the proper syntax for this in MySQL? Thanks, Jesse -- MySQL Genera

Stored Procedure Conversion

I am converting a MS SQL Server ASP application over to use MySQL. I have two simple stored procedures that I need to convert. I have very little experience with MS SQL stored procedures, and none-what-so-ever with stored procedures in MySQL, so I really don't know what this should look like. I'll

RE: Datatype conversion

yes..exactly thats what i am planning to do now. Thank you sujay _ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, October 17, 2005 7:35 PM To: Sujay Koduri Cc: mysql@lists.mysql.com Subject: Re: Datatype conversion Sujay Koduri <[EMAIL PROTECTED]> wrote on

Re: Datatype conversion

actually > holding an integer or decimals. Is this possible to do or i have to manually > do it only. > > Thank you sujay Unless you can somehow extract some additional information about your fields, you will not be able to automate such a conversion. How were you planning to make the

Datatype conversion

hi all, i have a strange problem here. I have around 600 tables in Oracle DB(On 8i, so i am not able to use mysql migration tool kit!!). Now i want move all of these to mysql. I am initially trying to convert the schema from oracle to mysql. My problem is, in the existing oracle DB, for storing b

Re: cast and numeric conversion

Scott Noyes wrote: I've got two columns, one is 'integer' (and store negative value), the other one 'tinyint unsigned' (only > 1 stored in it), when I multiply these columns, quantity with negative value does not show up. (I expect -50*10 to give : -500, but the field stay blank.) I've look a bit

Re: cast and numeric conversion

> I've got two columns, one is 'integer' (and store negative value), the > other one 'tinyint unsigned' (only > 1 stored in it), when I multiply > these columns, quantity with negative value does not show up. > (I expect -50*10 to give : -500, but the field stay blank.) > I've look a bit at the doc

cast and numeric conversion

Hi, I've got two columns, one is 'integer' (and store negative value), the other one 'tinyint unsigned' (only > 1 stored in it), when I multiply these columns, quantity with negative value does not show up. (I expect -50*10 to give : -500, but the field stay blank.) I've look a bit at the docu

RE: free MySQL conversion to MSSQL tool

Sent: Thursday, July 28, 2005 6:13 AM To: [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Subject: Re: free MySQL conversion to MSSQL tool [EMAIL PROTECTED] wrote: > Does anyone know a free tool to convert MySQL to MSSQL > > Thank you > Andrew > > phpMyAdmin (http://www.phpmya

Re: free MySQL conversion to MSSQL tool

[EMAIL PROTECTED] wrote: > Does anyone know a free tool to convert MySQL to MSSQL > > Thank you > Andrew > > phpMyAdmin (http://www.phpmyadmin.net/) version 2.6.3-pl1 has the option to export the data in "mssql" format (and much others). You need a php enabled web server able to connect to you

Re: free MySQL conversion to MSSQL tool

expect? A tool which transforms mysql files on disk > to > mssql files? I don't think this exists and would probably be hardly > possible. > Perhaps there are tools reading from a (mysql) db and writing to another > (mssql) database via a programming language. But conversion of da

Re: free MySQL conversion to MSSQL tool

Perhaps there are tools reading from a (mysql) db and writing to another (mssql) database via a programming language. But conversion of database files? I don't think this exists. Stefan > > Thank you > Andrew -- Stefan Kuhn M. A. Cologne University BioInformatics Center (http://

free MySQL conversion to MSSQL tool

Does anyone know a free tool to convert MySQL to MSSQL Thank you Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: avoiding conversion during insert?

Jacek Becla <[EMAIL PROTECTED]> wrote on 07/21/2005 02:47:20 PM: > Hi, > > Is there a way to insert binary data representing numbers > directly into (preferably MyISAM) table. We are trying to > avoid conversion from ASCII to float/double/int... > > Thanks, >

avoiding conversion during insert?

Hi, Is there a way to insert binary data representing numbers directly into (preferably MyISAM) table. We are trying to avoid conversion from ASCII to float/double/int... Thanks, Jacek -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Oracle to MySQl conversion

Good evening all, I've got an Oracle text dump from a client for conversion to MySQL. Before I dive into SED or Perl does anyone know of a script to convert the dump file? I did the dev site by hand, not much to it, the site is fairly simple. Mostly NUMBER to INT, VARCHAR2 to VARCHAR, and

Re: Premature InnoDB conversion.

A, - Original Message - From: "A Z" <[EMAIL PROTECTED]> Newsgroups: mailing.database.myodbc Sent: Tuesday, February 01, 2005 2:14 PM Subject: Premature InnoDB conversion. MySql 4.0.14 We tried to convert MyISAM table format to INNODB format, it took forever to fi

Premature InnoDB conversion.

MySql 4.0.14 We tried to convert MyISAM table format to INNODB format, it took forever to finish the process, someone intervened and killed the process through Task Manager. Now can't run Mysqld-nt, running it with the --console reports the followings. Your help is appreciated. Microsoft Wind

Re: Date Conversion on Mysql 4.0.2

Minh La wrote: Hi, Can some help me with a date conversion problme that I am having. I have a date data in the following format: 'Month Days Year Hour:Minute AM/PM' Example: 'Aug 21, 2004 2:00 PM' So far the hours that I have spent have been in vain. I tried using str_t

Re: Date Conversion on Mysql 4.0.2

Minh La wrote: So far the hours that I have spent have been in vain. Next time a couple of minutes with the Fine Manual instead? :-) I tried using str_to_date, but it keeps failing. Looks like it's not in version 4.0.2? Quoting the FM: "STR_TO_DATE() is available as of MySQL 4.1.1." FWIW, -- Ha

Date Conversion on Mysql 4.0.2

Hi, Can some help me with a date conversion problme that I am having. I have a date data in the following format: 'Month Days Year Hour:Minute AM/PM' Example: 'Aug 21, 2004 2:00 PM' So far the hours that I have spent have been in vain. I tried using str_to_date, but it k

Re: Data conversion question

Thanks Konrad, Yves On Thu, 23 Dec 2004 23:28:31 +0100, Konrad Kieling <[EMAIL PROTECTED]> wrote: > > Does MySQL have commands that would allow me to convert Base64 data to > > Binary and then convert that Binary to a string format? > have a look at the attached file (hope the attachment did not

Re: Data conversion question

Does MySQL have commands that would allow me to convert Base64 data to Binary and then convert that Binary to a string format? have a look at the attached file (hope the attachment did not get stripped). it contains some udf-functions for base64 en/de-coding. a little description is included. ciao,

Data conversion question

Hello, I was looking throught the manual a bit, I haven't found the answer I'm looking for... Does MySQL have commands that would allow me to convert Base64 data to Binary and then convert that Binary to a string format? Thanks, -- Yves Arsenault -- MySQL General Mailing List For list archiv

Re: Double conversion error

Hello. Update works fine on my 4.1.7-debug-log MySQL instance on Linux. May be you should switch to the latest release. "Berry, Brett C" <[EMAIL PROTECTED]> wrote: > Hello, > > The create table statement is as follows: > > CREATE TABLE `call` ( > `call_id` int(10) unsigned NOT

Re: Double conversion error

Hello, The create table statement is as follows: CREATE TABLE `call` ( `call_id` int(10) unsigned NOT NULL auto_increment, `init_lband` int(10) unsigned NOT NULL default '0', `chan_assign_sec` tinyint(3) unsigned default NULL, `adn_time_sec` tinyint(3) unsigned default NULL, `setup` cha

Re: Double conversion error

Hello. Can you send complete test for your problem (i.e SHOW CREATE TABLE on your tables, buggy sql statement...)? On my 4.1.7 instance of MySQL everything looks fine: mysql> desc v1; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +-

Double conversion error

Title: Double conversion error I have a query where I perform an update "where (CALL_ID = 2.37000e+002);" This query updates nothing, even though my "CALL_ID" column has an id of "237". If I change the end of this query to read: "where (

Re: table conversion problems

Sergei Skarupo wrote: Hi Donny, Thanks for your reply. This table only uses ints and floats, but the floats are allowed to be null, which means, as far as I understand, that it's not a fixed row length... What makes you think that? VARCHAR, TEXT, and BLOB are the variable-length column types

RE: table conversion problems

on [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 6:37 PM To: Sergei Skarupo; 'Mysql List (E-mail)' Subject: RE: table conversion problems Sergei, I don't know much about innodb, but myisam doesn't have a 4 gig limit unless you are using a dynamic type of table.

RE: table conversion problems

ge- > From: Sergei Skarupo [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 26, 2004 8:36 PM > To: Mysql List (E-mail) > Subject: table conversion problems > > Hi all, > > Started a conversion from MyISAM to InnoDB; it's been almost two days and > the statemen

table conversion problems

Hi all, Started a conversion from MyISAM to InnoDB; it's been almost two days and the statement is still executing... The (MyISAM) data table size is almost 4G. There were two reasons for this conversion: to start supporting transactions and to avoid the 4G limit of MyISAM tables;

RE: Date Conversion Function

Message- From: Victor Pendleton [mailto:[EMAIL PROTECTED] Sent: Thursday, July 29, 2004 12:27 PM To: Christopher L. Hood; '[EMAIL PROTECTED] ' Subject: RE: Date Conversion Function I do not know of an MM() date function in MS SQL, only mm used for the date part. What are you att

RE: Date Conversion Function

I do not know of an MM() date function in MS SQL, only mm used for the date part. What are you attempting to accomplish? -Original Message- From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: 7/29/04 11:17 AM Subject: Date Conversion Function M$ SQL server has a function MM that will do

Re: Date Conversion Function

ql.com/doc/mysql/en/Date_and_time_functions.html -- Original message from [EMAIL PROTECTED]: -- > M$ SQL server has a function MM that will do some date conversion, is > there an equivalent in MySQL ?? > -- MySQL General Mailing List For list archives: htt

Date Conversion Function

M$ SQL server has a function MM that will do some date conversion, is there an equivalent in MySQL ?? Chris Hood Investigator Verizon Global Security Operations Center Email: [EMAIL PROTECTED] Desk: 972.399.5900 Verizon Proprietary NOTICE - This message and any attached files may

Re: Display of "?" and Hex conversion

On Fri, Jul 02, 2004 at 01:52:06PM -0500, Boyd E. Hemphill wrote: > We discovered a rather odd situation where some space characters where > being displayed as "?". > > In tracking this down, it was determined that the server had stored the > hex value "A0" rather than "20" by using this query:

Display of "?" and Hex conversion

All: We discovered a rather odd situation where some space characters where being displayed as "?". In tracking this down, it was determined that the server had stored the hex value "A0" rather than "20" by using this query: select LocationId, LevelId, Hex(NameLn),NameLn from Location w

GMT->DST time conversion in (My)SQL ?

 ) FROM table ...    ... This basically works but of course only if the select statement return rows with datetime entries in the year 2004. Eg if there are rows with a datetime field of "2003-xx-xx" then the statement from above will fail. Is there any more general way to do s

Re: Mysql 4.0 -Oracle Stored Procedure Trigger Conversion

Garg, Piyush (EM, GECIS) wrote: Hi Everybody, Is there any way we can tranform the Stores procedure and Triggers present under Oracle Custom Application to mysql. Please tell ways or any tools which can help us rewrite the logic in Mysql. Thanks and regards, Piyush Stored Procedures ar

Mysql 4.0 -Oracle Stored Procedure Trigger Conversion

Hi Everybody, Is there any way we can tranform the Stores procedure and Triggers present under Oracle Custom Application to mysql. Please tell ways or any tools which can help us rewrite the logic in Mysql. Thanks and regards, Piyush -- MySQL General Mailing List For list archives: http://lists

InnoDB Conversion

Hi. I have a query that has been running for 10.7 hours. It is converting a 3.6GB MyISAM to Innodb. 38448 | copy to tmp table | alter table `MESSAGES` type=innodb The innodb data file has increased 8.6GB in size since the command started. How do I tell how far through the conversion the

Re: mySQL SQL Conversion

"Logan McKinley" <[EMAIL PROTECTED]> wrote: > I am using MySQL (4.0.17) and am getting errors with the following SQL > statement originally writen for MS products. > > SELECT > survey_questions.Question_ID, > First(survey_questions.Question_Text) AS FirstOfQuestion_Text, <== this line > returns e

mySQL SQL Conversion

I am using MySQL (4.0.17) and am getting errors with the following SQL statement originally writen for MS products. SELECT survey_questions.Question_ID, First(survey_questions.Question_Text) AS FirstOfQuestion_Text, <== this line returns errors i believe it is the AS Avg(survey_responses.Response)

Re: Automatic conversion from `char` TO `varchar`

OK, this will be my last post on this topic. Mainly I want to point out that I was taking the wrong conclusions from the results of my tests. I followed the advice of Michael Stassen and ran some more tests using int columns for joins and got pretty much the same trend. So I guess the real answer i

Re: Stability of MyISAM-Ststis vs. Dynamic - (was: Automatic conversion from `char` TO `varchar`)

PROTECTED]> Sent: Monday, February 09, 2004 10:01 AM Subject: Stability of MyISAM-Ststis vs. Dynamic - (was: Automatic conversion from `char` TO `varchar`) As to the discussion about char vs. varchar fields, I am now into a problem which is near by the above one: We are about to design a new data

Stability of MyISAM-Ststis vs. Dynamic - (was: Automatic conversion from `char` TO `varchar`)

conversion by dumping data and structure, removing the table, changing the fields and then inserting structure and data again. * Is there another way to do this ? * Has anybody ever had to rebuild a corrupted table, and is rebuiling a static table really easier for software than rebuilding a dynamic

Re: Automatic conversion from `char` TO `varchar`

MySQL 4.1.1a on Win32). I setup > a > > webpage with my sample code (VB) so that you can run > the > > test yourself: > > > > http://au.geocities.com/m_fagan/VARCHARvsCHAR.html > > > > The results were that table join on CHAR-CHAR was about > 15% &g

Re: Automatic conversion from `char` TO `varchar`

R. Does anyone know how to stop the auto-conversion of CHAR to VARCHAR ? - Original Message - From: "Hassan Shaikh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Saturday, January 10, 2004 7:06 AM Subject: Automatic conversion from `cha

Re: Automatic conversion from `char` TO `varchar`

.html The results were that table join on CHAR-CHAR was about 15% faster than join on VARCHAR-VARCHAR. Does anyone know how to stop the auto-conversion of CHAR to VARCHAR ? - Original Message - From: "Hassan Shaikh" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EM

LONGBLOB datatype conversion to text

Does anyone know of a function to employ when retrieving a LONGBLOB column - Im creating an ad hoc query and would like to see the data in text format.

  1   2   3   >