Questions tagged as 'mysql'

Tagged questions
0
answers

Upload BD to a Linux server - MySQL

I have my BD in MySQL and locally I work in Windows, but when I want to work remotely I have to upload my BD to a Linux server and I do it through the "Putty", what I do is generate the Script from the Workbench that I have in Windows, copy and...
asked by 24.08.2018 / 22:16
0
answers

Group by min and average FROM_UNIXTIME MYSQL

I have the following query: SELECT DATE_FORMAT(FROM_UNIXTIME(history.clock), "%Y") as year, DATE_FORMAT(FROM_UNIXTIME(history.clock), "%m") as month, DATE_FORMAT(FROM_UNIXTIME(history.clock), "%d") as day, DATE_FORMAT(FROM_UNIXTIME(history.clo...
asked by 14.08.2018 / 15:24
1
answer

How does a column of dates compare to a specific date?

In this image on the left side are the tables that give me, on the side right is what he asks me to do and below in blue is the code that I made in MySQL database language do not know what statement should be used to be able to select...
asked by 17.08.2018 / 04:23
0
answers

Mysql Master-Slave

I just made my PC server slave where I have the app uploaded to get the mysql data when they are updated on the server. My query is the following, because although I did not understand it well, this consumes many resources of my pc? Are you cons...
asked by 15.08.2018 / 16:19
0
answers

Add records using PA with variable

I do not have an id to enter a student who is from abroad with Carrera and I want to calculate it using a SELECT in my PA, but it tells me Error Code: 1136. Column count does not match value count at row 1 DELIMITER $ CREATE PROCEDURE agregarE...
asked by 19.08.2018 / 17:03
1
answer

When trying to insert data into the DB I get an error [HY093]

The fact is that I am trying to insert users through PDO and CRUD and this is generating an error which I can not solve. The error is exactly this    SQLSTATE [HY093]: Invalid parameter number: parameter was not defined File containing...
asked by 22.03.2018 / 11:40
1
answer

Create a trigger to copy value from one field to another field within the same table in mysql

Good help please, if someone could give me an example to copy the value of one field to another field of the same table, when I update the first field. thanks     
asked by 19.08.2018 / 03:04
0
answers

update several rows from a checkbox datatable with jquery, mysql and php

my question is: how can I update several fields of a mysql table after selecting multiple rows in checkbox datatable with jquery and php here the code: <script type="text/javascript"> $(document).on("ready", function(){ listar...
asked by 16.08.2018 / 15:40
0
answers

# 1045 - Access denied to user

I am doing an update of a table through a csv and it shows me this error. I asked my hosting provider for help, but they do not give me a specific answer. All the forums I've seen, have the solution but when you're working locally. Error S...
asked by 11.08.2018 / 22:03
0
answers

problems with dataset and reportviewer (mysql)

Hello all good night, I am starting with the reports in a small system in c # and mysql, I add a dataset and when I want to use the stored procedure it shows me this error: and if I try with a table, the same thing happens, create the e...
asked by 12.08.2018 / 02:08