Mysql Help - Digit Technology Discussion Forum

Forum

		Digit Technology Discussion Forum > Software > Open Source
Mysql Help

Mark Forums Read

Open Source A place where you can talk to like-minded people about the fastest growing software movement today! Discuss anything and everything about Open Source software and Operating Systems.

Closed Thread

16-11-2006, 02:13 PM	#1 (permalink)
Desi-Tek.com In The Zone Join Date: Oct 2006 Location: Mumbai Posts: 365	Mysql Help How to use foreign key and store procedure in mysql? pls post the information with example. Regards, Dheeraj __________________ Dhiraj Thakur thakur.dheeraj(@)gmail.com

	Advertisements. Register and be a member of the community to get rid of them.
Advertisement

Old

16-11-2006, 02:50 PM

#2 (permalink)

GNUrag

FooBar Guy

Join Date: Jun 2004

Location: GNUmbai

Posts: 1,245

Default

Re: Mysql Help

Quote:

Originally Posted by Desi-Tek.com

How to use foreign key and store procedure in mysql? pls post the information with example.

Regards,
Dheeraj

First make sure that you are using MySQL 5.x series which now has support for Stored Procedures, Views and Triggers. For foreign keys make sure that your tables are using InnoDB engine.

it wont be wise of us to create examples for you and post here. Please do your homework first, let us know where you are stuck, and then ask.

__________________
- --
http://web.gnuer.org

GNUrag is offline

16-11-2006, 03:06 PM	#3 (permalink)
Desi-Tek.com In The Zone Join Date: Oct 2006 Location: Mumbai Posts: 365	Re: Mysql Help actually i know how to create view, sp, trigger in ms sql, is it same in mysql? or does it has any syntax difference? __________________ Dhiraj Thakur thakur.dheeraj(@)gmail.com

16-11-2006, 03:36 PM	#4 (permalink)
GNUrag FooBar Guy Join Date: Jun 2004 Location: GNUmbai Posts: 1,245	Re: Mysql Help cool, if you already know SQL, then just head over to official MySQL documentation. read this and try to make sense of it. http://dev.mysql.com/doc/refman/5.1/...eign-keys.html http://dev.mysql.com/doc/refman/5.1/en/views.html http://dev.mysql.com/doc/refman/5.1/...rocedures.html http://dev.mysql.com/doc/refman/5.1/en/triggers.html there is almost no syntax differences between various databases. __________________ - -- http://web.gnuer.org

Old

27-11-2006, 12:24 PM

#5 (permalink)

bukaida

In The Zone

Join Date: Jul 2005

Location: KOLKATA

Posts: 267

Thumbs up

Re: Mysql Help

Quote:

How to use foreign key and store procedure in mysql? pls post the information with example.

check this out.
http://www.informit.com/articles/art...&seqNum=8&rl=1

__________________
Desktop: P-IV 2.4GHz, 512MB DDR, 865GBF Mother Board,
G-Force 5200FX, 17" Samsung flat, WinXp with SP2,
Kaspersky Internet Security 2009.
Laptop:LENOVO 3000 C100 D7 lappy with 2GB DDR2.

bukaida is offline

Closed Thread

Bookmarks

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On Forum Rules

Latest Threads
Sony announces the water-proof Xperia go and Xperia acro S - by clmlbx
Your Gaming Backlog/Progress Report! - by Ethan_Hunt
Language learners' discussion thread !! :D - by icebags
Official Android discussion thread - by amitabhishek
Windows 8 Thread. - by Sujeet
post your gaming hardware ! - by NoasArcAngel
Lumia 900 - by maverick786us
Unable to Boot into Ubuntu 11.10 after Hibernation! - by buddyram
Urgent help required! - by nikhilnayak
Dual Core Confusion!!!! - by rahulpv102

Advertisement

All times are GMT +5.5. The time now is 10:31 AM.

Search Engine Optimization by vBSEO 3.3.2