Questions tagged as 'mysql'

Tagged questions
1
answer

Array with Mysql

I'm trying to make a music draw but it always displays the last song registered in the database $sql = "SELECT nome FROM CadMusicas"; $result = mysql_query($sql, $conecta); while($consulta = mysql_fetch_array($result)) { $antigos= arra...
asked by 26.04.2016 / 18:57
1
answer

Merge, in table in mysql

I'm not good at describing, so I'll leave an example. I have this structure. CREATE TABLE IF NOT EXISTS 'Teste' ( 'ID' int(11) NOT NULL AUTO_INCREMENT, 'Var_1' varchar(255) NOT NULL, 'Var_3' varchar(255) NOT NULL, 'Var_5' varchar(25...
asked by 03.04.2016 / 03:27
0
answers

Php + Mysql does not perform deletion or table change

Good afternoon, I'm trying to make a page execute the deletion of specific records in a given table from a Mysql database. In another table, this deletion and also the change work perfectly, but in that the values of the table are not present...
asked by 03.04.2016 / 23:22
0
answers

Query MySQL Same Column Different Parameters

Oops, simple thing, I have a test table, organ and state tables teste = 'teste_estado_id_1' 'teste_estado_id_2' 'orgao_id' orgao = 'orgao_id' estado = 'estado_id' In an exact query, connect the test table with its two...
asked by 02.04.2016 / 21:12
0
answers

I am having problems with my method of updating in the java application, it does not update in the bank

public Boolean alterar(Exemplo exemplor){ Boolean retorno = false; String qry = "update funcionario set nome = ?,rg = ?,orgaoExped = ?,dataExped = ?,dataDeNascimento = ?,email = ?,estadoCivil = ?,sexo = ?,cnh = ?,titulo = ?,"...
asked by 14.04.2016 / 20:32
1
answer

Problem with Mysql connector in rails

I am not able to create a database for my Rails application it says the following message: Error    C: \ Ruby21-x64 \ DevKit \ Project> rake db: create DL is deprecated, please   use Fiddle rake aborted! LoadError: Please install the mys...
asked by 01.04.2016 / 01:18
2
answers

Insert multiple records of a form

I'm trying to make a multiple insert into the database via $ _POST but the result is not as expected <form name="formulario" method="post" enctype="multipart/form-data" action=""> <input name="texto" type="text"/> <...
asked by 29.04.2016 / 06:18
1
answer

Unwanted loop behavior mysql_fetch_assoc

I'm having problems in a while loop where it has a mysql_fetch_assoc function that retrieves a value from a column in a table called requests in the delivered column. I made a if to see if it has a yes' s' in the column that was...
asked by 28.04.2016 / 21:02
1
answer

Error in the data update method next to the bank

I am using MySQL and Java in netbeans, however the SQL string code does not update. I do not know what might be giving error, because I already checked the sql and apparently it is ok. I have in my class DAO , method update...
asked by 04.04.2016 / 22:57
1
answer

How to increment the code field of type varchar () automatically in MySQL?

I need to do a stock control, where the product code should be varchar , because the code will be formed by the short name of the product category followed by a sequential number, so I will not use the product_ID column that is i...
asked by 13.04.2016 / 02:11