RE: converting numeric to date-time?

2014/09/04 08:40 -0700, Jan Steinman > From: "Ed Mierzwa (emierzwa)" > > > FROM_UNIXTIME(1409304102.153) /*your epoch column here*/ I don't think the OP has a Unix timestamp. The number looks suspeciously like concatenation of date digits, "140930" at the beginning looks like Septem

Re: converting numeric to date-time?

- Original Message - > From: "Jan Steinman" > Subject: RE: converting numeric to date-time? > > I don't think the OP has a Unix timestamp. OP explicitly says "epoch including milliseconds" - so it's going to be three digits too long :-) divide

Re: converting numeric to date-time?

> From: Jan Steinman >To: mysql@lists.mysql.com >Sent: Thursday, 4 September 2014, 16:40 >Subject: RE: converting numeric to date-time? > > >> From: "Ed Mierzwa (emierzwa)" >> >> >> FROM_UNIXTIME(1409304102.153)/*your epoch column

RE: converting numeric to date-time?

> From: "Ed Mierzwa (emierzwa)" > > > FROM_UNIXTIME(1409304102.153) /*your epoch column here*/ I don't think the OP has a Unix timestamp. The number looks suspeciously like concatenation of date digits, "140930" at the beginning looks like September 30, 2014. If that's the case, you need to

RE: converting numeric to date-time?

mber 01, 2014 5:51 PM To: Rajeev Prasad Cc: MYSQL General List Subject: Re: converting numeric to date-time? * Rajeev Prasad [2014-09-01 17:55]: > I have a column in a table which is epoch time including milliseconds. > > e.g. = 1409304102153 > > > now i want to display all

Re: converting numeric to date-time?

* Rajeev Prasad [2014-09-01 17:55]: > I have a column in a table which is epoch time including milliseconds. > > e.g. = 1409304102153 > > > now i want to display all fields in the table but this field as: "2014-8-29 > Fri 09:21:42: GMT" (whatever comes in ) > > > and i am not findi

RE: Converting Mysql to mysql cluster

> -Original Message- > From: Kevin Peterson [mailto:qh.res...@gmail.com] > Sent: 27 March 2013 06:58 > To: mysql@lists.mysql.com > Subject: Converting Mysql to mysql cluster > > Hi, > > My site is using mysql and PHP, now for the scale purpose want to > introduce mysql-cluster. Few que

Re: Converting Microsoft SQL database to MySQL

- Original Message - > From: "Halász Sándor" > > noting that MySQL does not really support CSV: one can set all Not *entirely* accurate: MySQL does include a CSV engine that you can use in the same way you would use InnoDB or any other engine. If you create a table a with engine=CSV a

Re: Converting Microsoft SQL database to MySQL

I would appreciate the help if anyone could share what tools will you recommend of converting SQL database to MySQL. The Data Wizard for MySQL software by SQL Maestro Group includes a powerful Data Pump tool that can transfer schema and data from any DBMS to MySQL: http://www.sqlmaestro.com/pro

Re: Converting Microsoft SQL database to MySQL

2012/01/30 15:06 +0800, James I am involved in a project to migrate our entire database from Microsoft SQL to MySQL. I would appreciate the help if anyone could share what tools will you recommend of converting SQL database to MySQL. If it is SQL server, maybe dumping in charact

Re: Converting Microsoft SQL database to MySQL

Thanks Carl. I found a tool called Full Convert that did conversion (small database only) from MSSQL to MySQL. I tried to test their Trial version and it converts completely with similar structure, fields, etc.. Because it's trial version, some more than 5

Re: Converting Microsoft SQL database to MySQL

I do this quite frequently. In our case, we are converting competitors data so the process is to use Navicat (premium) to bring the data from MSSQL to MySQL (in the same fields, etc.) and then use a program to convert it into our format so it will run on our system. The only thing I have had t

Re: Converting INNODB to file-per-table?

Hi, You can convert the tables themselves semi-online. Just do set global innodb_file_per_table=1; and no a no-operation alter on each table with alter table tablename engine=innodb; Note that the global variable is just a default, the currently connectd threads will use the shared tablespace

Re: Converting INNODB to file-per-table?

Thanks, Rolando! It's kind of a scary procedure (dump, drop, reload) that involves significant down-time, but I guess it's necessary. On 11 Feb 11, at 10:24, Rolando Edwards wrote: > I wrote an article in www.stackoverflow.com about how to convert absolutely > every InnoDB table to .ibd and pe

RE: Converting INNODB to file-per-table?

I wrote an article in www.stackoverflow.com about how to convert absolutely every InnoDB table to .ibd and permanently shrink the ibdata1 file http://stackoverflow.com/questions/3927690/howto-clean-a-mysql-innodb-storage-engine/4056261#4056261 Enjoy !!! Rolando A. Edwards MySQL DBA (SCMDBA) 1

Re: Converting INNODB to file-per-table?

Dump the entire DB, drop the DB, restore the DB. On Fri, Feb 11, 2011 at 11:53 AM, Jan Steinman wrote: > Our incremental backups seem to be filling with instances of ib_logfile1, > ib_logfile2, and ibdata1. > > I know that changing a single byte in a single INNODB table causes these > files to b

Re: Converting String to Text in mysql

You can do some trickery with auto increment fields and multiple-column indexes. Have a look at http://www.bitbybit.dk/carsten/blog/?p=131 Beware that this is apparently a MyISAM-specific trick. / Carsten On Tue, 6 Apr 2010 16:02:48 +0530, "Suryanarayanan" wrote: > I am new to mysql a

RE: Converting MyISAM to InnoDB

If you have a column defined as auto_increment, there must be a key on it. This is true both in myisam and innodb. If you need further help, please show us the full structure of the real table you're operating on (not the one from your sandbox), the statement you run, and the error message. R

Re: converting non-materialized view to a table?

At 04:55 PM 1/14/2010, Jacek Becla wrote: Hello, I need to convert a non-materialized MySQL view to a MySQL table. Are there any tools to do that? Thanks, Jacek Jacek, Can't you just do a: create table mytable select * from myview; ??? Mike -- MySQL General Mailing List For list arc

Re: converting some rows from utf-8 to iso-8859-1

yep, thru php it's easy: just do a utf8_decode($value). but is it possible directly from the mysql command line. On 31/08/2007, Ken Peng <[EMAIL PROTECTED]> wrote: > > On Thu, 30 Aug 2007 11:41:14 +0200, "Olav Mørkrid" > <[EMAIL PROTECTED]> said: > > if a table column is supposed to contain text i

Re: converting some rows from utf-8 to iso-8859-1

On Thu, 30 Aug 2007 11:41:14 +0200, "Olav Mørkrid" <[EMAIL PROTECTED]> said: > if a table column is supposed to contain text in iso-8859-1, but utf-8 > encoding have snuck in on a few rows by mistake, how are these rows > converted into iso-8859-1? > > what i am looking for is something like this

Re: Converting a field or converting a date?

In the last episode (Dec 05), Nstor said: > I am not very savy with SQL and I need help. I have a char field > that contains a date and the date is in DD-MM- and I want to sort > it but the sort is wrong because 01-04-2007 comes out before > 10-22-2006. > > Is there an easy way to provide a c

Re: Converting TEXT to BLOB with special chars

At 14:16 +0200 18/7/06, Mike van Hoof wrote: And for the everything in utf8... will try this next time i get this kind of a problem... When you do, you'll need to send out the proper header from your php scripts: header ('Content-type: text/html; charset="UTF-8"'); and put this in your MySQL c

Re: Converting TEXT to BLOB with special chars

Chris Sansom schreef: At 13:40 +0200 18/7/06, Mike van Hoof wrote: Well.. gonna try some text-converting in php then... And yeah, it really needs to be a blob field... not my choice, but we got a CMS which operates on field types from MySQL... and a blob field wil generate an WYSIWYG field...

Re: Converting TEXT to BLOB with special chars

At 13:40 +0200 18/7/06, Mike van Hoof wrote: Well.. gonna try some text-converting in php then... And yeah, it really needs to be a blob field... not my choice, but we got a CMS which operates on field types from MySQL... and a blob field wil generate an WYSIWYG field... but i think i am going

Re: Converting TEXT to BLOB with special chars

Addison, Mark schreef: From: Mike van Hoof Sent: 18 July 2006 12:18 To: Addison, Mark Subject: Re: Converting TEXT to BLOB with special chars Addison, Mark schreef: From: Mike van Hoof Sent: 18 July 2006 10:49 Hello, I am having a

RE: Converting TEXT to BLOB with special chars

From: Mike van Hoof Sent: 18 July 2006 12:18 > To: Addison, Mark > Subject: Re: Converting TEXT to BLOB with special chars > > Addison, Mark schreef: > > From: Mike van Hoof Sent: 18 July 2006 10:49 > > > Hello, >

RE: Converting TEXT to BLOB with special chars

From: Mike van Hoof Sent: 18 July 2006 10:49 > > Hello, > > I am having a problem, and am hoping this is the wright list > to post to. > > I have a TEXT field with text in them (duh!)... this text > also contains > special characters like é ß ü etc... > But when i convert the TEXT field to a

Re: Converting string hex column to integer

Wolfram Kraus napsal(a): On 28.06.2006 13:54, Dušan Pavlica wrote: Hello, I have column of type char(2) containing hex numbers (e.g. "0A", "FF", ...) and I cannot find correct function which could convert those hex numbers to integers so I can perform futher calculations. I experimented with

Re: Converting string hex column to integer

On 28.06.2006 13:54, Dušan Pavlica wrote: > Hello, > I have column of type char(2) containing hex numbers (e.g. "0A", "FF", > ...) and I cannot find correct function which could convert those hex > numbers to integers so I can perform futher calculations. I experimented > with HEX(), CAST(), CONVER

Re: Converting varchar field into primary key

- Original Message - From: "gerald_clark" <[EMAIL PROTECTED]> To: "Jonathan Mangin" <[EMAIL PROTECTED]> Cc: Sent: Tuesday, May 16, 2006 3:08 PM Subject: Re: Converting varchar field into primary key > Jonathan Mangin wrote: > > >>>

Re: Converting varchar field into primary key

Jonathan Mangin wrote: I'm creating a new MySQL database from an existing Filemaker db. My problem is that some of the existing 'numbers' in one column (it was a text field in FMP) have leading zeros. eg: 003, 0007, 012, 001234. I need to maintain these numbers 'as is' - complete with zer

Re: Converting varchar field into primary key

> > > I'm creating a new MySQL database from an existing Filemaker db. > > > > > > My problem is that some of the existing 'numbers' in one column (it > > > was a text field in FMP) have leading zeros. eg: 003, 0007, 012, > > > 001234. I need to maintain these numbers 'as is' - complete with

Re: Converting varchar field into primary key

> > I'm creating a new MySQL database from an existing Filemaker db. > > > > My problem is that some of the existing 'numbers' in one column (it > > was a text field in FMP) have leading zeros. eg: 003, 0007, 012, > > 001234. I need to maintain these numbers 'as is' - complete with > > zeros

Re: Converting varchar field into primary key

> I'm creating a new MySQL database from an existing Filemaker db. > > My problem is that some of the existing 'numbers' in one column (it > was a text field in FMP) have leading zeros. eg: 003, 0007, 012, > 001234. I need to maintain these numbers 'as is' - complete with > zeros. I've tried

Re: Converting password to old format.

Sorry, I have no idea about that :) Eugene Kosov wrote: Yes I know restoring plain password from it's hash is impossible (at least in theory ;)) but I don't need password itself. I thought if we know f1(x) (PASSWORD) and f2(x) (OLD_PASSWORD) we possibly can get such f(x) that will make exp

Re: Converting password to old format.

Yes I know restoring plain password from it's hash is impossible (at least in theory ;)) but I don't need password itself. I thought if we know f1(x) (PASSWORD) and f2(x) (OLD_PASSWORD) we possibly can get such f(x) that will make expression f2(x) = f(f1(x)) truth for every x. I haven't any

Re: Converting password to old format.

AFAIK, PASSWORD() or OLD_PASSWORD() is one way function, it means in math if you do f(x) = y, you never know x, all you now is the result of f(x) ~ y Moreover, do you have a problem with new password format? Eugene Kosov wrote: Hi, everyone! I have transfer user's database and grants from

Re: Converting password to old format.

Eugene Kosov <[EMAIL PROTECTED]> wrote on 03/23/2006 07:03:15 AM: > Hi, everyone! > > I have transfer user's database and grants from one mysql server > (4.1.15) to an older one (4.0.26). I don't know user's password and have > only it's hash. How can I convert hashed password stored in > mys

RE: Converting database and its tables to UTF-8

: Gabriel PREDA [mailto:[EMAIL PROTECTED] Sent: Tuesday, February 14, 2006 6:30 PM To: mysql@lists.mysql.com Cc: Peter Lauri Subject: Re: Converting database and its tables to UTF-8 Hi Peter, That will be a lot of work ! 1. First make a back-up... it's always a good ideea ! 2. For every

Re: Converting database and its tables to UTF-8

Hi Peter, That will be a lot of work ! *1.* First make a back-up... it's always a good ideea ! *2.* For every table in the database alter String Types into BINARY string types that means: - *(VAR)CHAR(M)* will become *(VAR)**CHAR(M) BINARY* or *(VAR)**BINARY(M)* - *TINYTEXT, TEXT, MEDIUMTEXT,

Re: Converting decimal to binary

Actually please ignore my previous question. I just had a brain cramp. Thanks >>> "Ed Reed" <[EMAIL PROTECTED]> 1/18/06 11:34:11 AM >>> Can you (or anyone else) explain to me how, or point me somewhere that I can learn how this works? I'd really like to know more about how bitwise arithmetic

Re: Converting decimal to binary

Can you (or anyone else) explain to me how, or point me somewhere that I can learn how this works? I'd really like to know more about how bitwise arithmetic works. Thanks >>> Francesco Riosa <[EMAIL PROTECTED]> 1/10/06 4:58:47 PM >>> Francesco Riosa wrote: > And another one is (in inverse orde

Re: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam

Francesco Riosa wrote: > And another one is (in inverse order for laziness): > > select > (8 & 1) AS `0` > , (8 & 2 > 1) AS `1` > , (8 & 4 > 1) AS `2` > , (8 & 8 > 1) AS `3` > , (8 & 16 > 1) AS `4` > , (8 & 32 > 1) AS `5` > , (8 & 64 > 1) AS `6` > , (8 & 128 > 1) AS `7` > ; > but this one look

Re: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam

> > > > >>>> "Gordon Bruce" < [EMAIL PROTECTED] > 1/10/06 1:44 PM >>> >>>> > Actually CONV converts from any base to any base so if it is base 10 > then just replace the 16's with 10's. > > Too much ti

RE: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam

n just replace the 16's with 10's. Too much time looking at dump's. -Original Message- From: Bill Dodson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 3:09 PM To: Gordon Bruce Cc: Ed Reed; mysql@lists.mysql.com Subject: [SPAM] - Re: Converting decimal to

RE: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam

t;> Actually CONV converts from any base to any base so if it is base 10 then just replace the 16's with 10's. Too much time looking at dump's. -Original Message- From: Bill Dodson [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 10, 2006 3:09 PM To: Gordon Bruce Cc: Ed

RE: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam

Ed Reed; mysql@lists.mysql.com Subject: [SPAM] - Re: Converting decimal to binary - Bayesian Filter detected spam If you really do mean decimal (base 10) you could use Gordon's solution like this: SELECT MID(CONV(HEX(245),16,2),1,1) AS `7`, MID(CONV(HEX(245),16,2),2,1) AS `6`, MID(CONV(HEX(245),16

Re: Converting decimal to binary

If you really do mean decimal (base 10) you could use Gordon's solution like this: SELECT MID(CONV(HEX(245),16,2),1,1) AS `7`, MID(CONV(HEX(245),16,2),2,1) AS `6`, MID(CONV(HEX(245),16,2),3,1) AS `5`, MID(CONV(HEX(245),16,2),4,1) AS `4`, MID(CONV(HEX(245),16,2),5,1) AS `3`, MID(CONV(HEX(245),16,

RE: Converting decimal to binary

If by Decimal you mesn HEXIDECIMAL you can use CONV where the 1st arg is the HEX value, 2nd arg is From Base and 3rd arg is To Base. You will have to suround the aliases with "`'s" if you really want the names to be numeric. mysql> select MID(CONV('A5',16,2),1,1) AS `7`, ->MID(C

Re: Converting table to InnoDB

Jonathan Chong wrote: I have a table on my forum that's frequently accessing with reads and writes. On a busy day, the table is locked when people are posting messages and the page hangs when you try to read a topic. Is it worth me converting the table to InnoDB, as I've heard that InnoDB doesn'

Re: converting access (.mdb) files...

If you can catch hold of a windows box then there is tool called SQLyog that has a great migration tool. I was able to import a clients MDB database with all the FKs directly from Access to MySQL. You dont need to go thru Access -> Script -> MySQL. You can download it from http://www.webyog.com

Re: converting access (.mdb) files...

Perhaps you could try "MySQL Migration Toolkit" http://dev.mysql.com/downloads/migration-toolkit/1.0.html still beta though... NB! ATTENTION: Before installing the MySQL Migration Toolkit please download and install the Java 5.0 or 1.4.2 Runtime Environment (JRE) from http://java.sun.com NOTI

Re: converting access (.mdb) files...

Craig Hoffman wrote: Anyone know a way to convert MS Access DB files (.mdb) into a format MySQL can import? I'm on a Mac hence I don't have Access. mdbtools: http://mdbtools.sourceforge.net/ -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Au

Re: converting access (.mdb) files...

There used to be a program called "AccessDump" that will dump access tables into .sql files. Their website seems to be unresponsive at the moment, though. Here's a link: www.AccessDump.com They are from the south, so it's possible that the site was affected by the hurricane. Jenifer -

RE: Converting to InnoDB?

On Mon, 25 Apr 2005, mathias fatene wrote: Sorry, Alter table toto ENGINE=innodb. You don't must, you can. You can also have differents storage ENGINES in the same mysql database. With innodb, you will earn ROW level locking. Best Regards Mathias FATENE Thanks, Mathias! Carl Ca

RE: Converting to InnoDB?

nswer -Original Message- From: mathias fatene [mailto:[EMAIL PROTECTED] Sent: lundi 25 avril 2005 19:33 To: 'Carl Riches'; 'mysql@lists.mysql.com' Subject: RE: Converting to InnoDB? Yes, but your myIsam Tables stay myisam ones. After restarting, you must change t

RE: Converting to InnoDB?

Yes, but your myIsam Tables stay myisam ones. After restarting, you must change them to innodb by : Alter table toto storage=innodb. For new tables, they will have innodb storage. Best Regards Mathias FATENE Hope that helps *This not an official mysql support answer -

Re: Converting Integer values to date type

Mahmoud Badreddine wrote: I got it working , thank you. I only could do what I wanted to do in multisteps however. I couldn't figure out the nested querying , and it's bugging me. Here's how I issued it. mysql> update tableDummy set newDate=(select str_to_date('(concat(DayVal,".",MonthVal,".",YearV

Re: Converting Integer values to date type

I got it working , thank you. I only could do what I wanted to do in multisteps however. I couldn't figure out the nested querying , and it's bugging me. Here's how I issued it. mysql> update tableDummy set newDate=(select str_to_date('(concat(DayVal,".",MonthVal,".",YearVal))','%d.%m.%Y')); And a

Re: Converting Integer values to date type

In the last episode (Mar 18), Mahmoud Badreddine said: > Hello, > I have a table with separate integer values for the day, month and year. > I would like to group them all under one field of type date. > I tried a few commands but I haven't captured the right syntax yet. > > so if the field names

Re: Converting Text columns from mysql 4.0 to 4.1

Hello. Please send us an output of the following statement: SHOW VARIABLES LIKE '%char%'; See: http://dev.mysql.com/doc/mysql/en/charset-conversion.html Bruce Dembecki <[EMAIL PROTECTED]> wrote: > Hi! We have a problem converting our 4.0 text columns from a Hong Kong > database

Re: converting to Innodb.

Fredrik Carlsson wrote: Hi list, I have a question regarding mysql and innodb. My current setup uses myisam and the db size is about 1.6 GB with two table that each have about 500k rows. I perform alot of fulltext search on these tables and they can sometimes take along time to finish and when t

Re: converting to Innodb.

Roger Baklund wrote: Fredrik Carlsson wrote: Hi list, I have a question regarding mysql and innodb. My current setup uses myisam and the db size is about 1.6 GB with two table that each have about 500k rows. I perform alot of fulltext search on these tables and they can sometimes take along time

Re: converting to Innodb.

Fredrik Carlsson wrote: Hi list, I have a question regarding mysql and innodb. My current setup uses myisam and the db size is about 1.6 GB with two table that each have about 500k rows. I perform alot of fulltext search on these tables and they can sometimes take along time to finish and when t

Re: Converting table type

> At 11:06 -0500 10/30/04, Michael Satterwhite wrote: > >On Saturday 30 October 2004 10:58 am, Paul DuBois wrote: > >> > >> What output does the following statement produce? > >> > >> SHOW VARIABLES LIKE 'have_innodb'; > >> > >> If YES, the ALTER TABLE statement should have worked. > >> If N

Re: Converting table type

Hi. I think you should upgrade to MySQL 4.0.22. Michael Satterwhite <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding quoted-printable, charset: us-ascii, 23 lines --] > > I'm running MySQL 4.0.21 > > In order to use Foreign Keys, I'm trying to convert a table Type to INNODB. I >

Re: Converting table type

At 11:06 -0500 10/30/04, Michael Satterwhite wrote: On Saturday 30 October 2004 10:58 am, Paul DuBois wrote: What output does the following statement produce? SHOW VARIABLES LIKE 'have_innodb'; If YES, the ALTER TABLE statement should have worked. If NO, your server doesn't have InnoDB support

Re: Converting table type

On Saturday 30 October 2004 10:58 am, Paul DuBois wrote: > > What output does the following statement produce? > > SHOW VARIABLES LIKE 'have_innodb'; > > If YES, the ALTER TABLE statement should have worked. > If NO, your server doesn't have InnoDB support built in. > If DISABLED, your server suppo

Re: Converting table type

At 9:24 -0500 10/30/04, Michael Satterwhite wrote: I'm running MySQL 4.0.21 In order to use Foreign Keys, I'm trying to convert a table Type to INNODB. I issue a statement of the form Alter Table TblName Type=INNODB; This statement appears to execute correctly. I would expect this to affect the Sh

Re: Converting table type

Michael, All your e-mails come as an attachment in my mailbox instead of plain e-mail. >> Why not simply recreate it with the InnoDB table type? >> >> If there's data in it, rename the old table, recreate the >> table and pump the data. >> >> All done! > >Certainly that *COULD* be done, but it sh

Re: Converting table type

On Saturday 30 October 2004 09:35 am, Martijn Tonies wrote: > Why not simply recreate it with the InnoDB table type? > > If there's data in it, rename the old table, recreate the > table and pump the data. > > All done! Certainly that *COULD* be done, but it shouldn't be necessary (according to t

Re: Converting table type

Why not simply recreate it with the InnoDB table type? If there's data in it, rename the old table, recreate the table and pump the data. All done! With regards, Martijn Tonies Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL Server. Upscene Productions http://www.ups

Re: Converting date in MySQL

On Thursday 14 October 2004 04:00 pm, Mike Johnson wrote: > It does matter, though. You can't use DATE_FORMAT() to translate > '10/14/2004' into '2004-10-14.' No, your right, that would be wrong. > It looks like what the poster wants is STR_TO_DATE() (a la > STR_TO_DATE('10/14/2004', '%m/%d/%Y'),

RE: Converting date in MySQL

From: Jeff Smelser [mailto:[EMAIL PROTECTED] > On Thursday 14 October 2004 03:35 pm, Stuart Felenstein wrote: > > No :),. cause it seems that those formats are for > > outbound, db ->. > > I was looking for the other direction. > > Huh? It really doesnt matter does it? They work either way.. >

Re: Converting date in MySQL

On Thursday 14 October 2004 03:46 pm, [EMAIL PROTECTED] wrote: > For values headed into a SQL statement, use whatever functions are > available to you in the language (PHP, PERL, Python, Java, VB Script,...) > you are using to accept the user's input in order to make the commands you > send MySQL c

Re: Converting date in MySQL

For values headed into a SQL statement, use whatever functions are available to you in the language (PHP, PERL, Python, Java, VB Script,...) you are using to accept the user's input in order to make the commands you send MySQL correct. You just need to convert the date into "-MM-DD hh:nn:s

Re: Converting date in MySQL

On Thursday 14 October 2004 03:35 pm, Stuart Felenstein wrote: > No :),. cause it seems that those formats are for > outbound, db ->. > I was looking for the other direction. Huh? It really doesnt matter does it? They work either way.. I use those functions all the time for inbound.. Jeff pgps

Re: Converting date in MySQL

No :),. cause it seems that those formats are for outbound, db ->. I was looking for the other direction. Stuart --- Jeff Smelser <[EMAIL PROTECTED]> wrote: > On Thursday 14 October 2004 03:12 pm, Stuart > Felenstein wrote: > > Thanks , I know the page and have the links > > bookmarked! > > So y

Re: Converting date in MySQL

On Thursday 14 October 2004 03:12 pm, Stuart Felenstein wrote: > Thanks , I know the page and have the links > bookmarked! So you got the answer from it right? Jeff pgpSsmcBOJscM.pgp Description: PGP signature

Re: Converting date in MySQL

Thanks , I know the page and have the links bookmarked! Stuart --- Jeff Smelser <[EMAIL PROTECTED]> wrote: > On Thursday 14 October 2004 02:45 pm, Stuart > Felenstein wrote: > > > Apparently, mysql does not like the format > > "MM/DD/" > > Then again I tried it around , still no dice. > > I

Re: Converting date in MySQL

On Thursday 14 October 2004 02:45 pm, Stuart Felenstein wrote: > Apparently, mysql does not like the format > "MM/DD/" > Then again I tried it around , still no dice. > It's intended to go into a Date" column. http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html All, you every need

Re: converting timestamps to US Date format

> > > Hi there, > > > > I am having trouble converting a timestamp from mySQL to the US Format > > mm/dd/. Can someone please help. I am also having trouble > > converting -mm-dd into a normal mm/dd/ format as well. A bit off-topic but, if you are able to use Perl anytime during

Re: converting timestamps to US Date format

Gary: Am I looking at PHP's "date()" function? You are taking a timestamp from a MySQL table and wanting to convert it into a US format. Is the timestamp stored in your MySQL table a Unix timestamp or a MySQL timestamp? It's important to note that you can't take a MySQL timestamp and use PHP's

Re: converting timestamps to US Date format

Gary Mack wrote: Hi there, I am having trouble converting a timestamp from mySQL to the US Format mm/dd/. Can someone please help. I am also having trouble converting -mm-dd into a normal mm/dd/ format as well. Normal format *is* -mm-dd. I am using the following line of code: d

Re: converting timestamps to US Date format

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Monday 05 July 2004 06:07 pm, Gary Mack wrote: > Hi there, > > I am having trouble converting a timestamp from mySQL to the US Format > mm/dd/. Can someone please help. I am also having trouble converting > -mm-dd into a normal mm/dd/

Re: Converting table types

Greg Macek <[EMAIL PROTECTED]> wrote: > I was wondering what happens when you change table types. Does MySQL > automatically get rid of the old table files? Yes, MyISAM files are deleted. As for converting InnoDB -> MyISAM, then of course, InnoDB tablespace is not deleted, but freed. --

Re: Converting a different database to mysql

Hello, If the db has an ODBC driver then you can try SQLyog from www.webyog.com Karam --- Glenn McCord <[EMAIL PROTECTED]> wrote: > Gidday. Is there anyway to convert an Advanced > Revelations/Open Insight > database into a mySQL database. > > Cheers, > Glenn > > -- > MySQL General Mailing Li

Re: Converting to Percentages

Hi all I have a legacy table to convert where the schema has changed. originally the primary key was a multi field key, keyed by a customer id and then within each customer, numbers 1,2,3... etc. cust no 1 1 1 2 2 1 2 2 . . 4323433 1 4323433 2 4323433

Re: Converting to Percentages

David Blomstrom wrote: --- Roger Baklund <[EMAIL PROTECTED]> wrote: use test; Yikes - you lost me on the second word! Are you talking about the sort of "test" that's described on this page?: http://dev.mysql.com/doc/mysql/en/running_mysqltest.html No. "use test" tells mysql to work in the test d

Re: Converting to Percentages

--- Roger Baklund <[EMAIL PROTECTED]> wrote: > use test; Yikes - you lost me on the second word! Are you talking about the sort of "test" that's described on this page?: http://dev.mysql.com/doc/mysql/en/running_mysqltest.html > create table pct (red int,blue int,gray int); > insert into pct v

Re: Converting to Percentages

* David Blomstrom > Suppose you have a table with four columns. The first > three colums each list a numeral, and the fourth > column lists the sum of those numerals, like this: > > 3 | 3 | 4 | 10 > 10 | 10 | 5 | 25 > > Now, suppose you wanted to also display those numerals > as percentages: > > Re

Re: Converting tables to innoDB

At 18:43 -0400 4/21/04, Brad Tilley wrote: Hello Mysqlers, I have a few small DB's (less than 10,000 entries per table) that track computer inventory in a mid-sized organization. Currently, all of the tables are MyISAM. Is there any compelling reason to convert these to InnoDB? We're not having an

RE: Converting tables to innoDB

No, there is no reason to covert them to INNODB unless you want an ACID compliant table format, and have disk space to spare. MYISAM support a wide variety of mySQL featured, such as full text searches, a key buffer, and a few other nice things such as a being able to get a row count in ms time.

Re: Converting from MS SQL Server to MySQL

Hi, > I am sure conversion questions are asked a lot, I need to move what is a MS > SQL Server database to a MySQL database, both table stuctures, data, and a > web application with a very large number of queries. > > I am looking for any advice on this undertaking, things to be mindful of and > s

RE: Converting from MS SQL Server to MySQL

The *best* way to do this is via conversion software. I find that for table creation and data transfer, http://dbtools.com.br has the best free tool. It converts all your Access and SQL based databases over to MySQL without any hitches. Really good help files and web site as well. Intelligent Conv

Re: Converting an Access Table to MySQL

Victor, It's at the same URL www.mysqlfront.de I'm not sure it's stable yet Subject: Re: Converting an Access Table to MySQL From: Victor Medina <[EMAIL PROTECTED]> To: zzapper <[EMAIL PROTECTED]> Copies to:

Re: Converting an Access Table to MySQL

thanxss! :) On Fri, 2004-01-09 at 12:04, zzapper wrote: > On Fri, 09 Jan 2004 11:48:42 -0400, Victor Medina <[EMAIL PROTECTED]> > wrote: > > > > > > >hey hey hey! wait a second there! is there a new mysqlfront? :o where > >can i download it? :) 3.0??? I already love and worship mysq

Re: Converting an Access Table to MySQL

On Fri, 09 Jan 2004 11:48:42 -0400, Victor Medina <[EMAIL PROTECTED]> wrote: > >hey hey hey! wait a second there! is there a new mysqlfront? :o where >can i download it? :) 3.0??? I already love and worship mysqlfront 2.5, >i thought it was dead :( >do you have a link? Victor, It's at the same

Re: Converting an Access Table to MySQL

On Fri, 2004-01-09 at 11:44, zzapper wrote: > On Fri, 9 Jan 2004 20:40:44 +0530, "Nitin Mehta" > <[EMAIL PROTECTED]> wrote: > > >you need not write any scripts, just use MySQL Front to Import/Export dat from M$ > >Access > > Are you using MySqlfront2.5 (the original) or the new 3.x? > > BTW I

  1   2   3   >