向一个表中的5个字段插数据，数据的来源是另一个表中的5个字段，如何来写SQL语句

Question

Insert into career_user_info 
     ( 
      USERID, 
      USERNAME, 
      PASSWORD, 
      EMAIL, 
      USERREALNAME, 
      ) 
      SELECT  
        pnt.referenceid,                                        
        PM.username,                                            
        PM.password,                                             
        pnt.Email,                                              
        pnt.name,                                               
     FROM per_NormalTalent pnt,per_MEMBER PM; 
没有AS。

Answer 1

Insert into career_user_info 
     ( 
       USERID, 
       USERNAME, 
       PASSWORD, 
       EMAIL, 
       USERREALNAME, 
      ) 
SELECT  pnt.referenceid,                                        
        PM.username,                                            
        PM.password,                                             
        pnt.Email,                                              
        pnt.name,                                               
FROM    per_NormalTalent pnt,per_MEMBER PM; 不需要加'AS'的。per_NormalTalent pnt和per_MEMBER PM之間有關聯條件，否則的話好像是個笛卡兒乘積
數據量會比較的大

Answer 2

使用的AS的話是這樣的
CREATE TABLE career_user_info 
AS
SELECT  
        pnt.referenceid,                                        
        PM.username,                                            
        PM.password,                                             
        pnt.Email,                                              
        pnt.name,                                               
     FROM per_NormalTalent pnt,per_MEMBER PM;

Answer 3

顺便问一下，这条SELECT  
        pnt.referenceid,                                        
        PM.username,                                            
        PM.password,                                             
        pnt.Email,                                              
        pnt.name,                                               
     FROM per_NormalTalent pnt,per_MEMBER PM;
一共可选择出三万多条数据，但我在运行插入的时候提示值过多，难道三万多条不能一次插入吗？

Answer 4

career_user_info 中某个字段长度比插入字段的长度小