Questions tagged as 'mysql'

Tagged questions
1
answer

You have an error in your SQL syntax;

I've been using this code for a long time now that it came to give this error    Error: Database Select Failed:       You have an error in your SQL syntax; check the manual that   correspond to your MySQL server version for the right syntax...
asked by 26.06.2014 / 14:48
2
answers

How to install PHP server with separate components

A stupid doubt but I researched here and found nothing. I already have MySQL running on my computer, how do I install PHP without installing EasyPHP, Xampp? Because usually these programs already bring MySQL together. How do I?     
asked by 30.12.2014 / 22:20
2
answers

Can anyone tell me what is causing this error

The email field in the database is unique <?phprequire_once("conexao.php"); $nome = $_REQUEST['nome']; $email =$_REQUEST['email']; $telefone = $_REQUEST['telefone']; try{ $conexao = new PDO($banco,$user,$senha); $sql = "INSERT IN...
asked by 02.07.2018 / 00:46
2
answers

Query of non-similar records

I have a table where I make the exchange data of some traders, For example, prof A has in common the exchange with prof F, so F has with A as well. But in the barter report I would not want you to show F with A, only A with F, because the inform...
asked by 25.06.2018 / 17:31
1
answer

How do I "explode" sometimes receive more values?

I have a code that reads a txt and saves it in the database, but sometimes it will receive more values, eg: I have the following txt: |texto|texto|texto| |texto|texto|texto|texto| If I use to receive the 4 fields, it gives error in hav...
asked by 20.08.2018 / 13:27
1
answer

Is there a way to retrieve data from a MySQL database?

I gave a delete in some files of the table, have some way to recover? I heard about flashback, but for the little I researched it is only for oracle.     
asked by 16.10.2014 / 22:54
5
answers

Product search by name and brand

I have two tables, one called tags with the product tags and another called products . Within this table products have shirts, pants and etc. I want him to do a search, for example "Hollister shirt," he will return all shirts with the Holli...
asked by 07.03.2014 / 17:04
4
answers

How can you insert into the mysql database a string containing the *

I'm using PHP and Mysql and I'm trying to add a NEXTEL and CLARO type radio ID field: 23*4567 But when I check what has been inserted, I see that it only registered what is before *, thus: 23 Using a normal query like this: INSERT IN...
asked by 06.03.2014 / 21:55
1
answer

How to update the database with SELECT Sum

I need to do update of a table by adding two values (money + deposited), thus getting the total . This total I already have using the code Select SUM(dinheiro)+(depositado) total from usuarios WHERE id=1 But I wanted to put the abov...
asked by 27.07.2018 / 16:56
2
answers

Update tables using trigger, from a main table

I have the following structure: A main table X, where the "header" of the sale is stored. A Y table, where sales items are stored. A Z table, where some sales data will be saved, from triggers fired from table X. In this, every time...
asked by 02.08.2018 / 20:41