Questions tagged as 'mysql'

Tagged questions
2
answers

Search is not performed after connecting to the Java database

I'm trying to search the database using the code in java, but I can not. The database is connected, but the search is not performed. I created two classes, one that owns the class with the connection method, and the other, which is the main one....
asked by 27.07.2018 / 16:02
2
answers

How to do MYSQL and PHP query using an array as pro condition WHERE

I am making a query in MYSQL that brings the emails that were sent. These emails are in the emails column, separated by commas, as in the emails table sent below. emailsenviados IDenvio|emails 1 |[email protected],[email protected],[email protected] 2 |[email protected]...
asked by 16.07.2018 / 21:48
2
answers

PDF view in browser

I'm researching a way to view PDF file in the browser and print it all over the web (This action will be done by the user). Someone knows some tool that works with this. I'm using PHP and MySQL in my project. My intention is that you look simila...
asked by 07.03.2014 / 13:06
2
answers

Auto increment ID value

In my MySQL Workbench I have 4 tables with the auto increment id. But when I fill in the form it adds non-consecutive values. For example: I fill in a form for the first time and the ID it puts me is 3. I want the Id to be followed....
asked by 12.02.2014 / 12:28
3
answers

Get the structure of a table through a query

Through PHPMyAdmin, by accessing a table, we can see the structure of the table in the structure tab that lists the fields, the types of data that each accepts, among other information. How can I get through a query the details of...
asked by 11.03.2014 / 19:32
1
answer

How to make a unique field for each foreign key?

I am studying mysql and I came across the following situation and would like to know if there is a solution structuring my tables to solve this. Assuming I have two tables; user (id, user, password) and annotations (id, title, text, userid). In...
asked by 06.06.2018 / 18:13
2
answers

Add multiple products to a single package mysql

Good afternoon I have two tables encomenda and prod_encomenda . My goal is to assign a order multiple products. Both contain id_encomenda , so I assume that the structure of the tables is well done! What I mean exactly is...
asked by 12.06.2018 / 15:57
1
answer

MySQL table with datetime field, how to know how many days have passed?

Hello, I have a table where the following fields exist. prod_id [int 11] prod_nome [varchar 100] prod_desc [textarea] prod_valor [double 10,2] prod_data_cadastro [datetime] I need to create a SELECT that shows the time that passed to the...
asked by 29.04.2018 / 05:49
1
answer

Filtering data in mysql

I have a table called tb_codigos containing the following columns: cod , txt1 , txt2 I need to add the number of characters in the two columns txt1 and txt2 , in the example below the character size is 6, when I try to filter all the...
asked by 23.04.2018 / 19:34
1
answer

How to show the record that was most repeated in the MYSQL table?

For example, if I did a record of John about 5 times (that is, I did 5 records of John) and then I registered other names normally, without repeating anything, I wanted to know how to give a select showing the name of John, since he was the one...
asked by 02.05.2018 / 00:39