I have the table below: create table tablex (fileID int, file varchar(10), name varchar(10)); insert into tablex (fileID, file, name) values (1, 'file1' , 'AAA'),(1, 'file1' , 'AAA'),(1, 'file1' , 'AAA'),(2, 'file2' , 'AAA'),(2, 'file2' , 'AAA'),(2, 'file2' , 'AAA'),(1,…
There are two tables in my project: posts and post_categories. Each post in the posts table has a post_category_id relating to post_categories.id as fk, and each entry in post_categories has a parent_id - self-referencing post_categories.id. On the website, the post…
Having a very difficult time determining the root cause of this bug, not sure if its a devart connector issue or what. I have two queries that are simply generating a list of data and outputting in a table. When…
I have a problem that my code did't give me output, it's connect Python to MySql without change the value I want to change, I have 2 scripts file one of them config have my host, password and user and…
I have a query, works fine. In the last step I want it to order the whole table DESC based on the number of items in the 'Item List' column, but it's not working. SELECT t8.username AS 'Username', GROUP_CONCAT(CASE WHEN…
I have a code in SQL SELECT NAME, ROLL, PHONE_NO FROM STUDENT I want to add a new column with in the same extract which will have the same 9 digit phone number value but the last digit should be…
Initially the website is built with wordpress. The domain got changed from https://olddomain.com to https://newdomain.com and I have to migrate to DB as well. In the Post content there is image url like https://olddomain.com/wp-content/upload/2023/01/imagename.png https://olddomain.com/wp-content/upload/xxxx/xx/imagename.png etc. what i want to…
I am developing a chatting application. I have written a SQL to get the active chats associated with the user. It used to get user to user chat and group chats based on sort it in descending order based on…
I am pulling date from local server: $year = date("Y"); $day = date("d"); $month = date("m"); In my MySQL database, I have three fields, dateday datemonth and dateyear on a record. Format of database values are 26,6,1971. I want to…
I would like to create sql script that will split a csv into 3 mysql tables However, whenever, i run the sql script below, it throws an error, no subject or that in the field list.I have doubled cross my…