home
( I have string seprated with comma e.g (sports,concert,entertainment ) I want to check or compare...
I need to select data between 2 values from a table by using MAX because each SID has different VID...
I've two datasets, as shown below - Historical: +-------+-------+-----------+ |prod_id|prod_cd| ...
Hi guys im having an issue with my intellij react project, ive already connected to the MySQL DB...
NOTE: I've tried to be as clear and concise as possible with the question. If you downvote the...
This question already has an answer here: Can I mix MySQL APIs in...
I have trigger created in my database. I need to pass PHP variable to that trigger. I tried...
I am working with supermarket app using c#, php and mysql. There is the database(with more than 25...
I am trying to run the following SQL string in PDO. I can confirm that the code does execute in...
so I want to select all timestamps in each days of the last 7 days and put them in a json array,...
Well , i'm trying to build a chat page related to db , php So like this SQL goes like this $sql =...
I have a simple UDP server that works - I want to enter the data I'm getting to MySql. When I...
I want to fetch child and sub child locations by parent location. For example, I have location...
Following the SQL query used to retrieve data using get method and md5 link. $strSQL = "SELECT *...
I created a simple class to test the communication to my localhost database, that I created with...
We've a connection to a mysql data source for Google Data Studio, but in some cases the date fields...
This question already has an answer here: PHP: “Notice:...
I'm using MySql. I have two different databases data1 and data2. Let us say that data2 is like a...
I have a table like this, id name contractId ageGroup ageFrom ageTo sellingAmount ...
I have this to direct to a page after it ends inserting $id = $_SESSION['hola'];...
I am using root as username. My program will refresh every 5 seconds. What it does is, it query...
Im using wordpress with twentyfourteen as theme. On the right sidebar, I already have widget that...
I want to query data from two different MySQL databases to a new MySQL database. I have two...
Using MySQL Workbench, I have a MySQL InnoDB with a few hundred records. The records table has...
How to Filtered data and show it accordingly Drag AND Drop Table Column Fields using angular js or...
I am attempting to join 3 tables and update some values based on the data in the tables. The table...
I Keep getting Invalid Syntax error on the Colons which is this thing : <- I checked the code...
Is there any way to convert all data from the post contents to custom field value using sql...
Here is the first query SELECT left.description, right.description FROM left JOIN right ON...