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

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

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

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

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

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

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

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

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:

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

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

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

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

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/

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,

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

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

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

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

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

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).

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

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

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

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

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

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

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.

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

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/

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 \ \\ \ _\__.__/ ))|| ;

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,

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

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';