Introduction to MySQL - TCD

Chapter 1 Introduction to MySQLA oife Conventions in this documentCommands to be entered on the UNIX/Linux command line are preceded byunixprompt>and those to be entered on the MySQL prompt are preceded bymysql>. UNIX commands are case sensitive whereas MySQL commands (exceptpasswords) are The MySQL interfaceOne simple (in terms of its appearance and capabilities) way of accessing MySQLis through the standard interface. To enter the MySQL interfaceunixprompt> MySQL -u wbyeats -pEnter password: MySQL >The -u tag precedes the username, and the -p tag invokes the passwordprompt. To log in as any other user replace the username commands are then typed on the MySQL command line. The end ofeach command is defined by a semicolon ;. Once you have entered the mysqlinterface you can select a database to look at (with theusecommand) and useany MySQL queries to read, edit, or add > use tissueinfo; MySQL > show tables;+-----------------------------+| Tables_in_tissueinfo |+-----------------------------+| gene_map || gene_info |+-----------------------------+ MySQL > quit1 CHAPTER 1.

Chapter 1 Introduction to MySQL Aoife McLysaght 1.0 Conventions in this document Commands to be entered on the UNIX/Linux command line are preceded by

Loading..

Tags:

  Introduction, Mysql, Introduction to mysql

Information

Related search queries