Questions tagged as 'mysql'

4
answers

What's the difference between LIKE, IN and BETWEEN in MySQL?

I'm doubtful about the difference and use of the LIKE , IN and BETWEEN tags in MySQL. When should I use the tags and example?     
asked by 13.11.2017 / 15:27
1
answer

How to concatenate a SQL statement inside a MySQL Stored Procedure?

In the following example, we have an example already running in PHP. The scenario of the issue is the setting up of a "navigation link" based on a data structure. $node = '006002009'; // Esta informação é obtida dinamicamente. $segmentos = s...
asked by 16.03.2015 / 03:19
6
answers

How to save the day in the bank?

How do I automatically save the day in the database without having to spend it when adding the product, ie every time you add a product, it automatically writes the date of the computer to a table attribute.     
asked by 08.10.2015 / 18:30
3
answers

How to convert a MySQL connection to MySQL? [duplicate]

I decided to listen to some users to make the conversion but I need your help because I have done a lot of research and nothing works. The first file is: <?php include_once("/pasta/connectserver.php"); $table = "rjpsync_tag, rjpsync_i...
asked by 17.09.2014 / 13:47
3
answers

What better way to create an app that works offline and synchronize data with the server? [closed]

I'm digging into the Mobile world, where I had the first challenge, which is to create an Android App for basic registration, name, age, etc. The complicated (at least for me) is that I have to update this data saved in SQLite from Android to...
asked by 20.05.2015 / 23:27
3
answers

Search for certain dates in the VARCHAR field in SQL (MySQL)

I have the following condition: WHERE sv_users.userDataNascimento LIKE '%95%'; And this condition searches on a date ( 11/12/1995 ), type VARCHAR and not Timestamp , a year ending with the numerals 95 . This numera...
asked by 16.01.2014 / 13:07
6
answers

How to convert UTF-8 characters in PHP

In my web application, I'm using a MySQL database that has the EditableContent table. This table has the content field, which is of type text and has the input format utf8-bin . In the database the characters appear...
asked by 19.08.2014 / 02:19
2
answers

How to insert EMOJI - SMARTFONES in MySQL database with PHP? [duplicate]

Well, as the question is very self explanatory, I will only reinforce the question. I have an APP system of conversation, which through HTML , I command for PHP with Ajax , but if the user tries to insert some emoji in> (emotion)...
asked by 03.08.2015 / 18:16
0
answers

Recursive call error in nested procedures

I have some MySQL procedures to do the following: The main code will always call the procedure CALL sp_syncTabela . The sp_syncTabela will check if there is another specific procedure for tableName passed as argumen...
asked by 17.11.2014 / 21:46
2
answers

Data type for latitude and longitude

I'm working on a new project where I need to save the latitude and longitude coordinates of an address in the database. Is there an ideal data type for this? I searched and saw some recommendations for using decimal, but I'm in doubt if it...
asked by 10.10.2016 / 15:31