Code: Select all
mysql> show create table sessions
-> ;
+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| sessions | CREATE TABLE `sessions` (
`session_id` varchar(40) NOT NULL DEFAULT '0',
`ip_address` varchar(16) NOT NULL DEFAULT '0',
`user_agent` varchar(50) NOT NULL,
`last_activity` int(10) unsigned NOT NULL DEFAULT '0',
`user_data` text NOT NULL,
PRIMARY KEY (`session_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+----------+--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+Code: Select all
mysql> INSERT INTO `sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`) VALUES ('7e7cbc6c0a6b5a7246326ef09be8bf8d', '10.0.0.5', 'Opera/9.80 (Windows NT 5.1; U; en) Presto/2.7.62 V', 1302982686)
-> ;
Query OK, 1 row affected, 1 warning (0.09 sec)
Code: Select all
mysql> show warnings
-> ;
+---------+------+------------------------------------------------+
| Level | Code | Message |
+---------+------+------------------------------------------------+
| Warning | 1364 | Field 'user_data' doesn't have a default value |
+---------+------+------------------------------------------------+
Code: Select all
Error Number: 1046
No database selectedCode: Select all
use 'mydbname'Code: Select all
##
## database access settings in php format
## automatically generated from /etc/dbconfig-common/bubba-album.conf
## by /usr/sbin/dbconfig-generate-include
## Tue, 22 Feb 2011 20:11:16 +0100
##
## by default this file is managed via ucf, so you shouldn't have to
## worry about manual changes being silently discarded. *however*,
## you'll probably also want to edit the configuration file mentioned
## above too.
##
$dbuser='album';
$dbpass='sDdvfL2nPbh6';
$basepath='';
$dbname='album';
$dbserver='';
$dbport='';
$dbtype='mysql';