Posts by Eduardo Oliveira • 1 point

• 0

  votes

  1

  answer

  21

  views

  A: How to define the data types of the columns of a Jtable equal to the Mysql database?

  Just use the parse. For example, you have a String variable but in the database it is int, you put: int x = Integer.parseint(String variable); so you will have a variable of the same type as your…

  java mysql jtable

  answered 4 years, 3 months ago Eduardo Oliveira 1

• 0

  votes

  2

  answers

  36

  views

  A: Consult related data without repetition

  You can use the inner join even, if you want to analyze the contracts. SELECT * FROM contrato INNER JOIN compromisso ON compromisso.codGerado = contrato.codigos WHERE compromisso.blocker = '1'; This…

  sql mysqli inner-join

  answered 4 years, 3 months ago Eduardo Oliveira 1