Questions tagged as 'mysql'

Tagged questions
0
answers

Insert Error: Incorrect integer value 'EXAMPLE' for column 'id_example' at row 1

I am trying to insert into my mySQL database through Visual Studio 2017 - C # (localhost-wamppserver) but it is giving error. The first column of the records table is the record_id which is the primary key of the records table and is auto_inc...
asked by 01.06.2018 / 11:48
0
answers

How to send data from the combobox to a DBMS sql server? [closed]

I have an application where one of the forms contains a comboBox with data filled from the Item (Collection) property. How to send data that is in this comboBox to a sql server database?     
asked by 01.06.2018 / 10:25
0
answers

Google chart - Treemap does not appear

Hello, I'm trying to plot a treemap with data coming from a BD (mysql), but nothing appears. I have tried several alternatives and to no avail. I already managed to plot several graphs, except the treemap, I believe that the problem is in the cr...
asked by 01.06.2018 / 14:24
4
answers

How to create a real-time notification system similar to Stack Overflow?

I am developing a Help Desk system, and would like some ideas on how to create a notification system similar to Stack Overflow itself, whenever any new support is registered. I want to use PHP, MySQL and jQuery only. Should I use window...
asked by 16.03.2014 / 20:21
0
answers

Execution time estimate - Select

I'm running some performance tests on my DB using MySQL, and I was left with the following question. Is there any way to predict how long it will take to run a MySQL query after it starts running? I noticed that in Client Connections I g...
asked by 16.05.2018 / 13:31
1
answer

Subquery returns more than one value

When performing an update within a procedure, the message appears saying that the comparison subquery brings more than one result. The subquery has been tested and only returns one result since it searches for the Exam id and this is unique for...
asked by 13.05.2018 / 16:37
1
answer

Doubt about highcharts and php

For styling a web page, I often use the highcharts graphics with information from a mysql database via php. For those unfamiliar with highcharts, here's a sample code below. Highcharts.chart('minhadiv', { chart: { type: 'bar' }, xAxis: {...
asked by 24.05.2018 / 13:17
0
answers

Duplication of values when importing .csv file when there is one or more column (s) missing in the file

When I import a .csv file to save to the database and the file is missing the name of some column instead of inserting null in the database, it repeats the value of the first column. Here's an example; $sourcePath = $_FILES['fileTabelaTes...
asked by 24.05.2018 / 22:37
0
answers

How to minimize mysql migration problems 4 to 5

Good evening guys, I have a system that was developed last year for a client. The client hired a server and the staff installed mysql 5 on it. The problem now that I'm in is that field int and date that are empty in the registration query of...
asked by 08.05.2018 / 03:26
1
answer

How do I get the location of a bookmark and save it to the database using google map?

I have a marker on my map, it is "draggable", I would like to know how I can find the latitude and longitude of this marker, and later store it in the database. I have read the documentation of google map api but have not found how to do this...
asked by 08.05.2018 / 19:16