Tagged Questions
2
votes
0answers
362 views
A better database plugin for Netbeans, other than the standard one
Netbeans has a database plugin, which you can add columns or tables, but it doesn't have options for mysql, such as autoincrement or foreign key management for innodb.
Is there any alternatives to ...
2
votes
0answers
129 views
How to define empty polygon for spatial column in MySQL?
I'm trying to create spatial index over table column (bbox polygon default NULL) but get error: All parts of a SPATIAL index must be NOT NULL.
Problem is that I supposed some rows would contain ...
1
vote
0answers
50 views
Does the default character set and collate of MySQL databases affect the stored data in any way?
I think I understand the difference between character set and collation, explained here: What does character set and collation mean exactly?
However I do not know if the default character set and ...
1
vote
0answers
67 views
How to design bill table with dynamic bill details
I have different module such as painting, chasis_repair, over_oiling sections
Each module have seperate bill table for example painting_bills, chasis_repair_bills, over_oiling_bills
Now I have to ...
1
vote
0answers
69 views
How should I setup my mySQL tables for this simple php points system?
Hello I am trying to figure out the best way to setup my two mysql tables for a simple points system?
What I have:
1 - users table with id (unique),name,email,etc
1 - points table with id (auto ...
1
vote
0answers
98 views
MySQL database design for products with multiple properties and three types of properties
I need to build a database for products that have a set of generic properties such as name, price, size etc.. which I have done fine. But, each product has a set of nutritional values, which need to ...
1
vote
0answers
93 views
MySQL Workbench Deleting From Catalog
Recently I started using MySQL Workbench to design my data structures with an UML diagram. However, there is one thing I could figure out. It seems that if I delete a table from the EER-diagram view, ...
1
vote
0answers
68 views
Django database design with foreign key
I have a Django app that displays analytics for stock data. One thing that I would like to show in my analytics is a plot of current return (y axis) and risk (x axis) for stocks in the S&P500
...
1
vote
0answers
26 views
How can I guarantee row consistency with a Master-Master database replication?
I have a process that makes a call to a 3rd party system to perform some action. My users can schedule these calls in my web application, which inserts a row in my database. A scheduled process will ...
1
vote
0answers
42 views
Source not available during model and database syc in MySQL work Bench
I am trying to update a table and sync it with the source but the source isnt available as you can see in the screen shot
and the script is
CREATE TABLE IF NOT EXISTS `DAHMS`.`Answers` (
`aid` ...
1
vote
0answers
49 views
How to design the db for column update voting system?
Assuming that the db has a table 'houses' -> house_id(pk) | color | nbr_of_windows;
The houses table is populated by 1 user but later , if a column has to be updated , the update will be finalised ...
1
vote
0answers
236 views
Proper database structure for storing orders which contain products with different attributes
I've been trying to come up with a solution for my problem for several days now, but without luck. I was hoping someone might be able to help me. I'm sorry if the description is too long.
I would ...
1
vote
0answers
244 views
What is the best performance of design for my tables?
I have 3 tables that they can be on 1table. What is the best performance for its design?
I need a fast database on search and read, not on insert.
These 3 tables will be read too more than be ...
1
vote
0answers
119 views
Database design in MySQL for Rails
I'm fairly new in setting up databases. I've started building an application and after searching Google and stackoverflow I didn't find a answer that fit my needs sufficiently.
Currently I have a ...
1
vote
0answers
84 views
Live Search for Names Library
I'd like to implement a live search for items in a webpage. And I'd like to know:
The best DB design approach.
Find any good library (mysql, php, javascript/jquery) for it.
Background: The items ...
