phpMyAdmin 导出的表 t_Favorites 语句

最新推荐文章于 2026-06-27 22:07:43 发布

原创最新推荐文章于 2026-06-27 22:07:43 发布 · 699 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#phpmyadmin #null #character #collation #sql

本文提供了一个使用phpMyAdmin进行数据库备份的具体实例，包括了备份文件的详细内容及结构，展示了如何备份一个名为“livon_Discuz”的数据库中的表“t_favorite”。此备份文件还包含了表结构及样例数据。

-- phpMyAdmin SQL Dump -- version 3.3.10 -- http://www.phpmyadmin.net -- -- 主机: localhost -- 生成日期: 2011 年 06 月 11 日 19:02 -- 服务器版本: 5.0.67 -- PHP 版本: 5.3.6 SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- 数据库: `livon_Discuz` -- -- -------------------------------------------------------- -- -- 表的结构 `t_favorite` -- CREATE TABLE IF NOT EXISTS `t_favorite` ( `F_intFavoriteId` int(11) NOT NULL auto_increment COMMENT '主键', `F_strOrderBy` varchar(500) character set latin1 default '1', `F_strTitle` varchar(500) character set latin1 default NULL, `F_strDescription` varchar(5000) collate utf8_bin NOT NULL default '无' COMMENT '简述', `F_strAddress` varchar(500) character set latin1 NOT NULL, `F_isNewWindow` varchar(11) collate utf8_bin NOT NULL default '_blank', `F_strSysNumber` varchar(500) character set latin1 NOT NULL, `F_intCategoryId` int(11) NOT NULL, `F_dtmCreated` timestamp NOT NULL default CURRENT_TIMESTAMP, `F_dtmLastModified` datetime default NULL, `F_strNote` varchar(2000) character set latin1 default NULL, PRIMARY KEY (`F_intFavoriteId`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=22 ; -- -- 转存表中的数据 `t_favorite` -- INSERT INTO `t_favorite` (`F_intFavoriteId`, `F_strOrderBy`, `F_strTitle`, `F_strDescription`, `F_strAddress`, `F_isNewWindow`, `F_strSysNumber`, `F_intCategoryId`, `F_dtmCreated`, `F_dtmLastModified`, `F_strNote`) VALUES (1, '1', '163.com', '0', 'http://www.163.com', '1', 'Livon', 1, '2011-05-27 11:09:55', '0000-00-00 00:00:00', ''), (2, '1', 'test', '0', 'test2', '_blank', 'LIvon2', 1, '2011-05-29 12:43:55', NULL, NULL), (3, '1', 'test', '0', 'test2', '_blank', 'Livon', 1, '2011-05-29 12:56:09', NULL, NULL), (4, '1', 'test', '0', 'test2', '_blank', 'Livon', 1, '2011-05-29 13:03:46', NULL, NULL), (5, '1', 'test', '0', 'test2', '_blank', 'Livon', 1, '2011-05-29 13:05:51', NULL, NULL), (6, '1', 'test', '0', 'test2', '_blank', 'Livon', 1, '2011-06-05 22:14:37', NULL, NULL), (7, '1', 'test', '', 'test2', '_blank', 'Livon', 1, '2011-06-12 02:06:09', NULL, NULL), (8, '1', 'test', '无', 'test2', '_blank', 'Livon', 1, '2011-06-12 02:17:34', NULL, NULL), (9, '1', 'test', '无', 'test2', '_blank', 'Livon', 1, '2011-06-12 02:18:25', NULL, NULL), (10, '1', 'test', '/r/n 123</', 'test2', '_blank', 'Livon', 1, '2011-06-12 02:22:32', NULL, NULL), (11, '1', 'test', '/r/n 123/r/n', 'test2', '_blank', 'Livon', 1, '2011-06-12 02:23:42', NULL, NULL), (12, '1', 'test', '/r/n çœ‹çœ‹æ±‰å—è¡Œä¸è¡Œã€‚/r/n', 'test2', '_blank', 'Livon', 1, '2011-06-12 02:24:13', NULL, NULL), (13, '1', 'test', '/r/n çœ‹çœ‹æ±‰å—è¡Œä¸è¡Œã€‚/r/n', 'test2', '_blank', 'Livon', 1, '2011-06-12 02:25:47', NULL, NULL), (14, '1', 'test', '/r/n 看看汉字行不行。/r/n', 'test2', '_blank', 'Livon', 1, '2011-06-12 02:28:18', NULL, NULL), (15, '1', 'test', '/r/n 看看汉字行不行。/r/n', 'test2', '_blank', 'Livon', 1, '2011-06-12 02:29:59', NULL, NULL), (16, '1', 'test', '/r/n 看看汉字行不行。 /r/n', 'test2', '_blank', 'Livon', 1, '2011-06-12 02:32:13', NULL, NULL), (17, '1', 'test', '/r/n 看看汉字行不行。 /r/n', 'test2', '_blank', 'Livon', 1, '2011-06-12 02:35:46', NULL, NULL), (18, '1', 'test', '/r/n 呵呵/r/n', 'test2', '_blank', 'Livon', 1, '2011-06-12 02:36:07', NULL, NULL), (19, 'my order by', 'my title', '/r/n my description/r/n', 'my address', '_blank', 'my sys number', 0, '2011-06-12 03:14:07', NULL, '/r/n my note/r/n'), (20, 'my order by', 'my title', '/r/n my description/r/n', 'my address', '', 'my sys number', 0, '2011-06-12 03:14:18', NULL, '/r/n my note/r/n'), (21, 'my order by', 'my title', '/r/n my description/r/n', 'my address', '', 'my sys number', 0, '2011-06-12 03:41:13', '2011-06-12 03:41:13', '/r/n my note/r/n');