Questions tagged as 'mysql'

Tagged questions
2
answers

inner join without duplicates

I'm doing a system in php in which I have two tables in one save the records and in another the boxes where each record goes, the result is this way -------- -------- --------------- CASILLA SECCION REPRESENTANTE -------- -------- -...
asked by 15.06.2017 / 22:46
3
answers

Query in MySQL joining several tables [duplicated]

I'm trying to do a query in mysql in several tables at once but the results that I get do not end up serving me. This is the code I'm using: SELECT *, art.id AS IdArt, art.nombre AS NombrArt, conf.Conf1 AS Sexo, ean.id AS IdEan FROM 'Ar...
asked by 15.06.2017 / 19:52
1
answer

Union MySQL - Multitasking Procedure

Problem statement: Perform a procedure with the following two functionalities: • Alphabetically arranged list of waiters indicating their name, surname, ID and the person in charge. • Alphabetically arranged list of participating chefs...
asked by 12.02.2018 / 17:58
1
answer

Update a record if it does not exist or if

How can I verify if the registry exists and then update it if it does not exist that I insert it? I tried this, but it does not leave me. UPDATE tienda SET Campo1 = 'carro' WHERE ID = '123' IF @@ROWCOUNT = 0 INSERT INTO tienda VALUES ('coch...
asked by 05.06.2017 / 15:02
1
answer

Search MySql using a drop-down list select with php Ajax Jquery

I am doing a search input using the event keyup in jquery, now if instead of input I use a select what event would I use or how would I do in that case? This is the input <input type="text" name="pedido" class="form-...
asked by 03.08.2017 / 16:47
1
answer

Filter select so that the result does not show all records

I have a table with the following structure: codigo / signo /importe With this select I get the following: codigo / cargo / abono / saldo But I want it to not show those that have zero balance (0), how do I filter that? SELECT codigo...
asked by 02.08.2017 / 20:46
2
answers

Consequences for not using semicolons at the end of mysql queries in PDO?

I had some data mixes in my mysql table and I'm thinking if that would be due to lack of some semicolons at the end of my queries. Let's say I have this code: $sql = "DELETE FROM customers_2016 WHERE customer_db_id = ? "; $stmt = $pdo->...
asked by 29.03.2017 / 16:28
1
answer

Difference between JDBC and JSON [closed]

My purpose is to connect to a remote data base (MySQL) from Android, make queries, create tables and those basic things. What is the difference between making a connection using the Java JDBC, and using PHP JSON or something like that? (Excus...
asked by 26.03.2017 / 03:47
1
answer

Visual Studio 2017 Does not detect DataSet

I do not understand why it happens, because if I enter the class inside the app_code folder on the website there is no problem, I'm new with c # and mysql I'm sorry if it's silly, on the other hand, the connection string is it okay ?...
asked by 21.03.2018 / 21:01
2
answers

I can not search by name in mysql

I have a table called debtors with 2 fields, name and amount, where name is a% co_of% of 20 and I value a% co_of% of 13, the key field is name and is% co_of%, I can not run a simple query as: echo implode("",mysql_fetch_row(mysql_query("SELECT...
asked by 06.04.2017 / 19:54