I have a question that has brought me various incompatibilities. With the evolution of PHP and Mysql, more recent versions have appeared, this way the Mysqli. This is where my problem resides, I would like to know which is the correct way to con...
I'm developing a C # application, and I need to know if I can build the database to install with the application, I've already seen something here about SQLite, but I do not know the tool and I do not know if it stores images, my case will have...
I was used to using SQL for web projects, always using MySQL.
One day I had to write a C ++ program that used databases. At first I chose SQLite but needed other computers on the network to connect to the database.
So I opted for PostgreSQ...
This is the following I have a search field on a form where the user types for example a color or product and is returned to it a list of products with the characteristics typed in the form, the problem and the following, when I pass the array i...
I already have a local server on my machine (localhost) with MySQL running normally. From there, I would like to connect my database with Java, but ... how do I do this? Is there a Swing component that displays the fields of a given MySQL table?...
Is it a good practice to create a table to record all the images in a database, or can I create the columns that save the image information for each specific need?
For example, let's suppose I want to create a table for categories of a websit...
Hello, directly asking, how does this type of field work?
I know there are three types:
BLOB = 64KB, MEDIUMBLOB = 16MB and LONGBLOB = 4GB
Given this example:
CREATE TABLE COMPROMISSOS (
ID INTEGER NOT NULL,
DESCRICAO...
Currently, to export only the structure of a particular database, I use the following:
mysqldump -h host -u usuario --no-data --database banco > dump.sql -psenha
This generates an SQL file, all solved. However, this is a manual process t...
We often see in multithreaded applications that use a connection to a database, the use of a connection polling , in which it stores a pool of open connections. way to increase performance so that you do not have to open connections at all time...