Questions tagged as 'mysql'

Tagged questions
0
answers

SGBD Setting all columns notnull automaticallyamene

Is there any configuration in sgbd that forces the bank to set all the columns of a table as notnull? Whenever I import some database or create a table in my DB, all columns are not null. I would like to resolve this.     
asked by 30.09.2015 / 19:47
1
answer

Delete a specific ID entered as serialize in a column in MySQL

In my db, I have a column called Range_ids , which inserts IDs using the serialize function. These IDs stay as an array, the problem is how I can make a DELETE of the specific ID within the column. //Usando a função seriali...
asked by 23.10.2015 / 03:50
0
answers

How to insert data into two different tables with the same form?

I have a dynamic form in which the questions come from a database table, some questions have multiple choice answers that also come from the database. but other questions are text. When submitting, I needed the multiple choice response to go to...
asked by 23.10.2015 / 12:49
0
answers

How to change image upload code to work in mysql?

I got this code to upload image to work in PostgreSQL, but I would like to change it to work in phpMyAdmin, but I'm finding a certain difficulty, and I'd like to count on the help of friends. The code looks like this: //Instancia a clase pa...
asked by 09.09.2015 / 23:41
2
answers

Search with date range [duplicate]

In MySQL I have a table that has two DATE fields: data_inicial and data_final . In the System I have a Field (TextField) where I type a date. This date does not need to be accurate, but rather matches the range. Example:...
asked by 05.10.2015 / 23:05
0
answers

Generate table in PHP with specific data for MySQL

I have a table in a MySQL database, and I need to generate a table with PHP, but it is not a trivial table. My table has the following fields: codigo , item , preco and quantidade . I need to generate a table where for e...
asked by 05.10.2015 / 20:07
0
answers

show similar product / property with php and mysql

I'm developing a feature on my site to show similar properties by title and valo9r, but my idea did not work: <?php //Armazeno o resultado do titulo da consulta anterior da tabela imoveis em um variável $titulo_semelhante = $results['titulo...
asked by 25.08.2015 / 19:20
0
answers

Plugin Bootstrap Typeahead + PHP and MySQL

I'm trying to use Bootstrap's auto-complete Typeahead feature for a few days with this plugin: biggora / bootstrap-ajax-typeahead . After searching a lot, I found only vague answers, but nothing conclusive about how to use this plugin looking f...
asked by 12.09.2015 / 20:48
2
answers

How to get more than one bank category in the same table

I'm developing a system for watching movies online and wanted to know how do I make movies that are in 2 categories listed in both categories. I'm getting to list only at first ... could anyone help? I have the movie table on my system and th...
asked by 26.08.2015 / 04:13
1
answer

Query with two summations for the same column

Is it possible to do a query where two sums are executed on the same column in the same query? What I have is the following: Total sales sum select month(emitido_date) as mes, ifnull(sum((det.preco * det.quantidade) * (iva.valor/100) +...
asked by 11.08.2015 / 10:33