database sql

I have a background working with relational databases but recently started to dabble in CouchDB and was surprised by how some non-relational…

In order to improve insert performance and load on server, I've decided to divide a large table into 2. A big table which will only be used for…

Im building an application and Im having a bizarre issue where sometimes an sql statement will work and the very next call the exact same sql…

I am wondering if there is any method available to implement event trigger based on time. Lets say i want to deleted/modify a record in a certain…

I have a Table (t) like this t.Name t.Parent t.Id John Bob 1 Frank Bob 2 Alice Frank 3 Tim John 4 Lucy Bob 5 Tim Frank 6 ... Now I want to replace…

thanks for taking the time to read this. Essentially I have 3 tables. Posts, Follows, Artists. What I am trying to do is pull all the 'Posts' from…

I want to query across two tables: members and payments . One member record could join with many payments. However, I need each payment record to be…

I use com.mysql.jdbc.Driver I need insert and get id. My query: INSERT INTO Sessions(id_user) VALUES(1); SELECT LAST_INSERT_ID() FROM Sessions LIMIT…

I'm new to databases, and is exploring SQL vs noSQL. What kind of data is highly relational and benefits from SQL and what kind of data does not?…

I have the following tables: users: user_id user_name message: message_id thread_id to_id from_id title message_text message_date status The desired…

I dont know what type of Audit logging system do I need for my tables design. Sometime staff change the name of the product, price, options or…

i am trying to display a varchar(40) from database to php page field. the value in database is "test address" but when it displays on page it only…

An invoice can contain 1 or more orders, how to archive this? Example of Invoice: OrderID | Order Date | Amount 31 10/02/2011 £1.50 43 12/02/2011…

I've been using MySql and I need to column called Status in a table. I know this word 'Status' is a keyword in mysql, and I would like to know if…

Here is my table: table employee ( char(50) name datetime startdate datetime finishdate } Assume that at least one employee started everyday since…

I have downloaded and stalled the MySQL server 5.5 version via .DMG on my Mac. But I am confused as to what to do next. I have the preference…

I need to create a basic database for user authentication. So far, every user has a name, a password and a role. I've found this somewhere on the…

I have a plans table: tariff | monthly_cost -------------------------- Lion , 15.00 Lion , 20.00 Cat , 15.00 Cat , 20.00 Cat Extra , 20.00 Cat Extra…

I am building a service which provides a newsletter system for the users. My question is, how to organize it on the database? user opens account…

having a little trouble with this query. I have two tables ... Account - ResourceID (int) AccountID (int) (unique auto-inc) Resource - TextName…