Questions tagged as 'mysql'

Tagged questions
2
answers

Search in 2 fields at the same time

Eae, I have two fields in a mysql table, description and degree. How do I find a result when I search for WORD and 4 (WORD from the description field and 4 from the field? PS: Both description and degree are in text mode. PS2: if I...
asked by 17.06.2018 / 19:19
0
answers

Foreign Keys Are "Breaking" Lines in Export

Good morning! I'm having difficulty exporting a SELECT that I created, it happens that when using INTO OUTFILE the file that is exported is breaking the lines where "Join" exists. So I ask your help so that I can solve this problem. Note: Whe...
asked by 10.04.2018 / 15:28
0
answers

Shuffled information Magento 1.9.3.8 and bug in pagseguro

Hello. I recently updated the magento to version 1.9.3.8, everything went well, until I came across an issue, new registrations are going to the shuffled database (language in place of name, password hash in place of last name, last name in plac...
asked by 01.04.2018 / 02:32
1
answer

Change button Sign in to logout

First of all, I want to let you know that I am a beginner, both in PHP and in the database, and thank you for help because I need to deliver a job and I am in deadline I have a login button and I want you to switch to logout when the sessio...
asked by 01.04.2018 / 02:39
0
answers

Trigger within transaction

I'm using Mysql 5.7 with PHP 7 and I noticed that when I add a simple trigger to a table that is inside a transaction, it takes a very long time to execute the process, it does not happen when it is out of the transaction. / p> Does anyone kno...
asked by 01.04.2018 / 03:39
1
answer

Delete table record with foreign key

Where is the Error? DELETE FROM postagens WHERE id='$p_id' AND u_id='$u_id' SET FOREIGN_KEY_CHECKS = 0; Clarifications: p_id = post id (primary key) u_id = user id (foreign key)     
asked by 01.04.2018 / 20:09
0
answers

Problem with cyclic relationship

I have a question: I have a user who submits documents that are read by other users. Is there a problem in this cycle?     
asked by 02.04.2018 / 14:02
1
answer

Call list + Subscribers and participants per event

I have the following tables: I need to list COMPANIES and REGISTERS IN THE EVENT (which can have more than one talk) and in the same line bring the QTD OF GIFTS by lecture in columns ... Thus I would get a parameter of use per lecture i...
asked by 30.03.2018 / 22:28
1
answer

Remote Connection to DBA MYSQL + PHP

Hello, I'm trying to make a test connection to a server called *    infinityfree I'm using php with PDO. Call to connect. <?php try { $connex = new PDO("mysql:host=sql206.epizy.com;dbname=epiz_21864346_controle_estoque","epiz...
asked by 30.03.2018 / 16:15
0
answers

Handle Transactions - Node, mysql

I am developing a POC where I need to register a sale. For this, I use this code: this.salvarVenda = function(connection, objeto, response, callback){ let sqlVenda = utilVenda.createSaveQuery(objeto); console.log(sqlVenda);...
asked by 30.03.2018 / 18:27