Related column is "invoiceid". Also, this is a PostgreSQL database. As i couldn't find place to post it, i have chosen this forum.


CREATE TABLE "public"."orders" (
"id" int4 DEFAULT...

Sorry. Yes i have.

Select * from table1 Where myid='PO-1-09/09';

Also, Like and IN don't work as well.

Hi,

PO-1-09/09 is a data stored in varchar column. When i do select * from table myid='PO-1-09/09', it doesn't return any value. If i change PO-1-09/09 to 5, and search for it, 5 returned related...

Hi,

This T-SQL works fine but i just want to make sure that it is also reliable. Do you think this is reliable?

Thanks


CREATE DEFINER=`root`@`localhost` PROCEDURE `addNewUser`(IN...

Hi,

I am thinking to create an e-commerce web site. I just want to find out about the logic behid processing the order that have more than one order. How do we place an order? Stock check and...

Yes you are right.

Hi,

I have mysql database dump xxx.sql
How can i convert xxx.sql to xxx.csv?

Thanks

Although, i have used naw33n's solution, manojjena1982's solution seems usefull to. mwasif's solution needs some time to be absorbed.

Thanks

Understood. Thanks. It works now.

Let's say a texbox has "PHP, ASP, developer, programmer, web developer, Java"

What SQL statement could be be for me to use to return results?

Thanks

Hi,
INSERT INTO money (salary) VALUES ('100,000,000.00')

100,000,000.00 is stored as 100.00 in decimal (14,2).
I don't know what is wrong?

Thanks

Hi,

How do i order results for most relevant one?

Select id, title from data where (titleLIKE '%PHP developer%')

id title
---- -------------------------------
1 ASP...

Hi,

In what sql cases we should lock particular rows? Is it UPDATE and DELETE only.

Thanks

How do i solve it verruckt24 ? I can connect to the database but i cant use phpMyAdmin GUI page.

Hi,

I get this error in my myPhpAdmin in WAMPserver 2f.
#1045 - Access denied for user 'root'@'localhost' (using password: NO)

How can i solve it?

Hi,

I need to find out the term for two different query types.

I know that we name queries as PL/SQL stored in the database and called in web pages like view, str.proc.
What do we call queries...

Thanks for the link, very helpful.

Hi,

Is a stored procedure faster or a normal inline query in a web application? I use mysql but i guess answer must be same for all databases. Maybe not!

Also, how do i test speed of the query...

Hi,
I deliberately do mistake on line INSERT INTO table2....... but, it still commits despite variable of rowcount is set to 0. How can solve it?

Thanks


BEGIN
DECLARE rowcount INT; ...

Thanks for information

For example,
First INSERT and SELECT run successfuly.
Second INSERT doesn't run.
In this case first INSERT must be canceled too. This is in a stored procedure.
Thanks

I am just trying to...

Hi dickersonka,

How would you apply your solution to code below? I couldn't do it.

Thanks again


BEGIN
DECLARE add INT;
INSERT INTO Table1 (col1, col2) VALUES (1,2);

Hi,

I have a cookie with 5 products. There will be a loop to read one by one and reduce from stock in database for each product. Now, If something goes wrong half way through i want to cancel...

I will try it again and let you know what exactly error was.
Thanks

Yes you are right. It must be CREATE FUNCTION testVAT(myMoney DECIMAL(4,2)). But, still doesn't work.

Hi,

MySQL function below is not working. I cant find the mistake. Can you help me?

Thanks


CREATE FUNCTION testVAT(DECIMAL(4,2))
RETURNS DECIMAL(4,2)
DETERMINISTIC

Because, i want to learn how to read OUT parameter.

Hi,

Stored proc code below works fine in MySQL command prompt. It returns John because it is in table. However, i can't return or read the Out parametter in PHP. I mean i cant retrieve John. I did...

Sorted. i have created everyting again.

Hi,

How do we save person's pictures in database?Do we just create column "pictutePath" and enter this value "../pictures/user1.jpg" for each person or is there any other way?

Thanks

Hi

Code below generates this error "Table 'sis_audit.pay' doesn't exist".

UPDATE pay SET Ref='111', date='2008-11-11' WHERE id=29

When i create same table in different database, no error at...

Thank you guys. It works now. Tejusi, your solution is in use.

I tried but didn't work. I dont use this logic. Therefore, ignore this post.
Thanks for your reply tejusi/

I'll try and let you know.
Thanks guys

Hi,
How can i pick next or prevoius day in mysql? Any function like curdate() ?
Thanks

Sorry i have forgotten to put "then".

Hi,

Code below is wrong but i can't find the mistake.


Set @RecAdj:=(SELECT SUM(Paid) AS Total FROM payment WHERE PayDate = CURDATE());

if ISNULL(@RecAdj)
set @RecAdj:= 0;
end if;

Hi,

Select closing From balance Where account_no = 12 Limit 1 returns an error "You can't specify target table 'balance' for update in FROM clause"
Where is mistake?
Thanks


AFTER INSERT ON...

Hi,

I have "Balance" table that is shown below.

Table :Balance
todaysDate/openBalance/closeBalance
------------ --------------- --------------
2008-07-24 250000 100000
...

Hi,

I encrypte my data when i insert into database.
insert into person (name, psw) values ('john',SHA1('111'));

What about when it comes to checking that particular encripted values? Is there...