MySQL Query给出错误(1064)
问题描述:
嗯,我试图加入我的两个表使用内部连接。这是我在运行查询:MySQL Query给出错误(1064)
select * from online_booking.Booking_ID, movie_schedule.Movie_ID, online_booking.Customer_Name, online_booking.Customer_Cell_No, online_booking.Quantity_Of_Tickets
from movie_schedule
inner join online_booking
on movie_schedule.Movie_ID=online_booking.Movie_ID
这是我的表结构:
CREATE TABLE IF NOT EXISTS `movie_schedule` (
`Movie_ID` int(20) NOT NULL AUTO_INCREMENT,
`Movie_Name` varchar(100) NOT NULL,
`Movie_Date` varchar(20) NOT NULL,
`Show_Time` varchar(100) NOT NULL,
`Movie_Cost` int(20) NOT NULL,
`Tickets_Availability` varchar(20) NOT NULL,
PRIMARY KEY (`Movie_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;
CREATE TABLE IF NOT EXISTS `online_booking` (
`Booking_ID` int(15) NOT NULL AUTO_INCREMENT,
`Quantity_Of_Tickets` int(10) NOT NULL,
`Customer_Name` varchar(20) NOT NULL,
`Customer_Cell_No` varchar(20) NOT NULL,
`Movie_ID` int(15) NOT NULL,
PRIMARY KEY (`Booking_ID`),
KEY `Movie_ID` (`Movie_ID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=114 ;
ALTER TABLE `online_booking`
ADD CONSTRAINT `online_booking_ibfk_1` FOREIGN KEY (`Movie_ID`) REFERENCES `movie_schedule` (`Movie_ID`);
令我惊讶的是,我发现了以下错误:
错误代码:1064 你的SQL语法有错误;检查对应于你的MySQL服务器版本使用附近的正确语法手册在线条“movie_schedule 内连接online_booking上movie_schedule.Movie_ID = online_ ” 2 (0采取MS)
我缺少的东西?任何帮助,将不胜感激。
答
你已经把字段列表之后,从,
请更改select * from <field list>
到select <field list> from
像这样:
select online_booking.Booking_ID, movie_schedule.Movie_ID, online_booking.Customer_Name, online_booking.Customer_Cell_No, online_booking.Quantity_Of_Tickets
from movie_schedule
inner join online_booking
on movie_schedule.Movie_ID=online_booking.Movie_ID
检查,其中来自您选择。连接查询应该被命名,然后从该命名表中选择。 – observo
近距离投票,错字,你有'从'两次 – Drew