Questions tagged as 'mysql'

1
answer

How to reset the auto_increment value (NO TRUNCATE)?

How can I reset / restart the value of AUTO_INCREMENT in Mysql , without using TRUNCATE ? In some cases, it is not possible to use TRUNCATE table in some tables.     
asked by 24.08.2015 / 14:38
2
answers

Expandable table how to do Double select?

In this script one I have an expandable table Showing by GROUP by nome , that when we click on the line, will expand, showing a second table listing all the lines referring to GROUP by nome . Closed Table: OpenTable:Howshoul...
asked by 13.10.2015 / 17:38
1
answer

Problems with quotation marks when importing data from Excel to the Bank (MySQL) [closed]

I have an Excel file with a lot of data, the problem is that there is apparently some double-quote data, and when you load that data, all columns are mismatched and therefore the data is populated in wrong (different) columns. I am using Drea...
asked by 13.11.2015 / 14:23
1
answer

Doubt with php and mysql

Can someone help me get a doubt here? I'm starting in php now, I created a database in mysql (phpmyadimin) and listed the primary key of one table as a foreign key in another. At the time I run the php script with the idea of saving in the datab...
asked by 07.01.2016 / 21:11
1
answer

Filter a query using an attribute in Laravel

I have, in short, the following structure: Suppliers : id | cnpj | razao_social | endereco_id People : id | nome | tipo_pessoa | fornecedor_id Model - Supplier: public function endereco() { return $this->hasOne('...
asked by 15.09.2015 / 17:54
1
answer

Data passed via function

I created a function to register images that until yesterday at 6:00 PM worked normally and this morning the form data is not being passed. incredible as it may seem, nobody tampered with the code. <?php //Chama a função inser...
asked by 16.09.2015 / 14:28
1
answer

Add parameters get value of a select / option in url

I have in the page that lists the properties of my site a search form and a select that does the ordering of the result. Theproblem:Searchingtheformandpassingintheurlthevaluesviagetctr=0&min=20000&max=999999&suites=3etc.andsoonafterc...
asked by 17.09.2015 / 22:54
1
answer

Set Default Value HTML Form with PHP

I have the following situation: I have a simple example form to display information for a bank to change and then write them back. In this case the problem is in the NAME_OPERATOR, where I wanted to have already set the value that is stored in t...
asked by 17.09.2015 / 15:15
1
answer

Order movies by IMDB link

Good evening, I come here to question the SO community if anyone has an idea how to do this: Example, when we insert an IMDB link in the input and give submit, it adds the movie to the order list as in the image ..     
asked by 11.09.2015 / 00:08
1
answer

Connect Java system to the database on the server

I have a Desk system in which I'm trying to connect to a database that stays on the server. But every time I try to connect it gives the following error:    java.sql.SQLException: null, message from server: "Host   'nco-inf-04.cop.com.br' is...
asked by 12.08.2015 / 13:28