Questions tagged as 'mysql'

Tagged questions
1
answer

Insert selected records into another table

I need to export data from a table that I have in our intranet to a table in the internet, I created a table where I show the events and in that the user can choose the ones that want to export through checkbox selection. I pass the id (s) to...
asked by 24.07.2014 / 16:14
1
answer

Mysql Stored Procedure Error

I have a connection table that I need to delete every month to include new data. I made a stored procedure to automate this process. This table has about 3 million rows in a monthly period. This may increase or decrease a bit each month. I ma...
asked by 06.08.2014 / 14:57
4
answers

Jquery does not work in PHP

I do not know why. The page does not work. Does anyone know how to help me figure out the problem? I want the date mask to work in the data and the Venc_Garantia % Can anyone help me? <html> <head> <script src="C...
asked by 25.07.2014 / 15:10
1
answer

How can I paginate these results? [duplicate]

I made a SQL to filter results according to the desired parameters that resulted in the following statement: $query = $pdo->query("SELECT * FROM imovel ".trim($where, ' AND ')); Since I used PDO to mount the $query do I have to...
asked by 10.10.2014 / 14:34
1
answer

DROP DATABASE in phpMyAdmin

How do I enable DROP DATABASE in phpmyadmin? Every time I try to drop a bank it gives an error saying that the command is not enabled. I'm using phpMyAdmin in WAMP on my local machine.     
asked by 24.10.2014 / 20:10
1
answer

How to tell if a file was viewed

I'm doing a system in php where the counter sends a file to the client (using database). My question is as follows, how to do when the client accesses this file, be sent to the database the time and date it was opened. I was able to resolve i...
asked by 02.06.2014 / 21:48
4
answers

How to define the database tables?

I need to compute X hours worked for an employee X in month X. For example, John worked 20 days in January, 12 days in February, and so on. I'm lost in relation to the table, do I create a table only for dates? Or create columns inside the emplo...
asked by 15.05.2014 / 17:06
1
answer

Assign value to the input text

I have the code below that is working perfectly, that is, whenever I move the images I have the left and top scales of the same ones. But this is appearing with LI and I need it to appear in the VALUE of an INPUT TYPE = TEXT, as I need to send t...
asked by 13.04.2015 / 15:50
1
answer

Add Letter in a field with 20000 lines

I have a produto table filled with 20000 products and I need to add a o in the first character of the codigo field of all rows. How can I do this with MySQL?     
asked by 07.04.2015 / 12:07
2
answers

MySQL Licensing

I'm starting to develop a system that runs on Android, Web, and Windows. The 3 versions should talk to each other and the three versions will have the same functions will be a port of the same application for 3 platforms. The system will be d...
asked by 26.12.2014 / 00:04