I need to export a mysql database to excel, the problem is that the file has 1,200,000 records and excel only supports 1,048,576. How to do this export via command line and separating in tabs to be supported in excel?
I'm trying to make a login screen with the following attributes
If Login and password are the same as the typed data
enter another if
If the ADM (database) attribute is equal to "s" you should open the Main menu if not the meniPrincipa...
I have 3 Tables
Vehicles
idVeiculo | Placa | Prefixo
oleomotor
idMotor | idVeiculo | datatroca | kmtroca | horimetroca | proximatroca |idMecanico
I have this query below that shows the result of the last changes of each vehicle...
How to correctly subtract these two columns in the SQL script?
SELECT DISTINCT b.prefixo as idVeiculo,
max(datatroca) as datatroca,
max(kmtroca) as kmtroca,
max(horimetroca) as horimetroca,...
Hello,
I needed to take on the development of a servlet that was in someone else's hands. The same is contained in a Tomcat server and must connect to a MySql database to store data of users registered in their forms.
The problem is that I...
I'm creating a rest app using Springboot, JPA and as Mysql database. It works fine but it has something strange when I enter the database.
I used the Workbench to create the relational entity diagram above the schema generated by JPA, but it...
Next, I'm having a form here while filling it up using PHP to validate the data and save it to the MySql database. However, I type the normal date and when I view the table of saved data, the date is the only date that is left undisturbed. Someo...
I'm creating a simple php login page based on in this video .
However, after doing exactly as the video describes, I learned that my PHP version has updated and can not use the command mysql_connect .
<?php
// Get values passe from f...
Well, I'm developing a search field for an application where the user types an address or name of an establishment and the system dynamically returns the results, but in the results it is necessary to return the distance between the user and the...