Questions tagged as 'mysql'

1
answer

MYSQL to POSTGRESQL via SED

I'm looking for a way to migrate my backup from a MySQL database to Postgresql. The simplest way I found was by using sed on top of the backup, but it did not work. It was as follows: 1 - Performing a backup 2 - Running the command s...
asked by 13.10.2016 / 18:39
3
answers

Variable Title PHP

Good afternoon, I'm trying to leave each page with a different title picking based on the id. I have to tell you that I'm a good beginner in the field and probably should not be anything special, my code looks like this: <?php include '...
asked by 11.10.2016 / 19:09
1
answer

Change date to commercial date (MySQL)

I need to change the Date of my database, considering the Business Date used in the company I work for. Here, a business month is between 26/M-1/AAAA and 25/M/AAAA . Where M-1: last month. For example, today the trade date is...
asked by 04.09.2017 / 21:31
3
answers

Select in each answer different values with the Bank MySql

I would like to know how to select the number of records in a table where only values greater than 6 are selected, but in each result it would be different with the MySql database, for example: Tabela Notas Unidade I | Unidade II | Uni...
asked by 02.09.2017 / 18:34
1
answer

Table with 2 td with select inputs displaying return only on the first line

I have 1 table with 1 list of modules, and I have 2 columns that have some options that can be chosen through select.   The issue is that the select's only loads the data in the first row of the table, the next comes out blank, I think that's t...
asked by 06.09.2017 / 06:03
1
answer

Google Chats: Show total above column and grid show 1 to 1

I have the following chart: Ineedtodisplaythelinesfrom1to1anddisplaythenumberalsoofthetotalatthetopofthecolumn.Iknowthatbothwillgivethesameresult,andthatIhave2differentsituations,becausein1caseIhavetoshowthetotalandintheotherchangetheamounto...
asked by 20.09.2016 / 01:19
1
answer

"Error: Can not issue data manipulation statements with executeQuery ()" no Select

Doing the method to select all data from a table, however it is returning me error. console: Open bench. java.sql.SQLException: No value specified for parameter 1 No value specified for parameter 1 at com.mysql.jdbc.SQLError.createSQL...
asked by 23.09.2016 / 10:27
1
answer

Rollback transaction does not work as expected

I've recently been implementing a request sequence in Visual Basics, and would like to rollback when some fail. So I did the following: Public Class DAO Dim connection As New MysqlConnection Dim command As New MySqlCommand Dim dr A...
asked by 18.01.2017 / 19:55
2
answers

UPDATE on multiple tables with the same column?

Let's imagine a scenario where I need to give a update in 10 different tables in the same column in all of them updating a given data, will the syntax below work? UPDATE tab1, tab2, tab3... SET id_usuario = 'novo id' WHERE id_usuario =...
asked by 12.01.2017 / 12:32
1
answer

I can not assign a database value to a php variable

Hello everyone, I'm new to php and I'm having a hard time getting a user table (id, login, password, level) according to the level of the user should go to a different panel, the login part is ok, only the level value I can not assign to a varia...
asked by 23.08.2016 / 05:55