MySQL

When I am trying to select some rows from MySQL database in my C++ project I am getting an error:

I have a function which gets me all tables with their columns from an old database to a new databaseEverything is working fine so far

I need to know the last price of the product when last i was given to that company using PHP & Mysql , Ajax , Jsone

I have checkin and checkout data at a time stamp level

PQGrid: How I can save changes from grid to DB when I have a View as data source

I'm trying to call a local strategy from my js but when I try to submit the form it looks like it's calling but it's not making anything

How to use same columns multiple times in where conditionI want to use 'meta_key' and 'meta_value' multiple times

I have problems starting mysql server (56

Is there any way I can use the array from $query and use it in another query like the $query2 below? It works but it only returns the first data of the array

Im trying to get a query correct where I can display the data by State with each of the States cities with stores in it with the COUNT (Number of stores in each city)Any help is greatly appreciated

I have a mysql db containing data from 2014 until now ( the dbhas reached 2 tera)I need now to archive the data and lighten the production tables

My LOAD_FILE query is not working during execution lost connection please help

On Cloud SQL, with MySQL engine, how can I replace the functionality LOAD DATA INFILE

I have a dataset that looks like the following:

I'm using this query to get the count of rows grouped by cmp2 field but I need to get a column for every cmp2 even if its sum result is 0I can't get it this way:

I am trying to reset the cumulative count for every kind of insurance_statusright now my code brings back a cumulative count but does not start over when the insurance_status changes

How to Select all win user id ?

Let say I have 3 users, 1 of them is a superuser and 2 are just ordinary usersI want the 2 ordinary users to have access to a particular table but they can only view the records inserted by themselves, while the superuser can view all the records inserted by any user

This code can only assign ranks up to what seems like 128 peopleI need to be able to set ranks for 1500

I am trying to create a character selection CLI using python

I am trying to pull data from a database and assign them to different liststhis specific error is giving me a lot of trouble "TypeError: tuple indices must be integers, not str" i tried converting it to float and etc, but to no success

From what I know, when I do select * into [sometable], the PK (and other constraints) will not be included in the new data (sometable)Is there any other effect beside that PK and Constraint?

I have to do a MySQL to SQL Server migration using the SSMA toolThe MySQL DB cannot come down so the conversion has to happen live