Chinaunix首页 | 论坛 | 博客
  • 博客访问: 389333
  • 博文数量: 73
  • 博客积分: 2580
  • 博客等级: 少校
  • 技术积分: 837
  • 用 户 组: 普通用户
  • 注册时间: 2005-06-01 10:34
个人简介

开始工作时的技术blog变成了自己成长成熟的吐曹blog

文章分类
文章存档

2012年(2)

2011年(2)

2009年(5)

2008年(1)

2007年(16)

2006年(38)

2005年(9)

我的朋友

分类: Mysql/postgreSQL

2006-03-24 10:25:36

显示mysql中的数据库
show databases;  //注意后面有个s
创建数据库
create database test;  //test为你要创建的数据库名
删除数据库
drop database test;
使用数据库
use test;
显示数据库test中的表
use test;
show tables;
将*.sql的数据文件导入test数据库中
use test;
source < *.sql   
附:
关于Warning: Cannot modify header information的解决办法(转载)
If you got this message: "Warning: Cannot modify header information -
headers already sent by ...."
如果在执行php程序时看到这条警告:"Warning: Cannot modify header
information - headers already sent by ...."
Few notes based on the following user posts:
有以下几种解决方法:
1. Blank lines (空白行):
Make sure no blank line after of the calling php script.
检查有 后面没有空白行,特别是include或者require的文件。不少
问题是这些空白行导致的。
2. Use exit statement (用exit来解决):
Use exit after header statement seems to help some people
在header后加上exit();
header ("Location: xxx");
exit();
3. PHP has this annoying problem, if your HTML goes before any PHP code
or any header modification before redirecting to certain page, it'll
said "Warning: Cannot modify header information - headers already sent
by ...." Basically anytime you output to browser, the header is set and
cannot be modified.  So two ways to get around the problem:
3a. Use Javascript (用Javascript来解决):
self.location(\"file.php\");"; ?>
Since it's a script, it won't modify the header until execution of
Javascript.
可以用Javascript来代替header。但是上面的这段代码我没有执行成功... 另外
需要注意,采用这种方法需要浏览器支持Javascript.
3b. Use output buffering (用输出缓存来解决):

... HTML codes ...
... PHP codes ...
header ("Location: ....");
ob_end_flush();
?>
This will save the output buffer on server and not output to browser
yet, which means you can modify the header all you want until the
ob_end_flush() statement.  This method is cleaner than the Javascript
since Javascript method assumes the browser has Javascript turn on. 
However, there are overhead to store output buffer on server before
output, but with modern hardware I would imagine it won't be that big
of deal.  Javascript solution would be better if you know for sure your
user has Javascript turn on on their browser.
就像上面的代码那样,这种方法在生成页面的时候缓存,这样就允许在输出head
之后再输出header了。本站的许愿板就是采用这种方法解决的header问题。
4.set output_buffering = On in php.ini (开启php.ini中的output_buffering
)
set output_buffering = On will enable output buffering for all files.
But this method may slow down your php output. The performance of this
method depends on which Web server you're working with, and what kind
of scripts you're using.
这种方法和3b的方法理论上是一样的。但是这种方法开启了所有php程序的输出缓
存,这样做可能影响php执行效率,这取决于服务器的性能和代码的复杂度。
我的问题是用3b的办法解决的
阅读(996) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~