我用的是 mysql-noinstall-5.1.6-alpha-win32.zip 请帮忙一下,谢谢!
解决方案 »
- 多对多关系~
- Mysql数据库查询问题
- money 和 datetime
- 通过网络访问mysql数据库
- my.cnf用什么打开?
- 在线等,mysql 的安装
- (MYSQL问题)新系统第一次运行bin目录下的winmysqladmin.exe后,会弹出一个窗口要求输入帐号和密码,还没进行操作一不小心关掉了,之后
- 在mysql中能用代码直接将数据库(表)转换成dbf格式吗?或者有第三方程式吗?
- 数据库问题。。小白求指点。。
- 请教高手:(1064) You have an error in your SQL syntax
- mysql和serv-u以及php结合起来编制发布动态ftp服务器
- 关于使用外键关联表的删除,更新问题
(C) 版权所有 1985-2001 Microsoft Corp.C:\Documents and Settings\acer>d:D:\>cd mysql\binD:\mysql\bin>mysql -h localhost -u root -p
Enter password: ***
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 5.1.6-alpha-nt-maxType 'help;' or '\h' for help. Type '\c' to clear the buffer.mysql> create database dkqnew;
-> //
Query OK, 1 row affected (0.00 sec)mysql> use dkqnew//
Database changed
mysql> create table userinfo(userid int,username varchar(10),userbirthday date); -> //
Query OK, 0 rows affected (0.09 sec)mysql> create table userinfolog(logtime datetime,loginfo varchar(100)) //
Query OK, 0 rows affected (0.06 sec)mysql> describe userinfo //
+--------------+-------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+-------------+------+-----+---------+-------+
| userid | int(11) | YES | | NULL | |
| username | varchar(10) | YES | | NULL | |
| userbirthday | date | YES | | NULL | |
+--------------+-------------+------+-----+---------+-------+
3 rows in set (0.02 sec)mysql> create trigger beforinsertuserinfo
-> befor insert on userinfo
-> for each row begin
-> insert into userinfolog values(now(),CONCAT(new.userid,new username));
-> end;
-> //
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'befor
insert on userinfo
for each row begin
insert into userinfolog values(now()' at line 2
mysql>
创建触发器出错,不知为什么????