Questions tagged as 'mysql'

Tagged questions
0
answers

how can I make a trigger for 2 tables?

I'm thinking about making triggers that save when there is insert in 2 tables, I mean I have this table: --- tbl_cliente --- Cod_Cli mail password First name Surname age birth date and I have this other table --- tbl_adm...
asked by 09.10.2018 / 14:59
0
answers

Enter db values of select's radio

I have a query. How can I enter the data of a set of select's radio into my database ?, I mean, I have a list of students that I need to take assistance from and the list is automatically generated along with the select's radio. $template_asi...
asked by 16.09.2018 / 20:48
2
answers

My database allows me to save different grades of the same subject in the same period

I have another question related to the database. I have the following relational database for rating control. However, I have a problem in the PeriodicPeriod table, which is that it is allowing me to place different grades for the same subject...
asked by 15.09.2018 / 03:14
0
answers

Error in LOAD DATA INFILE in Python3.4?

I have the following script in python3.4 to insert data into a MySQL table: import pymysql connection = pymysql.connect(host='localhost',user='root',password='',db='bd',charset='utf8mb4',cursorclass=pymysql.cursors.DictCursor) cur...
asked by 18.09.2018 / 02:59
1
answer

Extract coordinates of an address with the Google Maps API

I'm building a map with custom markers taken from a MySQL database I have the following var in js with different coordinates var locations = [ {lat: 41.641581, lng: -4.780962}, {lat: 41.681581, lng: -4.740961},...
asked by 14.09.2018 / 08:07
0
answers

rewriting Mysql fields or fields to null

I have a hosting in Godaddy of unlimited space with a MySQL database in MyISAM for my application. The bbdd has a weight of 280.4Mb and one of the tables contains 120713 records. For some time now some of these fields in this table are being...
asked by 14.09.2018 / 17:41
1
answer

connection to mysql remote (local network) does not work

My application must be connected to MySQL that resides on a computer in my local network, with static IP. In the connection string of my class conexion I put the IP of that computer, but it is impossible to connect. I have my chain...
asked by 14.09.2018 / 15:26
1
answer

use while cycle data in a query outside the cycle

Hello everyone is a bit I understand the title sorry, if what I want is to use a data I get from a query of a while while in another query I'm doing within the same php document this is my while cycle <?php...
asked by 13.09.2018 / 21:28
1
answer

Sort registration of a MySQL query

I have the following table which I get from another database of a clock checker. idemployee fecha 1 '2018-09-10 8:56:00' 2 '2018-09-10 8:58:23' 1 '2018-09-10 14:00:23' 1 '2018-09...
asked by 22.09.2018 / 17:54
1
answer

how can I do a SELECT * FROM WHILE with a PHP Array?

I have a query ... I have in a table called coins a field called Prefix and in another table called directories I have a field where I keep the word DEL ie What I want is to show in a select-box is, first to unfold country and city, and...
asked by 22.09.2018 / 20:15