Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2010
    Posts
    1

    Unanswered: no reaction to create table

    the following is in my console:
    mysql> create table balance_sheet(
    -> Code CHAR(6),
    -> Date DATE,
    -> 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));
    '>
    '>
    when i press enter , just output : '> ,no other reaction ,on error message,can't to create my table ,what's wrong?
    think you in advance.

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    what's wrong? the quote as part of the column name
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •