几个简单的mysql命令就可以解决的问题非要用什么phpmyadmin么？

yangbiao168

显示mysql中的数据库
show databases;  //注意后面有个s
创建数据库
create database test;  //test为你要创建的数据库名
删除数据库
drop database test；
使用数据库
use test;
显示数据库test中的表
use test;
show tables;
将*.sql的数据文件导入test数据库中
use test;
source
附:
关于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 ...
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的办法解决的


本文来自ChinaUnix博客，如果查看原文请点：http://blog.chinaunix.net/u/7425/showart_90092.html