Questions tagged as 'mysql'

2
answers

Count positions of an SQL field

How do I manage to count each position in this array? I was working with SQL queries what happens is that I can not get the positions .     
asked by 22.12.2016 / 22:37
1
answer

Date and time with JCalendar and send it to a database with datetime field

How to store a date and time with JCalendar and send it to a database with datetime field?     
asked by 27.10.2016 / 23:26
0
answers

Connect python with mysql database in the cloud [closed]

p and that runs on my pc and a database in my hosting. How can I make the connection of said bd with the .py script?     
asked by 28.10.2016 / 23:21
1
answer

Python date concatenation in a query for mysql

I have the following mysql query. SELECT purchase.DATE, products.ID, products.NAME, purchase_details.UNITS, purchase.REFERENCE, purchase_details.PRICE,purchase.ID_PROVIDER FROM purchase INNER JOIN (products INNER JOIN purchase_details ON produ...
asked by 02.11.2016 / 19:43
0
answers

Problems grouping query in CakePHP

I need to ask a question for a portfolio module in accounting, I have a sales table where I am bringing all the data and I group them for each client and add up the total of each client, I need you to bring me a list grouped by client and below...
asked by 31.10.2016 / 14:36
1
answer

Compare 1 to 1 rows in SQL

Good, moving forward a little more I came across another problem: I have the following table: Tabla1 +----+--------------------+-------------+-------+------------+ | Id | ultima_realizacion | vencimiento | tarea | id_cliente | +----+-------...
asked by 20.10.2016 / 22:18
1
answer

Help RecyclerView check CheckBoxy save to database

Hello, someone could help me please, I'm doing an application on xamarin android as a project at school, but I have doubts with a CheckBox and RecyclerView, what happens is that the user is supposed to be able to select one or several items with...
asked by 30.08.2016 / 22:22
3
answers

How to know which CheckBox were selected To be able to Update

Currently I am working on a pop-up window and I have it in the following way It is assumed that this is the update view, for which said user has already registered his information before, now I would like to know how I do it so that in...
asked by 15.08.2016 / 02:52
1
answer

The BEFORE INSERT trigger works only on a BEFORE UPDATE

I have this trigger ( trigger ) named BEFORE UPDATE in MySQL : CREATE DEFINER='root'@'%' TRIGGER 'CalcularCamposCalculadosActuacionesU' BEFORE INSERT ON 'actuacion' FOR EACH ROW BEGIN SET NEW.TieneFiltrosValidos = (selec...
asked by 09.03.2017 / 11:39
1
answer

How can you decrease the amount of a field in a column in Mysql?

Good, I hope you can help me, I'm doing a php and mysql system of a school about registration, what I want to do is the following: I have a student form where you put your data to register after this happens to the course form where I have the c...
asked by 18.07.2017 / 03:59