Questions tagged as 'mysql'

Tagged questions
0
answers

Error inserting into the database

I'm getting an error while trying to insert into the database. See below. <?php define("CMD_CRIAR_POST", 0); define("CMD_BUSCAR_POSTS", 1); define("CMD_EDITAR_POST", 2); define("CMD_EXCLUIR_POST", 3); define("CMD_...
asked by 03.05.2016 / 02:22
1
answer

Comparison of data

My scenario : I got a code on the internet that does the OpenVPN log parser and plays it in the database to play a table on an html page. The output looks something like this: link This parser parses a log file that has all clients logged in....
asked by 25.05.2016 / 17:00
0
answers

Button loads all instead of filtering by group

I have a problem, where if I press the button to load more blocks through the database, it will load all in the order of the ID, however if I have some filter it continues loading all instead of just that filter and every time I press it to load...
asked by 24.05.2016 / 22:32
1
answer

How to get LAST_INSERT_ID () from a mysqli_multi_query () function with SET and INSERT?

This is my 'method' of Placing Bets on my betting system. In this method, I register data in two tables, a BET call and another BET_MATCHES, the system is controlled by time, so in all the registers I need to set the TIME_ZONE = '-03: 00' to...
asked by 24.05.2016 / 21:06
1
answer

backup mysql specific content data via java

Hello, I have the following method that backs up my database: public static void makeBackup() throws IOException{ String caminho = "C:\Program Files\MySQL\MySQL Workbench 6.3 CE\mysqldump.exe"; ProcessBuilder pb = new ProcessBuilder(ca...
asked by 25.05.2016 / 15:40
0
answers

Search in MySQL with FULLTEXT IN BOOLEAN MODE including the keyword operators?

How to make a query through the query MATCH (column1, column2) AGAINST ('keyword' IN BOOLEAN MODE) in an InnoDB table with two fields indexed by FULLTEXT, including the operators that are in the word being searched? Understand: SELECT * FRO...
asked by 23.04.2016 / 04:35
0
answers

Get Table Id generated by setFetchMode (PDO :: FETCH_ASSOC)

Good afternoon friends, I'm trying to generate a link by sending a parameter that would be the row ID of the clicked table <a href="page?id=echo'.rows['id'].'">Editar</a> This code works in mysqli and mymsql without any problems...
asked by 28.05.2016 / 21:44
1
answer

update blank column with mysql php

I need to update on a table but only on the columns that are blank and not all, just a specific number. For example, having this table: col1 col2 col3 col4 col5 col6 col7 id1 val1 val2 id2 val1 id3 I want to update id1, id2, id3 in 2...
asked by 30.05.2016 / 18:06
0
answers

Problems with User Session in PHP

I have a system of bets, in this system I have dealers to sell the bets, and they earn commission for it. The problem is: When many resellers are online selling and posting bets on the system, at some point the dealer's betting line 1 is regi...
asked by 22.06.2016 / 16:23
2
answers

What version of the MySql connector on Azure?

I'm starting with the Azure platform and I was testing a web api in Asp.Net with EF6 and MySql, however when I upload the application to the Azure server and try to call a service that queries my database, it returns a page from MySql connector...
asked by 18.04.2016 / 14:04