I am doing some pagination for a web site using MySQL and Java. The SQL I am using is something like
SELECT * FROM table WHERE ....... LIMIT 0,10
There Where clause differs depending on ...
hi,
Please kindly assist is there a isnull() function in mysql?
Thanks.
Server = MySQL 3.23
Idea : To get the time difference between two fields
select sttime, endtime, (period_diff(endtime, sttime)) as a from worklog
where id > 2000 limit 10;
+-------------...
The script -www.nihaorr1.com/1.js is getting inserted into every record of my organizations SQL db. I'm the accidental techie in my office, and I'm clueless as to the vulnerability in our cod...
Is there some kind of workaround that would make it possible to achieve the equivalent of Oracle's DECODE function in a MySQL query? Or could it be done through some convoluted PHP code?
I'...
hello dear
I can call a stored procedure that returns a result set in the MySQL Query Browser, but if I try to call it from a vb.net program then I got this error "PROCEDURE xxx can't return...
Looks like mysql 3.x version does not support union or intersection.
How would I achive this in mysql without using intersection keyword?
select * from a
intersection
select * from...
Hello experts, hope you can help me with this problem:
I'm trying to use the create function statement inside a delphi program using Zeos DBO to connect to a MySQL 5.0.41 server. here's the...
EE Experts:
I know that there are about 10 answered questions in the EE knowledge base with this or similar title, but so far none of them have a solution that I have been able to make work...
Hi!
I need to retrieve records that have been modified in the past 30 days and the past 7 days. I've tried using
$query = "SELECT * FROM dd_productinfo ORDER BY code DESC where DATE_SUB(D...
Hello All Experts!
I am building a database of ICONS, literally ICO files and would like to display them in a webpage using PHP, MySQL.
I have been able to upload, insert and retrieve / ...
i have a phone number in the format of (561) 297-3060 substr statement. I want it to update it with a sql statement to 5612973060.
Hi,
I have three select boxes which I implode to create one variable called $tcomp. This is saved into my db table. What I want to do is compare the variable date ($tcomp) held in the dat...
I have a Plesk Server with Plesk 8.1 installed on it. Since Plesk 8.1 supports remote database like MYSQL and PostgreSQL i decided to hosts some databases on another server.
So i bought a new...
This is probably pretty simple to do. But, I need a mysql command to copy/update one empty column with another column's data in the same row for multiple rows in a table.
I need column1's ...
Ello everybody,
Anyone know how to do this code in php to mysql
I have a mysql table that I want to insert Blobs(pdf's) into from the commandline.
The pdf's are on workstation with network connection to mysql server.
D
Hi all,
I have selected a row of a table by using select query. How can I know the row's number of that row ?
Hi,
I need help to resolve the following error. I am running mysql 5.0 (on windows xp). I have been able to connect mysql 5.0 before but I executed "webroot spy sweeper" a program meant to ge...
I'm having trouble connecting to my local MySQL server, and I'm not sure what I'm doing wrong here. I have a very simple script. When I try to connect with the hostname 'localhost', I get an e...
I am trying to create a list of data where id is sorted highest to lowest, but where each name is unique.
For example:
name : id : text
aaaa : 11 : stuff
bbbb : 12 : more stuff
aaa...
What's the easiest way to change column order in a mysql table?
Thanks
How can I make Entity relationship diagram for my Mysql tables. Is there any tools for that?
I have a problem with my query here. I get this error message Cannot add or update a child row: a foreign key constraint fails.
I am trying to make a wall where people can write on it.
I h...
I have this query:
SELECT timediff(stop_time,start_time) as total from `work`;
which gives me this
239:53:36
where 239 is hours, 53 is minutes and 36 is seconds.
Instead, I want i...
