MySQL column that will check if a date column is past 30 days
Not sure if this is possible…
MySQL column that will check if a date column is past 30 days
Not sure if this is possible…
MySQL column that will check if a date column is past 30 days
Not sure if this is possible…
MySQL column that will check if a date column is past 30 days
Not sure if this is possible…
Unable to set my database to read only in MySQL
When I try and make my database read only (not for any actual purpose, just for the sake of seeing that I can), MySQL tells me that I have a syntax error.
Unable to set my database to read only in MySQL
When I try and make my database read only (not for any actual purpose, just for the sake of seeing that I can), MySQL tells me that I have a syntax error.
Delete record and update default column to zero if one
I want virtual delete one item in database , when (id = 2 And productId = 1 and deleted=0) . this query change row id 2 and set deleted column to one, it means row deleted and if this row is default then change to default=0 (that mean this row not default row) and random select another row d product=1 set default column to one. this query work correctly. but when i have only one row of productId = 1 this query not work because needs min two rows of productId = 1 and deleted=0.
Delete record and update default column to zero if one
I want virtual delete one item in database , when (id = 2 And productId = 1 and deleted=0) . this query change row id 2 and set deleted column to one, it means row deleted and if this row is default then change to default=0 (that mean this row not default row) and random select another row d product=1 set default column to one. this query work correctly. but when i have only one row of productId = 1 this query not work because needs min two rows of productId = 1 and deleted=0.
Delete record and update default column to zero if one
I want virtual delete one item in database , when (id = 2 And productId = 1 and deleted=0) . this query change row id 2 and set deleted column to one, it means row deleted and if this row is default then change to default=0 (that mean this row not default row) and random select another row d product=1 set default column to one. this query work correctly. but when i have only one row of productId = 1 this query not work because needs min two rows of productId = 1 and deleted=0.
Delete record and update default column to zero if one
I want virtual delete one item in database , when (id = 2 And productId = 1 and deleted=0) . this query change row id 2 and set deleted column to one, it means row deleted and if this row is default then change to default=0 (that mean this row not default row) and random select another row d product=1 set default column to one. this query work correctly. but when i have only one row of productId = 1 this query not work because needs min two rows of productId = 1 and deleted=0.