Questions tagged as 'mysql'

Tagged questions
1
answer

How to insert excel table in mysql using php

I have a table in excel with more than 300 lines and I would like to insert the data of this table in mysql in phpmyadmin Currently php usage Thank you for your attention!     
asked by 25.03.2018 / 00:14
1
answer

Is there any way to retrieve the history of all queries executed on a MySql server?

I have a transaction in a table of a MySql database and (php + apache). I was wondering if I could retrieve (either in the apache log or in the MySql log) the ip from where the query that made this insert was generated. Any ideas?     
asked by 26.03.2018 / 22:39
1
answer

Error Code: 1136. Column count does not match value count at row 1

I am trying to insert data into a table, but I am not getting it, giving this error: "Error Code: 1136. Column count does not match value count at row 1.", does anyone know how to solve? > I've created the following table: create table pesso...
asked by 24.04.2018 / 21:14
2
answers

SUBSTRING_INDEX in mysql

I have these values in the database table, where in the field the comma gathers separates as if it were a column. The data looks like this: Id------arrachar 1 2018-04-26,Peq_Almoço,14,Almoço,12,Almoço_(Dieta),2,Lanche,14,Jantar,10,Jantar...
asked by 24.04.2018 / 13:59
1
answer

MySQL Workbench Access Denied

Good afternoon, I'm having problems with mysql workbench, it's giving permission denied, but when I enter the terminal as superuser I get access. (Access image denied in workbench) (terminalaccessimageasroot) (my.cnfcode)#TheMariaDBconfigura...
asked by 23.04.2018 / 21:49
2
answers

Calculate time difference

Hello friends, how are you? So I have the following problem that I had never solved before and I do not even know where to start. I am creating a scheduling system I have the table from above for config in this scheme I have 3 rooms, the o...
asked by 24.04.2018 / 16:40
1
answer

Best way to create a click report (PHP MySQL)

I am setting up a real estate market system where real estate developers can see the land available for construction. Then I want to record the clicks that each developer gives on any land so I can pull reports of the most clicked, which land th...
asked by 21.03.2018 / 19:08
1
answer

Trigger with sum between dates

Good Night, I need help that I can not get, I have two tables in my db. 1 - Portfolio table composed of: CREATE TABLE 'carteira' ( 'id' int(11) NOT NULL, 'datat' datetime DEFAULT NULL, 'vl_cliente' decimal(10,2) DEFAULT NULL )...
asked by 12.05.2018 / 01:01
2
answers

Formatting phones in the mysql table

I have a MYSQL table with the people record that the phones are formatted in this way. 519995150105 5133116284 51991178789 51999862438 What I need is a command that formats the phones to look like this: (51)9995150105 (51)33116284 (51)9...
asked by 17.04.2018 / 20:23
1
answer

Drag a div and drop it, save its location in the database [closed]

Hello, I have the following code: <div style="width:200px;height:200px;background-color:red"> <div style="width:20px;line-height:20px;border-radius:100%; background-color:blue">1</div> <div style="width:2...
asked by 23.03.2018 / 19:02