Help!!! The error message "SELECT in a stored procedure must have INTO"

Hi everyone, This is my first project in MySql database. I use VB.Net and OleDb to connect to MySql(5.0.1 alpha-max). When I call the stored produce, I get the error message: ERROR [42000][MySQL][ODBC 3.51 Driver][mysqld-5.0.1-alpha-max]You have an error in your SQL syntax. Check th

Help:how can i connect mysql server with the server's IP but not localhost?

Hi: Now i can use command: mysql -h localhost -u root -p connect to mysql server. But when i use command: mysql -h 127.0.0.1 -u root -p or: mysql -h 10.0.0.1 -u root -p (10.0.0.1 is the IP of mysql server) i failed,why? and how can do ? Thanks. __ Do you Yahoo!

RE: myODBC?

re is what I'm confused about: Do I 1) install both iODBC and myODBC on the Irix system? or 2) install iODBC on the Irix one and myODBC on that Linux machine where the mySQL db physically located? Thanks! Wen -Original Message- From: Venu [mailto:[EMAIL PROTECTED]] Sent: Friday, Augus

myODBC?

ng an Irix machine that tries to use a mySQL db on a Linux box (natively via port forwarding) so I'm trying to decide where to install what... thanks. Wen Tien - Before posting, please check: http://www.mysql.com/manual.ph

myODBC on Irix 6.5 follow-up

, query Wen Tien UCLA, Department of Computer Science [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread

myODBC on Irix 6.5

mySQL database while maintaining open database connectivity please feel free to comment as well... Thanks a bunch in advance. Wen Tien UCLA, Department of Computer Science - Before posting, please check: http://www.mysql.com/manu

Re: Starting MySQL

Please add /usr/local/mysql/bin in your PATH. dwayne> I'm fairly new to MySQL and unix. I have installed mysql on redhat 6.2 without too many problems. I am changing my o/s to FreeBSD 4.2 and have installed mysql after many hours of grief. I have mysql set to start at boot time and this seems t

Re: [Q] DBI connect with MySQL(SOLVED)

Okay, I get it. The problem comes from the statement below, wen> $db = param('test') or die("Could not find database!"); After I revised it to "my $db = "test" or die("Could not find database!");" I get expected result. Thanks for

Re: [Q] DBI connect with MySQL

out to print out some html. iii> iii> $output->header(); I add "$output->header();" just behind "my $output = new CGI;", but the result does not change. Maybe still there are other factors as you said. Thanks so much for your in

[Q] DBI connect with MySQL

r, start_html('title'=>"Information on $host => $db", 'BGCOLOR'=>'white'); print <$host $db Tables END_OF_HTML my @tables = $dbh->func( '_ListTables' ); foreach (@tables) {

[Q] DBI connect with MySQL

r, start_html('title'=>"Information on $host => $db", 'BGCOLOR'=>'white'); print <$host $db Tables END_OF_HTML my @tables = $dbh->func( '_ListTables' ); foreach (@tables) {

Re: mysql ./config..... concerning lncurses

markr> error messages show that lncurses, lcurses, ltermcap, could not be found. markr> We are running Debian Linux 2.2x, on SPARC. We are trying to install markr> 3.23.33. Any help would be useful thank you. FYI, you can get 3.23.xx.deb from unstable in Debian. Regards, --W

Re: Deleting Tables

ing... coter> coter> # mysql -uroot -p homework < home1.sql coter> Enter password: coter> ERROR 1050 at line 9: Table 'home1' already exists One solution is adding "DROP TABLE IF EXISTS home1;" in home1.