schema

i will create schema the database MySQL. There are username, password etc and rating system and available in month. Standard it looks like this: id…

I am having a mysqldump file which contains schema as well as data dump. I need to import only database schema from my sqldump. I tried with…

I have many products (product_id). Users (user_id) view the products. I want to query which users viewed whatever product in the last 24 hours . (In…

We have currently one running project which uses RDBMS database( with lots of tables and stored procedures for manipulating data). The current flow…

I am designing a database using the mySQL workbench tool. The diagrams are excellent for showing the overall structure of the database but they do…

Hi, So I have multiple sqlite database. /path/database1.db /path/database2.db When i make a Zend_Db_Table for it, how do I specify which db to use?…

hello:) I would like to make a simple plan: I did something like this: CREATE TABLE IF NOT EXISTS `plan` ( `id` int(20) NOT NULL AUTO_INCREMENT, `a`…

I'm creating a list of members on my site, and I want to enable them to look for eachother by first name and last name or either one. The catch is…

Hi, I am creating a system where users can join and create groups. Within these groups, members can create topics and respond to topics already…

I am currently developing a framework for my all softwares I will develop and it's almost done. My framework can be used in two ways: 1. For admin…

Hello, I'm trying to implement a messaging system in PHP and MySQL but I'm having some trouble deciding on how I should do the tables and queries.…

When using CREATE SCHEMA schema_name in postgres, how do you prevent SQL injection of the schema_name parameter, if it needs to be user-input?…

Hi, I need help setting up my MySQL Database. I would like the database to have a table called accounts. All user accounts would be kept in that…

I have a server, that was created for me. On it there is a schema called "test". I've logged in with root user, and created a new schema called…

Does usage of NULL to fill empty cells on my tables make searches / queries faster? For example is this 90 2 65 2011-04-08 NULL NULL 134 2 64…

Hi SO Community. Is it possible to use Hibernate to, at runtime, create a new database (using the annotations of the model objects as schema, or…

I have this schema for support of in-site messaging: When I send a message to another member, the message is saved to Message table; a record is…

I have several databases that have tables with the same name. I mean, I got the following databases mydb1 , mydb2 , etc and each mydb has a table…

greetings. I have a table full of songs full of data (artist, songname, link, etc). I want to set up a relationships with tags. In the end, I want…

Every week, I have to completely replace the data in several very large MySQL tables. So what I normally do is delete the existing data, import the…