luofeiyu 发表于 2010-4-23 21:16:56

很长的table命令，如何没有执行？

我的createtable命令特别长，在终端中，输入后，如何让它执行：
请看我的终端：
mysql> CREATE TABLE balance_sheet(CodeVARCHAR(6),DateVARCHAR(8),Cash_and_cash_equivalentsVARCHAR(20),Trading_financial_assetsVARCHAR(20),Note_receivableVARCHAR(20),Account_receivableVARCHAR(20),Advance_moneyVARCHAR(20),Interest_receivableVARCHAR(20),Dividend_receivableVARCHAR(20),Other_notes_receivableVARCHAR(20),Due_from_related_partiesVARCHAR(20),InventoryVARCHAR(20),Consumptive_biological_assetsVARCHAR(20),Non_current_asset(expire_in_a_year)VARCHAR(20),Other_current_assetsVARCHAR(20),Total_current_assetsVARCHAR(20),Available_for_sale_financial_assetsVARCHAR(20),Held_to_maturity_investmentVARCHAR(20),Long_term_account_receivableVARCHAR(20),Long_term_equity_investmentVARCHAR(20),Investment_real_eastateVARCHAR(20),Fixed_assetsVARCHAR(20),Construction_in_progressVARCHAR(20),Project_materialVARCHAR(20),Liquidation_of_fixed_assetsVARCHAR(20),Capitalized_biological_assetsVARCHAR(20),Oil_and_gas_assetsVARCHAR(20),Intangible_assetsVARCHAR(20),R&d_expenseVARCHAR(20),GoodwillVARCHAR(20),Deferred_assetsVARCHAR(20),Deferred_income_tax_assetsVARCHAR(20),Other_non_current_assetsVARCHAR(20),Total_non_current_assetsVARCHAR(20),Total_assetsVARCHAR(20),Short_term_borrowingVARCHAR(20),Transaction_financial_liabilitiesVARCHAR(20),Notes_payableVARCHAR(20),Account_payableVARCHAR(20),Item_received_in_advanceVARCHAR(20),Employee_pay_payableVARCHAR(20),Tax_payableVARCHAR(20),Interest_payableVARCHAR(20),Dividend_payableVARCHAR(20),Other_account_payableVARCHAR(20),Due_to_related_partiesVARCHAR(20),Non_current_liabilities_due_within_one_yearVARCHAR(20),Other_current_liabilitiesVARCHAR(20),Total_current_liabilitiesVARCHAR(20),Long_term_loanVARCHAR(20),Bonds_payableVARCHAR(20),Long_term_payableVARCHAR(20),Specific_payableVARCHAR(20),Estimated_liabilitiesVARCHAR(20),Deferred_income_tax_liabilitiesVARCHAR(20),Other_non_current_liabilitiesVARCHAR(20),Total_non_current_liabilitiesVARCHAR(20),Total_liabilitiesVARCHAR(20),Paid_in_capitalVARCHAR(20),Contributed_surplusVARCHAR(20),Treasury_stockVARCHAR(20),Earned_surplusVARCHAR(20),Retained_earningsVARCHAR(20),Translation_reserveVARCHAR(20),Nonrecurring_itemsVARCHAR(20),Total_equity(non)VARCHAR(20),Minority_interestsVARCHAR(20),Total_equityVARCHAR(20),Total_liabilities_&_shareholder's_equityVARCHAR(20));
    '>
    '>
按下回车键没有用！

luofeiyu 发表于 2010-4-23 21:36:10

我在终端输如成下面的命令也没有反应：
mysql> create table balance_sheet(
    -> CodeVARCHAR(20),
    -> DateVARCHAR(20),
    -> Cash_and_cash_equivalentsVARCHAR(20),
    -> Trading_financial_assetsVARCHAR(20),
    -> Note_receivableVARCHAR(20),
    -> Account_receivableVARCHAR(20),
    -> Advance_moneyVARCHAR(20),
    -> Interest_receivableVARCHAR(20),
    -> Dividend_receivableVARCHAR(20),
    -> Other_notes_receivableVARCHAR(20),
    -> Due_from_related_partiesVARCHAR(20),
    -> InventoryVARCHAR(20),
    -> Consumptive_biological_assetsVARCHAR(20),
    -> Non_current_asset(expire_in_a_year)VARCHAR(20),
    -> Other_current_assetsVARCHAR(20),
    -> Total_current_assetsVARCHAR(20),
    -> Available_for_sale_financial_assetsVARCHAR(20),
    -> Held_to_maturity_investmentVARCHAR(20),
    -> Long_term_account_receivableVARCHAR(20),
    -> Long_term_equity_investmentVARCHAR(20),
    -> Investment_real_eastateVARCHAR(20),
    -> Fixed_assetsVARCHAR(20),
    -> Construction_in_progressVARCHAR(20),
    -> Project_materialVARCHAR(20),
    -> Liquidation_of_fixed_assetsVARCHAR(20),
    -> Capitalized_biological_assetsVARCHAR(20),
    -> Oil_and_gas_assetsVARCHAR(20),
    -> Intangible_assetsVARCHAR(20),
    -> R&d_expenseVARCHAR(20),
    -> GoodwillVARCHAR(20),
    -> Deferred_assetsVARCHAR(20),
    -> Deferred_income_tax_assetsVARCHAR(20),
    -> Other_non_current_assetsVARCHAR(20),
    -> Total_non_current_assetsVARCHAR(20),
    -> Total_assetsVARCHAR(20),
    -> Short_term_borrowingVARCHAR(20),
    -> Transaction_financial_liabilitiesVARCHAR(20),
    -> Notes_payableVARCHAR(20),
    -> Account_payableVARCHAR(20),
    -> Item_received_in_advanceVARCHAR(20),
    -> Employee_pay_payableVARCHAR(20),
    -> Tax_payableVARCHAR(20),
    -> Interest_payableVARCHAR(20),
    -> Dividend_payableVARCHAR(20),
    -> Other_account_payableVARCHAR(20),
    -> Due_to_related_partiesVARCHAR(20),
    -> Non_current_liabilities_due_within_one_yearVARCHAR(20),
    -> Other_current_liabilitiesVARCHAR(20),
    -> Total_current_liabilitiesVARCHAR(20),
    -> Long_term_loanVARCHAR(20),
    -> Bonds_payableVARCHAR(20),
    -> Long_term_payableVARCHAR(20),
    -> Specific_payableVARCHAR(20),
    -> Estimated_liabilitiesVARCHAR(20),
    -> Deferred_income_tax_liabilitiesVARCHAR(20),
    -> Other_non_current_liabilitiesVARCHAR(20),
    -> Total_non_current_liabilitiesVARCHAR(20),
    -> Total_liabilitiesVARCHAR(20),
    -> Paid_in_capitalVARCHAR(20),
    -> Contributed_surplusVARCHAR(20),
    -> Treasury_stockVARCHAR(20),
    -> Earned_surplusVARCHAR(20),
    -> Retained_earningsVARCHAR(20),
    -> Translation_reserveVARCHAR(20),
    -> Nonrecurring_itemsVARCHAR(20),
    -> Total_equity(non)VARCHAR(20),
    -> Minority_interestsVARCHAR(20),
    -> Total_equityVARCHAR(20),
    -> Total_liabilities_&_shareholder's_equityVARCHAR(20));
    '>
    '>
我一输入回车键，就出现'>
请问，原因在哪里？

kider 发表于 2010-4-26 09:15:08

最后一行有问题：字段中有个" ' "号，不符合命名规则，建议不要那么长...
页: [1]
查看完整版本: 很长的table命令，如何没有执行？