Questions tagged as 'mysql'

Tagged questions
1
answer

Doubt to use the combobox

Good morning, I have a final work of the web development chair, where I need to create a crud for teams, players, create a Brazilian championship style table and create the rounds. I already managed to create the cruds and the table of the ch...
asked by 09.06.2016 / 14:18
1
answer

PHP How to get a random value like in rand ($ min, $ max) but with a query?

For example, in a browser game I want the user to click on attack to return another user who has + - the same battle power as he. $select = $mysqli->query("select * from data order by rand()"); This way it always returns a random value,...
asked by 06.06.2016 / 04:28
1
answer

Error Data Report Group Footer VB6

Oops! I need to add one more field in a vb6 report report as in the image The connection to the bank is done via ODBC Driver 5.1 with MySQL database. I use this SQL for report generation: SELECT *, venda.TotalS AS total_venda_agrup...
asked by 30.03.2016 / 17:25
2
answers

Select from all companies that have catalogs

I'm having a problem with a select in two tables that are returning the value twice. I have the companies table and table catalogs that are linked by company.id and catalogs.id_enterprise . When I make a select that has two...
asked by 18.05.2016 / 15:29
2
answers

Questions to send data via POST

Hello, I'm trying to send via $ _POST some data for validation and subsequent insertion into the database, which I could do in another project the exact way I'm trying to do it now, but I'm not getting it. This is the code for my Form: <...
asked by 08.07.2016 / 01:00
2
answers

How to concatenate columns from different tables?

Hello, I'm having this code and I'm trying to make an adaptation to use it, but I'm having trouble bringing the contents of the edit column of the quant_img table, but I'm not sure how. Friends could give me a light of how I can do !!!! Below...
asked by 24.03.2016 / 00:37
1
answer

Java Desktop with Mysql Bank

I'm trying to write an image to the MySql database, the table is just below, the code to load the image is right after that, I'm using a button to load a JLabel, after that I use another button to insert the image image in the database, just bel...
asked by 23.03.2016 / 18:54
1
answer

MySQL migration to Mariadb

I have a MySQL server that has several banks; some gigantic. I've been studying and seen that various services migrated from MySQL to MariaDB. As this is a fork, could I simply migrate this data from one server to another or should I take some p...
asked by 14.03.2016 / 14:45
1
answer

Query Query MySQL

I have a small question and difficulty in trying to solve my problem, I have the following query: SELECT 'PcldCliente'.'id', 'PcldCliente'.'nome', 'PcldCliente'.'agencia_id', 'PcldMain'.'id', 'PcldMain'.'cliente_id', 'PcldMain'.'sa...
asked by 14.03.2016 / 14:19
2
answers

Is there a difference between connecting to the bank using a class and through visual studio: ToolsConect_to_database? [closed]

I'm learning C # and would like to know if there is a difference between the two connection types mentioned in the title. If so, which ones?     
asked by 20.03.2016 / 20:09