Questions tagged as 'mysql'

Tagged questions
1
answer

How to import firebird data into mysql?

How to import data from Firebird to Mysql using PHP ?     
asked by 18.06.2014 / 13:44
1
answer

Export MySQL database to SQLite

I usually use a database in applications that I develop locally. With mysql whenever I need to clone the application to another machine, I need to generate a dump of the database and import it to the local database again. I thin...
asked by 05.02.2014 / 17:57
1
answer

Error when deploying on Wildfly

I'm getting an error while trying to deploy my application on Wildfly 8:    Caused by: org.jboss.as.server.deployment.DeploymentUnitProcessingException: JBAS011445: Failed to get adapter for persistence provider 'org.hibernate.jpa.HibernatePe...
asked by 10.02.2014 / 19:15
1
answer

List the last users logged in (GROUP BY AND ORDER BY)

I have two tables ( user and log ), and would like to list the users by sorting by the last logged in. I'm using GROUP BY to join the logs (since a user can have more than one). The problem occurs when I add the ORDER BY , return...
asked by 23.04.2017 / 15:52
2
answers

Is it possible to do an INSERT and an UPDATE in the same query in java?

I would like to know if it is possible to make a INSERT and a UPDATE in the same query, that is, in the same operation. I'm using the following to do both. public Connection conn = null; ... conn = DriverManager.getConnection...
asked by 13.01.2017 / 01:16
1
answer

Automatic backup with MySQL [duplicate]

Is it possible to perform automatic backup in mysql? Example: I target a folder which Mysql will generate every day at 6:00 PM the database backup.     
asked by 21.08.2017 / 20:34
2
answers

How to check if a date is already in the correct format in php?

I'm getting a date in form and in firefox the DATE field behaves like a normal text field. Hi, I have a date in the format dd/mm/yyyy , so I have a function that converts this date to save in MariaDB (MySql). The problem is that in chrome...
asked by 11.08.2017 / 15:25
1
answer

Accessing SQL Server 2008 data from MySQL

Does anyone know if I can access data from a SQL Server 2008 database from a MySQL database? It would be something like Linked Server, but otherwise.     
asked by 11.09.2017 / 19:35
2
answers

Select values that are not in another table

My scenario is as follows: Row Table IhavetheActivitytable I need to mount a select, taking the values from the queue table, but I need to exclude from the queue the values that already exist in the activity table. If in the activi...
asked by 28.10.2017 / 15:28
2
answers

Returning linked data

With the help of Milrak Pereira Pessoa and Wéllingthon M. de Souza, I edited my code ... I have a product code and it has 5 types and 5 descriptions. I'm trying to bring to the user the types and descriptions within the blank table. However, the...
asked by 20.10.2017 / 21:47