sql

I have a PHP search script which queries a MySQL database. Currently, when no results are displayed the script shows and error. How can I make it…

I want to only display 5 results from my database with my PHP search script. How can I do this? My PHP code is: <?php…

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…

Is it possible to create a drag from mysql and count the total number of rows, but only get 20 rows at a time?

The import breaks in both phpmyadmin and bigdump. The backup is created using a php script I found online: <?php set_time_limit(0);…

I've got a table for a payroll system, with four fields, and some sample data: pkref employee_id new_wage effective_date ===== =========== ========…

I have a field with this kind of info "web-1/1.,web-2/2.,web-3/3.,web-4/4.,web-5/5.". Other registers could have different values like…

I have the following query to fetch rows from wpr_subscribers provided that the conditions in the query. SELECT subscribers.* FROM wpr_subscribers…

I have three tables in my database. Their schema is basically: books: id | book_title books_tags: id | book_id | tag_id books_votes: id | book_id |…

I need create sql script for insert in many tables - total near 2000, but tables linked (it is an xml adjancency model) - so after have inserted in…

I have many different csv files that I would like to convert in to database tables. The csv files are not always consistent, meaning that the…

I have a query timeout problem. When I did a: SELECT COUNT(id) AS rowCount FROM infoTable; in my program, my JDBC call timed out after 2.5 minutes.…

Is there any potential speed increase in using underscores instead of words with spaces in a query? For example, searching a column named "label"…

I have the following constructor (as a test): CREATE TABLE product (id BIGSERIAL PRIMARY KEY, ext hstore); CREATE INDEX ix_product_ext ON product…

I have no idea if that title conveys what I want it to. I have two tables containing phone records (one for each account) and I'd like to get call…

I am rewriting an application for my company which requires a database. We are currently using SQL Server 8 and I will be updating the database. My…

Ok, I'm trying to base something similar off of this, but not quite getting it nailed: GROUP BY and ORDER BY Basically, wanting a query to find the…

What I am trying to do is list an entry each time they have referred someone and that person is listed in the entries table as well. 3 different…