EQEmulator Forums

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)
-   Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)
-   -   Making databases portable from one version to the next (https://www.eqemulator.org/forums/showthread.php?t=5982)

Trumpcard 03-15-2003 07:22 AM

Making databases portable from one version to the next
 
For any database creators:

Try to use the following syntax when creating your inserts, it will make your databases much more portable between releases.

INSERT INTO TABLENAME (cola,colb,colc,cold) VALUES (valuea,valueb,valuec,valued);

Using this format will make the source usable if we add fields to the exisitng structure in a later release. Most new fields end up with a DEFAULT VALUE, so they will be automaticlly filled in if they are not specified. Using the above format will help greatly with the widely feared (columns dont match) errors.

Thanks!


All times are GMT -4. The time now is 10:11 AM.

Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.