Tagged Questions
0
votes
1answer
13 views
Related items - make two way correlation between records
I'm using a MySql database, where I have a table called books.
I would like to implement a system by which the user can relate two items, so that when viewing one, it appears a link to the other.
My ...
0
votes
2answers
14 views
Syntax error in MySQL delete trigger
Help with MySQL trigger?
I am trying to create an on delete insert trigger in my SQL... I have so far:
CREATE
[DEFINER = {user| CURRENT_USER }]
TRIGGER ProjectDoneTrigger After Delete
ON Project FOR ...
0
votes
0answers
18 views
Howto: database for coaching exercises, where the elements in images are indexed [closed]
I have been lurking for a while. This is my first post - please be gentle with me.
I am a Soccer Coach, and I'd like to build an open source archive of exercises. I have some experience with ...
0
votes
1answer
25 views
How to create a trigger that moves deletions to another table?
I have a MySQL database with a project and a projectover table (projects are completed by employees) and I need to create a trigger that whenever a project is deleted from the project table, it is ...
-2
votes
2answers
18 views
Create multiple tables of the same type in a database (MySQL/MariaDB)
I am trying to find a quick way of creating multiple tables in a database. This is what I tried.
USE FILESERVER;
CREATE TABLE FILESERVER.FS01 ,FILESERVER.FS02, FILESERVER.FS03 ,FILESERVER.FS04, ...
1
vote
0answers
21 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
2answers
34 views
Conditionally add a column to a mysql table
I have a project where I want to be able to manage several instances of the same database on several people's localhosts. I want each developer to be able to reset their DB back to the canonical ...
1
vote
2answers
30 views
Where would tables that are not normalised be applicable?
Is it ever best practise or recommended to use a table of the following?
id, uid, fieldname, fieldvalue
4, 12, gender, male
5, 12, age, 21-30
6, 12, location, 5
7, 13, gender, ...
-2
votes
0answers
18 views
Design a database same as Alexa [closed]
I'm going to create a site same as Alexa for my country sites.
I develop a toolbar and looking for a optimized database for saving data.
Here: ...
1
vote
1answer
21 views
sql query to sum over deltas in a table
I have incoming sensor data that is stored in a table. Each record for a sensor has few "counter" columns. Counters are nothing but a snapshot in time. example records are shown below.
|id | ...
0
votes
3answers
31 views
Data storage for stock price data, daily AND weekly?
I am storing price history data for 3500 differnt stocks from 1970 to present (with a cron job running to update it every day).
What is the best way to store this data? It will be used to run ...
0
votes
0answers
23 views
What DB structure to use for optional parameters?
The way our system currently works needs to change in order for us to expand our offerings. We track vehicles and store all their data and we allow our clients to request reports on the data. All of ...
0
votes
0answers
18 views
the right way to make group chat
im trying to make a php chat system with an option to group chat...
i have a table for the users:
Users Table:
+------------------------------------------------+
| id | name | password | ...
0
votes
2answers
41 views
Is there any built-in alternatives to cron in MySQL or other databases? [duplicate]
It's pretty basic what I'm asking.
Imagine a column for date in users table.
Username --- RegistrationDate ----- Authority
user1 - (today's date) - 1
user2 - (yesterday's date) - 1
...
1
vote
2answers
26 views
what is better, many repeated rows or increasing the tables?
I have a file sharing app. I did not store files in DB. Its just in folders. Those are user uploaded file.
Now each file can be shared with multiple users, say 1 file shared with thousand.
I want to ...
