Questions tagged as 'mysql'

Tagged questions
2
answers

Can Sqlite work completely offline?

I need to save my alarms so that after the device is restarted, they are put back into operation. The problem is that I get them all through my database at mysql . What made me think that maybe it would be a good idea to save it to a...
asked by 26.06.2016 / 20:18
3
answers

Check if a date is earlier than another date

Good morning, I would like to know if there is a way to check if one date is earlier or higher than another, in my code there are 2 date type inputs, which send their values to the database, however a date will start something and the other end,...
asked by 08.06.2016 / 13:30
2
answers

Inheritance Modeling MySQL and C #

I am having a question about modeling a DesktopApplication system in C # with MySQL. Essentially I will have the Client, Supplier, PF and PJ entities. PF can be a customer or supplier. And PJ can also be a customer or supplier. My goal is to...
asked by 09.03.2016 / 20:24
2
answers

Return 0 when SUM is NULL

When it does not find results it returns NULL , how can I do for the search return me 0 when NULL ? SELECT SUM(coluna1 + coluna2 + coluna3) FROM table WHERE nome='funalo' AND MONTH(data) = 09 AND YEAR(data) = 2018     
asked by 10.08.2018 / 15:27
3
answers

Verify that a record was deleted when executing DELETE query

I'm doing a simple PHP code to delete database email, but I need to use if and else if a given action occurs. If, for example, deleting an email displays a certain message, or if it does not have the requested email in the datab...
asked by 19.10.2015 / 02:28
1
answer

Maximum size for database tables

What can be the maximum size that a table can have? To be clearer: a table in MySQL, what is the maximum size it supports? And in SQL Server, Oracle, PostgreSQL?     
asked by 07.07.2016 / 20:17
5
answers

Subtract sums of fields in two distinct tables

I need to add the value of a column in SQL, so it looks like this: SELECT SUM(qtdsaco) FROM armazem This code works. Now I need to add the value of the other table, it looks like this: SELECT SUM(qtdsaco) FROM armazem2 So I had to take...
asked by 24.08.2016 / 21:37
2
answers

How to store form data in 2 different banks?

I have a form that the data needs to be saved to a local bank and another bank on a server. Is there any way to do this without duplicating the "insert" of the code? In the connection file I configured the 2 connections, but only inserted in...
asked by 01.10.2015 / 15:11
1
answer

What kind should I use to save only the (undated) time in a database?

I'm in doubt on what kind I should use to work with hours on my system. Should I use DateTime , Time or TimeStamp . I wish the times were saved in this format: HH:MM     
asked by 09.07.2015 / 18:43
3
answers

What is the best way to insert a large amount of records into the database?

Hello, I'm creating an application where I need to constantly query a worksheet, pick up the data from it and insert it into the database (MySql).    The point is that these worksheets will always have at least 55,000 (fifty-five thousand) re...
asked by 30.07.2015 / 21:54