Questions tagged as 'mysql'

Tagged questions
2
answers

Problem to join two SELECTs in a single statement

I need help with a SQL statement regarding the MySQL database. The select below returns me data coming from two tables. Use for a search engine I'm developing. SELECT perfil_usuario_unificado.nome_fantasia ,perfil_usuario_unifi...
asked by 02.02.2016 / 02:49
1
answer

PHP MySQL: Compare Data between Two Tables

I have the following tables raffle and games in a particular Mysql bank. Home In the draw table, the data of the contest number, 1st drawn, 2nd, 3rd, 4th and 5th decade are stored. draw table + -------------------------------------------...
asked by 07.01.2016 / 16:41
2
answers

How to display total records in a ManyToMany relationship when I use HAVING?

I have the tables below: articles tags article_tag (pivot table with article_id and tag_id columns) In the query below I can retrieve articles that have both tags (with id 1 and 3). In the query only articles that have the two tags th...
asked by 07.01.2016 / 04:04
1
answer

Select in three tables in a list - MYSQL

I have three tables: ESCRITORIOS id nome ESCRITORIOS_SEGMENTO id_escritorio id_segmento SEGMENTOS id nome_segmento What I need is to give a SELECT to list this information as well SEGMENT BLABLA: desk 1, desktop 2 BLIBLI SEGME...
asked by 22.02.2016 / 17:57
2
answers

Pass values from the JQuery Mysql option

I'm having a hard time submitting a specific field in the case of <select> with 3 <option> . When I get the field to insert some data into the database, it does not have the value, but rather the Undefined or Object info...
asked by 30.12.2015 / 13:54
1
answer

Perform update and insert in mysql via asp classic

Good morning people I would like to help a little bit boring, maybe even something banal I have a page in asp connect.asp as follows <%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"% <% dim conn sub AbreConn() 'Criamos o objeto de conexã...
asked by 04.01.2016 / 14:45
1
answer

REGEXP Regular Expression in Mysql

I have the following problem: I need to make a query (The site was developed in wordpress) where I have several health specialties. When an item is marked with two categories it is registered as follows in the database: ["1", "19"] , I...
asked by 07.01.2016 / 19:48
1
answer

Is it impossible to trick a table with foreign keys even though it is empty?

Consider table "A" and "B". Table "B" has a foreign keys referring to table "A". The "A" table has no foreign keys. None of the tables have records. When trying to truncate table "A", the following error is returned:   Can not truncat...
asked by 11.01.2016 / 12:47
1
answer

Query in a certain string

I would like to know how to do a query in the database of a certain string, for example I would like in the field "name", I would like to make a query by name: vinicios, and would like to return all the records that contain the name vices regardl...
asked by 26.02.2016 / 02:02
1
answer

How to display a photo of the database?

I can not display the photos I'm sending to the database. I am doing a comment system with photo and managed to send them to the database (mysql). I created my bank, then my table. I made the connection and all the items in the table are receivi...
asked by 26.02.2016 / 17:12