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
-
0
votes0
answers46
viewsIs it possible to disable transaction log in Sybase Anywhere 9?
It is possible to disable transaction log on Sybase Anywhere 9. Disable for a specific table?
-
0
votes1
answer5001
viewsRemote procedure call failed. [0x800706be]
After installing SQL Server 2008 R2, access SQL Server Management Studio but server name does not appear and SQL Server Configuration Manager services are not active.…
-
0
votes1
answer77
viewsDoubt about 'NUMA' (non Uniform memory access) in Microsoft SQL Server
Someone can help me understand in English the concept of 'NUMA' and its characteristics? I have found sites in English etc, but I still do not understand!
-
0
votes1
answer257
viewsDisplaying saved image in PHP database /Restaurant
$pdo->bindValue( ':img_prato' , $_REQUEST['img_prato']); = sw-profile.jpg How do I display the image, not the path? Insert.php <?php require_once 'usuario.php'; require_once…
-
0
votes1
answer145
viewsSyncing the Desktop and Mobile Database?
Well I will start working on a LARGE project, which will be MULTIPLATFORM, both for Desktop and Mobile, and we are discussing a way, to work with the DATA BASE in both applications. The interactions…
-
0
votes1
answer151
viewsTables with database data
Someone knows how to restrict a certain number of rows in the table, but when doing scroll see the rest of the data? For example, a company that stores customer data in BD and wants to see all…
-
0
votes0
answers110
viewsHow to display the duration of a bd video with the getid3 extension?
<?php Include ("getid3/getid3.php"); $filename="nome_do_video.mp4"; $getID3 = new getID3; $file = $getID3->analize($filename); echo $file['playtime_string']; ?> It’s just that when I try to…
-
0
votes1
answer75
viewsHow to Persist Progressive Discount Information?
I have a situation where there is the following business rule: when using the system to place an order it is possible to place a progressive discount that occurs by adding a variable number of…
databaseasked 9 years, 4 months ago SomeDeveloper 18,074 -
0
votes1
answer713
viewsMysql - Derivative Value Triggers
I looked it up and couldn’t find it anywhere. I am starting in Database studies and need the following help: A table Gang has the following structure: Id_class(auto incrementable)…
-
0
votes0
answers119
viewsOptimize SQL Code
I wonder if the one way I can optimize this sql code (mysql) that I did, the search is too slow, taking too long to bring the selected fields, I’ve done some tests but it’s still the same. SELECT…
-
0
votes0
answers39
viewsSave Arrayiterator to Mysql
I’m having trouble saving a list of items on ArrayInterator, where I need to save this data to the table by clicking a save button. Array code: <?php ... $p = new…
-
0
votes1
answer790
viewsinserting image in mysql database
If I want to insert an image in the database just use the following query: INSERT INTO teste (Id_Blob,Na_Imagem) VALUES (1,LOAD_FILE("C://imagem.png")); if I want to insert an image that be on…
-
0
votes1
answer6798
viewsView database in Sqlite
Is there any way I can view the Sqlite Database without having to write the command in the application? I would like to see the records inserted in a table, but I do not know if on Android only…
-
0
votes1
answer68
viewsProblems entering data into database
Good, I’m here with a problem because I enter all the data but does not keep me in the database. Does anyone here know the problem with the following codes: <form…
-
0
votes2
answers114
viewsInsert Mysql error
Well, I’m trying to create a menu, and my sql is returning the following error: These are the results you’re picking up, so I gave an echo to see if it was going properly. Who we are is the name…
-
0
votes2
answers513
viewsMYSQL - Column order and performance
I may be asking a silly question, but come on. The order of the columns in the MYSQL interferes something in terms of performance in some way (whether in writing or in research)? Foreign keys are at…
-
0
votes1
answer583
viewsForeign keys in database modeling
A primary key can have two foreign keys in different tables? For example:
-
0
votes1
answer210
viewsSearch with OR in Django
Hello I’m developing my 1° application in Django and I’m having difficulty with more complex research in DB. Here is my MODEL: class Tag(models.Model): objects = GChartsManager() idtag =…
-
0
votes1
answer65
viewsDifficulty with Encoding
Good, I have a file PHP with encoding UTF-8. And the text with accents in the part HTML they look like they should, but when I go to the database. Encoding of the database Data from the database…
-
0
votes1
answer36
viewsElaboration of an application for publishing events
I’m wanting to make an application for events it’s in development more as I will post the posts of the events in the application type will have an event in such a corner I want this event to appear…
-
0
votes2
answers658
viewshow to display related posts via php tags
I have a posting system where the user makes a post with the following fields: title, description, tags (separated by comma) as I could make a query in the table through the tags and display the…
-
0
votes1
answer126
viewsBackup SQL SERVER database
I have a database stored on the client’s server. I only have access to the Connection string of this database, so I can manage it, as I can back up the bd on Server for My Local Machine, for…
-
0
votes0
answers29
viewsMysql PHP transaction concept
You can use the concept of programming transaction in PHP, because in java you have this possibility. How to do this in PHP ? Example commit, rolback...…
-
0
votes0
answers40
viewsIs it feasible to use BLOB for BD images?
I’m designing a database and I’m wondering if I should store profile images in a field blob in the table or store the image physically in a Storage and create a field text that contains the image…
-
0
votes1
answer88
views -
0
votes1
answer4099
viewsHow to list data from a Mysql database using the Java List (jdbc) method?
I’m having trouble trying to list the data. Exception in thread "main" java.lang.Nullpointerexception at modelo.Dao.getLista(Dao.java:111) at principal.Main.listarViagem(Main.java:161) at…
-
0
votes1
answer217
viewsTclientdataset does not start
I create at runtime a TClientDataSet, start, do Insert, but in some computers does not start or create the TClientDataSet. Windows from my computer (Desenv) Windows 7 32 bits, works perfectly.…
-
0
votes1
answer114
viewsCommunication between database and the Python app - mini password-taking system
Hello, I am learning python and I decided to do a mini project, a simple system of chips, while I thought about the subject came me some doubts and I could not find anything about. The program would…
-
0
votes1
answer421
viewsUpdate one entity after entering data into another
I urgently need to find some way to resolve this problem that has trapped me for over a week. Once solified, I believe I can use this medium to do other operations that my system will have. I have…
-
0
votes2
answers3513
viewsHow to run an application with Database on Android?
I’m starting my activities in the mobile world, and would like to build an application that uses Database for Android platform, an example application so I can move forward, I looked on the internet…
-
0
votes1
answer1137
viewsHow to open the image in the gallery by clicking on it through my application?
My app has a button that when it is pressed opens the camera, as soon as I take the photo, it is placed in an Imageview on the screen and the image path is saved in my database. I would like to know…
-
0
votes1
answer59
viewsSelect multiple to avoid 2 database queries
I have the following select (using PDO): $usuariosListados = $pdo->prepare("SELECT user_1, user_2 FROM usuarios WHERE user_1 = '".$_SESSION["usuario"]."' AND estatus = 2"); $usuariosListados…
-
0
votes1
answer56
viewsConvention for attributes that preserve types
A table stores data from teachers. Each teacher has a degree: specialist, master, doctor, post-doctor and others. Another table present in the base is the publications. Each publication may (or may…
-
0
votes0
answers607
viewsSql Server 2008 - Error: Undefined object reference for an object instance?
I was using sql server 2005, after doing the update, all databases does not allow the display of tables in Design mode, and does not let create new tables. I tried to make the creation of a table in…
-
0
votes0
answers107
viewsSelect Advanced separated by hour
I rode a SELECT to return some information from my table separated by time and date. Until this part is all working correctly. Now I need him to select the same data only from another date, being…
-
0
votes1
answer45
viewsList database file and put a new row after a certain number
I’ve been trying for days to find a small solution: Example: I have this code: //LISTAR AS PLAYLISTS $dados_playlist = mysql_fetch_array(mysql_query("SELECT * FROM playlists where codigo =…
-
0
votes1
answer466
viewsOrganize schedules in the Database
For the construction of a table on the site that will contain a listing of every day of the week, how can I create these tables in the database? For example: Bus line schedules from one city to…
-
0
votes1
answer58
viewsDoubt in app creation
I’m creating a mobile app phonegap/Cordova in which I need to search the name of a location, phone and address and find it on a map. I am in doubt if I use phonegap/Cordova Geolocation or the google…
-
0
votes2
answers1544
viewsExport SQL Server 2014 Database
I need to export the SQL Server database to send to a friend. However I am not getting, I wonder if I copy these files and send to it, if it will work in his SQL Server (I do not know what version…
-
0
votes2
answers159
viewsJavascript and C language accessing the same database
I’m using a Facebook APP (and Javascript SDK) to use login on a website, in addition I must store some basic information about the user. As required by the teacher, this site was built "using the C…
-
0
votes1
answer146
viewsQuestions for Swift app development
I’m working with an iOS app and I’m using Swift. My client who owns a restaurant would like to use an administrative panel to add new dishes to the app. I wonder if there’s a panel on the net that…
-
0
votes2
answers1165
viewsbring data from the database with Javascript
I have a <a href="javascript:void(0);" class="justificar" data-value="<?= $l->img_id?>"> that when you click, I need you to bring a data from the database, but I don’t know how to…
-
0
votes1
answer280
viewsCan I have procedures with the same name and number of parameters in the same package (ORACLE)?
I can have a package with two procedures of the same name, quantity and type of parameters just by diversifying the name of the parameters?
-
0
votes1
answer94
viewsMy application does not change database data
I’m developing a software for a video rental company with MVC. There are two problems: not changing people’s attributes and displaying the following error: java.sql.Sqlexception: Column 'code' not…
-
0
votes0
answers183
viewsDifferent results for Mysql 5.1 and 5.7 query
We developed a project for a client using Mysql 5.1.68 and at the time of publication we identified that the client’s hosting had version 5.7.4. After publishing the project, we started to check…
-
0
votes2
answers6610
viewsSelect within select sorted by the second mysql query
I got a problem, I don’t know if I’m doing it right, but come on. I have a table that lists some employees ( tblTecnicos ). I have another table , which has the records of services that these…
-
0
votes1
answer204
viewsMysql beginner with a lot of difficulty
Guys, I wanted to start learning MySQL, but I’m not getting started, I don’t understand the software or anything, the web tutorials don’t talk about MySQL in Mac, only in Windows. I downloaded the…
-
0
votes1
answer246
viewsQuery in SQL, query a limited number of record
I am having a problem regarding the limit of return of information per query, For example: I have a table called "Cars". This table has 2 fields "Model" and "Color". How can I make an appointment…
-
0
votes0
answers174
viewsApplication does not access database when hosted
I have a trial hosting, but I can’t access the database. persists.xlm: <?xml version="1.0" encoding="UTF-8"?> <persistence version="2.1" xmlns="http://xmlns.jcp.org/xml/ns/persistence"…
-
0
votes1
answer371
viewsI can run any query on SQL Server without passing credentials, is that normal?
I was looking to restart the SQL Server service, that’s when I discovered a way to manipulate the database without logging into the system. See: I opened Management Studio. I canceled the…