Results 1 to 4 of 4

Thread: Administration of MySQL

  1. #1
    Join Date
    May 2009
    Posts
    1,191

    Administration of MySQL

    A database can store a large amount of organized manner. A database must be able to provide any such data from queries. I am a newbie in MySql. How to check the administration of MySQL. How is it associated tables and what are the parts of this powerful application. In a short way how does it work.

  2. #2
    Join Date
    Apr 2008
    Posts
    1,948

    Re: Administration of MySQL

    A database consists of tables with different names corresponding to data stored therein. There are several drivers of different tables in MySQL (MyISAM, InnoDB, MERGE, etc. ..). It is quite possible to mix engines table within a single database. Each of these tables consist of fields of different names with different properties. For example, some fields accept only letters, other than numbers or other binary data. Usually, the field size is fixed. Each of the fields contain data. Like a table.

  3. #3
    Join Date
    May 2008
    Posts
    2,012

    Re: Administration of MySQL

    A table with multiple fields (ID_AMIS, NAME, FIRST NAME ... etc) which contain various information are called records. The field is said ID_AMIS primary key. The value of a primary key can not be duplicated - There can be several ID_AMIS with the value 1 for example. For example, one might take the NAME fields as primary key. However, this would have been a problem if several people have the same surname. This key allows you to reference the row in the table.

  4. #4
    Join Date
    Apr 2008
    Posts
    2,005

    Re: Administration of MySQL

    The constraints allow to verify the validity of data. The constraints can prevent the inclusion of incorrect data. For example, an invalid date. Inserting Null in a field not accepting this value. Finally, in the case of using foreign keys, referencing data not available. Connections to a database are subject to authentication. As a general rule to connect to a database, you must have the IP address or the name of the server hosting the database, the name of the database to which you want to connect, the user of the database having the right to connect to the database and the password of the user with the right to connect to the database.

Similar Threads

  1. UGC NET Public Administration
    By devgowri in forum Education Career and Job Discussions
    Replies: 1
    Last Post: 22-09-2011, 11:47 AM
  2. Replies: 4
    Last Post: 13-01-2011, 01:08 AM
  3. Programs for administration of MySQL
    By Spy$Eyes in forum Software Development
    Replies: 2
    Last Post: 17-12-2010, 03:45 AM
  4. mysql config file in MySQL
    By Netorious in forum Software Development
    Replies: 4
    Last Post: 18-03-2010, 09:43 PM
  5. Replies: 3
    Last Post: 07-11-2009, 09:36 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,695,736.59967 seconds with 16 queries