I’m in charge of some applications that manage many TB of images. We’ve found that storing file paths in the database to be best. There are a couple of issues: database storage is usually more expensive than file system storage you can super-accelerate file system access with standard off the shelf products for example, many … Read more
In addition to violating First Normal Form because of the repeating group of values stored in a single column, comma-separated lists have a lot of other more practical problems: Can’t ensure that each value is the right data type: no way to prevent 1,2,3,banana,5 Can’t use foreign key constraints to link values to a lookup … Read more
It seems like you want to retain the original price of each item ordered. What I’d do is go with option 1, then create another column in your table that holds a string that identifies each item in the order. For example, if I were selling fruit, a banana could have iZ as a unique … Read more
Here are my responses to your questions: Whenever you look at two tables and see a Many to Many relationship, you can solve the problem easily using a linker table. Also known as a junction table “is a database table that contains common fields from two or more other database tables within the same database. … Read more
Try a WHERE clause like this: WHERE ReceivedDate > current date – 7 days
Single quotes are used to indicate the beginning and end of a string in SQL. Double quotes generally aren’t used in SQL, but that can vary from database to database. Stick to using single quotes. That’s the primary use anyway. You can use single quotes for a column alias — where you want the column … Read more