Questions tagged as 'mysql'

Tagged questions
2
answers

Sort database records in VARCHAR with semicolons

How can I sort records from saved databases like VARCHAR . I tried the code below without success. How can I format to get the expected order? SELECT *, CAST(representantes_vendas.valor AS INT) FROM representantes_vendas INNER JOIN represe...
asked by 09.04.2018 / 14:42
1
answer

Query Database between tables

Database has 4 tables tabela 1 |escola|descricao| tabela 2 |matricula|nome|estado| tabela 3 |matricula|escola|posicao| tabela 4 |matricula|diretor|nome I need to do a search by state (in table 2) and return the results:    Enrollment,...
asked by 09.04.2018 / 17:08
2
answers

Create links with one name of a mysql table and display its contents on another page. It's possible?

I'm trying to create a page in php that will fetch the name of several tables from a database, show the names of the tables, and create a link for each table. As soon as the user clicks the link, it is taken to another page where the contents of...
asked by 13.07.2014 / 19:37
2
answers

Regex in MySQL to fetch certain results from X time

I have a field in the table set to DATE and the data is saved in this field as follows: year-month-day hour: minute: second Exemplo: 2014/04/22 18:32:00 I need to develop a query that returns me only given year / day / month. A scheme:...
asked by 27.04.2014 / 18:39
1
answer

How to relate the same table without conflict?

I have a user table, and a tanned table. The tanned table has: usuario_curtido and usuario_curtiu . When I run select u.usuario_nome from usuarios u JOIN te_curtidas_usuarios c ON c.curtida_usuario_curtido = u.usuario_id ORDER...
asked by 14.03.2018 / 05:31
2
answers

Convert HTML5 table + images to CSV or SQL

I have a big problem! I have basically 1 million and a half records including images in an HTML5 table (it starts right there, the browser does not render all the images). My idea was to convert this table to CSV, and thus play to a MySQL...
asked by 19.10.2017 / 07:34
2
answers

Random Card Deck

I'm creating a site for people playing cards with php. I would like to know how to create a deck of 50 cards for each person. In the database I have a table with 300 different cards and of these 300 cards I want the user to register generate 50...
asked by 26.08.2017 / 01:18
1
answer

Highchart chart that imports the table values from the database

I have a system where students are enrolled in training classes, every registered student is "scheduled" to attend and when he / she attends, in addition he / What I want is to make a chart using Highcharts that compares the number of students...
asked by 13.09.2017 / 16:12
1
answer

Put 00 on the left in another variable [duplicate]

I have an HTML form that receives the number according to the ID registered in SQL and saved in another variable, however the ID is sequential and without zero, for example: ID 1 ID 2 ID 3 I needed to get this ID and put it in the Number...
asked by 11.09.2017 / 22:54
3
answers

Get data that is not in the [duplicate] table

In Mysql I have a login table, which shows who logged in to the system: id | cod_user After the website is ready and working, the client has passed me a list of cod_usuario that CAN log into the system, so I created a table can and d...
asked by 13.04.2018 / 16:10