<?php
mysql_connect('localhost','****','****');
mysql_select_db('****');
mysql_query("create procedure show() select * from shop_class;") or die(mysql_error());
?>MySql 5.0.15版本
错误提示:
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 'show() select * from shop_class' at line 1不明白是什么意思.mysql里面已经有表proc,不过mysql_install_db没有运行过.也不知道怎么运行.
mysql_connect('localhost','****','****');
mysql_select_db('****');
mysql_query("create procedure show() select * from shop_class;") or die(mysql_error());
?>MySql 5.0.15版本
错误提示:
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 'show() select * from shop_class' at line 1不明白是什么意思.mysql里面已经有表proc,不过mysql_install_db没有运行过.也不知道怎么运行.
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货