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
votes3
answers3400
viewsField value related to another field of another table?
In MS Access I have two tables: tbCursos and tbPeople tbPeople contains: ID, Nome, CursoID, CursoNome; tbCursos contains: ID, Nome; It is possible to make the field CursoNome table tbPeople have the…
-
1
votes1
answer1358
viewsHow to save and recover a date field in Sqlite3?
The point is that on the Sqlite website itself says that for fields date is to use numeric type or string, all right with numeric I write in the bank the date without special characters, however in…
-
1
votes1
answer848
viewsProblems with Mysql Server for OS X
Hello, Has anyone here managed to install the MySQL Server for Mac? I installed it, but I can’t start it! I click on its panel button, ask for the password, type and nothing. Trying for the…
-
1
votes2
answers1980
viewsHow to group results from a row query to columns
Good afternoon, have this query SELECT tblcliente.idCliente, tblclienterespostapre.resposta FROM tblcliente INNER JOIN tblclienterespostapre ON tblclienterespostapre.idCliente = tblcliente.idCliente…
-
1
votes1
answer53
viewsI cannot enter user through/php database
Good morning, you guys. I’m facing a somewhat embarrassing problem. I can update the user via the panel I built, but I can’t add a new user to it. Follows the code. <? if…
-
1
votes0
answers33
viewsWhat a PHP class would look like to do a database search with PDO
I’m trying to do mine framework, I’ve already managed to create a class called Model, within it has a function called getDataBaseConnection() and now how do I do it? I can’t create another function…
-
1
votes1
answer1739
viewsHow to use "Sync" from Laravel 5.1?
I recently discovered a feature of eloquent called sync, I saw that he kind of compares the data passed with the data that’s in the database and deletes or inserts what’s different. I wanted to…
-
1
votes2
answers601
viewsHow to use my already populated Firebird database for a web project in visual Studio 2015 using Entity framework?
I have an already populated Firebird database and would like to use this same database for a Web project in visual studio 2015. I already installed Firebird ADO.NET Data Provider and tried to give a…
entity-framework firebird connection visual-studio-2015 databaseasked 8 years, 9 months ago Victor Glauber 95 -
1
votes1
answer6989
viewsmb_convert_encoding vs utf8_encode()
I did an update on php on the server and identified that they were not being coded in the standard utf-8, the first thing I checked was the connection class I use, which in this case is adodb. In my…
-
1
votes1
answer81
viewsHow do I know the current connection the system is using in Cakephp 3.0?
Hello, I am working with two types of connections in databases with different settings. I want to know how I can get the current connection that the page is running dynamically. Currently I use…
-
1
votes1
answer630
viewsEncrypt Sqlite3
There is a free way to encrypt Sqlite3 database? I’ve seen some pretty expensive proprietary software.
-
1
votes1
answer152
viewsReturn method with throw
This method has the type of return Connection, however in the blocks catch there is no return conn and still there is no compilation or execution error. I believe it is by throws and throw but I…
-
1
votes1
answer5456
viewsConnection of the Database to the 000webhost
I’m having a problem connecting to 000webhost The code I have is: I think I’m fine because I just changed the values you matched to the localhost <?php ob_start(); $link =…
-
1
votes0
answers39
viewsUsing two Resultset + Userlist
I’m doing two distinct database searches that will return various data that will be entered in a list. I need to create a single list with this data. And the queries must concatenate with each…
-
1
votes1
answer947
viewsShared database
First of all, I have no experience with databases. Well, my question is the following, how to create a database for an android application, in which data registered in it, could be accessed by all…
-
1
votes0
answers90
viewsHow is the database of a WEB application created and configured?
How is created and configured database of an application WEB? Routines responsible for the creation of the database and all CRUD in the application itself when it is first started on the server or…
-
1
votes1
answer23
viewsShow occurrences as fields
I am doing a query in the database, I wonder if it is possible to group elements and display them as if they were fields and within these fields the amount of occurrences. ex: The table looks like…
-
1
votes1
answer54
viewsIn which cases work with more than one php database?
I am working on a system where more than one company will have its space and I want to do something where companies register their products and visitors (users) can first of all see all companies…
-
1
votes2
answers371
viewsCodeigniter View
I am not able to present data on View. Model bank class ModelBanco extends CI_Model { public $em; public $senha; public function __construct(){ parent::__construct(); } function get_user(){…
-
1
votes1
answer465
viewsExtracting postgresql data to file
I am trying to extract data from a table to a file with the following command: COPY historico TO '/home/jessica/teste.txt'; But the following error occurs: ERROR: could not open file…
-
1
votes1
answer202
viewsPre-written database (Phonegap/Cordova + sqlite)
I am developing an App using Phonegap/Cordova and Sqlite, but along with the application it is necessary to go a database containing approximately 50MB of text information. I’m using the app…
-
1
votes1
answer71
viewsHibernate with bank
I am using creating a program that adds an information in a database through Hibernate, almost an hour ago it was working perfectly, but now when I run the code generates these errors.…
-
1
votes1
answer421
viewsProblem using javascript, NODE JS and CSV database
Hello! I’m doing a project for the school using IBM’s Bluemix and am having some problems finding my mistake. I am using a database in CSV that has as parameters the neighborhood, number of rooms,…
-
1
votes0
answers176
viewsCommunication failure with Communications link Failure database
I have a database that is in the cloud, because it’s from a site that I and some colleagues are creating and I needed to connect it to Netbeans, I put the host, the name of the database, user and…
-
1
votes1
answer163
viewsjava programming and database connection
I have a problem that’s making me miserable. Here’s the thing: I have a database and have my program in java everything connected, already created the jar file and all. But the problem is that the…
-
1
votes1
answer164
viewsHow to change runtime driver letter in Delphi
Friends, I decided to simplify the use of a system in Delphi, using the banco de dados and the executable available in a pen drive. With that, I have my tables on Access, and arranged in a…
-
1
votes2
answers6151
viewsWhich Mysql command kills the process if a query takes more than 20s to execute?
People would like to know some configuration command in mysql, which kills the process if the query takes more than 30 seconds to return some result exists ? as ?
-
1
votes1
answer99
viewsMysqli Prepare with Loop for Select
I’m trying to make a SELECT using MySQLi and PREPARE in a FOR but not working. Always returning a single zero. Application Code: if( $teste = $mysqli->prepare("SELECT COUNT(*) AS TOTAL_CONTATOS,…
-
1
votes0
answers32
viewsA database or an individual database for each user?
Good people, I thank you for being here helping me, come on. I’m having a question I’m having a hard time getting answers to. Let’s say I’m creating a system, OK. In this system each company will…
-
1
votes1
answer56
viewsAccess Violation in module 'Dbxcommondriver220.dpl'
I’m having trouble using Firebird in Embarcadero C++ XE8. Error: Access violation in module 'DBXCommondriver220.dpl'
-
1
votes1
answer368
viewsHow to implement product returns?
I am having difficulties in implementing a requirement in database modeling, this requirement corresponds to product returns. This is the scenario that occurs the returns and the different modes of…
-
1
votes1
answer168
viewsHow to know the contents of a foreign key for filling another table?
I will give as an example 2 tables of a database: User and Address. where the user has the idEndereco attribute as a foreign key to the address table. The ids are with AUTO INCREMENT, yet, how do I…
-
1
votes1
answer128
viewsCreate Divs according to database entries
Good morning, I am developing a website and would like to create a new div for each entry the database presented in php. I need to make a page with the same principle of a blog, the last content…
-
1
votes0
answers113
viewsConnecting Powerpoint to Access through VBA?
I’m creating a kind of "urn" Power Point would like to 3 (three) basic solutions for calculating votes; When you click the confirm button, the vote is automatically sent by e-mail, to a particular…
-
1
votes1
answer4170
viewsInsert various data into ibexpert
Good guys a little while ago I started using the Firebird and I have the following problem , when trying to insert some data directly in the IB Expert it returns me the following error : Invalid…
-
1
votes1
answer622
viewsHow to receive a variable within the php URL
I’ve had a problem for two days that I can’t decipher. I need the login and password variable passed in my system login form, to reach the url that receives the user and password parameter. This way…
-
1
votes1
answer335
viewsPostgresql many processes
I have Postgresql installed in a machine where runs a system, and throughout the day there are several processes with postgres.exe and consumes machine resources. At times it has more than 100…
-
1
votes3
answers404
viewsHow to store static information without using a database?
How to store static information without using the database? For example, let’s say that I have a text on a page, which does not need changes frequently, and to avoid using server resources and/or…
-
1
votes1
answer438
viewsHow to create a select in Firebird?
Create a select listing 03 fields from any table by sorting the data through the 2nd field. I’m pretty weak in Irebird someone can tell me how to do it?
-
1
votes2
answers186
viewsTaking image from Mysql
I’m making a website in PHP and MySQL to store the products and their image. On the products page there are 5 or more models and I need to pick up 5 or more images of each product. I don’t know if I…
-
1
votes1
answer110
viewsShould I use foreign_key in both has_many and belongs_to?
I have two models. Office and Employee. Employee has office_id as foreign key. So, which is correct? class Office < ActiveRecord::Base has_many :employees, foreign_key: 'office_id' end class…
-
1
votes0
answers174
viewsHow to Update SQL Server Localdb Version
I have a site project in ASP.NET MVC shared on team and home pc. I can connect in DB normally, however, when I log some user registered on the site on the pc of the job it happens the following…
-
1
votes1
answer143
viewsI’m having trouble connecting SQL with java
Well... I did some classes, and it was time to connect to search for a data in the bank; Ok. He had already connected with the BD, however, when I did the class to fetch the data, he keeps giving…
-
1
votes1
answer56
viewsProblems in PHP
Hey, you guys, come on! I’m new with PHP and Mysql Database. For several days I’ve been breaking my head with a code and I can’t find the error at all. :/ I have an index.php page, with a form…
-
1
votes1
answer201
viewsHow to measure the amount of disk space required for an ALTER TABLE operation?
I need to make some changes to one of the tables to add new columns. The problem is that I cannot do it. I get the following error: PG::Diskfull: ERROR: could not extend file…
-
1
votes1
answer513
viewsBring BD data with javascript
Hello ! I have a MENU and a submenu within each item of this menu. Every time I click on a menu item, it opens a sub-menu (accordion effect). There’s a way to make a select within the database and…
-
1
votes1
answer199
viewsUpdate table with data from another table decreasing character
Hello, I have the bank BDMCOM1 that has a table Product Balance and a column Quantity with values like: 1,000. But I have another bank BDMCOM1_V3_ALEA that also has the table Product Balance and…
-
1
votes1
answer657
viewsCreate Postgres "Numeric" Field in Laravel 5.1
I need to create a field like Numeric existing in postgres using migrations from the Laravel, can anyone tell me how I do? I tried that, but it didn’t roll: public function up() {…
-
1
votes1
answer108
viewsHow to return an SQL with result?
I need to select several tables linked by the "user id" and return the data to compose a profile page, but some of these tables may be empty at first, that is, the query will not find the "user id"…
-
1
votes3
answers4847
viewsINSERT inside a SELECT - SQL Server
I need to do an INSERT inside a SELECT in some cases in my Query. An example of how accurate: SELECT IdTabela, Nome, CASE WHEN IdTabela > 10 THEN INSERT INTO TabelaExemplo (IdTabelaExemplo)…