Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2010
    Posts
    2

    Unanswered: Explain the difference between use and require.

    Explain the difference between use and require.

  2. #2
    Join Date
    Nov 2003
    Posts
    2,932
    Provided Answers: 12
    http://www.merriam-webster.com/dictionary/require
    http://www.merriam-webster.com/dictionary/use

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by ali0482 View Post
    Explain the difference between use and require.
    USE is a mysql command to choose which database you want subsequent SQL statements to work in
    Code:
    USE pr0nstars;
    REQUIRE is an option on the mysql GRANT command
    Code:
    GRANT priv_type [(column_list)] [, priv_type [(column_list)]] ...
        ON {tbl_name | * | *.* | db_name.*}
        TO user [IDENTIFIED BY [PASSWORD] 'password']
            [, user [IDENTIFIED BY [PASSWORD] 'password']] ...
        [REQUIRE
            NONE |
            [{SSL| X509}]
            [CIPHER 'cipher' [AND]]
            [ISSUER 'issuer' [AND]]
            [SUBJECT 'subject']]
        [WITH [GRANT OPTION | MAX_QUERIES_PER_HOUR count |
                              MAX_UPDATES_PER_HOUR count |
                              MAX_CONNECTIONS_PER_HOUR count |
                              MAX_USER_CONNECTIONS count]]
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •