I have a mysql procedure which has out parameter and some print statements for debugging. I am calling this procedure from Unix shell script, idea is to assign the out parameter to a unix variable, which i use to check…
I want to make visible a button, but only when a string exists. This is the way I thought, but I'm not seeing any change to my UI. Furthermore, the loop doesn't exit, despite only returning a single result. using…
I got this MySQL query, I need to join both tables apps and contacts, but I am getting this error: MySQL said: Documentation #1054 - Unknown column 'messages.app_id' in 'on clause' My query: SELECT `messages`.*, ( SELECT COUNT(*) FROM messages…
i want to create setting model LIKE tcg/voyager to can use like this *** setting('site.title') *** . how to generate ? iwant to save to db. like tcg/voyager . thanks.
Let's say I have a table with logs. The value of status column may be NULL and I would like to UPDATE this value by copying value from the log for same settingid which have non-NULL status and closest (smaller…
I want to deploy a Dockerfile build on EC2(fargate). I got the following error in cloudwatch. 'Failed to create pool.: Error (None)' I have come up with a solution to this problem. I change method from build to build_unchecked in…
Should I put INDEX on staff_id & client_id CREATE TABLE conversation ( id INT(7) UNSIGNED AUTO_INCREMENT PRIMARY KEY, staff_id INT(7) UNSIGNED, client_id INT(7) UNSIGNED, summary TEXT, FOREIGN KEY (staff_id) REFERENCES staff(staff_id) ON DELETE CASCADE, FOREIGN KEY (client_id) REFERENCES client(client_id) ON…
I am trying to call categories but only if a document is assigned to those categories. The document has the categories stored as a JSON type. In the WHERE it is only bringing back the rows that have document uids…
How can I make MySQL throw an error (not simply issue a warning) when I try and perform a mathematical operation with text in the SELECT list. For example: SELECT 'foo' * 'bar'; I want that query to fail.
I'm having a bit of trouble with getting a select statement to work correctly. I have the following tables: recipe recipe_ingredient pantry recipe1 ingredient1 Ingredient1 recipe1 ingredient2 Ingredient2 recipe2 ingredient3 I want a select statement that returns recipes when the…