Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > ORA-00922:选项缺失或无效_MySQL

ORA-00922:选项缺失或无效_MySQL

WBOY
Release： 2016-05-27 13:46:28
Original
2369 people have browsed it

1、错误描述

 

SQL> create table info_stu from select t.stu_id,t.stu_name,t.stu_age from info t;
 
create table info_stu from select t.stu_id,t.stu_name,t.stu_age from info t
 
ORA-00922: 选项缺失或无效
Copy after login

2、错误原因

由于用数据库表中某些字段创建一张新表，中间的连接是用AS，而不是用from

3、解决办法

SQL> create table info_stu as select t.stu_id,t.stu_name,t.stu_age from info t;
 
Table created
Copy after login

Related labels：
Missing
source：php.cn
Previous article：MySQL5.7的错误堆栈缓冲_MySQL Next article：【原创】mysql 错误缓冲堆栈_MySQL
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Website using Live Server doesn't work when I launch it from a file I tried several browsers and in every case the website works fine with LiveServer. On the ...
From 2024-04-06 12:46:18
0
1
403
Unit test OverflowException: Maximum retries reached 10,000 times, unique value still not found So I'm doing some unit testing before implementing new functionality. I run the test but i...
From 2024-04-06 11:27:39
0
2
347
Securing Next.js routes with Supabase I am implementing route protection by creating a protection page and whenever the user is ...
From 2024-04-06 11:13:00
0
1
430
Add the Endpoint _header attribute to the JSON response object I'm testing pulling data from a remote endpoint service (npoint.io). When I get back the r...
From 2024-04-05 10:35:39
0
1
1376
React TS error: Missing properties when using Types I'm trying to make a filtration system and I'm running into a problem. I set several types...
From 2024-04-05 00:24:10
0
1
285
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template