We accept safe and secure Credit Card and PayPal Payments.
 
Perl Scripts

All Count
Attachment Mailer
Perl Scripts Build A FAQ Plus
Perl Scripts Clock In Center
eBackup Automated
Easy Poll
eSurvey
Fetch a File
Form Maker
Mailing List Server
MySQL Mate
PDF Creation
QCart
Quick Fix
Quote of the day
Speed Search
Task Manager
Traffic Pack
Upload Plus
Upload Gold
Upload Pro
Website Manager

 
Free Perl Downloads

Free Perl Scripts Main Page
Free Perl Scripts 404 Alerter
AccessLog Viewer
Build A FAQ
PHP Scripts eBackup
Free PHP Scripts ErrorLog Viewer
eVars - Server Info
HT Pass Creator
Upload Lite
Website Manager

 
JavaScripts

Free Java Scripts Alert Boxes
Free JavaScripts Browser Sniffer
Check email
Generators
Slide Show
Sudoku
Window Maker
More...

 
Extra Utilities

ASP Scripts Ascii Codes
Free ASP Scripts Color Picker
Font Finder
HT Pass Creator
Meta Cloak
Meta Magic
Pano Zooms
SlideShow
Server Size

 
Online Tutorials

Free HTML Scripts Glossary
Free HTML Scripts HTML
JavaScript
MySQL
SSI
Build Traffic
Other

 
Miscellaneous

About Us
Graphics
Testimonials
Installations
Latest versions

 
Hawk Eye in Tennis

Should Hawk Eye replace linesmen and lineswomen at all tennis tournaments?







 
View all Polls

Run Polls on your site

Run your own Surveys

 
Store Download FAQs Contact Us Support Programming Policies  
Tables     List of Categories

Page 1 Page 2

  1. What are the types of data that can be stored?

  2. How do I read a list of current tables in a database?

  3. Do you have a script that will assist me?







  1. What are the types of data that can be stored?

    See our new FAQ on Data types and Definitions for more information.

    Types are specified using a definition when either creating or altering a table. The most common are VARCHAR(length) and INT(length) where length is a number that specifies how many characters can be stored within the column. Below is (or will soon be) a full list and a short description for each. Remember, when using INT, that any value inserted into the database that begins with a 0 (zero) will have the zero dropped. In such cases where you will need the preceding zeros to be stored, you should use VARCHAR() instead.

    Type Description
    TINYINT(length) An integer with a value range of 0 - 255. And a signed range of -128 to +127. Can also be INT1(length)
    SMALLINT(length) An integer with a value range of 0 - 65535. And a signed range of -32768 to +32767. Can also be INT2(length)


    Top of Page



  2. How do I read a list of current tables in a database?

    Try using the listtables function
    @tables = $VAR{db}->listtables
    The function has been deprecated and will not work with all servers. $VAR{db} is of course the connection variable.
    $VAR{db} = Mysql->connect($DBHOST, $DBNAME, $DBUSER, $DBPASS);


    Top of Page


  3. Do you have a script that will assist me?

    Yes, we use MySQL Mate

    Top of Page


Page 1 Page 2

Was this page helpful?    
Speed Search our site
Website Monitoring with SMS TXT alerts

Plesk Hosting
Linux servers with Plesk Control Panel, cgi-bin, crontab manager, Mysql, PHP and ASP.

Discounted Scripts
Subscribe to our periodial newsletter to receive special offers.

Bathroom Hygiene
How often do you thoroughly clean your bathroom?








View all Polls

Run Polls just like this one on your website!


About us | Contact us | Script FAQs | Script Support | Website Hosting | Our Policies | Store | Testimonials
Subscribers log in here. Subscribe to our periodical newsletter for special offers on commercial scripts, hosting, exciting business opportunities, and industry news and events. Our Mailing List Software is powered by Consolidator    
HTML Plain text
©1999 - 2015 All content Copyright PerlScriptsJavaScripts.com Proudly hosted by LinuxHostingPlans.com