Posts by Otavio Faria • 70 points

• -5

  votes

  1

  answer

  476

  views

  Q: SELECT SQL WITH WHERE "DOUBLE"

  I am trying to make a query in the Mysql database with the following syntax SELECT id, codigo, faca, descricao, vendedor, imagem FROM produtos WHERE sit = 1 AND descricao = ESTE Even that part works…

  mysql sql phpmyadmin

  asked 5 years, 10 months ago Otavio Faria 70

• 1

  votes

  1

  answer

  3159

  views

  Q: Replace in the inverted bar " " in java

  I need to take the backslash (" ") of a string, I’ve searched in several ways, but none of it worked. Please help me, follow code. f = new File(path,prefix + "_" + dataArq + "_" +…

  java

  asked 5 years, 11 months ago Otavio Faria 70

• 3

  votes

  1

  answer

  5250

  views

  A: How to increase the size of varchar in Mysql?

  ALTER TABLE "nome_tabela" MODIFY "NOME_CAMPO" varchar(60); Remembering that the table name and the field name is without quotation marks ("").

  mysql

  answered 5 years, 11 months ago Otavio Faria 70

• 1

  votes

  2

  answers

  165

  views

  Q: How to do a double "Update" in Mysql

  I am developing software in PHP/HTML/MYSQL FRONT. I need to update a table but change two columns at once. Here comes my doubt in the $gravaprat1 variable, because it is not executing the second…

  php mysql mysqli

  asked 5 years, 11 months ago Otavio Faria 70