Questions tagged as 'mysql'

Tagged questions
1
answer

Import csv without duplicate records

I have a worksheet with 32000 records, and I need to play to a table in the database. The problem is that in this worksheet I do not have the ID of the records and I can not let it duplicate when I import. I need to make that when I do the impor...
asked by 12.04.2017 / 20:38
1
answer

resize an image and then save it in mysql

From a form I want to resize an image only after and then save in mysql, or grab an already saved image in mysql and resize it and then update the registry. Thanks so much if anyone can help me. * the table in mysql * CREATE TABLE 'imagem...
asked by 11.04.2017 / 23:31
1
answer

Recording only the last line in the DB

To make a form to input products into stock (NF mirror) so I am using a javascript code to clone the rows. So, okay, the problem is when it's time to register because it only registers the last line of products, will it be a problem in my ins...
asked by 11.04.2017 / 19:44
0
answers

Doubt in the order of the table fields in case of foreign keys of less importance hierarchically

Hello, fellow programmers! I'm just a beginner in the programming world and in StackOverflow and need to ask a question! I'm making some adjustments to a database I'm working on after finding great tabs for standardizing fields and tables. As...
asked by 26.05.2017 / 15:24
2
answers

Display column quantities in each table

As I do for phpmyadmin show me this: --- tabelas --- usuarios(5) clientes(20) admins(2) for example using some mysql command or even some phpmyadmin functionality?     
asked by 15.04.2014 / 23:15
1
answer

how can I use group by next to order by

How to use GROUP BY along with ORDER BY ? I need to sort my tabela form ASC but I can not use GROUP BY how should I do to use the two together? code snippet: mysqli_query($conn, "SELECT nome_fotos, img, id_...
asked by 04.05.2017 / 06:43
0
answers

PhpMyAdmin does not open after changing default

Good afternoon guys, After modifying the default Mysql password (in the Xampp interface), it does not open anymore and displays the following error message: 1045 - Access denied for user 'root' @ 'localhost' (using password: YES) "phpMy...
asked by 07.04.2017 / 17:29
1
answer

error in importing table into database

I'm trying to import a table but it has this error. - - Structure of the table tb_colaboradores CREATE TABLE tb_colaboradores (    id_colaborador int (11) NOT NULL,    nome varchar (40) NOT NULL,    userna...
asked by 27.05.2017 / 17:07
1
answer

Create code to update Schema

I use Mysql WorkBench to manipulate my MySQL database and tables. When I export the table, it generates code similar to the following code: CREATE TABLE 'entrada' ( 'id' int(11) NOT NULL AUTO_INCREMENT, 'idProduto' int(11) NOT NULL,...
asked by 02.04.2017 / 01:45
0
answers

MySQL did not return any records

Even creating the database in PHP My admin being careful in the tables, it presents this error="MySQL did not return any records"; This is my .PHP, my bank is = register, having the table = users, with the following attributes = name, surname...
asked by 02.04.2017 / 03:37