Reformatting a Column
Posted by: Gunnar Feltborg
Date: March 07, 2014 05:55AM

I have migrated Access to MySQL. I'm a beginner at MySQL and MySQL Workbench. Have a table in Workbench called bokingList with a column Fran (DateTime) e.g 2014-02-15 10:35:00. I want to reformat the column From to hours:minutes e.g 10:35.
In SQL Query I write:
SELECT date_format(Fran,'%H:%i') FROM bokning_lokalserver.bokingList;
However, I have no button Apply.
When trying Edit Table Data , its in read-only mode.
It is editable only if the table has a primary key.
Is there any fix to deal with table without primary key?
How do I set a column as Primary key
Could any one Help me please.

Options: ReplyQuote


Subject
Written By
Posted
Reformatting a Column
March 07, 2014 05:55AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.