Help! I am new to MySQL

Alles, was MariaDB und MySQL betrifft, kann hier besprochen werden.

Help! I am new to MySQL

Postby Blackhawk » 09. September 2016 21:17

I was wondering if anyone could help, I am trying to get the date in my View to order in ascending order. Every time I try it keeps coming up with an error stating the syntax is wrong.

The code of the view is below:
ALTER VIEW `MyFlights` AS SELECT
DATE_FORMAT(`Flights`.`FlightDate`,'%d-%b-%Y') AS `FlightDate`,
`Flights`.`Departed`,
`Flights`.`Arrived`,
`Flights`.`Airline`,
`Flights`.`FltNo`,
`Flights`.`ACReg`,
`Flights`.`Aircraft`
FROM `Flights` WHERE 1


How can I get the date in order?
Blackhawk
 
Posts: 2
Joined: 09. September 2016 21:09
XAMPP version: ?
Operating System: Windows

Re: Help! I am new to MySQL

Postby Altrea » 09. September 2016 22:27

Full-blooded error message
We don't provide any support via personal channels like PM, email, Skype, TeamViewer!

It's like porn for programmers 8)
User avatar
Altrea
AF Moderator
 
Posts: 11926
Joined: 17. August 2009 13:05
XAMPP version: several
Operating System: Windows 11 Pro x64


Return to MariaDB - MySQL

Who is online

Users browsing this forum: No registered users and 18 guests