I currently have a table that contains a timestamp(6) column. I need to
copy the data in that column to a new table with the column structure as
timestamp(14), what is the best way to do it (now that the timestamp
structure is changed)?
Thanks
Jonathan
--- ignore below
query
sql
---
---
A few days ago I asked about how to know which database I am currently
in, I got an answer and I also replied to thank the send but the email
was returned. Any way I forgot to document it. I remember the answer
listed three methods to do it, they are "mysql> \s", "mysql> status".
Could you (or som
For example I have three databases, db1, db2, db3.
I have used command "mysql> use db1;" to select db1, then forsome silly
reason I forgot which db I am in. Is there a quick mysql command that
can show that you are in "db1"?
Cheers
Jonathan
--
