Questions tagged as 'mysql'

0
answers

Working with two databases in Laravel [closed]

I'm creating an application that needs to connect to 2 different databases. A database I'm creating (MySQL) and a database I got ready that I have permission to query only (SQL Server). The purpose of the application is to query the data of the...
asked by 19.10.2015 / 12:08
1
answer

My calendar only displays the first scheduled appointment each day

I've set up a calendar with a calendar in PHP + MySQL, it's already 80% of the development. But, I have a problem, such as if I registered for an event for 7/20/07, this appointment is normally displayed in the calendar. If I schedule another...
asked by 17.07.2015 / 17:34
2
answers

How to find a collation of a table or bank using a SQL query?

I can perfectly visualize the collation of a given table or database by PHPMyAdmin. But if I did not have this tool mentioned above, how could I do to find the collation by doing a SQL query manually?     
asked by 13.03.2017 / 14:03
4
answers

How to order a MySQL search with date in d-m-Y format?

The date in my database is saved as dia-mês-ano . I would like to know how I can sort by date using this date format.     
asked by 08.04.2014 / 17:07
1
answer

Find ID in a column of delimiter-separated IDs in MySQL

I use a table called chat and inside it has a whole structure for my chat script and I'm trying to create chat in groups, so far so good. However, within the chat table there is a column named participantes where I enter the...
asked by 19.06.2014 / 23:51
2
answers

MySQL BD random record preventing consecutive equal records

I have a database where I want to get a random record. I can do this perfectly with: $query = "SELECT * FROM 'mytable' ORDER BY RAND() The problem is that the database contains the order of entry of the records of the jockeys in the competit...
asked by 27.02.2015 / 05:04
1
answer

Problem with long polling

Well I've done a script here to fetch information from the real-time database, but it works fine if I add it directly to MySQL, but it works fine on the page when I insert text it works for MySQL and if you disable script long polling it al...
asked by 22.02.2015 / 22:51
1
answer

Accentuation-Based Error [duplicate]

Hello I'm developing a Hybrid APP that uses a PHP Webservice to send an email and call a procedure in MySQL by filling it with the same email data, until the part of sending the email is all OK it sends successfully, however at the moment I...
asked by 20.07.2016 / 13:12
3
answers

Working with tags in MySQL

On a system I would like to categorize some users with tags. However there are groups of tags (for example, UF tag group, Interests). I'm trying to do a query where I can answer some questions like: I want all users in the state of SP or MG a...
asked by 14.01.2016 / 16:20
4
answers

Select between dates in Mysql

Good afternoon, I have the following problem: I have a DATA_ENTRATE column of type date and I need a select that compares to DATA_ENTRATE and the " current date " (eg today is 28/08/2015, tomorrow would be 08/29/2015), and return me on...
asked by 28.08.2015 / 21:36