Questions tagged as 'mysql'

Tagged questions
1
answer

Many-to-many relationship in laravel 5.4

I am doing the assignment of Teachers - Degrees, that is to say I have a Teaching model and a Grade model and their relationship is of many to many so when it comes to making the migration creates a pivot teacher_graduate table. According to I u...
asked by 25.08.2017 / 04:11
1
answer

I can not connect to MySQL from C #

I'm trying to connect to a MySQL database in C #, and my code has been working perfectly since I started, but sometimes I know it's giving me this error like, every 2 days, sometimes it connects sometimes not , I have 2 DB in different servers a...
asked by 04.11.2017 / 09:16
0
answers

Error with consecutive field in MySql

First of all, thanks for reading. I am adding data from php to a bd and I have a field in my table that has to be generated consecutively, but when I delete some fields and add a new one, the consecutive numbering stays in the last field that...
asked by 24.04.2018 / 02:37
0
answers

HELP! How to make this MySQL query

I have these tables, payroll, deductions, bonuses, advances, employee, and what I want is to add the total bonus, total deductions, total advances, then show this data, and with this calculate the total salary and group it by idEmpleado, I've do...
asked by 24.04.2018 / 06:40
1
answer

Check value String in SQL

I am creating a trigger in SQL, in which I use the UDFs to invoke a JAVA code. This Java code returns a string, from which I have to check the value to allow an action or not. What SQL function can I use to check the contents of that String in a...
asked by 11.08.2017 / 13:50
1
answer

Do a GROUP BY to a query with an ORDER BY

I have a table called schedule with these columns: I currently have this information: I would like to sort them by the hour first and then group them per day but I do not know how to do the query in order to do the two instructions....
asked by 04.09.2017 / 20:30
1
answer

Problems with special characters mysql php [duplicate]

well as I mention it: I have a simple database with a single table because it is a test where ALL (the database, the table, the text fields) is with a collation "utf8_general_ci" then to the time to read from php the text field that has ñññ''0...
asked by 08.08.2017 / 04:29
1
answer

Do I need the total of word matches between 2 strings with MySQL?

I already managed to bring the Categories in which at least found (1) a word, regardless of the order (in a MyiSAM table with Fulltex index) ...... Now the problem is knowing the total of coincidences that had in each record or the one that had...
asked by 05.08.2017 / 00:31
0
answers

MySQL query from script [closed]

I have a computer connected by SSH to another computer from which I want to run a bash script to query an external host in MySQL. I connect without problems from the command line as follows: mysql -h HOST -u USER -pPASS Once connected, I...
asked by 14.08.2017 / 12:28
1
answer

Error sending arduino data to my local server

I have a problem to send my sensor data to a local server, I had already tested it with a single sensor and it worked for me, it was the lm35, now that it adds another sensor I can not send the data, in arduino it tells me that everything is cor...
asked by 09.08.2017 / 10:18