Hi,
I have an issue with a script's SQL query that I've written.
It looks for software items in the database similar to the current page.
The current page is identified by a string like...
I am getting an error when I try to execute this stored procedure; I can't figure out why as the syntax looks OK to me.
You have an error in your SQL syntax; check the manual that correspon...
Hey,
I'm working on a question, and I got an answer, but I have no way of finding out if I'm right or wrong... so I was hoping I could get some help to figure that out:
This is th...
Hi Guys
I've got shared hosting with Fasthost with a MYSQL database. All was working fine intill about 10 minutes ago. I'm getting the below error:
Cannot start session without errors,...
Hi experts,
I want to vary the WHERE clause in my query depending on what day and time it is. My current clause works fine from Monday to Friday but is too rigid&
SELECT match_info from...
I'm getting the wrong "Average" for every record displayed and I can't seem to figure out why
For example:
YEAR SumBatRuns Innings NotOuts Average
1989 215 6 0...
I would like to know how can i speed up the full text search on a mysql database (except scaling up the server).
Mysql server version 5.0
below is a query im performing, and it takes forever.
What it does it that it extracts data from a set of tables - problem is that i have around 4 million records in the "boxes" table, refe...
Dear Experts,
This is urgent. If I mess up a database, how do I restore it if I made a backup of it using
mysqldump -uusername -p --databases DBNAME1 > DBNAME1.sql
I am assuming li...
Hello, when i tried to run my query I get this error
This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery'
im using mysql database.
I've 2 tables noticias(news) and ...
Hi, I have a apache server 2.2 with PHP 5. I am trying to connect to mysql but keep getting an error saying mysql_connect(). I installed mysql 5.1 and migrated a table into it using mysqladmin...
Hi,
I've one stored procedure in which I am doing complex calculations after that I want to use that stored procedure's output in another stored procedure table so that I can do furthur cal...
Hi,
Need help with the below MYSQL query. I keep getting 'Subquery returns more than 1 row' on the one page. Is there something I can use to combat this problem?
Thanks
I've got the below 3 queries that work out the total number of Balls a player has bowled. As you see they are all very similar except for the Fixture.Notes clause.
Is there a way I can comb...
What would be the best way to do the following query?
I have a table that holds quote info
Quote outcomes are pending, accepted or not accepted
Each quote has one of these values 99,499...
I connect to the internet wirelessly... I connect to a wireless network, and the browser asks me for username/password.
Since this is the only way I have to connect and it's only limited to...
I have trouble connecting a client on a Windows machine though MySQL database on a Linux server, using ODBC with SSL. Without SSL, no problem. I need the connection to be encrypted; I am not s...
I'm using MySQL dump 10.13 Distrib 5.1.37, for Win32 (ia32) to transfer data to a host, however it is not working.
No data is written, I just get a generic message, claiming the dump was suc...
I've got the below query and am trying to display every Dismissals.DismissalsFull record for the count(*), but it's only displaying those with a record in MatchPlayerBatting. How come? What am...
Hopefully I explain this well enough
Lets say I have
table1 name = news
column1 = news_id
table2 name = groupNews
columns:
news_id
group_id
How ...
I have windosw vista ultimate os 64 bit
I have sql2008 and it installed with adventureworks database.recentley i have uninstalled sqlserver 2008.
After that i have installed sqlserver 20...
Hi,
I would like to select records in the WHERE condition based on the following.
This is based on a date of today being 2009-09-21 08:00:00
If a user had a userinfo.creationdate of 2...
Hi expert,
I have a time databse which is using VB.net and MySQL. I want to add the total hours of each for each employee indicated as below:
Date Employee In1 Out1 In2 Out2 Total
x ...
Is it possible to run a MySQL SELECT statement with a WHERE / LIKE clause to look for all specified field entries containing the hyphen character?
ie. I have records containing info such as...
Ok I have 2 pump run times that I want to get calculate over a given period of time. The they are stored in the "tagvalue" column the keeps on counting up in hours. For example:
tagname ...
