Questions tagged as 'mysql'

Tagged questions
1
answer

Record data once a month (Php mysql)

Hi, I'm doing a php application with Codeigniter and mysql. And I have a table in which you should do a single insert once a month, that is, if until today you have not registered anything you should let me do the insert, otherwise you should no...
asked by 16.03.2017 / 14:09
5
answers

The form that is inside a while is saved twice in the database

The form I have it in a while loop within an echo to be able to resivir the data of a query and then with a form send it to another table in the database but it is saved twice as I can do so that they are saved just one time? <?php //Mo...
asked by 18.03.2017 / 21:38
1
answer

Magento 2 migration tool without client attributes

I have a problem migrating the data from magento 1.7.xx to magento 2.1.x which is to ignore some attributes of the client such as the cedula, in the table eav_attribute this is the data that I want to ignore, (the following image is from the mag...
asked by 23.03.2017 / 17:00
1
answer

Why is not the employee registered in mysql from php?

I have this form to register an employee: <!DOCTYPE html> <html> <head> <meta charset="utf-8"> <link rel="stylesheet" href="EstiloEmpleados.Css"> <style media="screen"> .enviar{ margi...
asked by 11.05.2017 / 04:01
1
answer

Permissions in MySQL

Good afternoon, I am configuring MySQL on a server by directAdmin. My problem is that I create a user and I want him to see only 5 tables of N that the database has. If someone could give me a serious solution, it would be very helpful....
asked by 18.04.2017 / 17:20
0
answers

query distinct mysql

I have two tables: students (student_id, id_carrera, nro_doc ... rterc, eterc) PK (student_id, id_carrera). debts (rterc, eterc, date_of_voice, number_of_voice, amount, expiration ...) The table does not have debts. The field eterc is e...
asked by 18.04.2017 / 16:57
0
answers

Help when deleting a record with ajax and php

I have a CRUD but instead of users they are all managed with Ajax . The issue is that the update create works but in delete that is exactly the same as the others do not. Step to hang in code: $('#deleteUser').click(function() { if(...
asked by 19.04.2017 / 09:52
1
answer

Function of Php inserted in MySql only when the table is empty

Hi, I have the following php function that when calling it makes a call to a MySql process. The problem is that it only inserts the data when the table is empty. I am using Xampp, if I call the process directly from PhpMyAdmin there is no proble...
asked by 25.04.2017 / 21:17
1
answer

How to make a connection to MySql?

I'm doing an application that inserts an excel sheet to a table in MySQL, the application is inserting the data well, but the error is that after inserting 149 rows I get this error "An error has been generated when setting the link to the DB.Fr...
asked by 26.04.2017 / 15:56
1
answer

Export dump data from Oracle to MySQL / PostgreSQL

I'm looking for the right way to export a Oracle g10 database from 16 gigas to MySQL and / or PostgreSQL em>. I say export because I want to have the new data dump formatted for MySQL / PostgreSQL and then do the migration. Mai...
asked by 11.03.2017 / 13:18