oracle show tables
mysql> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | test | +--------------------+ 2 rows in set (0.02 sec) mysql> show tables; ERROR 1046 (3D000): No database selected 请各位指教。
by mcumsigscr - MySQL - 2007-05-15 12:24:45 阅读（2002） 回复（6）
Now we meet a problem, when we use one of the below: alter table services add foreign key (`Customer ID`) references `customer`.`Customer ID` on delete cascade or alter table services add foreign key (`Customer ID`) references customer(`Customer ID`) on delete cascade we get the error message: Error Code : 1005 Can't create table '.\pc\#sql-15b0_1.frm' (errno: 150) (0 ms taken) any ideas ? th...
数据库建表的时候的表名用了双引号，也就是有大小写区分，用exp命令导出几张表的时候为什么会把表名自动转成大写，从而导致提示表不存在，请问高手有什么解决的办法？？
#!/usr/bin/python # import platform, os, sys import dircache, re fix = ('192.168.0.1', 'username', 'password', 'V1') ext = ('192.168.0.1', 'username', 'password', 'V2') replaces = ( (re.compile('AUTO_INCREMENT=\d+'), 'AUTO_INCREMENT=1'), ) def show_tables(define): result = [] file = platform.popen('mysql -s --host=%s -u%s -p%s %s 文件:dbma.zip 大小:1KB 下载: 下载 ...
• A table cannot contain more than 1000 columns. • The internal maximum key length is 3500 bytes, but MySQL itself restricts this to 1024 bytes. • The maximum row length, except for VARCHAR, BLOB and TEXT columns, is slightly less than half of a database page. That is, the maximum row length is about 8000 bytes. LONGBLOB and LONGTEXT columns must be less than 4GB, and the total r...
在load数据的时候：load from tmp of del modified by coldel| insert into o_customer 报如下错误: SQL0901N The SQL statement failed because of a non-severe system error. Subsequent SQL statements can be processed. (Reason "-204".) SQL0204N "SYSCAT.tables" is an undefined name. SQLSTATE=42704 汗啊。怎么系统表没有了？我执行：select * from syscat.tables 也报这个错误。 各位老大们，看在我国庆都不得...
一个局域网， 有一台服务器（REDHAT AS3) ,有双网卡：eth0: 192.168.1.10 (内网) eth1: 61.180.99.87 ( 公网) 要求功能: 1. 现在希望内网(192.168.1.0/24) 所有机器能上网. 2. 外网的机器通过 61.180.99.87:80 访问内网中的一台机器(192.168.1.100) 的3389端口.( 也就是说端口映射) 用iptables 如何实现? 请高手帮忙 下面是我的配置，有问题： echo 1 >/proc/sys/net/ipv4/ip_forward iptables ...
