Menu
In MySQL, Can I put a restriction like below at database level?
I need to make sure 1. a specific column can only take either 'true' or 'false' values. 2. and exactly only one row should be having 'true' value?
632
i want to know how can we store multiple values in a sql column, or which is the best way to store the values in a sql column. which is the best way to store the Genre values in database. The best way by far, is NOT to store multiple values in a column. It violates normal form.
Method 2: Add Multiple Rows or Columns with Contextual Menu At first, select a number of rows or columns. Next right click and choose “Insert”. Then choose the right command as you need. The number of rows or columns is as the same as that of the rows or columns you selected at the very first.
Insert Data Only in Specified Columns It is also possible to only insert data in specific columns.
To select columns, choose one of the following options: Type SELECT , followed by the names of the columns in the order that you want them to appear on the report. Use commas to separate the column names.
Rather than having the boolean attribute in the table, you could have another table that contains one row and points to the row in the original table that you consider true.
Changing the true value is a matter of updating the foreign key in the TrueRow table.
196
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
