I'm working on a system where I'm going to import data from an Excel. Since these data will be temporary, I want to save the information for this imported column in JSON format in the database.
So, I was in doubt about using TEXT or...
When I run this code in MariaDB, it gives me this error when trying to create the toy table:
ERROR 1709 (HY000): Index column size too large. The maximum column
size is 767 bytes.
I do not know how to fix, MariaDB has already install...
Is there a way I can assign something to a column in MySQL so that when I perform the query I select them?
SELECT filtro_1,filtro_2,filtro_3 FROM filtros
But if the table is changed (like adding a new filter, now the filtro_4...
In a PHP system that communicates with BD (MySQL) to retrieve the information and return it to the user who accesses it, is it necessary to establish multiple connections with the Bank? Or just one?
What size of a large query ? I need to make a function to send query to the server but I can not exceed the limit to not crash the server:
public function sqlExecute($sql_code) {
if ($sql_code != "" && strlen($sql_code) &...
SELECT COUNT(*) AS contador, hora_efetivada FROM minha_tabela WHERE status=2
I have a counter that returns the total value of status 2 in the database, but in my column named hora_efetivada there are several times. How do I make...
I'd like to be able to limit the display of news that I've written to my banco de dados to 30 days from today's date, for example:
Show registered news from 03/02/2016 to 02/01/2016 , I tried to use some solutions that I f...
A funeral home asked me to do a simple customer registration scheme for them.
A customer can have several dependents who benefit from his or her contracted plan if he or she is killed. I am in doubt as to the data model. I could create two ta...
I could get a code on the internet paste here and try an answer but I'd rather have it help me with the logic and programming of a script to upload images in Ajax. I do not know how to start, I'm a beginner but I already know some things about j...
I hypothetically have a publicação table that has, by default, the autores attributes (derived from a relationship table), titulo , edição , editora and ano . However, depending on the type of publication (...