Interview Questions And Answers

Q: - What characters can I use to name my tables and fields, and what is the character limit?

The maximum length of database, table, or field names is 64 characters. Any character that you can use in a directory name or file name, you can use in database and table namesexcept / and .. These limitations are in place because MySQL creates directories and files in your file system, which correspond to database and table names. There are no character limitations (besides length) in field names.

Submitted By:-Martinos            Email-ID: - martinos_sa@rediff.com

Q: - The integer 56678685 could be which datatype(s)?

MEDIUMINT, INT, or BIGINT

Submitted By:-Martinos            Email-ID: - martinos_sa@rediff.com

Q: - Which PHP function retrieves the text of a MySQL error message?

mysql_error()

Submitted By:-Martinos            Email-ID: - martinos_sa@rediff.com

 

1
2