I am trying to create an SQL Query. I am stuck since I can't get the result that I want. I am using phpMyAdmin to try out these query's, What I have tried: I have tried to use the GROUP…
i am having trouble im using visual studio in my other windows form same code it is working properly but i am using it now on another form and it doesn't filter anymore i don't know why. I am trying…
I have to work with a friend in a wordpress project, and we want to be able to work everyone from our side in localhost. For this we are using git to have the same code, but we need to…
I am using a simple python function to connect to a MySQL database.I receive an error saying a variable is referenced before it is assigned, but this would not be the case if the connection had successfully established. Why is…
My current project is a social media app somewhat like Facebook. Now the post created by both users and news post (there is a cron running every 15 min and it fetch latest news from various news channels) are keeping…
I have a very strange problem, that I cannot get my head around. I am using Laravel for my backend application, where I am running a very simple query on table with 30k records all with proper indexes on it.…
I have a Magento shop (using MySql db) and just noticed that some developer introduced a custom db for capturing some structured data. Now I noticed that the tables are not linked via foreign keys with each other, but just…
I want to export all databases as separate .sql files but I get localhost.sql Can anyone here show me how we can accomplish this?
I am trying to insert some data with node.js. I installed MySQL support via npm, but It still seems to fail to input the right strings with INSERT INTO. (the row types in the database are tinytext and the strings…
Here i am again. Thank you so much for help. Here is my Old question on how i can select and display the grade of student in a junction table. Select and display all rows belonging to a specific ID…