MySQL Forums
Forum List  »  Newbie

1136 error Can't figure out how to fix it.
Posted by: Nicholas Mateik
Date: May 04, 2022 10:33PM

I'm new here and to this language as well, any help would be greatly appreciated.


CREATE TABLE Trading_Journal(
Total_Return DECIMAL(14,2) NOT NULL,
Return_Per_Share DECIMAL(14,2) NOT NULL,
Account_Balance DECIMAL(14,2) NOT NULL,
Return_on_Winners DECIMAL(14,2) NOT NULL,
Return_on_losers DECIMAL(14,2) NOT NULL,
Return_on_Long DECIMAL(14,2) NOT NULL,
Biggest_Profit DECIMAL(14,2) NOT NULL,
Biggest_Loss DECIMAL(14,2) NOT NULL,
Win_Percentage DECIMAL(8,2) NOT NULL,
Total_Trades DECIMAL(8,2) NOT NULL,
Max_Consec_Win DECIMAL(8,3) NOT NULL,
Total_Losers DECIMAL(8,3) NOT NULL,
Total_Shares DECIMAL(14,2) NOT NULL);

INSERT INTO Trading_Journal VALUES(
'21,293,681.96', '0.02', '21,293,681.96',
'21,324,537.90', '30,855.94', '16,695,913.88',
'57,360.00', '8,350.00', '99.35', '23,552', '2,073',
'2,073', '128', '74,613,725.00');

Options: ReplyQuote


Subject
Written By
Posted
1136 error Can't figure out how to fix it.
May 04, 2022 10:33PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.