Questions tagged as 'mysql'

Tagged questions
1
answer

My function (js - ajax) about registering my form

Good day forum. I have a detail with my forms, to add records to my database. I have two forms that are added through ajax-php: Form 1: <form class="form-horizontal" method="post" id="addpartidaspallets" onsubmit="return altaPallets()...
asked by 02.05.2017 / 21:58
1
answer

Select Where datatables with php and Ajax

I have a system that allows you to upload documents and for each document write your comments, this part already works but I need to show the comments that were written for that document using Datatable This is my code:    Table.php Thi...
asked by 29.03.2017 / 15:36
2
answers

How to select a range between dates to avoid an SQL insert?

I have a table called etapa which has id_etapa, etapa_inicial, etapa_final ... what statement (sql) can I make to show the stages that are between the etapa_inicial and the etapa_final ? since the idea is that if the...
asked by 28.03.2017 / 15:51
2
answers

I need to update (UPDATE) the result of a select in mysql for node js and myadminphp does not accept the instruction

I am working a socket.io to update a database. The data read and served by socket.io to a file pug I want to mark with estado=1 . Initially the value is 0. I want the% co_of% to read 10 articles and be in consult...
asked by 06.04.2017 / 01:32
2
answers

Check correct UPDATE in MySql with PHP-PDO

When launching a INSERT MySql with PDO I have the same result whether the update is done or not, as long as no errors occur, ie if for example the update does not meet the conditions of WHERE will not occur. Example: $sql = "UPDATE...
asked by 29.03.2017 / 22:48
1
answer

problem error query mysql delivery null values

hello I have an sql query and when the execution happens it gives me null values I do not know why they would be able to see if there is any error, all the tables have data tables participants enrollment solo_curse generic_course...
asked by 27.03.2017 / 19:26
1
answer

change of value of a text input in insert into table

The compte field does not know why it has a maximum limit of 4294967295 . As soon as you put a higher number, e.g. 4294967296 o 9876543210 , in that field, the highest accepted number is the one said at the beginning, but acc...
asked by 03.04.2017 / 22:15
1
answer

builtins.KeyError KeyError: 'SQLALCHEMY_TRACK_MODIFICATIONS' (Flask-python)

I am a student. I've been trying to solve this error for hours and I can not find a way to do it: This is the complete error: builtins.KeyError KeyError: 'SQLALCHEMY_TRACK_MODIFICATIONS' Traceback (most recent call last) File "C:\Users\Mar...
asked by 24.03.2017 / 18:15
3
answers

Error 1064 in create table [closed]

   (1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UNSIGNED AUTO_INCREMENT, nomCognoms varchar (60) not NULL unique_key, adreca goes' at line 2 $sql...
asked by 25.03.2017 / 11:26
1
answer

SQL Error BLOB Syntax

I am using XAMPP MySQL and I have created a table to which I have named users and within it created the following: userid: INT type PRYMARY KEY AUTO_INCREMENT name: of type VARCHAR (20) photo: BLOB type When I try to save the photo in...
asked by 30.05.2017 / 00:45