Questions tagged as 'mysql'

Tagged questions
0
answers

Error Unknown column 'undefined' in 'where clause'

Good morning, I have a table created through java code. The table is created without any type of error, but when I go to MySQL and pulse 2 times on any cell, it shows me a popup that indicates Unknown column 'undefined' in 'where clause'...
asked by 24.02.2017 / 21:40
2
answers

results from mysql_query php use it in another query mysql_query

I'm trying to do 2 PHP queries ... basically it would be the first one: $sql = \mysql_query("SELECT * FROM tblaccounts WHERE date BETWEEN '2015-12-25 0:00:00' AND '2016-07-20 23:59:00'"); the results of this query I need to be able to us...
asked by 10.09.2016 / 09:21
1
answer

Collation problem in BD and PHP

When I execute the UPDATE statement in PHP, in order to save the changes in the database (PHPMyAdmin), the information is stored with rare characters, that is, the letter ñ or the accents are not recognized .... The ñ appears like this: years...
asked by 20.10.2016 / 07:46
3
answers

Do a query on php but I get no results

Well the problem is the following I am doing a simple query with a where within php , I already echo some more with this type of syntax and I have done well, especially in logging and inserting data, the problem is this I work with...
asked by 23.07.2016 / 19:33
1
answer

Unable to find the driver com.mysql.jdbc.jdbc2.optional.MysqlXADataSource register this driver in the databases tab

I have a pool of connections in a weblogic 12C server, the connection and the insertion of data to the database, mapping the classes manually is done normally, the problem is when I try to do it with New Entity Classes from database in netbeans...
asked by 08.03.2016 / 01:35
0
answers

Trigger multiple

I am doing a trigger with multiple if, there is one that executes a before and an after, the problem is that the first statement is executed, the others elseif does not validate them. CREATE TRIGGER 'Trigger_SalidasTransaccion' BEFORE INSERT O...
asked by 20.04.2016 / 05:21
1
answer

list only the ads that have not been sent request

I have the following doubt, We are working on a system of classified ads, users log in and access classified ads of the company, they can send requests to the ads if they are interested (for example in the case of job vacancies). If the us...
asked by 23.05.2016 / 20:15
0
answers

Error: Data too long for column 'image' at row 1 with MySQL medium column

I am storing images that range from 1mb and maximum 7mb in a MySQL database. For this I have created a table with a field of type MEDIUMBLOB that has a capacity of 16,777,215 bytes which is the same 16mb. When I save images of up to 2.2mb it...
asked by 24.05.2016 / 01:54
2
answers

I do not take the char type in a table

I have a PHP form, I am telling you to create the following table: $sql=" CREATE TABLE auxtmp ( n_linea serial, c_concepto_mov char(2) not null, c_almacen_origen smallint default 0 not null, c_alma...
asked by 19.05.2016 / 20:12
3
answers

How to get the number of subsequent records in sql statement?

I have a table where I keep comments on topics: Id, id_tema, id_autor, comentario, fecha I need to ask a question that returns the number of comments after a certain comment on the same topic. The data I have is the Id of the comment, I hav...
asked by 20.11.2018 / 18:14