Questions tagged as 'mysql'

Tagged questions
2
answers

How to store state of a checkbox

I'm developing an application to make a school call list, I created Listview and populated it with data from a Mysql database, using Json . The problem is the following, I need to store the state of the selected checkbox...
asked by 06.04.2014 / 05:28
1
answer

How to compare Date with field in MySQL

I'm new to Java and I have a table in MySQL that has a field of type date and dates are stored in yyyy-mm-dd format. Now I need to retrieve only the records whose date field value is greater than or equal to today's date. I'm trying...
asked by 25.06.2014 / 23:19
1
answer

How to prevent a simple query from locking the entire MySQL database

I have an application in Rails that uses a MySQL database with a table with millions of rows. Sometimes it happens that some part of my application does a very heavy query, locking all the rest of the application. How do I prevent these pesky qu...
asked by 13.08.2014 / 02:53
2
answers

Return which of the query items are not in the table?

Is there any way to return which query items are not in a table? Let's say I have a query like this: SELECT id FROM tabela WHERE id IN (1,23,45,68,91,126,345,418,509,610); This will bring me a table with the query records that are prese...
asked by 01.10.2014 / 20:42
1
answer

Report Design UI for PHP

I've used Crystal Reports a lot to visually create my reports based on queries in the database. It was very easy to group repeated information into the query. I have searched for PHP software or libraries to do the same thing in web environme...
asked by 03.09.2014 / 01:26
1
answer

Validation of the strings size

I was creating a function to validate large text fields (description, observation, ...), which in SQL will be saved as TEXT , so basically I did this: function($valor, $min = 0, $max = 65000) { if (strlen($valor) >= $min || strlen...
asked by 28.09.2018 / 15:37
4
answers

Query data in the bank according to the date

Querying data in mysql in the last 3 days, that is, displaying data from the bank from day 15 to today (2/17/2014) I'm using it like this: $condicaoData = date('d/m/Y', strtotime("-3 days")); $selecionaTabela = mysql_query("SELECT * FROM no...
asked by 17.02.2014 / 14:27
2
answers

How to build friendly URLs, such as Facebook and Twitter.

I have a question, how can I build links like Facebook and Twitter? For example: http://facebook.com/nome-qualquer . I know that .htaccess treats the url in some way, but the question I'm beating is how to load the contents of ur...
asked by 13.03.2014 / 21:21
1
answer

Edit mysql ini in container

I am using docker to generate a LAMP. My yml looks like this: web: image: tutum/apache-php ports: - "80:80" links: - db volumes: - $PWD:/app db: image: mysql environment: - MYSQ...
asked by 28.08.2018 / 14:14
1
answer

Dump all banks for a specific user

I have the plant652 user who has 54 databases and I need to back them all up. How to do all one time in CentOS 6 with cPanel?     
asked by 13.09.2018 / 14:23