Menu
Using IntelliJ 14.0.3, whenever I try to create a new row inside a database table, the editor just creates a new row with default values for each column. Then I edit those default values with actual values. After refreshing, the row then disappears. Auto-commit is on.
Edit: Also happens in IntelliJ IDEA 14.1.1 Even with Auto-Commit off, after I create the row, edit the values, then click the Commit button, it is still not saved.
854
In the Database tool window, select a schema and navigate to File | New | Table. Alternatively, right-click the schema or database node and select New | Table. In the Create New Table dialog, specify table settings (columns, keys, indexes, foreign keys, grants). Click OK.
Disconnect from a database in a specified periodOn the Data Sources tab, select a data source that you want to modify. On the Options tab, select the Auto-disconnect after N seconds checkbox, where N is a number of seconds after which IntelliJ IDEA terminates the connection.
Delete a row Also, you can press Ctrl and click the necessary rows. ) on the toolbar. Alternatively, press Ctrl+Y or Delete .
After you filled new values in, you have to invoke 'Submit New Row' action - it's available in the inserted row's context menu.
The thing is, after you've hit 'Add New Row', the new row is only added in the UI, so that you can edit values. 'Submit New Row' action submits a new row to your dbms, 'Commit' commits current database transaction.
168
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
