|
|
Viewing 0 - 20 out of 11 Articles |
- how to add data at the end or start of text filed
Very simple query
update product set description=concat(description,'your text ') where category_id='2'......
Posted in:
SQL | By:
Shalesh | Date: 27 Apr 2011 4:08 pm |
Comments (0)- How to Copy Data from one table to another table in MYSQL
How to Copy Data from one table to another table in MYSQL
u can use Two mathods
1. By simple export import
2. or By Query
INSERT INTO tableone (f1, f2) SELECT t1, t2 FROM tabletwo
&n......
Posted in:
SQL | By:
Shalesh | Date: 27 Apr 2011 4:07 pm |
Comments (0)- Stored Procedure Help
I am creating a stored procedure (basic knowledge of sps on my part) and when I try to execute this sp I get an error message. I'm not sure what is wrong with it and how to fix it. Any idea's anyone?
......
Posted in:
SQL | By:
rekha singh | Date: 07 May 2010 4:29 pm |
Comments (4)- Database Management System
Database Management System
Database management system are used when large quantities of data that needs to be tracked in an organization. Classical paper based data management systems cau......
Posted in:
SQL | By:
rekha singh | Date: 29 Apr 2010 12:18 pm |
Comments (0)- Simple Insert data using(DATA SET) ds and dt
Save button event
protected void btn_save_Click(object sender, EventArgs e)
{
first f =......
Posted in:
SQL | By:
rekha singh | Date: 29 Apr 2010 11:36 am |
Comments (0)- Use of DISTINCT clause
Use of DISTINCT clause
In table, some of the columns may contain duplicate values. Sometimes you will want to list only the different (distinct) values in a table.
The DISTINCT claus......
Posted in:
SQL | By:
rekha singh | Date: 29 Apr 2010 11:14 am |
Comments (0)- Simple SQL SELECT Statement
SQL SELECT Statement
The SELECT statement is used to select data (THROUGH WHICH WE CAN GET DETAIL) from a database.
The result is stored in a result table, called the result-......
Posted in:
SQL | By:
rekha singh | Date: 29 Apr 2010 11:08 am |
Comments (0)- Logical AND Operator
Logical AND Operator
The AND operator displays a record if both the first condition and the second condition is true.
It can be used in any valid SQL statement such as select,insert,up......
Posted in:
SQL | By:
rekha singh | Date: 28 Apr 2010 1:10 pm |
Comments (0)- Simple insert Query
Simple insert Query
insert into <Table Name> <fileld name>values<field value>
Insert into sqldemo (id,password,status) values('sds','sad','sdsa');
Insert int......
Posted in:
SQL | By:
rekha singh | Date: 28 Apr 2010 1:07 pm |
Comments (0)- The UPDATE statement
The UPDATE statement
The UPDATE statement is used to update records in a table.
Syntax
UPDATE table_name
SET column1=value, column2=value2,...
......
Posted in:
SQL | By:
rekha singh | Date: 28 Apr 2010 1:03 pm |
Comments (0)- The DELETE statement
The DELETE Statement
The DELETE statement is used to delete rows in a table.
==========================================================
SQL DELETE Syntax
DELETE FROM table_name
WH......
Posted in:
SQL | By:
rekha singh | Date: 28 Apr 2010 12:59 pm |
Comments (0)
