Most voted "database" questions
A database (its abbreviation is BD, DB, database) is an organized collection of data typically used to model certain situations. Use this tag if you have questions about designing a database. If this is a specific database management system, like Mysql, for example, use this tag instead.
Learn more…3,414 questions
Sort by count of
-
1
votes1
answer3334
viewsUsing Group By in SAS Guide
I’m having trouble using the command GROUP BY, in the SAS. By definition, SAS only accepts the GROUP BY if used in the SELECT a summary function. So far, ok. Running the Proc below, the result comes…
-
1
votes2
answers2452
viewsHow to make a database connection using the Singleton design standard
Well I do many web applications, where I all use database, and every time I do a new project, I create a file responsible for making queries with the database (CRUD). Only that I want to change…
-
1
votes1
answer629
viewsRuby on Rails does not save to bank
Good night, you guys! I created a small form with two fields and in the future I intend to expand this form with one or two more fields. It happens that the insertion of the data in the sqlite is…
-
1
votes3
answers7802
viewsWhy did replacing all my "mysql" with "mysqli" stop my project?
What should I do? I must configure in the database? Before everything worked normally, user registration, login... <?php $host ="localhost"; $user ="root"; $pass ="senha"; $banco="usuarios";…
-
1
votes2
answers1783
viewsHow to run database on Android?
I’m making an application that connects to a database that is in sao paulo, it serves as a ratchet, checking by QRCODE users card if they are registered or not. It’s just that the company I’m…
-
1
votes1
answer3714
viewsMysql - Count different values from the same field
I have the following table: Tabela partidas +----+----------+------+---------------------+ | id | name | win | date | +----+----------+------+---------------------+ | 1 | Fulano | Y | 2014-01-01…
-
1
votes1
answer387
viewsIs there any technique for synchronizing a SQL Server database structure?
I had some problems recently when making modifications in the type approval environment and for bureaucratic reasons these modifications could not be inspected in the production environment and were…
-
1
votes1
answer97
viewsProblem with Adodb’s Insert_id function
In my code I perform two insertions using the Adodb 5 library, with the Mysql driver for PHP. But at certain times occurs the function Insert_ID() return an id (primary key) of a Insert previous to…
-
1
votes1
answer860
viewsSaving hexadecimal data in the database
I need to register in the database a document or image in hexadecimal format and then recover these data by converting them back to correct format.
-
1
votes1
answer204
viewsError Uploading File to Database
I’m trying to upload a file to the database. Only instead of him sending the file to you, he’s sending you his temporary location. My code is like this: $arquivo = $_FILES['arquivo']; $name =…
-
1
votes1
answer403
viewsTwo types of search in the same textbox
I wonder if it is possible to search two types of variables (one at a time) in a single textbox. Example: public ActionResult Index(string pesquisa) { var usuario = from u in db.usuario select u; if…
-
1
votes1
answer101
viewsDatabase migration from one server to another
I have an E-commerce that I developed through Wordpress, all his BD was on my old server, with the URL http://www.felipestoker.com/teste Now, already finished, I have to export everything to…
-
1
votes2
answers819
viewsRemove data from an array and insert into the table
I include in a array, user informed data. But, I use only one array to store data from two fields, where I use "P"(And the entered data) for the first field and "S"(And the data entered) for the…
-
1
votes3
answers855
viewsHow to change the selected option in my 'combobox' from a 'li'?
I need to make a page similar to this where I budget a computer. The last product of Chipart’s budget is the cabinet, their website has an option to open an image gallery and select which cabinet I…
-
1
votes2
answers1508
viewshow to select an option and update the values (price, images ...) that are in the database?
I have a system of computer budgets on the site, with several options, and I want to update the page values when selecting an option without refresh. So I searched I will need to use ajax, but I…
-
1
votes2
answers898
viewsProblem in database connection class
I’m having problems with my Mysql database connection class in Android Studio. Error: 10-16 15:04:02.872 532-532/com.example.dev.mbstore W/dalvikvm﹕ VFY: unable to find class referenced in signature…
-
1
votes1
answer112
viewsData grid with function 0 in the rest PHP or PHP+Ajax
I’m an Intermediate Programmer, and I’m at an impasse, I need to display some items and what’s missing I need you to fill out with a mayor model. Let’s explain the logic ok? In My Table (I will use…
-
1
votes1
answer344
viewsTwo models and a controller
Following the reasoning of that other question of mine, where I create two models for manipulations, as if I could use a controller to make the manipulations in the tables ? My intention in doing…
-
1
votes2
answers794
views -
1
votes2
answers10106
viewsChange SQL SERVER SA Password with Windows Admin Account
I received a machine with an instance of SQL Server 2008 installed, I can access this instance through SQL Server Management Studio Express with my Windows administrator account but I can’t perform…
-
1
votes2
answers582
viewsHow to create a function that returns the lowest expiration date between batches of a given product?
How I create a function that returns the shortest expiration date between batches of a particular product? Dry my SQL code: create database Exemplo; use Exemplo; create table produto (codProduto…
-
1
votes1
answer361
viewsAlways include records from the other table if the value of the related field is not NULL
I’m doing a query query, based on a table. In this table (Tablea) I bring several records from other tables, with some codes but one in particular is giving me a certain headache. There is a record…
-
1
votes2
answers1063
viewsLeft John returning more records
I have a main table with about 5,000 records, and I need to search for information in another table with 7,000 records. But my query is returning +6,000: SELECT principal.id, info.nome,…
-
1
votes0
answers83
viewsSet attribute as foreign key ebean intellij
I have the following class: @Entity public class exemplo extends Model { @Id private Integer id_nome; private String Designacao_PT; private String Nota_PT; public exemplo(Integer id_nome,String…
-
1
votes1
answer86
viewserror when converting an Oracle precedent into a Postgresql function in pl/pgsql
I adapted the code, but there is the following error : ERROR: relation "fields" does not exist CONTEXT: compilation of PL/pgsql function "p_grava_log" CREATE OR REPLACE FUNCTION F_GRAVA_LOG ( TIPO…
-
1
votes0
answers411
viewsmdaccess b - Microsoft JET Database Engine error '80004005'
Overnight (after a windows update) my MDB files no longer open via IIS - ASP) with the message: Microsoft JET Database Engine error '80004005' - non-specific error. Connection stopped working for…
-
1
votes1
answer87
viewsFormat result with concatenated field
I need to bring from my database a TIMEDIFF with field formatted like this: 12:50 (hours and minutes). I use the following excerpt:…
-
1
votes1
answer272
viewsSearch the database with encrypted data
I own a database where the entered data is encrypted through a function written in PHP, this function encrypts and decrypts. I need to search this table. For example, I search for "BRAZIL", but in…
-
1
votes1
answer648
viewsUnilateral replication in Postgresql
I have two servers. One is only and exclusively for testing. The other is for production itself. I need the test database to contain the same data from the production database. I can’t do a mirror,…
sql database postgresql synchronization replicationasked 9 years, 9 months ago Pedro Vinícius 1,870 -
1
votes1
answer85
views -
1
votes1
answer1688
viewsSecure backup using Mysql and C#
My application is C# and BD is Mysql, when I do the backup he creates a arquivo.sql. That one arquivo.sql can be easily edited in a notepad, or any other editor, thus leaving my comic very truthful,…
-
1
votes1
answer437
viewsLogical deletion of SQL Server records
We have the culture of making only logical exclusions in the application, keeping 2 fields where 1 is the date of exclusion and another char that gets’S' or 'N'. When we perform searches for deleted…
-
1
votes1
answer1769
viewsHow to insert UUID automatically into a Mysql Database?
Is there any way to insert a UUID automatically in a table field, in the same way as with a field of the type AUTO_INCREMENT? In a framework for PHP, Cakephp, when defining the primary key as…
-
1
votes2
answers219
viewsTool to debug a stored Procedure on linux
would like to know if anyone knows or even used any tool to realize a debug in stored procedures in linux. I am currently using the Mysql Workbench and the Dbvisualizer, but as far as I know none of…
-
1
votes2
answers167
viewsUse of the database connection class
It seems to be a silly question but come on, I have some tables in my database and I need to query them, but they are not @Entity, I did not create the sources, the only way to do the queries would…
-
1
votes1
answer238
viewsRelationship Tables
I have a table Endereco which serves as much to Funcionario how much for Supplier: 1 Funcionario possui 1 Endereco 1 Fornecedor possui 1 Endereco How I create this relationship without having…
-
1
votes1
answer601
viewsRelationship between tables in Mysql
I am creating a site and I have a problem in it, in this site I will display some characters of the game League of Legends and I will show which character is strong or weak in relation to others,…
-
1
votes1
answer77
viewsFail to delete using eclipselink
Good afternoon, everyone. I am maintaining a system that another developer started, before he was using Hibernate and then migrated to eclipselink. When using Hibernate was working normal, and when…
-
1
votes1
answer86
viewsMulti Sql Begin, database data protection
In my application I use BEGIN;, COMMIT;, ROLLBACK;, Try, Catch: Example: try{ $this->execute('BEGIN;'); // CODIGO COM VALIDAÇÕES $this->execute('COMMIT;'); }catch(Exception $e){…
-
1
votes0
answers60
viewsDAO class recording in multiple tables
I have a model object Mensagem that has the attributes Tipo and Descricao, the information of this object must be saved in a database, so I created a DAO class responsible for inserting it in the…
-
1
votes1
answer110
viewsJava project with Oracle and Mysql at the same time?
In view of an Oracle BD and a Mysql BD, and the impossibility of integration of both bases: It would be possible, for example, a class of my application to 'look' at the mysql table and update an…
-
1
votes1
answer5993
viewsHow to read an Excel 2013 spreadsheet and write to a Postgresql database?
I’m having trouble recording information in the database. This information I extract from an Excel file. For example, I have 3 fields and do not know how to take the first cell and record in the…
-
1
votes0
answers717
viewsOracle Data Modeler - Connect to Mysql Database
Hello! I’m having problems about two days ago about how to connect the ODM ( Oracle Data Modeler) to a mysql database. The process in all the locations I found consists of: -Start Oracle Data…
-
1
votes1
answer66
viewsError in Namedquery
Good evening guys, I’m looking to create a namedquery with a bank appointment. Follows: @NamedQuery(name="ListagemProdutosMesa",query="select Produto p FROM Produto p, Pedido pe, Conta c,…
-
1
votes1
answer994
viewsHow to convert to Database and check if a date is valid
How do I convert to YYYY-mm-dd and check if a date transmitted by a user via POST method is valid for my application?
-
1
votes1
answer264
viewsCart php quantity
I have a cart made in php and the products are in the database, as I do to put a restriction on in a particular product for example: Product number four in my database, I want it to be only 100.…
-
1
votes1
answer108
viewsSQL database for multiple users
Well, I have a question. I am developing a web application that will suit more than one user, however each user has different data recorded in the database, and this volume will be great, since the…
-
1
votes3
answers1239
viewsCode to display the login client data
Well my question is this, when logging in how I get session data? I think it’s a select, but when I do it I have to create a session? Because I want to search the data only of this client who logged…
-
1
votes1
answer389
viewsMulti-action and content notification system
I am trying to understand how best to make a notification scheme for multiple actions and nodes. Basically one should notify someone whenever an action of the type message or enjoy is performed.…
-
1
votes2
answers1431
viewsMake a program in c# that runs online
Hello, I’m a beginner in programming and I’ve touched a little with c# but very little! In my work was put a proposal for me to make a program in c#, html or java to store the release of company…