- Original Message -
> From: "Simon Fromme" <fro...@tralios.de>
> 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 a
idn'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/identifier-mappi
) 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 that the bare d is made
character string. But it seems that instead TIME(d), a character string, is
converted to some timestamp, a date. I wrote that I believe
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
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 :|
My
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
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 my.li...@mac.com wrote:
Hi, I just tried this on a
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
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 convert
uddin Ahmed Farooqui [EMAIL PROTECTED]
To: mysql@lists.mysql.com
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 one cms (Vivvo) to another (Drupal
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 TIMESTAMP
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/5.0/en/type-conversion.html states
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
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
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 expected
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
May 2007 12:08:11
To:MySQL General mysql@lists.mysql.com
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'
I need to grab this and include it in an insert sql that puts that value
in a table
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
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 mysql@lists.mysql.com
Subject: string to timestamp conversion
I have a table
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 17 09
To: 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
/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 / conversion path:
1
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
If you are do this in MySQL 5, try this:
ALTER TABLE table-name 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
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
-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 variables
related
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_buffer_pool_size (Default
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
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 type
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.
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
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
[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
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
--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]
Subject: Re: Bulk conversion of 3.23 latin1 to 4.1 utf-8
On 17.02.2006
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 reason,
accents and stuff did not convert
-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 take this latin1 3.23 dump and load
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
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
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
matter if you retrieve the data as utf8
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 retrieve the data as utf8
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:
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
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 University
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
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
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 about the first
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
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
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 have the
following query that I need to convert
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
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
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 decision by hand? You could probably write something
to dump your Oracle
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 10/17
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
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
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
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]
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://www.cubic.uni-koeln.de
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 database
files? I don't think this exists.
Stefan
[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 your mysql
: 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.phpmyadmin.net/) version 2.6.3-pl1 has
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,
Jacek
--
MySQL General Mailing List
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
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 CLOB
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 finish the process, someone
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
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 keeps failing.
Looks
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,
--
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_to_date, but it keeps
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 get
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
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.
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 NULL
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`
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 |
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 (CALL_ID = 237);, then the row with CALL_ID=237
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
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
:[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 statement is still executing...
The (MyISAM) data table size is almost 4G. There were
:[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. If you are using a fixed table
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 attempting
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
/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: http://lists.mysql.com/mysql
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
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
where
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:
'A0' is
...
...
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 such a timezone conversion or is the only
solution
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:
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
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
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 errors i
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)
this 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
, 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 database with high importance to stability
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
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]; [EMAIL PROTECTED]
Sent: Saturday, January
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 `char` TO `varchar`
Hi,
It's really strange but when I execute
-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 `char` TO `varchar`
Hi,
It's really strange but when I execute
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 - 100 of 224 matches
Mail list logo