saurav.prasad28

HI i think this is help ful for u This is for insert [code=sql]DELIMITER $$ CREATE /*[DEFINER = { user | CURRENT_USER }]*/ TRIGGER `saurav`.`aa` BEFORE INSERT ON `saurav`.`authortrigger` FOR EACH ROW BEGIN insert into authortrigger_copy(AUTHID,AUTHORFN,AUTHORLN) Delete TRIGGER DELIMITER $$ CREATE /*[DEFINER = { user | CURRENT_USER }]*/ TRIGGER `saurav`.`aa` …

HI lyardson I think this querry is helpfull for you Table name forums id name 1 \N 12 a 15 r 18 u 32 s 21 a 2 v Querry : [code=sql]SELECT A.6thmax, B.5thtop FROM ( SELECT id AS 6thmax FROM forums ORDER BY id DESC ) A, ( SELECT …

[QUOTE=Vandithar;881592]Hi, I am not using css! This is the data i.e in my table. [code] name +------------------------------------+ | name | +------------------------------------+ | This is an rna-binding protein. The data which is useful is available from the desired location. | +------------------------------------+ 1 row in set (0.00 sec) [/code] I tried with …

hi all Database Masters Here i have suffer one critical issue,i have two column a and b, Table name : Student "A" "B" "1" "SAntOsh" "2" "SAuraV" "3" "SAriya" "4" "SAnju" "5" "SAthiYa" These are the sample records from my Table field. The "B" column always start with 'SA', the …

Hi suppose i have two table book and authors [COde=sql]select * from book;[/COde] "book_id" "title" "first_name" "description" "publisher_id" "1" "Let us c" "Graham" "1" "1" "2" "Maths" "greee" "1" "2" "3" "Oparating system" "prasad" "39" "3" "4" "Micro processor" "jamej" "0" "4" "5" "Micro processor" "robert" \N "5" [COde=sql]select * …

Hi guys, I know what I need, but not sure how to do it.. a) Store values in a database field like: 12|3|43 b) How to retrieve these values as seperate variables. Appreciate any help! :'( Thanks

hi wowawiwa do this this is helful for u [code=sql]Update Table1 set field1 = REPLACE(field1, 'aa', '');[/code] Regards Saurav

HI try this [code=sql]SELECT tbl_Products.ID, tbl_Products.CategoryID, tbl_Products.Title, tbl_Products.[Description], tbl_Products.Body, tbl_Products.DateCreated, tbl_Products.DateUpdated, tbl_Products.ManufacturerID, tbl_Products.ManufacturerLocationID, tbl_Products.[Status] FROM tbl_Products JOIN tbl_ProductDetailsText ON tbl_Products.ID = tbl_ProductDetailsText.ProductID WHERE tbl_Products.CategoryID = 87 AND (tbl_ProductDetailsText.CategoryFieldID = 670 AND CAST(tbl_ProductDetailsText.CategoryFieldItem AS INT) >= 0 AND CAST(tbl_ProductDetailsText.CategoryFieldItem AS INT) <= 999) AND (tbl_ProductDetailsText.CategoryFieldID = 671 AND tbl_ProductDetailsText.CategoryFieldItem = 'Nike')[/code]

I think this is helpful for you select * from employee order by book_id limit 7; Thanks

[code=sql]"Table" "Create Table" "categories1" "CREATE TABLE `categories1` ( `cid` int(11) NOT NULL, `name` varchar(30) default NULL, `parentid` int(11) default NULL, PRIMARY KEY (`cid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1" "cid" "name" "parentid" "1" "A" "22" "2" "B" "23" "Table" "Create Table" "categories2" "CREATE TABLE `categories2` ( `parentid` int(11) default NULL, `cid` int(11) …