Questions tagged as 'mysql'

Tagged questions
1
answer

SQLSTATE [42000]: Syntax error or access violation: 1064

I'm having trouble viewing and entering data into the database, it's giving this error:    SQLSTATE [42000]: Syntax error or access violation: 1064 You have an   error in your SQL syntax; check the manual that corresponds to your   MariaDB se...
asked by 22.03.2017 / 23:57
2
answers

WP_Query complex

I'm putting together a calendar of events in Wordpress and I need to list all the events of the week grouped by the current day. I have events that last only one day and others that last the whole month. I created the custom post type "Events" a...
asked by 19.04.2017 / 18:26
1
answer

How to create a blob link in PHP?

Hi! Well, I'm creating a video site I'm having a problem playing the videos, I put the videos in mysql and I want to play them, I did not find any way to reproduce them maliciously. The only way I got it was like this: link Do you know how...
asked by 07.05.2017 / 23:37
2
answers

Delete in more than one table with a SQL?

I'm trying to apply a DELETE to more than one table, tables have a column (not with the same name) with the same attributes. I want to delete via ID. But I have the table usuario with column id and areausuario with column...
asked by 05.05.2017 / 02:48
1
answer

References lost at the time of persistence

Below are my entities and relationships: Order: @Entity @Table(name = "encomenda") @XmlRootElement(name = "objeto") @XmlAccessorType(XmlAccessType.FIELD) public class Encomenda { @Getter @Setter @Id @GeneratedValue(strategy...
asked by 22.03.2017 / 13:11
1
answer

Display return of a SQL query in Excel

My question is divided into two parts. The first one, it is possible to perform SQL command by Excel, as I need to display certain information from my MySQL database in a table in Excel. Note: I do not want to connect via ODBC, I need the q...
asked by 07.04.2017 / 14:37
1
answer

Select does not display data in listview

I can not get my return from my select in the bank. Where do I show the data in a listview. using (_connection = new MySql.Data.MySqlClient.MySqlConnection("Database=roubo_furto; Data Source=192.168.0.17;User Id=RFID;Password=1234;SslMode=None...
asked by 07.04.2017 / 00:11
1
answer

Conditional select that takes value from another table

I need to do a conditional select that checks a sum done this way: select round(sum(('gin'.'Caixa_9L' / 1000)),1) AS 'total' from 'gin' If this sum above is = 0, I need to get a value from one field in another table (called an asterisk) and...
asked by 07.04.2017 / 15:36
1
answer

Link call method in Controller - C # MVC

I have a MySQL table that is displayed on a page of my project: foreach (var item in Model) { <tr> <td>@Html.DisplayFor(modelItem => item.id)</td> <td>@Html.DisplayFor(modelItem => item.nomeMarca...
asked by 04.04.2017 / 11:45
1
answer

How to send 2 arrays / parameters via url?

I'm trying to send two parameters of the shopping cart through url, then the client to confirm, but I can only get an array on the other page and I do not know how to get two. I want to send the quantity of products and the product_id to...
asked by 18.03.2017 / 22:58