lemonhu / finance-qa-spider Goto Github PK

深交所官方平台的问答系统
http://irm.cninfo.com.cn/szse/index.html　　

全景网投资者关系互动平台
http://rs.p5w.net/index/company/showQuestionPage.shtml　　

新浪股吧
http://guba.sina.com.cn/?s=channel&chi

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> CREATE TABLE IF NOT EXISTS shse_qa(
-> -> current_time TIMESTAMP NOT NULL,
-> -> user_name VARCHAR(100) NOT NULL,
-> -> company_name VARCHAR(100) NOT NULL,
-> -> company_id int(20) NOT NULL,
-> -> question_time VARCHAR(100) NOT NULL,
-> -> question_content text NOT NULL,
-> -> answer_time VARCHAR(100),
-> -> answer_content text
-> -> )ENGINE=InnoDB DEFAULT CHARSET=utf8;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-> current_time TIMESTAMP NOT NULL,
-> user_name VARCHAR(100) NOT NULL,
' at line 2
mysql>