chive

Change SQL statement format

Bug #515888 reported by Matthias Burtscher
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
chive
Fix Released
Low
Matthias Burtscher
chive 0.2.0
0.1
Fix Released
Low
Matthias Burtscher
chive 0.2.0

Bug Description

SQL statement format is not very convenient, especially when inserting a new row, statement should be a two-line statement instead of this:

INSERT INTO `ctd1_acc_account` (
 `usrId`,
 `accountHolder`,
 `accountNumber`,
 `bankName`,
 `bankCode`,
 `ctrId`,
 `iban`,
 `bic`
) VALUES (
 '1',
 'tets',
 'test',
 'test',
 'test',
 'test',
 NULL,
 NULL
)

Revision history for this message
Matthias Burtscher (mburtscher) wrote :

Statements should always end with a semicolon!

Changed in chive:
importance: Undecided → Low
milestone: none → 0.1.3
Revision history for this message
Matthias Burtscher (mburtscher) wrote :

Changed to phpMyAdmin style:

INSERT INTO `ctd1_acc_account` (
  `usrId`,
  `accountHolder`,
  `accountNumber`,
  `bankName`,
  `bankCode`,
  `ctrId`,
  `iban`,
  `bic`
) VALUES (
  '1', 'tets', 'test', 'test', 'test', 'test', NULL, NULL
);

Changed in chive:
status: New → Fix Committed
assignee: nobody → Matthias Burtscher (mburtscher)
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.