ITPub博客

mysql> help describeName: 'DESCRIBE'Description:Syntax:{DESCRIBE | DESC} tbl_name [col_name | wild]DESCRIBE provides information about the columns in a table. It is ashortcut for SHOW COLUMNS FROM. As of MySQL 5.0.1, these statementsalso display information for views. (See [HELP SHOW COLUMNS].)URL: http://dev.mysql.com/doc/refman/5.0/en/describe.html[@more@]

mysql> help showName: 'SHOW'Description:SHOW has many forms that provide information about databases, tables,columns, or status information about the server. This section describesthose following:SHOW [FULL] COLUMNS FROM tbl_name [FROM db_name] [LIKE 'pattern']SHOW CREATE DATABASE db_nameSHOW CREATE FUNCTION funcnameSHOW CREATE PROCEDURE procnameSHOW CREATE TABLE tbl_nameSHOW DATABASES [LIKE 'pattern']SHOW ENGINE engine_name {LOGS | STATUS }SHOW [STORAGE] ENGINESSHOW ERRORS [LIMIT [offset,] r

[mysql@redhat ~]$ cat .my.cnf[mysql]user=rootpassword=root[mysqld]datadir=/mysql/mysql-5.0.41-linux-i686/data[mysql@redhat ~]$ cd /mysql/mysql-5.0.41-linux-i686[mysql@redhat mysql-5.0.41-linux-i686]$ ...

law

The origin of "B-tree" has never been explained by the authors. ... "balanced," "broad," or "bushy" might apply. Others suggest that the "B" stands for Boeing. [Bayer and McCreight were at Boeing Scie...

启动mysql时报错：Starting mysqld daemon with databases from /var/lib/mysqlSTOPPING server from pid file /var/run/mysqld/mysqld.pid071112 00:22:06 mysqld ended查看日志：＃less /var/log/mysqld.log其中有...

06年12月开始着手，到07年2月完成讲义雏形，然后讲授一遍。07年7月签订出版合同，又重新修改，花了半年时间，算起来也差不多花了10个月，今天终于把书稿寄给出版社了，可以歇一下了。预计2008年3月出版，但愿自己的...

locale -m 查看字符集locale -a 查看系统支持的locale设置hal

Dr. Codd formally presented his new relational model in a landmark work titled “A Relational Model of Data for Large Shared Databanks” in June 1970.1 He based his new model on two branches of mathem...

SQL> select dname from dept 2 where exists(select * from emp where deptno=dept.deptno) 3 /DNAME--------------RESEARCHSALESACCOUNTINGSQL> select distinct d.dname from dept d, emp e 2 where d.dept...

SQL> conn scott/tiger已连接。SQL> select dname from dept2 where not exists(select * from emp where deptno=dept.deptno)3 /DNAME--------------OPERATIONSSQL> select d.dname from dept d left outer join em...

SQL> conn scott/tiger已连接。SQL> select ename,sal from emp;ENAME SAL---------- ----------SMITH 800ALLEN 1600WARD 1250JONES 2975MARTIN 1250BLAKE 2850CLARK 2450SCOTT 3000KING 4000TURNER 1500ADAMS 1100J...

下载rlwrap的rpm包：rlwrap-0.18-1.i386.rpm以root帐号安装：rpm -ivh rlwrap rlwrap-0.18-1.i386.rpm启动SQL*Plus时，使用$ rlwrap sqlplus scott/tiger或者在oracle用户的.bashrc中设置alias：alias sqlplus="rlwr...

在Linux中，SQL*Plus不支持上、下方向键回显命令，也不支持左、右方向键移动光标，我们可以通过安装下面三个软件改变这种状况。 Term-Readline-Gnu，下载地址：http://search.cpan.org/dist/Term-ReadLine-GnuIO-Tty...

重装VMware上的操作系统，设置iso文件时，注意下面的Virtual device node要选择ide 0:0 CD-ROM-1，否则，依然从原有的操作系统启动，不能启动iso安装光盘。

安装centOS 5时，要注意选择以下安装选项：Select the Development -> Development Libraries, Development Tools and Legacy Software Development package groups.Under the Base System group, make sure you sel...

[oracle@redhat ~]$ cat sqlvalue#!/bin/bashVALUE=`sqlplus -s scott/tiger <<ENDset pagesize 0 feedback off verify off heading off echo offselect count(deptno) from dept;exit;END`echo ""$VALUE" rows retu...

Ctrl+L：刷新屏幕，相当于clear命令的效果。Shift+PgOn或Shift+PgUp：使得终端内容上下移动，每次移动一页，也可以使用Ctrl+PgOn或Ctrl+PgUp连续移动。显卡的内存决定可以回滚多少内容。Ctrl+A：使得光标移至行首Ctr...

编辑grub：其中的kernel /boot/vmlinuz-xxxxx ro root=LABEL=/1 rhgb quiet 改为：kernel /boot/vmlinuz-xxxxx ro root=LABEL=/1 rhgb quiet linux init=/bin/bash按b键启动系统，这时不需要输入密码。运行下面的命...

tune2fs -l