Questions tagged as 'mysql'

Tagged questions
1
answer

Count total equal records in two different tables with Group By among 3 related tables

I have tried to perform a query that extracts the information from a table where certain information is stored    This table contains comments Additionally I have two other tables that are related to this, such as the table of likes and r...
asked by 01.08.2018 / 03:28
0
answers

mysql_error.log

Every time I start MySQL in Xampp I get this error:    15:56:25 [mysql] Error: MySQL shutdown unexpectedly.       15:56:25 [mysql] This may be due to a blocked port, missing   dependencies,       15:56:25 [mysql] improper privileges, to cra...
asked by 12.09.2018 / 21:57
0
answers

Error processing the request error code: 500 Error text: internal Server Error

I have this error when trying to see the design view, I need to see the relationships of my tables, I have connected valet-linux and downloaded phpmyadmin in valet paths When I investigate only rogue to add code to the root of phpmyadmi...
asked by 29.07.2018 / 05:43
1
answer

Problem using INSERT INTO ON DUPLICATE KEY UPDATE

I have a problem using the INSERT INTO ON DUPLICATE KEY UPDATE statement which I use to upload an excel with a list of products which must be updated daily, and the sentence I use to update the ones that already exist and insert the new ones pro...
asked by 29.07.2018 / 16:47
0
answers

Flip plugin and javascript functions do not work after AJAX response

I'm using the Flip plugin to create a div for each MySQL table record and bring the results via AJAX, on the front div I show the name and on the back div I show some information. This is my code: index.html <div class="result"><...
asked by 03.08.2018 / 22:10
0
answers

How to perform a fulltext search in mysql?

You see, I know how to do it with MATCH AGAINST, but it does not recognize me numbers, for example: if I have a table: products id | product | doors 1 | Toyota car | two 2 | Corolla | 4 if the search I did outside: "car 4 doors" the...
asked by 01.08.2018 / 22:30
0
answers

How can I install the Mysqlnd library to avoid error when making inquiries through a WEB-SERVICE?

I have been looking for information in all kinds of forums and pages, including the PHP documentation, but I can not find how I can install this library, since I manage Web-Services to be able to consult my databases in Mysql but...
asked by 27.07.2018 / 23:43
0
answers

Very high Threads_created values in MYSQL base

Hello friends, a consultation. I have a PHP page which performs queries to a Mysql database, after restarting the services of my server, execute the command: show status like 'Threads%'; to my base and I obtained the following results:...
asked by 27.07.2018 / 12:51
0
answers

How to subtract hours from two columns of a jtable with mysql data

hi friends I hope you can help me! I need to subtract the hours of two columns of a table and show the result of the subtraction in another column of the table. I want to show the result in hours format, the data I bring from the database and th...
asked by 30.07.2018 / 03:27
0
answers

How to walk a pivot table?

I have a table 2 students and companies, the relationship is A student can work in many companies and a company can have many students consequently results in a pivot table student_business This pivot table has more independent additional da...
asked by 29.07.2018 / 22:12