Questions tagged as 'mysql'

Tagged questions
1
answer

Save file with extension

I would like to recover a file of type blob , and add the extension, without the user having to type this extension at the time of recovery. As it stands, I'm saving and also recovering, but recovering without the extension. I have the...
asked by 20.09.2015 / 21:17
3
answers

Store multiple checkboxes in a column with only PHP + MySQL

I am having difficulty storing multiple checkbox in the same field as the table. In this case, when filling out the form and marking more than one checkbox , it stores only the value of the last checkbox . Here are some sni...
asked by 24.08.2015 / 14:07
1
answer

ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '1' for key 'PRIMARY'

I'm trying to put id as the primary key but it gives this error:    ALTER TABLE causes auto_increment resequencing, resulting in duplicate entry '1' for key 'PRIMARY'     
asked by 17.07.2014 / 03:10
2
answers

How to do a replace into from one server to another?

I have the table below on 2 servers and I need server 1 to send all this information to server 2 ie the id, username, iddns, dns, ipdnstipo e ipdns fields as it is. Table CREATE TABLE IF NOT EXISTS 'trad' ( 'id' int(11) NOT NULL,...
asked by 05.09.2014 / 21:48
3
answers

Select with joins return last result by date

I have the tables drives, documents, and defenders: Defenders id | nome | cpf 1 | Nome 1 | 000000 2 | Nome 2 | 000000 3 | Nome 3 | Drives id | document_id | defender_id | data 1 | 123 | 1...
asked by 26.08.2014 / 18:33
1
answer

Select in encrypted value

Well, I created a table and entered a value into a field using SHA1 (encrypt), and I do not know how to select the value for that encrypted field. TABLE: CREATE DATABASE IF NOT EXISTS 'quest'; USE 'quest'; CREATE TABLE IF NOT EXISTS 'users'(...
asked by 12.09.2014 / 15:08
2
answers

How do I use MySQL Federated?

I need to use the FEDERATED Engine in my MySQL database but by default it is disabled, in some forums it says that in order to enable it, go to the configuration file my.ini and add the federated line below [mysqld ], I did such a procedure but...
asked by 03.09.2014 / 06:02
2
answers

Problems in content on demand (infinite scroll)

I'm trying to make the content increase by checking the user scroll down, but my code stopped here .. <script> $(document).ready(function() { var limit = 5; var offset = 0; var altura = 1000; $.post( "artes4.php", { limit: limit, offset:...
asked by 06.09.2014 / 01:53
1
answer

How to save data coming from the facebook SDK login in the database?

I'm using facebook api for login , and following the tutorial I have already been able to implement it, but I still do not understand how the system that picks up user information works. What I need to do is store this information in the dat...
asked by 03.08.2015 / 21:45
1
answer

How can I insert the results of a query into another table?

I'm running the following query directly from the phpMyAdmin : SELECT shop.id AS cart_details_id, shop.id AS cart_id, e.name AS client_name, e.nif AS client_tin, e.addr AS client_address, CONCAT (e.zipcode, ' ', e.zipcodeext) A...
asked by 24.12.2013 / 18:27