Why should not rely on $sth-rows() ?
Hi all, I read in DuBois's MySQL, Perl DBI API Reference part, it is written: $rv = $sth-rows(); Return the number of rows affected by the statement associated with $sth or -1 if an error occured. This method is used primarily for statements that do not return rows. For SELECT statements, you should not rely on the rows() method; count the rows as you fetch them instead. My question is, why we should not rely on $sth-rows()? Does it mean that it doesn't match sometime? Anybody ever experienced? Also, in the case of ERROR 1114: The table 'SQL22e0b00_0' is full. I found that this function returned -2 instead of -1. --bk - 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: .dump files
i had some others that i browsed into phpmyadmin and they seemed to work, but others, like this one, showed a Query error -but that method of imported population was probably wrong anyway, i guess. thanks here's the file: # MySQL dump 6.8 # # Host: localhostDatabase: netsloth # # Server version3.22.30 # # Table structure for table 'authors' # CREATE TABLE authors ( author_id int(11) DEFAULT '0' NOT NULL auto_increment, author varchar(50), email varchar(255), bio text, PRIMARY KEY (author_id) ); # # Dumping data for table 'authors' # INSERT INTO authors VALUES (1,'Joe Blow','[EMAIL PROTECTED]','Joe Blow is a freelance author hiding out from Federal authorities.'); INSERT INTO authors VALUES (2,'Brad Bulger','[EMAIL PROTECTED]','Brad Bulger is not a goldfish.'); INSERT INTO authors VALUES (3,'Jay Greenspan','[EMAIL PROTECTED]','Jay Greenspan has too much to do and is willing to accept help.'); INSERT INTO authors VALUES (4,'Fred Flinstone','[EMAIL PROTECTED]',''); # # Table structure for table 'content_admin' # CREATE TABLE content_admin ( username varchar(50) DEFAULT '' NOT NULL, password varchar(255) DEFAULT '' NOT NULL ); # # Dumping data for table 'content_admin' # INSERT INTO content_admin VALUES ('jay','7b4e9c6e28843bff'); INSERT INTO content_admin VALUES ('reader',password('reader')); # # Table structure for table 'content_stages' # CREATE TABLE content_stages ( stage_id int(11) DEFAULT '0' NOT NULL auto_increment, stage varchar(20) DEFAULT '' NOT NULL, stage_dsc text, PRIMARY KEY (stage_id) ); # # Dumping data for table 'content_stages' # INSERT INTO content_stages VALUES (1,'Writing','The story is still being written.'); INSERT INTO content_stages VALUES (2,'Editing','The story is written and is ready for review.'); INSERT INTO content_stages VALUES (3,'Proofreading','The story has been reviewed and is ready for spellchecking, URL checking, etc.'); INSERT INTO content_stages VALUES (4,'Live','The story is available on the live site.'); INSERT INTO content_stages VALUES (5,'Killed','The story has been killed.'); # # Table structure for table 'content_users' # CREATE TABLE content_users ( user_id int(11) DEFAULT '0' NOT NULL auto_increment, username varchar(20) DEFAULT '' NOT NULL, name varchar(50), email varchar(255), PRIMARY KEY (user_id) ); # # Dumping data for table 'content_users' # INSERT INTO content_users VALUES (1,'brad','Brad Bulger','[EMAIL PROTECTED]'); INSERT INTO content_users VALUES (2,'joe','Joe Blow','[EMAIL PROTECTED]'); INSERT INTO content_users VALUES (3,'fred','Fred Flintstone','[EMAIL PROTECTED]'); INSERT INTO content_users VALUES (4,'jay','Jay Greenspan','[EMAIL PROTECTED]'); INSERT INTO content_users VALUES (5,'eddie','Eddie Axelrod','[EMAIL PROTECTED]'); INSERT INTO content_users VALUES (8,'roxanne','Roxanne T. Beauregard',''); # # Table structure for table 'editing_stories' # CREATE TABLE editing_stories ( story_id int(11) DEFAULT '0' NOT NULL, UNIQUE story_id (story_id) ); # # Dumping data for table 'editing_stories' # INSERT INTO editing_stories VALUES (1); INSERT INTO editing_stories VALUES (5); # # Table structure for table 'killed_stories' # CREATE TABLE killed_stories ( story_id int(11) DEFAULT '0' NOT NULL, UNIQUE story_id (story_id) ); # # Dumping data for table 'killed_stories' # # # Table structure for table 'live_stories' # CREATE TABLE live_stories ( story_id int(11) DEFAULT '0' NOT NULL, UNIQUE story_id (story_id) ); # # Dumping data for table 'live_stories' # INSERT INTO live_stories VALUES (1); INSERT INTO live_stories VALUES (2); INSERT INTO live_stories VALUES (3); INSERT INTO live_stories VALUES (4); INSERT INTO live_stories VALUES (7); # # Table structure for table 'proofreading_stories' # CREATE TABLE proofreading_stories ( story_id int(11) DEFAULT '0' NOT NULL, UNIQUE story_id (story_id) ); # # Dumping data for table 'proofreading_stories' # # # Table structure for table 'stories' # CREATE TABLE stories ( story_id int(11) DEFAULT '0' NOT NULL auto_increment, stage_id int(11) DEFAULT '0' NOT NULL, publish_dt date, headline varchar(255), subtitle varchar(255), byline_prefix varchar(20), summary text, body text, PRIMARY KEY (story_id), KEY story_stage_key (stage_id) ); # # Dumping data for table 'stories' # INSERT INTO stories VALUES (1,4,'2000-07-01','My Story','It\'s sad but true.','By','A true story about nothing.','p\r\nHere is my first paragraph.\r\n/p\r\np\r\nHere is my second paragraph.\r\n/p\r\np\r\nHere\'s my third paragraph.\r\n/p\r\np\r\nHere\'s my fourth paragraph.\r\n/p\r\n'); INSERT INTO stories VALUES (2,4,'2000-06-24','A Big Test','This is the test you\'ve been waiting for.','By','Who knew? Testing is important.','p\r\nI think this is the first paragraph.\r\n/p\r\np\r\nWell, no, maybe this one is.\r\n/p\r\np\r\nNo, the other
Re: What does tmp_table_size *really* do?
On Sat, Jun 16, 2001 at 08:00:04PM -0500, Dan Nelson wrote: In the last episode (Jun 16), Jeremy Zawodny said: Err, I forgot to mention that there's a Using filesort in the output as well. That makes me believe it wants to write to disk (even if there may be sufficient RAM). I'm not sure Using filesort actually means it is going to create a file. The code seems to print filesort whenever an ORDER BY is requested (sql_select.cc:536). Even the manual simply says extra pass. Maybe it required a file-based table in an earlier version, but not anymore? Based on testing, I've found that Using filesort appears only when the number of records to be sorted is sufficiently high. The sort order (asc/desc) doesn't matter. But take a Using filesort query, put a LIMIT 10 on the end of it and see if it goes away. It does for me. Hmmm... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 0 days, processed 3,996,185 queries (50/sec. avg) - 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 calculate age?
Description: There is an example in this tutorial which I think is done incorrectly. http://www.mysql.com/documentation/mysql/bychapter/manual_Tutorial.html It says: SELECT name, (TO_DAYS(NOW())-TO_DAYS(birth))/365 AS age That code does not take into account leap years. I think such an example should be done the correct way because people might copy it and use it. In the program I'm writing, that one extra day of a leap year is important. One day makes a difference, legally, when a person is one day shy of being 18 years old. How-To-Repeat: Fix: Submitter-Id: submitter ID Originator:Philip Mak Organization: -Philip Mak ([EMAIL PROTECTED]) MySQL support: none Synopsis: manual errata Severity: non-critical Priority: low Category: mysql Class: doc-bug Release: mysql-3.23.36 (Official MySQL RPM) Environment: System: Linux sg1.indexthis.net 2.2.17-14 #1 Mon Feb 5 17:53:36 EST 2001 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='egcs' CFLAGS=' -O6 -fno-omit-frame-pointer' CXX='egcs' CXXFLAGS=' -O6-felide-constructors -fno-exceptions -fno-rtti -fno-omit-frame-pointer' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Apr 4 16:33 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 4101836 Jan 15 10:49 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20273324 Jan 15 10:49 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Jan 15 10:49 /usr/lib/libc.so lrwxrwxrwx 1 root root 10 Apr 4 16:34 /usr/lib/libc-client.a - c-client.a Configure command: ./configure --disable-shared --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --enable-assembler --with-mysqld-user=mysql --with-unix-socket-path=/var/lib/mysql/mysql.sock --prefix=/ --with-extra-charsets=complex --exec-prefix=/usr --libexecdir=/usr/sbin --sysconfdir=/etc --datadir=/usr/share --localstatedir=/var/lib/mysql --infodir=/usr/info --includedir=/usr/include --mandir=/usr/man --without-berkeley-db --without-innobase '--with-comment=Official MySQL RPM' Perl: This is perl, version 5.005_03 built for i386-linux - 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 languages
Hello, Hi,can you please tel me about The different languages of database' data created by mysql, If mysql can manipulate arabic data, And if we can create a database that contain arabic and latin data. Thanks B HAYET Get free email and a permanent address at http://www.netaddress.com/?N=1 - 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
Income on the Net!
Here is an opportunity that you can take up FREE. If you join as an affiliate, we'll teach you how to build a profitable business on the Internet, using our system to create an income stream and earn income globally, 24 hours a day. Don't let this opportunity slip past you - our organization is already well over 1 million strong and growing at around 6,000 each day! Join us and let's work together to get a share of all those members. Just hit: mailto:[EMAIL PROTECTED]?Subject=Opportunity To be removed from this list, hit: mailto:[EMAIL PROTECTED]?Subject=Remove - 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: innodb admin questions
ryc writes: My application needs to insert between 200-500k rows about once a day... When using MyISAM tables I determined the best way to get this done (while still allowing users to perform select statements from the table) was to use mysqlimport with --low-priority. This way all the inserts get bundled up into large groups, and the low-proriorty allows select statements to continue. However I switched the table type to Innodb now and I am not sure what the best way to insert these rows would be. There is: a) continue using mysqlimport (without low-priority??)... the question about this is will mysqlimport group the inserts into one large begin/commit block, or will each insert have its own block? b) create the begin/insert/commit statements myself What way would be the fastest and least abrasive on the server? Another question I have is reguarding memory usage... Will innobase use any of the key-buffer memory Mysql is using for MyISAM tables or is the only memory innobase uses defined with innodb_buffer_pool_size? Thanks!! ryan Hi! Innobase uses it's own memory and has nothing to do with MySQL'a key_buffer that is used for MyISAM only. Regarding inserts, betst way to accomplish this is without any transactions, but with multi-row inserts and with max_allowed_packet and net_buffer_length set at higher values. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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: .dump files
That is a .sql file renamed to a .dump file, there's no difference. Import it with phpMyAdmin or mysql -u username -ppassword dbname whatever.dump i had some others that i browsed into phpmyadmin and they seemed to work, but others, like this one, showed a Query error -but that method of imported population was probably wrong anyway, i guess. thanks here's the file: (clipped) - 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.39 for Windows
Hey people, Does anybody know why subj is not available for download on mysql.com? -- Best regards, Olexandr Vynnychenko mailto:[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, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Income on the Net!
wtf is this doing in here, go away stupid fuck. Here is an opportunity that you can take up FREE. If you join as an affiliate, we'll teach you how to build a profitable business on the Internet, using our system to create an income stream and earn income globally, 24 hours a day. Don't let this opportunity slip past you - our organization is already well over 1 million strong and growing at around 6,000 each day! Join us and let's work together to get a share of all those members. Just hit: mailto:[EMAIL PROTECTED]?Subject=Opportunity - 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: Why should not rely on $sth-rows() ?
At 3:28 PM +0900 6/17/01, Batara Kesuma wrote: Hi all, I read in DuBois's MySQL, Perl DBI API Reference part, it is written: $rv = $sth-rows(); Return the number of rows affected by the statement associated with $sth or -1 if an error occured. This method is used primarily for statements that do not return rows. For SELECT statements, you should not rely on the rows() method; count the rows as you fetch them instead. My question is, why we should not rely on $sth-rows()? Does it mean that it doesn't match sometime? Anybody ever experienced? It's not guaranteed to work. It's not portable. In practice, it seems to work fine for MySQL. The warning is there so that you can't blame DBI if you rely on rows() and one day find that it fails. :-) Also, in the case of ERROR 1114: The table 'SQL22e0b00_0' is full. I found that this function returned -2 instead of -1. --bk -- Paul DuBois, [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, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Corrupt Tables??
Hello everyone. I am running a 2.2 Debian OS with 3.23.34a-log.. I had an entire database which was 2GB installed on a 2GB partition. Stupidly the database is not backed up and when I attempt to access the database an error is returned when accessing certain tables errno: 145 Saying that it can not open the table. I have looked up some infomration about repairing databases on the mysql site and found isamchk. however this only seems to work when you have *.ISM files. All of my files are .MYD .MYI and .frm. Does any one have any suggestions on how I can repair these tables? Michael Blood --:-- - 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: Corrupt Tables??
Michael Blood wrote: Hello everyone. I am running a 2.2 Debian OS with 3.23.34a-log.. I had an entire database which was 2GB installed on a 2GB partition. Stupidly the database is not backed up and when I attempt to access the database an error is returned when accessing certain tables errno: 145 Saying that it can not open the table. I have looked up some infomration about repairing databases on the mysql site and found isamchk. however this only seems to work when you have *.ISM files. All of my files are .MYD .MYI and .frm. Does any one have any suggestions on how I can repair these tables? Michael Blood --:-- Hi, isamchk is for the 'old' (ISAM) table format. Your table is in MyISAM format (this format appeared in 3.23); you should use myisamchk. Regards -- Joseph Bueno NetClub/Trader.com - 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
GEMNI,InnoDB and BDB
Any thoughts on the best support of transactional/ACID attributes for db tables in MySQL? Thank You, Anthony - 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: .dump files
thank you. that's sort of what i thought. now for the silly question: i know how to do it with 'monitor' (CLI), but where/how do you import using phpMyAdmin, please? (this i'd love to know :) i looked through the manual but didn't see anything for import db. Ted At 4:30 AM -0600 6/17/01, Chris Bolt wrote: That is a .sql file renamed to a .dump file, there's no difference. Import it with phpMyAdmin or mysql -u username -ppassword dbname whatever.dump i had some others that i browsed into phpmyadmin and they seemed to work, but others, like this one, showed a Query error -but that method of imported population was probably wrong anyway, i guess. thanks here's the file: (clipped) - 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
RE: content management.. was .dump files
i'd like to use the db i sent but unless i'm importing wrong there's an error in it somewhere and thus it won't import. i don't suppose anyone who has it could take a peek? or knows where i can get something like it? Thank you. Ted Rogers At 4:30 AM -0600 6/17/01, Chris Bolt wrote: That is a .sql file renamed to a .dump file, there's no difference. Import it with phpMyAdmin or mysql -u username -ppassword dbname whatever.dump i had some others that i browsed into phpmyadmin and they seemed to work, but others, like this one, showed a Query error -but that method of imported population was probably wrong anyway, i guess. thanks here's the file: (clipped) - 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
MYSQL++: Any ideas why this code causes the program to crash?
I wrote this program in VC++ using the MYSQL++ API for VC. I have a generic function (below) which I call numerous times each time with a different query string. It works fine the first time around. But the second time I call this function it causes the program to crash. I think it could be that a constructor is called but no deconstructor. Could this be the problem? What deconstructor should I use?? I have trimmed the code for functionality: --CODE-- void main() { bool j = ExecQuery(select * from stock); } bool ExecQuery(string sQuery) { Connection con(def_db_name, def_host_name, def_user_name, def_password); Query query = con.query(); // This creates a query object that is bound to con. query sQuery; // You can write to the query object like you would any other ostrem cout endl Query: query.preview() endl; // Show the query before it is executed // Query::preview() simply returns a string with the current query // string in it. Result res = query.store(); // Query::store() executes the query and returns the results Row row; cout.setf(ios::left); // cout setw(17) Database Name endl endl; Result::iterator i; for (i = res.begin(); i != res.end(); i++) { row = *i; cout setw(17) row[0] setw(4) row[1] setw(7) row[2] setw(7) row[3] row[4] endl; } cout endl Records Found: res.size() endl; return 1; } --END OF CODE-- ANY INPUT APPRECIATED Thanks lots David Ayliffe ([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, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Allowing every one to query a table ?
Hello, I am currently trying to figure out how to allow every users that connect to my database to do a select on the table news under database admin. I tried doing grant select on admin.news to '%' but if seems to have failed. Does anyone know how to allow anyone to do a select * from admin.news without allowing them to browse the whole admin database? ie select * from admin.news; would work select * from admin.tel; would NOT work Thanks in advance. Klashma.
Using mysql_data_seek() is very slow
What is the current way to move back and forwards and to any position in a recordset without losing performance I am testing MySQL I have 10 records in a table Using res = mysql_store_result( MYSQL ) ; int iRows = (int) mysql_num_rows( res ); for (i = 0; i iRows; i++) { MYSQL_ROW row; while (row = mysql_fetch_row(res)) { Is very fast But if I want to use mysql_data_seek() it is very slow - 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 Error Codes
I have a web page which is based on mysql databases using PHP coding, but the web page refuses to display correctly. It always returns an error message: Fatal error: Call to undefined function: mysql_select_db() in /usr/local/games/hlds_l/hlstats-1.01/hlstatsinc/db.inc on line 67 Is it something to do with my apache settings? Else is it down to a mysql conf or package or even php? Web Site address is http://210.10.124.14/hlstats.php Any help would be much appreciated. Regards, Sam -- Sam Peascod Highway Internet Services Pty Ltd ABN:14 088 130 269 Part of the LiSP Group http://www.lisp.com.au Servicing the Dubbo, Mudgee, Coonabarabran, Gilgandra Warren areas of LiSP.**NOW OPEN IN SYDNEY!** Enquiries 02 6372 3645 PO Box 461 Fax 02 6372 0963Mudgee NSW 2850 *ASK US ABOUT OUR NEW UNLIMITED HOURS PLAN FOR JUST $24.75!!** - 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: Allowing every one to query a table ?
At 4:38 PM -0400 6/17/01, Klashma wrote: Hello, I am currently trying to figure out how to allow every users that connect to my database to do a select on the table news under database admin. I tried doing grant select on admin.news to '%' but if seems to have failed. That's not legal GRANT syntax, so you're not really showing us the statement that you issued. Also, assuming that your statement was correct and legal, it may be that you've also issued some other GRANT statement that grants more expansive privileges. GRANT SELECT ON admin.news TO specific_user@specific_host is probably something like what you want. Does anyone know how to allow anyone to do a select * from admin.news without allowing them to browse the whole admin database? ie select * from admin.news; would work select * from admin.tel; would NOT work Thanks in advance. Klashma. -- Paul DuBois, [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, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL query - not too complex?
I need some help with a query to sum data for each id and write it into a new table. I have a source data table for each calendar month containing i.d.'s (not unique) and a value and I need to sum all the values for each i.d. for all months into a new table (where each i.d. will now be unique). The only way I could see of doing it was in two or more stages? Duncan - 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: access denied problem
mysqladmin -u root password mysql password is used to change the password. -p is used to log on if a password has already been set. Don't know exactly what you want to do but possibly you're looking for mysqladmin -u root -p password your_new_password If that doesn't work and you don't know the password, look up skip grants in the manual. - Original Message - From: chao cheng [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 17, 2001 3:40 Subject: access denied problem Hi, I just installed Mysql from source for Linux. When I type the following command: mysqladmin -u root password mysql I got this error: mysqladmin:connect to server@localhost' failed error:'access denied for user:'root@localhost'(using password:NO)' Can some tell me how to correct this problem? Thanks! - 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
Fw: confirm unsubscribe from mysql@lists.mysql.com
- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 9:21 AM Subject: confirm unsubscribe from [EMAIL PROTECTED] Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. To confirm that you would like [EMAIL PROTECTED] removed from the mysql mailing list, please send an empty reply to this address: [EMAIL PROTECTED] Usually, this happens when you just hit the reply button. If this does not work, simply copy the address and paste it into the To: field of a new message. I haven't checked whether your address is currently on the mailing list. To see what address you used to subscribe, look at the messages you are receiving from the mailing list. Each message has your address hidden inside its return path; for example, [EMAIL PROTECTED] receives messages with return path: mysql-return-number[EMAIL PROTECTED] Some mail programs are broken and cannot handle long addresses. If you cannot reply to this request, instead send a message to [EMAIL PROTECTED] and put the entire address listed above into the Subject: line. --- Administrative commands for the mysql list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, send a message to the address in the List-Unsubscribe header of messages from the list. If you don't know how to display headers and haven't changed E-mail addresses since subscribing, you'll be successful with an e-mail to: [EMAIL PROTECTED] Send mail to the following for info and FAQ for this list: [EMAIL PROTECTED] [EMAIL PROTECTED] Similar addresses exist for the digest list: [EMAIL PROTECTED] [EMAIL PROTECTED] To get messages 123 through 145 (a maximum of 100 per request), mail: [EMAIL PROTECTED] To get an index with subject and author for messages 123-456 , mail: [EMAIL PROTECTED] They are always returned as sets of 100, max 2000 per request, so you'll actually get 100-499. To receive all messages with the same subject as message 12345, send an empty message to: [EMAIL PROTECTED] The messages do not really need to be empty, but I will ignore their content. Only the ADDRESS you send to is important. You can start a subscription for an alternate address, for example [EMAIL PROTECTED], just add a hyphen and your address (with '=' instead of '@') after the command word: [EMAIL PROTECTED] To stop subscription for this address, mail: [EMAIL PROTECTED] In both cases, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete your subscription. If despite following these instructions, you do not get the desired results, please contact my owner at [EMAIL PROTECTED] Please be patient, my owner is a lot slower than I am ;-) --- Enclosed is a copy of the request I received. Return-Path: [EMAIL PROTECTED] Received: (qmail 16974 invoked from network); 31 May 2001 02:21:54 - Received: from dhas.sga.net.th (HELO mailserver.dhas.com) ([EMAIL PROTECTED]) by www.mysql.com with SMTP; 31 May 2001 02:21:54 - Received: from ssd226 ([10.2.4.129]) by mailserver.dhas.com (8.11.0/8.11.0) with SMTP id f4V2Hml25109 for [EMAIL PROTECTED]; Thu, 31 May 2001 09:17:48 +0700 Message-ID: 010801c0e97a$dd890400$[EMAIL PROTECTED] From: dha siam mysql [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: test Date: Thu, 31 May 2001 09:39:07 +0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary==_NextPart_000_0105_01C0E9B5.89C64A40 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 This is a multi-part message in MIME format. --=_NextPart_000_0105_01C0E9B5.89C64A40 Content-Type: text/plain; charset=windows-874 Content-Transfer-Encoding: quoted-printable --=_NextPart_000_0105_01C0E9B5.89C64A40 Content-Type: text/html; charset=windows-874 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=3DContent-Type content=3Dtext/html; = charset=3Dwindows-874 META content=3DMSHTML 5.50.4134.100 name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVnbsp;/DIV/BODY/HTML --=_NextPart_000_0105_01C0E9B5.89C64A40-- - 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
Fw: confirm subscribe to mysql@lists.mysql.com
- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 9:21 AM Subject: confirm subscribe to [EMAIL PROTECTED] Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. To confirm that you would like [EMAIL PROTECTED] added to the mysql mailing list, please send an empty reply to this address: [EMAIL PROTECTED] Usually, this happens when you just hit the reply button. If this does not work, simply copy the address and paste it into the To: field of a new message. This confirmation serves two purposes. First, it verifies that I am able to get mail through to you. Second, it protects you in case someone forges a subscription request in your name. Some mail programs are broken and cannot handle long addresses. If you cannot reply to this request, instead send a message to [EMAIL PROTECTED] and put the entire address listed above into the Subject: line. --- Administrative commands for the mysql list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, send a message to the address in the List-Unsubscribe header of messages from the list. If you don't know how to display headers and haven't changed E-mail addresses since subscribing, you'll be successful with an e-mail to: [EMAIL PROTECTED] Send mail to the following for info and FAQ for this list: [EMAIL PROTECTED] [EMAIL PROTECTED] Similar addresses exist for the digest list: [EMAIL PROTECTED] [EMAIL PROTECTED] To get messages 123 through 145 (a maximum of 100 per request), mail: [EMAIL PROTECTED] To get an index with subject and author for messages 123-456 , mail: [EMAIL PROTECTED] They are always returned as sets of 100, max 2000 per request, so you'll actually get 100-499. To receive all messages with the same subject as message 12345, send an empty message to: [EMAIL PROTECTED] The messages do not really need to be empty, but I will ignore their content. Only the ADDRESS you send to is important. You can start a subscription for an alternate address, for example [EMAIL PROTECTED], just add a hyphen and your address (with '=' instead of '@') after the command word: [EMAIL PROTECTED] To stop subscription for this address, mail: [EMAIL PROTECTED] In both cases, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete your subscription. If despite following these instructions, you do not get the desired results, please contact my owner at [EMAIL PROTECTED] Please be patient, my owner is a lot slower than I am ;-) --- Enclosed is a copy of the request I received. Return-Path: [EMAIL PROTECTED] Received: (qmail 16870 invoked from network); 31 May 2001 02:21:41 - Received: from dhas.sga.net.th (HELO mailserver.dhas.com) ([EMAIL PROTECTED]) by www.mysql.com with SMTP; 31 May 2001 02:21:41 - Received: from ssd226 ([10.2.4.129]) by mailserver.dhas.com (8.11.0/8.11.0) with SMTP id f4V2HTl25087 for [EMAIL PROTECTED]; Thu, 31 May 2001 09:17:30 +0700 Message-ID: 00fd01c0e97a$d2a22ee0$[EMAIL PROTECTED] From: dha siam mysql [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mail Date: Thu, 31 May 2001 09:38:48 +0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary==_NextPart_000_00FA_01C0E9B5.7E592E20 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 This is a multi-part message in MIME format. --=_NextPart_000_00FA_01C0E9B5.7E592E20 Content-Type: text/plain; charset=windows-874 Content-Transfer-Encoding: quoted-printable --=_NextPart_000_00FA_01C0E9B5.7E592E20 Content-Type: text/html; charset=windows-874 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=3DContent-Type content=3Dtext/html; = charset=3Dwindows-874 META content=3DMSHTML 5.50.4134.100 name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVnbsp;/DIV/BODY/HTML --=_NextPart_000_00FA_01C0E9B5.7E592E20-- - 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: SQL query - not too complex?
At 2:32 AM +0100 6/18/01, [EMAIL PROTECTED] wrote: I need some help with a query to sum data for each id and write it into a new table. I have a source data table for each calendar month containing i.d.'s (not unique) and a value and I need to sum all the values for each i.d. for all months into a new table (where each i.d. will now be unique). Sounds like you need to combine 12 separate tables into a single table that has an additional column to indicate which month each row is for. Then you should be able to sum the values easily. Trying to do this for bunch of separate tables will be difficult - many queries. The only way I could see of doing it was in two or more stages? Duncan -- Paul DuBois, [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, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Fw: confirm subscribe to mysql@lists.mysql.com
Hi, are you trying to point out something, or are you just trying to be annoying? Let us know if there is something that we can do for you. --On Monday, June 18, 2001 09:07 +0700 dha siam mysql [EMAIL PROTECTED] wrote: - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 9:21 AM Subject: confirm subscribe to [EMAIL PROTECTED] Hi! This is the ezmlm program. I'm managing the [EMAIL PROTECTED] mailing list. To confirm that you would like [EMAIL PROTECTED] added to the mysql mailing list, please send an empty reply to this address: [EMAIL PROTECTED] Usually, this happens when you just hit the reply button. If this does not work, simply copy the address and paste it into the To: field of a new message. This confirmation serves two purposes. First, it verifies that I am able to get mail through to you. Second, it protects you in case someone forges a subscription request in your name. Some mail programs are broken and cannot handle long addresses. If you cannot reply to this request, instead send a message to [EMAIL PROTECTED] and put the entire address listed above into the Subject: line. --- Administrative commands for the mysql list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, send a message to the address in the List-Unsubscribe header of messages from the list. If you don't know how to display headers and haven't changed E-mail addresses since subscribing, you'll be successful with an e-mail to: [EMAIL PROTECTED] Send mail to the following for info and FAQ for this list: [EMAIL PROTECTED] [EMAIL PROTECTED] Similar addresses exist for the digest list: [EMAIL PROTECTED] [EMAIL PROTECTED] To get messages 123 through 145 (a maximum of 100 per request), mail: [EMAIL PROTECTED] To get an index with subject and author for messages 123-456 , mail: [EMAIL PROTECTED] They are always returned as sets of 100, max 2000 per request, so you'll actually get 100-499. To receive all messages with the same subject as message 12345, send an empty message to: [EMAIL PROTECTED] The messages do not really need to be empty, but I will ignore their content. Only the ADDRESS you send to is important. You can start a subscription for an alternate address, for example [EMAIL PROTECTED], just add a hyphen and your address (with '=' instead of '@') after the command word: [EMAIL PROTECTED] To stop subscription for this address, mail: [EMAIL PROTECTED] In both cases, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete your subscription. If despite following these instructions, you do not get the desired results, please contact my owner at [EMAIL PROTECTED] Please be patient, my owner is a lot slower than I am ;-) --- Enclosed is a copy of the request I received. Return-Path: [EMAIL PROTECTED] Received: (qmail 16870 invoked from network); 31 May 2001 02:21:41 - Received: from dhas.sga.net.th (HELO mailserver.dhas.com) ([EMAIL PROTECTED]) by www.mysql.com with SMTP; 31 May 2001 02:21:41 - Received: from ssd226 ([10.2.4.129]) by mailserver.dhas.com (8.11.0/8.11.0) with SMTP id f4V2HTl25087 for [EMAIL PROTECTED]; Thu, 31 May 2001 09:17:30 +0700 Message-ID: 00fd01c0e97a$d2a22ee0$[EMAIL PROTECTED] From: dha siam mysql [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: mail Date: Thu, 31 May 2001 09:38:48 +0700 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary==_NextPart_000_00FA_01C0E9B5.7E592E20 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 This is a multi-part message in MIME format. --=_NextPart_000_00FA_01C0E9B5.7E592E20 Content-Type: text/plain; charset=windows-874 Content-Transfer-Encoding: quoted-printable --=_NextPart_000_00FA_01C0E9B5.7E592E20 Content-Type: text/html; charset=windows-874 Content-Transfer-Encoding: quoted-printable !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=3DContent-Type content=3Dtext/html; = charset=3Dwindows-874 META content=3DMSHTML 5.50.4134.100 name=3DGENERATOR STYLE/STYLE /HEAD BODY bgColor=3D#ff DIVnbsp;/DIV/BODY/HTML --=_NextPart_000_00FA_01C0E9B5.7E592E20-- - 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 --On
RE: MySQL Error Codes
On 18-Jun-01 Sam Peascod wrote: I have a web page which is based on mysql databases using PHP coding, but the web page refuses to display correctly. It always returns an error message: Fatal error: Call to undefined function: mysql_select_db() in /usr/local/games/hlds_l/hlstats-1.01/hlstatsinc/db.inc on line 67 Is it something to do with my apache settings? Else is it down to a mysql conf or package or even php? Web Site address is http://210.10.124.14/hlstats.php try: ?php phpinfo(); ? and check if mysql support in compiled into you PHP. Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. - 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
Problem with INTO OUTFILE 'filename' - I am into vicius circle
Hello, I am new in this list, so let me explain problem: I use third party server provider, so having little access to resources (no telnet). I need backup remote data (BLOB fields included) and downlad it to client machine. To make things clear decided use INTO OUTFILE command to store data. Problem is INTO OUTFILE 'truefilename' command will ask for a true file name (no file pointer allowed). When I run this command, server doesnt allow create file, even making /tmp/truefilename. I tried fool OUTFILE by first creating temporary writable file via TMPFILE() PHP function, but this function just returns pointer instead name of file. I didnt find any PHP function to get name of file from file pointer. I don't want to write again all annoying code to save BLOB fields, but also can't use MySql facilities. How can I fool OUTFILE command? is there some output device a-la-console (con: in DOS) to make INTO OUTFILE 'con:' flow data to browser instead file? (I can catch browser data and redirect to local machine). Is there some way of telling OUTFILE to use file pointer instead file names? Thanks for any help from you. I asked this question on several groups, but no response obtained yet. Thanks very much Miguel - 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
Number of Word Matches
Hi there, I'm using select queries like SELECT * FROM table_name WHERE col_name LIKE '%some_word%' to find rows that have col_name match to some_word. But I would also like to find the number of word matches for each row so that I can order these rows according to their relevances and word matches. How can I do that?? Thank you for your help! - 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
import entire db (small) via phpMyAdmin
Is importing an entire db (small) into MySQL via phpMyAdmin possible? If so, how. Thanks in advance. Ted Rogers - 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
Is an Object-Relational MySQL available?
Hi, All, I need an object-relational database. Can MySQL have such a capability? Thanks, Li Bing _.._ .' '-. `. __/__(-. `\ \ /o `o \ \\ \ _\__.__/ ))|| ; .--; || \ (`) || \ _|`---' .' _, _||`\ '`_\ \ '_,.-';_.-`\| \ \_ .' '--'---;` / / |\ |_..--' \ \'-'.' .--'.__/__.-; `` (___...---''` \ _/_\ /ASU\ [EMAIL PROTECTED] \___/ 480-965-9038(L), 480-829-8492(H) http://www.public.asu.edu/~libing - 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
FW: FW: FW: HELP! functions don't work...
-Original Message- From: Les Roberts [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 17, 2001 9:06 PM Cc: Dawn H Subject: Fwd: FW: FW: HELP! functions don't work... first I apologize for the bad function name... I had changed it to several and left it at dayname() which, as you noted, is not valid. But monthname(), which is valid, fails exactly the same way. note the page http://65.108.143.207 says: Fatal error: Call to undefined function: monthname() in /home/ccrb/ccrb-www/index.html on line 7 and the code printf(test for jon... monthname is %s,monthname(2001-06-17)); Again, I apologize. Nothing is worse than asking for help and not getting the supporting evidence right. -Original Message- From: Don Read [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 17, 2001 2:38 PM To: Dawn H Subject: RE: FW: HELP! functions don't work... On 17-Jun-01 Dawn H wrote: -Original Message- From: Les Roberts [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 17, 2001 9:29 AM To: [EMAIL PROTECTED] Subject: HELP! functions don't work... please pass along to anyone who might help... If you look at http://65.108.143.207/ you'll see I get the following error: Fatal error: Call to undefined function: dayname() in /home/ccrb/ccrb-www/index.html on line 8 This indicates that I'm missing most all of the functions. Is there a standard include that I need, or is my php installation not complete? Here is the line of code in question: ?php printf(test for jon... dayname is %s,dayname(2001-06-17)); localhost.dread$ pwd /usr/local/share/doc/apache/phpmanual localhost.dread$ grep dayname * localhost.dread$ There isn't a PHP function 'dayname', date(), strftime(). mktime() are what you are looking for. Regards, -- Don Read [EMAIL PROTECTED] -- It's always darkest before the dawn. So if you are going to steal the neighbor's newspaper, that's the time to do it. Filter fixer: database,sql,query - 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: Is an Object-Relational MySQL available?
On Sun, Jun 17, 2001 at 10:21:14PM -0700, Li Bing wrote: Hi, All, I need an object-relational database. Can MySQL have such a capability? Currently, MySQL is strictly relational. I haven't heard much discussion about adding object features to it--yet. Perhaps others know more than I on this matter, though... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 1 days, processed 11,000,938 queries (67/sec. avg) - 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
Similar queries gives different results
Hi, I am using mysql running under solaris. I am giving two similar queries and geting different results. I couldn't find the solution to this problem. Example. Q1.SELECT username,acctstatrtime,acctstoptime FROM radacct WHERE acctstarttime '200106011200'; ( Connections to internet after 12:00 - 01/06/2001 ) Result of Q1 usernameacctstarttimeacctstoptime jon 2001-06-01 12:01:00 2001-06-01 12:10:02 mike2001-06-01 13:02:00 2001-06-01 13:15:07 simon 2001-06-01 13:06:06 -00-00 00:00:00 Q2.SELECT username,acctstatrtime,acctstoptime FROM radacct WHERE username = 'jon' order by acctstatrtime asc; ( Connections of "jon" up to now. ) Result of Q2 No result or the list of connections made before the above date. Does not show the above connection. But I know in the first query there is connection. How can it be ? Can anyone help me ? Thanks Mucahit Celikag