simple subquery syntax not working!
I have read through quite a bit of the MySQL manual concerning subqueries and cannot seem to get even the simplist of queries to work! I have a table called PersonRole which is the many-to-many joint table between two upper tables, Person and Role. I have tested the two pieces of the query alone and they work fine. (e.g. if I enter a 5 after the equal sign, it works and if I just type the subquery alone, it returns the single number 5.) So, why does mysql give me a syntax error? --- SELECT personRoleDBNum FROM PersonRole WHERE roleDBNum = (SELECT roleDBNum FROM Role WHERE role = 'STAFF') ERROR 1064: 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 'SELECT roleDBNum FROM Role WHERE role = 'STAFF')' at line 2 --- I must be dumb or just really really confused. Any help would be greatly appreciated. Renee = Renee Henderson -- [EMAIL PROTECTED] (WA state) Computer Programmer / Internet Specialist When you were born, you cried and the world rejoiced. Live your life in such a way that when you die, the world cries, and you rejoice. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
error 2013 and 2002 when i install the mysql database
Dear Sir, My Linux is RedHat Linux 6.0 I follow the below step to install the mysql version 3.23.37 database : 1. tar ¡Vzxvf mysql-3.23.37.tar.gz 2. ./configure ¡Vprefix/usr/local/mysql 3. make 4. make install 5. echo ¡§/usr/local/mysql/lib/mysql¡¨ /etc/ld.so.conf 6. ldconfig ¡Vv |grep libmysqlclient 7. echo ¡§/usr/local/msyql/bin/safe_mysqld /dev/null ¡¨ /etc/rc.d/rc.local 8. ./scripts/mysql_install_db 9. /usr/local/mysql/bin/safe_mysqld /dev/null 10. PATH=¡¨$PATH:/usr/local/mysql/bin¡¨ 11. mysqladmin version (The screen show out that : mysqladmin : connect to server at ¡¥localhost¡¦ failed Lost connection to Mysql Server during query) I check the file /etc/resolv.conf and I change the content from Search Servername To Search localhost Servername 127.0.0.1 I also check the file /etc/hosts and the content is 127.0.0.1 localhost localhost.localdomain After I prepare this two file, I input the command mysqladmin version It also not improve the situation. Then, I check the file /tmp/mysql.sock and /etc/my.cnf but this two files have not exist Can you ask me what¡¦s happen and how can I do ? This problem is very urgent for me. I attach the mysqlbug file to you From the very worry programmer RTO mysqlbug - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
have a great problem to install the mysql database
Dear Sir, I have a great problem to install the mysql database. I follow the instruction at the below : 1. tar -xvzf mysql-3.23.37.tar.gz 2. ./configure ¡Vprefix=/usr/local/mysql 3. make 4. make install 5. echo "/usr/local/mysql/lib/mysql" /etc/ld.so.conf 6. ldconfig -v | grep libmysqlclient 7. echo "/usr/local/mysql/bin/safe_mysqld /dev/null " /etc/rc.d/rc.local 8. ./scripts/mysql_install_db 9. /usr/local/mysql/bin/safe_mysqld /dev/null 10. PATH=¡¨$PATH:/usr/local/mysql/bin¡¨ 11. Mysqladmin version (when I input the no. 11 command, the screen show out that bash : Lost connection to MYSQL Server during query) Therefore, I input another command (/usr/share/mysql/mysql.server start) The screen show out that (Starting mysqld daemon with database from /var/lib/mysql) 12. chmod +x /usr/local/mysql/mysql.server 13. mysql (when I input the command mysql) The screen show out that : (Error 2013: Number of Processes running now : 1) (mysqld process hanging : Pid 955-killed ) (mysql restarted on Sat Apr 21 09:33:27 CST 2001) Please, can you ask me what ¡¥s happen and why, moreover; how can I do? From a worry programmer RTO - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
make your own binary?
Please provide guidance! I've been looking over the documentation, but haven't come across any instructions for creating your own binary distribution. The MySQL source distribution is installed and running on our development system. Now I want to make it into a binary distribution for installation on our production servers... MySQL 3.22.30 on a DEC alpha running tru64 unix 4.0d. patch kit 6 we're using version 3.22.30, as that's the version running on our other DEC alpha's v4.0f The source installation worked with the following: (for those of you who asked for pointers if I got it up) #CC="cc -pthread" # CFLAGS="-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all -arch ho st" # CXX="cxx -oldcxx -pthread" # CXXFLAGS="-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all -arch host" # export CC CFLAGS CXX CXXFLAGS # ./configure --prefix=/usr/local/mysql --enable-large-files --with-mysqld-ldfla gs=-all-static --disable-shared --with-named-thread-libs="-lpthread -lmach -lexc -lc" Are there arguments needed by the make_binary_distribution? So far I'm packing up empty directories... This MySQL newcomer appreciates any and all assistance you can provide. Thanks, Renee - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql install ? on tru64 system with Compaq c++
Would like to install this with cxx not gcc! Made the following adaptation to website documentation for section 4.12.6: CC="cc -pthread" CFLAGS="-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all -arch host" CXX="cxx -pthread" CXXFLAGS="-O4 -ansi_alias -ansi_args -fast -inline speed -speculate all -arch host" export CC CFLAGS CXX CXXFLAGS ./configure \ --prefix=/usr/local/mysql --enable-large-files --enable-shared=yes --with-named-thread-libs="-lpthread -lmach -lexc -lc" The configure appeared to work, however make exits on the following message: cxx -pthread -O -D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE -D_FILE_OFFSET_BITS=64 -O3 -DDBUG_OFF -O4 -ansi_alias -ansi_args -fast -inline speed -speculate all -a rch host -o .libs/mysql mysql.o readline.o sql_string.o completion_hash.o ../rea dline/libreadline.a -lcurses .libs/libmysqlclient.so -lm -lm -Wl,-rpath -Wl,/usr /local/mysql/lib/mysql ld (prelink): Can't open: /usr/local/mysql/lib/mysql (No such file or directory) ld: Can't open: /usr/local/mysql/lib/mysql (No such file or directory) *** Exit 1 Stop. *** Exit 1 Stop. *** Exit 1 Stop. last line of config.log shows the following: configure:8017: cc -pthread -std1 -c -D_LARGEFILE_SOURCE -D_LARGEFILE64_SOURCE - D_FILE_OFFSET_BITS=64 -O -DDBUG_OFF -O4 -ansi_alias -ansi_args -fast -inline spe configure:8121: checking character sett.c 15 We're running Tru64 Unix 4.0d with patch kit 6. cxx is version 5.7 Upgrading the OS is not an option right now. I'm totally new to the world of mysql so any assistance would be greatly appreciated. Best Regards, Renee Vasel DynCorp IS, LLC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php