Questions tagged as 'sql'

Tagged questions
2
answers

MySQL error "expects parameter 1 to be resource, boolean given in"

$query = "Select * from servico where ID_SERVICO = $id"; $result = mysql_query($query); if($row = mysql_fetch_array($result)) { $nome = $row['NOME']; if($nome == 'Marketing') { include ("servicos/marketing.php"); }...
asked by 07.08.2014 / 19:13
0
answers

Export tables to CSV strange characters

When I export a table to CSV in MySQL Workbench, it has strange characters due to accent. Is there a way to resolve this? And also, how can I select all the tables I want and export to different CSV files (one for each table)? Thank you!...
asked by 24.06.2016 / 22:04
2
answers

Update command does not update table

I have a problem with my CRUD. My code looks in the DB and returns the data to the screen correctly, the problem that when I save it, it does not update the DB and it also does not display any error messages. Here is the code for the data pag...
asked by 13.06.2016 / 13:22
1
answer

Calculate time interval in SQL

I have a table where I have 2 fields horainicio and horaafinal I'm wanting to get the results that fits between the initial and final values but without success follows what I'm using. I'mpickingupthecurrenttimeandtryingtomakethiscomparison$...
asked by 07.07.2016 / 16:34
0
answers

SQL error in your SQL syntax

I'm importing an sql with the following code: CREATE TABLE blog ( id INT PRIMARY KEY AUTO_INCREMENT, title VARCHAR(250) NOT NULL, body TEXT NOT NULL, url VARCHAR(250) NOT NULL); But you are returning the following error:    Notice in ./i...
asked by 06.06.2016 / 17:57
1
answer

Error in UPDATE function

I'm having this error while trying to run this update:    Fatal error: Uncaught exception 'PDOException' with message   'SQLSTATE [42000]: Syntax error or access violation: 1064 You have an   error in your SQL syntax; check the manual that co...
asked by 03.06.2016 / 03:08
1
answer

How to do a SELECT pull qty or weight of sql to a single column on the grid depending on the register?

I have the following doubt, I created a stock table in sql for packaging and raw materials, with registration in the same form. I created one line for weight and another for qtde in sql. And I created a grid with a single column "qtde / weight"...
asked by 02.06.2016 / 20:26
0
answers

Schedule with SQL (slowness)

I have a commercial management system and a much used module is the agenda. The programming (.net + Sql) worked very well, but now the table has about 1M of registers, and it is getting almost impractical to use the tool. The number of concurren...
asked by 18.10.2016 / 16:08
1
answer

Oracle - From / to WebFocus to Oracle

Well, I'd like some help. I have an ETL that was created in WebFocus, and I'm going to migrate it to Oracle. I have already done a good part of the / paras, and would like an alternative to the following situations. In WebFocus, it can use...
asked by 17.10.2016 / 20:02
0
answers

How do I put data from a form in php into a HeidiSQL table

I have a contact form in php , where when we submit we send an email with the data entered. What I wanted was to insert this data into a table in the HeidiSQL program. Form Code: <div class="pagina" id="contactos"> &l...
asked by 21.06.2016 / 13:17