Stack Overflow
Stack Overflow

Questions tagged [database-management]

115 questions
0
votes
0 answers

Options for Database Managers for SQL Server and MDS

I am looking at ways to visualize my database for non-technical end users. I want them to only have access to views (triggers can be put on views to enable updating) and let them add, delete and modify data. It should be a simple software (hopefully…
Ben Finn
  • 1
0
votes
1 answer

how to get the summation of column in the last row

select csm.csmCustomerName, cur.curNameOfCurrency, sum(sot.sotItemTotalAmount)as 'TotalItemsAmount', SUM(sorTotalTaxAmountValue) as 'TotalTax', SUM(sorTotalChargeDetailsAmountValue) as…
Kavr
  • 17
  • 10
0
votes
1 answer

Database Memory :: MySql Innodb how much storage memory allocation for empty field vs not empty field - varchar or text

I new in database, and dont know how and when mysql allocate memory space. In MySql Innodb how much storage memory allocation for empty field (no string inserted) vs not empty field? Other form of my question: When memory allocated space In MySql…
Ben
  • 25,389
  • 34
  • 109
  • 165
0
votes
2 answers

EF Database Generated key reach the maximum value

You know that by using the bellow attribute we can auto generate identity of int for each entry in case of Adding new entry: [Key, DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } If you had focused ever, Database…
Amirhossein Mehrvarzi
  • 18,024
  • 7
  • 45
  • 70
0
votes
1 answer

How to model a list to different entities efficiently?

Given the model below: CustomerType1(id, telephone, address) CustomerType2(id, telephone, name) OrderType1(id, timestamp, customerType1.id, comments, enum1) OrderType2(id, timestamp, customerType2.id, comments) OrderType3(id, timestamp, name) How…
spxcxlxxs
  • 57
  • 8
0
votes
1 answer

MySQL Privileges To Create Database

Is there a way to create a user in MySQL that have login access but no databases, but it allows the user to create a new database to a limit of 5 or what ever I decide. So basically what I want is to give a user access to create his own databases,…
Donald Jansen
  • 1,937
  • 4
  • 22
  • 41
0
votes
0 answers

Class for managing own database in C#

A very C# beginner question: Say I have a big table with data (a detailed "log" table of transactions, for example, held in a CSV file), and I need to perform database-like operations, such as queries (WHERE X > Y...), deletions, insertions and…
Hummus
  • 559
  • 1
  • 9
  • 21
0
votes
0 answers

mysql Database Relations Clutter Quandary

I Know this is probably not a typical question for SO, but I have to ask. I have a scenario where many users can create many tests, that have answers from many test-takers. The tests can contain as many questions as the user desires. I understand…
MichaelM
  • 3
  • 1
0
votes
2 answers

Django: Query works fine with Sqlite3, don't with others Database Management System

I have quite long query with 'Q()', with Sqlite3 works very well, but with postgresql or mysql I have strange error e.g. for postgresql: invalid input syntax for integer: "(" and for mySQL: Truncated incorrect DOUBLE value: '(' How could I run that…
IProblemFactory
  • 9,551
  • 8
  • 50
  • 66
0
votes
1 answer

How to manage eficiently the new products of my database?

I have a database of a store which I have to add new products constantly. But before publish a new product or after r modifying one the admin have to check if it has the correct data. I thought in two options to do it: 1.-Adding a new field called…
mllamazares
  • 7,876
  • 17
  • 61
  • 89
0
votes
7 answers

WhichdDatabase would prove efficient?

I have to develop a web application in Java, a pretty big one with loads of data to store and manipulate. I am also planning to use Hibernate and Spring. There are many databases available now like MSSQL Server, MySQL Server, Oracle, db2, etc..…
Richie
  • 9,006
  • 5
  • 25
  • 38
0
votes
1 answer

sql server split mirror db on to multiple devices

Say I have a large production mirrored 1TB DB that resides on a single MDF device and I would like to split that up into say 5 200 Gig devices. I want to do this without interruption to Production. I thought I could break the mirror and use the…
RayG
  • 1
  • 2
0
votes
1 answer

Inventory with multi - unit support feature

I have been developing an Inventory system (PHP Codeigniter & MySQL), I have setup almost everything except one feature which one of my clients wants to implement to the system - A multi - unit support feature for the system. Currently my system…
PinoyPal
  • 388
  • 3
  • 12
0
votes
1 answer

Database management tool that support Database server address in IPv6 format

I use Sybase ASE 15.5 on Windows server 2008 and use Sybase central (JDBC driver) for management. After configured my machine to IPv6 only mode ( pure IPv6) and correct the DSEDIT connection properties, I can ping Datase server and access Database…
Tuan
  • 2,303
  • 2
  • 25
  • 37
0
votes
3 answers

detecting open database connections

I've built a website and has been running for a while now. but suddenly today I received and error that the maximum connections to the DB is reached. how can I list the open connections and terminate them using PHP order even through the Db…
sikas
  • 5,435
  • 28
  • 75
  • 120
1 2 3 4 5 6
7
8