Best answeres tagged with mysql

0

answers

C3P0 Connection Pool

I have the following properties in my Hibernate XML for Connection Pool taken from the internet: <property name="hibernate.c3p0.min_size" value="4"/> <property name="hibernate.c3p0.max_size" value="4"/> <property name...

asked by 24.05.2016 / 13:54

3

answers

Relate Categories with Subcategories from the same table to another table

asked by 20.05.2016 / 23:41

1

answer

Error: "You have an error in your SQL syntax" [closed]

I'm getting the following error while attempting to change in BD: You have an error in your SQL syntax; check the manual that correspond to your MySQL server version for the right syntax to use near 'CODE = 0' at line 1 DAO pub...

asked by 30.11.2015 / 23:35

0

answers

Trigger in MySQL for movie rentals? [closed]

I need a little help because the teacher said that it is not to use FUNCTIONS and PROCEDURES , ONLY TRIGGER . Follow the picture of what he's asking for. I really can not do it. For me it had to exist before a% w_% where it ch...

asked by 30.11.2015 / 18:55

1

answer

Number of rows increases after use of JOIN

Hello, I'm new to SQL and am having a question. As in the example below, I wanted to get a description of the code in the 'a' table from a table 'b'. But the number of rows in table 'a' when I do this increases significantly. select a.banana,...

asked by 11.08.2016 / 00:30

2

answers

PHP - How do I make the left join with more than one record in the other tables not return repeated values in the columns? [closed]

I need to perform a SQL query in PHP, where I need to create a table from other 9 tables, joining all the columns with a LEFT JOIN, and with the 'Client' field as the key between the tables. However, in each table there is more than one record o...

asked by 11.01.2016 / 16:59

0

answers

Select dependent with three levels

I am putting together a simple vehicle reservation system for the company and need to set up a "triple" combo that verifies the vehicle and the times available for it. I made a double of the expected departure and arrival time, where the expecte...

asked by 27.11.2015 / 18:40

2

answers

What is the problem with this query? Not unique table / alias

I came across a problem: 1066 - Not unique table / alias: 'catalog_product_entity_decimal' SELECT DISTINCT catalog_product_entity.entity_id, sku, price as preco, qty as quantidade, stock_status as estoque, catalog_product_entity_decimal.val...

asked by 24.09.2015 / 21:37

3

answers

No select error using mysqli_query

I've done a php to list the rooms, but I'm having difficulty listing them, if anyone can help me, I would appreciate it. <?php $link = mysqli_connect("localhost","root","","hotel"); $result = mysqli_query("SELECT descricao FROM quartos WHER...

asked by 08.06.2015 / 21:53

1

answer

MySQL UPDATE function is editing right, but creates a new empty line at the end of the table [closed]

I'm breaking my head here, because the UPDATE function works fine when used purely by the terminal or the Workbench, but when I do the PHP code via HTML form parameters, it edits fine too, but creates a new line empty, and will create mor...

asked by 20.10.2015 / 22:42

Questions tagged as 'mysql'