Questions tagged as 'mysql'

Tagged questions
1
answer

SQL command in MYSQL

I'm creating a DBA and I need to do a CHECK on an index of my produto table, but I'm using MySQL and am having a syntax problem. Follow the example: CREATE TABLE produto( Cod_produto int primary key not null, nome_produto varchar(5...
asked by 25.08.2017 / 15:41
2
answers

Polite select component on html page with data coming from table

I have a php variable that has its value. ex: "AREA 05" This is displayed in the input. I have a table that is related to the logins according to these areas. How do I and if it is possible to use this php variable to popular the html sele...
asked by 11.10.2018 / 15:26
1
answer

Problems with phpMyAdmin UolHost [duplicate]

I have a site in the host uol and a database as well, the site communicates perfectly with mySql, but I have a desktop software that I need to communicate with mySql also, is there any configuration that I need to adjust so that mySql allow th...
asked by 20.12.2017 / 01:41
1
answer

How to recover tables from MySQL database with corrupted operating system?

I had a site installed on apache with windows server 2016, gave a problem in which the system was corrupted, but the files are la, the backup I have from the bank and a week ago, only in a week I I had worked on a lot of things, many hours of wo...
asked by 07.02.2018 / 00:57
1
answer

Table with variable size in HTML [closed]

I need an HTML table to be fed by a database but the amount of data is variable. The number of columns is fixed however the number of rows can vary. The table must match the volume of data provided by the database. The user just selects from whi...
asked by 02.02.2018 / 11:29
1
answer

UTF-8 Charset error when returning from database

My system has a charset error, but it is only with the data returned from the database. My charset in the HTML is right, the database is also right, and php.ini is also right. How do I solve the problem? Special characters are returnin...
asked by 25.09.2015 / 16:53
1
answer

linking a mysql database to android [closed]

I'm looking for a free host, where you can save my mysql database and connect it to the android application using the "Android Studio" program, can you help?     
asked by 23.06.2017 / 15:56
1
answer

Making quick queries [closed]

How can I make queries faster on a MySQL table with 3 million records, the table has only 4 columns, and it takes me almost 5 seconds to return data. The fields I'm searching for have index . The Query returns close to 50,000...
asked by 28.10.2016 / 11:19
1
answer

Sort PHP table [closed]

I'm trying to sort a table that is in PhP and that pulls the data from the database, I tried with js called sorttable, but it did not work, the table is with that code: echo '<table class="sortable">'; echo "<...
asked by 14.03.2018 / 21:40
3
answers

Update in the database is not working

My update in the bank does not work, it follows codes: aluno.php <form method="post" action="?acao=save&id_aluno=<?php echo $id; ?>"> <?php echo $pegaid; ?> <input type="text" name="ID" class="txt-m...
asked by 07.02.2017 / 05:43