On Sat, 18 Feb 2017, debt wrote:
How does one "grab" the existing data and then change it? Can this
be done solely in MySQL
I am not sure to understand your question ... you usually manipulate data
inside mysql ... but here it seems to me you are not talking of changing
the data VALUE (UPDATE table SET column=new value WHERE ...) but of
changing the DATA TYPE (ALTER TABLE table CHANGE or ALTER TABLE table
MODIFY depending on whether ypou change the column name too) or even of
(just) changing the FORMAT in which a value is displayed ...
Is there a formula to change the format of the data in a single
field in every record of a table? She has a "timestamp??? in a
text field formatted as 2017|02|16|04|58|42 and she wants to
convert it to a more human readable format like 2017-02-16 @
04:58:42
curious ... the default format for a time stamp is very similar to the
latter (except for you funny at-sign) :
mysql> select time from north33 limit 1;
+---------------------+
| time |
+---------------------+
| 2013-01-22 12:47:47 |
+---------------------+
and only if I cast it to an integer I get the other form
mysql> select time+0 from north33 limit 1;
+----------------+
| time+0 |
+----------------+
| 20130122124747 |
+----------------+
Anyhow I advise you to read the mysql manual and in particular the
function chapter and the "time and date function" subchapter. E.g. here
https://dev.mysql.com/doc/refman/5.7/en/functions.html
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql
