I just upgraded my MacBook-Air (2013) to macOS Sierra and when I try to install MySQL (mysql-5.7.15-osx10.11-x86_64.dmg) it installs correctly but when I try to do one:
sudo /usr/local/mysql/support-files/mysql.server start
or
sudo /usr/l...
I have a table in mysql generated by means of a stored procedure, I needed the table to show me some rows in a column and that I have already achieved, but now I do not know how to save the name of these columns in order to work with that data f...
I have two MySQL tables, the first with an id, name and the second with an id (related to the id of the first table) and a value.
I need to make a query that adds all the values with the same id from table 2 and shows it in a new column of table...
I have the following function that must take the data from a JSON and save it in a MySQL database
def saveMetric(metrics):
cnx = RDS_Connect()
cursor = cnx.cursor()
jsonMetrics = json.loads(metrics)
#print type(jsonMetrics...
I have made a small event registration module, taking between date and time fields: YY-mm-dd H:i:s . Users who register can be from different time zones. Then an event scheduled for a moment could not correspond with the other clients....
I have a problem with this subquery.
I have in a table two id, cveLider and cveOperador that are related to cveEmpleado , I have to get the name of both, I did it through a subquery but I get the error
ERROR 1242 Sub...
I am trying to persist against a MySql database using the Entity Framework the Code-First approach, use in EF6
I do not get an error, The problem is that I do not create the database or the table or add the records I persist.
We show our im...
I am studying the types of joins and doing exercises, I can do the inner joins without problems, but I have difficulty with the other variants such as the left join, in my example I have created a small and simple database.
Data entered...
I am having problems when making a date query, for example:
I have a column called Date and it is of type date, in which I only store date, time not! because of that date I want to do columns in which I take the months, in rows the years recorde...
I have this table
id departure value date
1065 | 2018-09-20 | 10490 | 2018-09-20 18:04:19 |
1034 | 2018-09-25 | 10582 | 2018-09-20 18:04:19 |
1035 | 2018-09-25 | 13096 | 2018-09-20 19:05:19 |
And this consultation
SELECT...