SV: Installation of mySQL on a Win2000 Pro machine
Hi The that you see in the command prompt is only for decoration you can easy change the look on you command prompt to show you something else. The proper way to start your program is: c:\mysql\bin\mysqld-max --standalone not the otherway. Regards Jonas Arvidsson PS. The look and apperance can be changed by issuing prompt=$p$g to something else. -Ursprungligt meddelande- Från: Andrew Aragi [mailto:[EMAIL PROTECTED]] Skickat: den 11 januari 2002 14:30 Till: [EMAIL PROTECTED] Ämne: Re: Installation of mySQL on a Win2000 Pro machine Hi Miguel.. still in the dark. I installed mySQL into the c:\mysql directory. So pardon my ignorance but what is the difference between besides the symbol? What does the do. When I use the latter it say that this cmd is not recognized. c:\mysql\bin\mysqld-max --standalone c:\mysql\binmysqld-max --standalone Andrew - 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 - 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
SV: More compile errors
Have you installed ncurses or termcap rpm's? Jonas Arvidsson -Ursprungligt meddelande- Från: Steve Mansfield [mailto:[EMAIL PROTECTED]] Skickat: den 9 januari 2002 13:48 Till: [EMAIL PROTECTED] Ämne: More compile errors Ok, I had a problem compiling Mysql 3.23.47 on RH 7.1. I kept getting: checking return type of sprintf... configure: error: can not run test program while cross compilingany way, i tried updating gcc to 3.0.3 which didn't help. So i installed all the RPM's for gcc 2.96-85 and it solved the problem. However, I now get the following a bit further along ./configure --blah-blah which is as follows: checking for tgetent in -lncurses... no checking for tgetent in -lcurses... no checking for tgetent in -ltermcap... no checking for termcap functions library... configure: error: No curses/termcap library found Any ideas any1?!?!?!?!?!?!?!?Q?Q?Q?? Regards Steve Mansfield Technical Manager [EMAIL PROTECTED] www.getreal.co.uk Real Data Services Ltd 117-119 Marlborough Road Romford Essex RM7 8AP [Office] +44 [0] 1708 704433 [Fax] +44 [0] 1708 748859 [Mobile] +44 [0] 7973 864677 www.be-an-isp.com www.isdn4free.co.uk http://signup.getreal.co.uk The information contained in this E-mail is confidential and solely for the intended addressee(s). Unauthorised reproduction, disclosure, modification, and/or distribution of this email may be unlawful. If you have received this email in error, please notify the sender immediately and delete it from your system. Real Data Services does not accept legal responsibility for the contents of this message if it has reached you via the Internet, as Internet communications are not secure. Any opinions expressed are those of the author and are not necessarily endorsed by the Real Data Services. Recipients are advised to apply their own virus checks to this message on delivery. - 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 - 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
How to grant user access to specific column
Hi This is my first question to this group. Is there anyway to grant access for all users to a table but two columns in that table should be readonly, and if username is something else it should have access to those two columns with read and write and change. Regards Jonas Arvidsson - 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
Can't create table from another table
Hi Sorry for this question but this is my first shot at this list. I have created a table that contains the following: CREATE TABLE liggare (raknare INT(10) UNSIGNED ZEROFILL DEFAULT '00' NOT NULL, projno INT(5) UNSIGNED ZEROFILL DEFAULT '1' NOT NULL, ritnummer INT(8) UNSIGNED ZEROFILL DEFAULT '' NOT NULL, utgava INT(2) UNSIGNED ZEROFILL DEFAULT '01' NOT NULL, besk CHAR(50) DEFAULT '' NOT NULL, kund CHAR(50) DEFAULT '' NOT NULL, utdatum CHAR(20) DEFAULT '' NOT NULL, utsign CHAR(5) DEFAULT '' NOT NULL, ritad CHAR(5) DEFAULT '' NOT NULL, operativ CHAR(10) DEFAULT 'Genius 14' NOT NULL, sokvag CHAR(100) DEFAULT '' NOT NULL, PRIMARY KEY(raknare)); Now I try to create another table with colums from the first table like this: CREATE TABLE godkann (raknare, projno) AS (SELECT raknare, projno FROM liggare); And I got this error: ERROR 1064: You have an error in your SQL syntax near ' projno) AS (SELECT raknare, projno FROM liggare)' at line 1 I'm running MySQL-3.23.38. Regards Jonas Arvidsson