If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > MySQL > no reaction to create table

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 04-23-10, 20:49
luofeiyu luofeiyu is offline
Registered User
 
Join Date: Apr 2010
Posts: 1
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.
Reply With Quote
  #2 (permalink)  
Old 04-23-10, 22:32
r937 r937 is offline
SQL Consultant
 
Join Date: Apr 2002
Location: Toronto, Canada
Posts: 19,525
what's wrong? the quote as part of the column name
__________________
r937.com | rudy.ca
please visit Simply SQL and buy my book
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On