Questions tagged as 'mysql'

2
answers

How to send checkbox data to a query with mysql?

I do not know how to start this whole process of sending multiple data to a query in the database. I always submit an item for each types but never submitted multiple items of the same type . The image below will best illustrate: Iwouldlikeyo...
asked by 03.09.2014 / 14:54
1
answer

Model "Product" table for multiple types of different products

How to model the Product table of a database? This table should store the following information: id, product name, quantity, price, status (if it is in stock, if it will be returned) and information pertinent to each type of product: food (nat...
asked by 14.07.2015 / 14:11
3
answers

How to make a LIKE ignoring accent?

I need to make inquiries in a database of registered users. However, I need this search done by the user name, through LIKE , and this should ignore the UTF-8 encoding present in the names. What I want to say is this: When yo...
asked by 14.08.2015 / 15:04
2
answers

Display longblob field contents containing PDF file

I have a question regarding the longblob data that is stored in the Database. I currently have this for the other data: echo "<tr><td>Email:</td>"; echo "<td>"; if ($exibe['Email']) { echo $exibe['Email']...
asked by 14.02.2014 / 11:09
1
answer

What is the difference between REPLACE INTO or ON DUPLICATE KEY UPDATE

I'm wondering what's the difference between using REPLACE INTO or ON DUPLICATE KEY UPDATE in mysql, are not both for the same purpose making a change to a field or more in the database? If the goal is someone else who enlightens me...
asked by 04.10.2017 / 14:07
2
answers

How do I return the words that appear the most in a column?

I have this table below which has two columns, being id and description : CREATE TABLE myBigTable ( id INT(11) AUTO_INCREMENT PRIMARY KEY, description TEXT NOT NULL ) After inserting some records, I made a simple selec...
asked by 07.03.2017 / 23:00
1
answer

SQLite and MySQL Synchronization

I have an application in which I have a database using SQLite and an external service using MySQL. Basically it is a task application, in which I can create a task in offline mode . When the user owns internet it will already automatically send...
asked by 05.12.2016 / 14:06
1
answer

How to structure a mySQL database from a JSON

I have the following structure json test: { "CE": { "Fortaleza": [ { "nome": "Teste", "email": "[email protected]", "cel": "(xx) xx-xx" }, { "nome": "Teste", "email": "[email protected]",...
asked by 12.01.2016 / 20:11
1
answer

How to insert / retrieve image in MySQL database

Would you like to know in a clear and simple way how to insert / retrieve an image in the MySQL database? I'm using FireDac to connect to the MySQL database. I have a JPEG image and want to save it to a MySQL database and be able to restor...
asked by 17.01.2016 / 16:05
4
answers

How to make a query that returns the last record of each day?

The doubt is simple, but unfortunately I do not think the resolution. I have a table with several records, and I need to make a query that returns the last record of each day of the last 20 days for example. Exemplo: |------------ teste ------...
asked by 20.01.2016 / 20:01