Questions tagged as 'mysql'

Tagged questions
1
answer

MySQL How to return only part of the result of the FULL-TEXT query

Let's say I have this text stored in a table in my database:    Lorem ipsum dolor sit amet, consectetur adipisicing elit, eiusmod sed   tempor inciudunt ut labore et dolore magna aliqua. Ut enim ad minim come,   wanted nostrud exercitation u...
asked by 04.05.2017 / 11:15
1
answer

I need to select sequences of numbers in a field of a table column

I have a 'Text' column in my 'process' table. Text consists of a VARCHAR (220), in this text I need to identify a specific word pattern. In this case a sequence of numbers with a "-" to separate: '1234-567' - There are 4 digits followed by '...
asked by 05.04.2017 / 18:22
2
answers

Login form returning error!

I have a login form that returns the following ERROR :    You have an error in your SQL syntax; check the manual that   correspond to your MySQL server version for the right syntax to use   near 'as value FROM olmp_cadparaprova WHERE email =...
asked by 30.10.2017 / 11:22
1
answer

Is there a naming pattern for table index names in Mysql?

This question seems simple, but wanted to know how to set a pattern. Normally using the Mysql Workbench a default is automatically set, as in the example below: fk_tabela1_tabela2_idx Note: I'm using Laravel which has nomenclature standar...
asked by 22.08.2017 / 18:38
2
answers

check user type for php access

I'm trying to create an admin panel. Ba table of the bank already created the field type, where if it is 1 is normal user and 2 administrator. What is the best method to find the type of user in the bank? Follow the code that I have already d...
asked by 27.08.2017 / 18:22
1
answer

Record values of a related table concatenated in the main entity query

I have two tables: server_and_server_servername. If you require more than one technician for an O.S., records of each technician are created in the second table listed by the order number (id). I would like to make an open order query that wo...
asked by 28.04.2017 / 16:37
1
answer

Apparmor DENIED Mysql

Save personal. I'm facing a small problem with my MYSQL in Linux Mint. When I try to initialize the service, APPARMOR denies the permission, it follows the logs: Ago 28 09:07:42 Comerlatto-NTB systemd[1]: mysql.service: Service hold-off tim...
asked by 28.08.2017 / 14:16
1
answer

Run mysql search after opening Modal

Galera, yesterday with the help of Bruno here on the page I managed to solve my problem of creating the modal, but today I have a new difficulty that I could not get over. Next to my modal opening with the opening through the normal click. Bu...
asked by 03.08.2017 / 03:17
1
answer

Mysql Database Synchronization between Servers (VPS)

I would like to synchronize my databases that are hosted between 3 different VPS, I would like to synchronize this data in real time when a record is changed in a database in a certain VPS automatically changes in the other databases in the othe...
asked by 31.07.2017 / 20:37
1
answer

Sitemap Mysql PHP divided into result quantities

<?php header("Content-type: text/xml"); echo'<?xml version=\'1.0\' encoding=\'UTF-8\'?>'; echo' <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLoca...
asked by 01.08.2017 / 17:38