I want to develop a Mess Manager Application. Where users(members) comes and goes in every month. Here is my Eloquent Query in my Controller which I tried: where session('dates') like- Nov-2023, Dec-2023, Jan-2024 $sessionDate = Carbon::createFromFormat('M-Y', session('dates')); $currentDate = now();…
I have a MySQL database named wc_players in which it has a table called players_wc. I want to copy the entire table to another database named as fifa which already has a table named fifa_wc. How can i add this…
I have a Flask app that is executing an sql query to retrieve a list of parts from a MySql database. My problem is that I am sure I have the SQL query correct, because it works in MySql workbench,…
I'm trying to use a SQL query to build a custom field that will identify each account as Search or PMax or Both (Search & PMax). Please help Thank you. Santosh. Here is rawdata and expected output in the attached…
Table A has an index on 'ObjectId'. We are querying this table using a select similar to this: SELECT FROM `A` AS a where `a`.`objectId` IN ('00017a41-1ac0-4775-822b-de00cfd5902d', '000216dc-03cb-4e73-8177-3c2e49bc6622', '00035b33-2a62-464a-817b-6e23e8961bce') In this case a list of three objectids. But in our…
Error while install MySQLClient package cPanel terminal. I am windows user and it's run on windows completely but when upload to cPanel and install mysqlclient it not working Error which i get in cpanel terminal ((project:3.8)) [shriyamc@callisto project]$ pip install…
I am trying to connnect MySQL to my django app. I keep on receive an error message suggesting me to install my SQL client first. When I run: python manage.py runserver Here is the errro message I receive: > (guessgame)…
I have several queries along the lines of: INSERT INTO my_data_archive.my_table (id, FieldName, Value, Position, PageId) SELECT id, FieldName, Value, Position, PageId FROM my_data.my_table WHERE PageId IN (SELECT id FROM my_data.page WHERE PageTypeId BETWEEN 33 AND 36 AND Deleted IS…
SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'employee_id' cannot be null (Connection: mysql, SQL: update attendance_employees set employee_id = ?, date = ?, clock_in = ?, clock_out = ?, late = -473049:00:00, early_leaving = 473058:00:00, attendance_employees.updated_at = 2023-12-19 16:23:08 where id…
I want to optimize performance of this MySQL query SELECT * FROM ( (SELECT * FROM users USE INDEX(names) WHERE name LIKE '%leo%') UNION (SELECT * FROM users USE INDEX(names) WHERE name LIKE '%le%') UNION (SELECT * FROM users USE…