sql
I'm trying to enforce one column of my table to contain strictly 6 chars. string. However I've some columns of type VARCHAR (e.g name, etc.) so mysql silently changes the column to VARCHAR. Is there any way I can force the column to contain only 6 chars. Thanks, -Pushkar S. Pradhan - 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
sql
Hi all, I am using mysql 3.23.49 solaris platform. I used load data local infile command to load tables. I got NULL entries in my rows (i.e. some rows have null in all fields) and since I executed this command twice I got same entries twice. I tried to remove null rows by doing: delete from book where subject='NULL'; But it didn't work, also how to delete identical rows? -Pushkar S. Pradhan - 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 3.23.49 code
I'm using 3.23.49, and trying to load the menagerie database (online examples) by executing the example: LOAD DATA LOCAL INFILE 'pet.txt' INTO TABLE pet; This is the error I get: ERROR 1148: The used command is not allowed with this MySQL version Is this not compatible with 3.23.49? -Pushkar S. Pradhan - 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
installing 3.23.49 on solaris 5.8 fails
I used gnu's make as recommended, make was successful, however gmake install gives the foll. error: /usr/local/gnu/bin/install -c copy-db /rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db /usr/local/gnu/bin/install: `copy-db' and `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db' are the same file gmake[2]: *** [install-benchSCRIPTS] Error 1 gmake[2]: Leaving directory `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench' gmake[1]: *** [install-am] Error 2 gmake[1]: Leaving directory `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench' gmake: *** [install-recursive] Error 1 I searched google, documentation but couldn't find any such errors reported? Does anybody know the problem, config. options: ./configure --prefix=/rstc/user1/erc/pushkar/mysql-3.23.49 -Pushkar S. Pradhan - 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
Re: installing 3.23.49 on solaris 5.8 fails
That's right, I install all other stuff the same way. I also forgot to mention I am not an admin, so I install everything in my own disk space on the n/w. Isn't that okay? It looks like you configured it to install in the source directory. Pushkar Pradhan wrote: I used gnu's make as recommended, make was successful, however gmake install gives the foll. error: /usr/local/gnu/bin/install -c copy-db /rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db /usr/local/gnu/bin/install: `copy-db' and `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/copy-db' are the same file gmake[2]: *** [install-benchSCRIPTS] Error 1 gmake[2]: Leaving directory `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench' gmake[1]: *** [install-am] Error 2 gmake[1]: Leaving directory `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench' gmake: *** [install-recursive] Error 1 I searched google, documentation but couldn't find any such errors reported? Does anybody know the problem, config. options: ./configure --prefix=/rstc/user1/erc/pushkar/mysql-3.23.49 -Pushkar S. Pradhan - 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 -Pushkar S. Pradhan - 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
unable to install mysql 3.23.49 on solaris-sparc
Hi, I'm new to this stuff. I first tried to install the binary distribution but it failed because of not finding libz.so, then I am trying to install with the source code, ./configure --prefix=/rstc/user1/erc/pushkar/mysql-3.23.49 make was okay, mesgs. were given about not finding libz.so but said it was okay and it could be linked later. but make install fails: /usr/local/gnu/bin/install -c test-ATIS /rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/test-ATIS /usr/local/gnu/bin/install: `test-ATIS' and `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/test-ATIS' are the same file *** Error code 1 make: Fatal error: Command failed for target `install-benchSCRIPTS' Current working directory /rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench *** Error code 1 make: Fatal error: Command failed for target `install-am' Current working directory /rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench *** Error code 1 make: Fatal error: Command failed for target `install-recursive' I dont' have admin priveleges so I'm installing on my own partition, thus I can't even do: shell groupadd mysql shell useradd -g mysql mysql Is that the problem? Thanks, -Pushkar S. Pradhan - 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
unable to install mysql 3.23.49 on solaris-sparc 5.8
Hi, I'm new to this stuff. I first tried to install the binary distribution but it failed because of not finding libz.so, then I am trying to install with the source code, ./configure --prefix=/rstc/user1/erc/pushkar/mysql-3.23.49 make was okay, mesgs. were given about not finding libz.so but said it was okay and it could be linked later. but make install fails: /usr/local/gnu/bin/install -c test-ATIS /rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/test-ATIS /usr/local/gnu/bin/install: `test-ATIS' and `/rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench/test-ATIS' are the same file *** Error code 1 make: Fatal error: Command failed for target `install-benchSCRIPTS' Current working directory /rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench *** Error code 1 make: Fatal error: Command failed for target `install-am' Current working directory /rstc/user1/erc/pushkar/mysql-3.23.49/sql-bench *** Error code 1 make: Fatal error: Command failed for target `install-recursive' I dont' have admin priveleges so I'm installing on my own partition, thus I can't even do: shell groupadd mysql shell useradd -g mysql mysql Is that the problem? Thanks, -Pushkar S. Pradhan - 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
Re: [PHP] Comparing array elements
You can use in_array or array_search. hey everyone, Does anyone have and ideas of wisdom on how to compare arrays (mysql result sets) and group items based on if they exist in two or more arrays? For example: I have a table, with a list of servers: server1 server2 server3 server4 server5 ... serverX I have a table that specifies which of the servers are grouped: group1 server1 server4 server5 Now, I want to compare group1 against the server list, and do something like the following: In group: server1 server4 server5 Not in group: server2 server3 serverX query -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -Pushkar S. Pradhan - 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