Mysql Introduction [easy]

#1 (permalink)

03-07-2005, 09:52 PM

Mysql Introduction [easy]

MySql Introduction - By Jd-inflames

Discussion thread for this tutorial....

__________________

Audi Videos | MySpace Layouts | About Me | Kid Sniffles

Last edited by missionsix; 04-14-2008 at 01:09 AM. Reason: Added link to the tutorial

[ reply ]

missionsix

missionsix is offline patandrew.com

Join Date: Feb 2004

Location: under you.

Posts: 4,860

#2 (permalink)

03-11-2005, 05:49 PM

Users should be aware that when setting COLUMN to equal VALUE, if VALUE is not numeric, it have one apostrophe on both sides. If VALUE is numeric, apostrophes are not required.

Hence,

Code:

UPDATE tutorial SET name="<a href=\"http://www.visualdesigncore.com\">Yes</a>" WHERE id=1;

Is fine. If you were to set id to equal VALUE, and have it text, the following is proper format:

Code:

UPDATE tutorial SET name="<a href=\"http://www.visualdesigncore.com\">Yes</a>" WHERE id='VALUE';

Now since id is set to auto_increment, perhaps it is not the best example. But remember, to either use apostrophes or quotations on either side of a non-numeric value, much like what is used when setting the column name.

Code:

UPDATE tutorial SET name="<a href=\"http://www.visualdesigncore.com\">Yes</a>" WHERE id=1;

[ reply ]

borednerd

borednerd is offline registered.

Join Date: Feb 2005

Posts: 31

#3 (permalink)

03-11-2005, 07:05 PM

i love you bored nerd.

Jesus i wish i could code.

__________________

Time for a Change.

Think Big, Expect Big

Audi RS4

[ reply ]

Jay

Jay is offline that other guy?

Join Date: Feb 2004

Location: Hawaii

Posts: 1,834

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Blending Renders [easy]	Disturbed	Tutorial Comment Forum	5	03-07-2005 05:07 PM
Making your Renders more 3d [Easy]	Beer Slut	Tutorial Comment Forum	13	02-06-2005 08:13 AM
Saving in C4D [easy]	missionsix	Tutorial Comment Forum	0	01-24-2005 06:01 PM
Micro Text [Easy] (2 1/2 Steps)	Mirco	User Submitted Tutorials	9	09-05-2004 03:30 PM

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Art, Design & Discussion