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

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

RE: myODBC?

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, August 24, 2001 9:33

myODBC?

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.php (the manual

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

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/manual.php (the manual

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

[Q] DBI connect with MySQL

* Could someone tell me what is wrong? Thanks a lot. Regards, --Wen [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the li

Re: [Q] DBI connect with MySQL

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 information. Regards, --

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 your consider

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, --Wen [EMAIL PROTECTED

Re: Deleting Tables

... 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.sql. Regards, --Wen [EMAIL