Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

3
  • It kinda works Vijaykumar. It shows me the single column and the format is changed. But when I go back to my table the content is not affected by my query Commented Nov 18, 2013 at 12:00
  • yes that's obvious,if you want this data you can redirect to some other table in your database + if this is working pls accept the answer Commented Nov 18, 2013 at 12:02
  • INSERT INTO stocks_remaining(DATE_FORMAT(Date,"%m/%d/%Y"), Item, Quantity) VALUES("02/05/2017", "mouse", 2) What would be the right syntax for this Commented Feb 4, 2017 at 9:47