My client gave me access to his hosting account in order to create a new user for his Wordpress site since he forgot the credentials for the old one. I got the FTP account and opened wp-config.php and normally i…
I use mysql and I have two tables with many to many relation and third table contains their foreign keys: album table: id name composition table: id name duration links table: id album_id composition_id How can I create sql query…
How to save long text from textarea-input line per line i have a form with a text area, i wanna save a long text line per line in mysql i have no idea $handle = fopen("inputfile.txt", "r"); if ($handle) {…
I have three tables Table A (orders) order_number order_id 9999 123 Table B (order_items) order_id product_id price 123 111 10 123 112 11 123 113 12 123 114 13 and Table C (product_customfields) product_id customfield_id customfield_value 111 10 A 112…
TABLE1 mach_id optout time 16543 NULL 2022-09-27 16543 YES 2022-09-26 16543 NO 2022-09-25 14444 YES 2022-09-27 15676 NO 2022-09-27 15676 YES 2022-09-26 11111 NULL 2022-09-27 11111 NULL 2022-09-26 Required table mach_id optout 16543 YES 14444 YES 15676 NO 11111 NULL…
I am trying to separate table results into those who are present and absent. For example, I have this users table here and user_attendance table here. Those users in the user_attendance table were present and I am trying to use…
I have 3 tables like this image: table-1 : topic +-------+-----------+-----------+-------------------+ | id | name | time | data | +-------+-----------+-----------+-------------------+ | 1 | John | 1 | 214-444-1234 | | 2 | Mary | 1 | 555-111-1234 | |…
Is there any gcloud command in GCP to list GCP SQL instance iam service-accounts. I am able to see in the GCP UI but I need cli command to print it the terminal. Could some one help me on this.
When I do the migration, I get the following message in the terminal: Migrations for 'bookList': bookList/migrations/0001_initial.py: Create model bookList And then I run the migrate command: Operations to perform: Apply all migrations: admin, auth, bookList, contenttypes, sessions When I…
This is my query, i'm using JSON_ARRAYAGG and JSON_OBJECT for hierarchy relations, but my concern is that i want data in following formated data. Don't be confuse with joins just help me get the data i want. SELECT CU.contact_group_id, JSON_ARRAYAGG(…