Sto impazzendo con questa insert:
codice:
INSERT INTO t_expenses ( id_bs_personal_data_business, id_company, id_expense_status, id_expense_type, id_exepense_category, scheduled, date_expense, expiry_date_paymet, date_payment, expense_number, cost, iva, remaining_cost delivered_to_business_consultant, id_staff, enjoy_by, note) VALUES ( 1, 283, 1, 3, 1, 0, '2014-12-01', '2014-12-02', '2014-12-03', '12/14', 0.00, 0.00, 0.00, 0, 78, 78, 'prova')
c' è qualcosa che non va nella sintassi e non capisco cosa. L' errore restituitomi da mysql è:
codice:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'delivered_to_business_consultant, id_staff, enjoy_by, note) VALUES ( 1, 283, 1, ' at line 1
Aiutino?