Questions tagged as 'mysql'

Tagged questions
2
answers

batch file to create mysql database

I'm trying to create a .bat batch file to create the database and then retrieve inaccuracies via sql file, follow the .bat file procedure: @echo off cls @echo. @echo Instalando DB cd C:\Program Files\MySQL\MySQL Server 5.6\bin\ mysql.exe -u ro...
asked by 28.03.2015 / 23:18
2
answers

How to apply password_hash for use of SELECT, INSERT and UPDATE?

I know password_hash works like this: string password_hash ( string $password , integer $algo [, array $options ] ) 1 - But I wanted to know how I can apply password_hash in these cases: $check = mysql_query("SELECT 'id' FROM 'da...
asked by 25.05.2014 / 01:51
2
answers

QUERY no expected result, what can be missing?

Complementing with current information, I understood the current result, and what it looks like is duplicate information, but on different tables, but this is not even with me since I arrived and it was like this and I'm still an intern, I'm jus...
asked by 07.04.2014 / 18:09
2
answers

AJAX code analysis

I found this code, which is like a Long Polling , and wanted to know if I might have problems using it. And I also wanted to know the cons of this code if I use it. pagina.html = > page that the automatic update occurs <!DOCTY...
asked by 25.03.2014 / 17:57
2
answers

Pick up the most recent month's records

I have a simple table that stores titles and date of publication, this in DATE format, and I need to get all the records of the most recent month / year. select titulo, publicacao FROM teste1 ORDER BY publicacao DESC     
asked by 30.08.2014 / 00:18
2
answers

Insertion in MySQL with PHP does not work for nothing

I'm trying to create a registration page and save the user's data in MySQL, but it's impossible to do that. I already researched the internet, but apparently my code is correct. SQL code: CREATE SCHEMA IF NOT EXISTS site; CREATE TABL...
asked by 03.10.2014 / 07:13
4
answers

How to get values separated by "BR" in MySQL?

The idea is simple ... I need to get values from a table (by doing SELECT) that are separated by <BR> from a STRING field and then storing a record in a table, inserting each separation. Example 1: Registration: "Enviado...
asked by 13.03.2014 / 19:58
2
answers

Count IF MySQL Workbench

I have a table that has an ID field. ID 1234 1234 1235 1235 1235 1236 And I would like to get the following result via query: ID ID_Counter 1234 2 1234 2 1235 3 1235 3 1235 3 1236 1 Where in the second column the fie...
asked by 02.02.2017 / 12:50
5
answers

Doubt in SQL query "between" or "in"

I am generating a report between date, as shown below: However,whenIenterthestartdate:Startingyear:2014Startmonth:6andFinalYear:2015FinalMonth:5IfIusetheINclausethequeryreturnsonlymonths6and5andnotreturningmonth4,butwhenusedBETWEENdoesnotretu...
asked by 18.06.2015 / 14:54
3
answers

Send POST Textarea one value per line

I have form with textarea where it will have a value per line. Example: I need to send this value to the MySQL Database. Then on another page I need to create a For to list these values. What brings me confusion is...
asked by 22.06.2015 / 14:09