MariaDB社区

标题: 很长的table命令，如何没有执行？ [打印本页]

作者: luofeiyu 时间: 2010-4-23 21:16
标题: 很长的table命令，如何没有执行？
我的create table命令特别长，在终端中，输入后，如何让它执行：
请看我的终端：
mysql> CREATE TABLE balance_sheet( Code VARCHAR(6),Date VARCHAR(8),Cash_and_cash_equivalents VARCHAR(20),Trading_financial_assets VARCHAR(20),Note_receivable VARCHAR(20),Account_receivable VARCHAR(20),Advance_money VARCHAR(20),Interest_receivable VARCHAR(20),Dividend_receivable VARCHAR(20),Other_notes_receivable VARCHAR(20),Due_from_related_parties VARCHAR(20),Inventory VARCHAR(20),Consumptive_biological_assets VARCHAR(20),Non_current_asset(expire_in_a_year) VARCHAR(20),Other_current_assets VARCHAR(20),Total_current_assets VARCHAR(20),Available_for_sale_financial_assets VARCHAR(20),Held_to_maturity_investment VARCHAR(20),Long_term_account_receivable VARCHAR(20),Long_term_equity_investment VARCHAR(20),Investment_real_eastate VARCHAR(20),Fixed_assets VARCHAR(20),Construction_in_progress VARCHAR(20),Project_material VARCHAR(20),Liquidation_of_fixed_assets VARCHAR(20),Capitalized_biological_assets VARCHAR(20),Oil_and_gas_assets VARCHAR(20),Intangible_assets VARCHAR(20),R&d_expense VARCHAR(20),Goodwill VARCHAR(20),Deferred_assets VARCHAR(20),Deferred_income_tax_assets VARCHAR(20),Other_non_current_assets VARCHAR(20),Total_non_current_assets VARCHAR(20),Total_assets VARCHAR(20),Short_term_borrowing VARCHAR(20),Transaction_financial_liabilities VARCHAR(20),Notes_payable VARCHAR(20),Account_payable VARCHAR(20),Item_received_in_advance VARCHAR(20),Employee_pay_payable VARCHAR(20),Tax_payable VARCHAR(20),Interest_payable VARCHAR(20),Dividend_payable VARCHAR(20),Other_account_payable VARCHAR(20),Due_to_related_parties VARCHAR(20),Non_current_liabilities_due_within_one_year VARCHAR(20),Other_current_liabilities VARCHAR(20),Total_current_liabilities VARCHAR(20),Long_term_loan VARCHAR(20),Bonds_payable VARCHAR(20),Long_term_payable VARCHAR(20),Specific_payable VARCHAR(20),Estimated_liabilities VARCHAR(20),Deferred_income_tax_liabilities VARCHAR(20),Other_non_current_liabilities VARCHAR(20),Total_non_current_liabilities VARCHAR(20),Total_liabilities VARCHAR(20),Paid_in_capital VARCHAR(20),Contributed_surplus VARCHAR(20),Treasury_stock VARCHAR(20),Earned_surplus VARCHAR(20),Retained_earnings VARCHAR(20),Translation_reserve VARCHAR(20),Nonrecurring_items VARCHAR(20),Total_equity(non) VARCHAR(20),Minority_interests VARCHAR(20),Total_equity VARCHAR(20),Total_liabilities_&_shareholder's_equity VARCHAR(20));
'>
'>
按下回车键没有用！

作者: luofeiyu 时间: 2010-4-23 21:36
我在终端输如成下面的命令也没有反应：
mysql> create table balance_sheet(
-> Code  VARCHAR(20),
-> Date  VARCHAR(20),
-> Cash_and_cash_equivalents  VARCHAR(20),
-> Trading_financial_assets  VARCHAR(20),
-> Note_receivable  VARCHAR(20),
-> Account_receivable  VARCHAR(20),
-> Advance_money  VARCHAR(20),
-> Interest_receivable  VARCHAR(20),
-> Dividend_receivable  VARCHAR(20),
-> Other_notes_receivable  VARCHAR(20),
-> Due_from_related_parties  VARCHAR(20),
-> Inventory  VARCHAR(20),
-> Consumptive_biological_assets  VARCHAR(20),
-> Non_current_asset(expire_in_a_year)  VARCHAR(20),
-> Other_current_assets  VARCHAR(20),
-> Total_current_assets  VARCHAR(20),
-> Available_for_sale_financial_assets  VARCHAR(20),
-> Held_to_maturity_investment  VARCHAR(20),
-> Long_term_account_receivable  VARCHAR(20),
-> Long_term_equity_investment  VARCHAR(20),
-> Investment_real_eastate  VARCHAR(20),
-> Fixed_assets  VARCHAR(20),
-> Construction_in_progress  VARCHAR(20),
-> Project_material  VARCHAR(20),
-> Liquidation_of_fixed_assets  VARCHAR(20),
-> Capitalized_biological_assets  VARCHAR(20),
-> Oil_and_gas_assets  VARCHAR(20),
-> Intangible_assets  VARCHAR(20),
-> R&d_expense  VARCHAR(20),
-> Goodwill  VARCHAR(20),
-> Deferred_assets  VARCHAR(20),
-> Deferred_income_tax_assets  VARCHAR(20),
-> Other_non_current_assets  VARCHAR(20),
-> Total_non_current_assets  VARCHAR(20),
-> Total_assets  VARCHAR(20),
-> Short_term_borrowing  VARCHAR(20),
-> Transaction_financial_liabilities  VARCHAR(20),
-> Notes_payable  VARCHAR(20),
-> Account_payable  VARCHAR(20),
-> Item_received_in_advance  VARCHAR(20),
-> Employee_pay_payable  VARCHAR(20),
-> Tax_payable  VARCHAR(20),
-> Interest_payable  VARCHAR(20),
-> Dividend_payable  VARCHAR(20),
-> Other_account_payable  VARCHAR(20),
-> Due_to_related_parties  VARCHAR(20),
-> Non_current_liabilities_due_within_one_year  VARCHAR(20),
-> Other_current_liabilities  VARCHAR(20),
-> Total_current_liabilities  VARCHAR(20),
-> Long_term_loan  VARCHAR(20),
-> Bonds_payable  VARCHAR(20),
-> Long_term_payable  VARCHAR(20),
-> Specific_payable  VARCHAR(20),
-> Estimated_liabilities  VARCHAR(20),
-> Deferred_income_tax_liabilities  VARCHAR(20),
-> Other_non_current_liabilities  VARCHAR(20),
-> Total_non_current_liabilities  VARCHAR(20),
-> Total_liabilities  VARCHAR(20),
-> Paid_in_capital  VARCHAR(20),
-> Contributed_surplus  VARCHAR(20),
-> Treasury_stock  VARCHAR(20),
-> Earned_surplus  VARCHAR(20),
-> Retained_earnings  VARCHAR(20),
-> Translation_reserve  VARCHAR(20),
-> Nonrecurring_items  VARCHAR(20),
-> Total_equity(non)  VARCHAR(20),
-> Minority_interests  VARCHAR(20),
-> Total_equity  VARCHAR(20),
-> Total_liabilities_&_shareholder's_equity  VARCHAR(20));
'>
'>
我一输入回车键，就出现'>
请问，原因在哪里？

作者: kider 时间: 2010-4-26 09:15
最后一行有问题：字段中有个" ' "号，不符合命名规则，建议不要那么长...

欢迎光临 MariaDB社区 (http://123.56.88.72/)