On Sun, Jun 17, 2001 at 11:48:04PM -0700, Jamie Krasnoo wrote:
>
> Is there a way to tell MySQL to automatically spread its tables over
> a number of disks without going through the trouble of symbolic
> linking the chunks to the different disks?
There isn't yet, no. It'd certainly be a nice addi
Is there a way to tell MySQL to automatically spread its tables over a
number of disks without going through the trouble of symbolic linking the
chunks to the different disks?
Thanks,
Jamie Krasnoo
[EMAIL PROTECTED]
-
Before p
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';
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
-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, i
Hi, All,
I need an object-relational database. Can MySQL have such a capability?
Thanks,
Li Bing
_.--"""--._
.' '-. `.
__/__(-. `\ \
/o `o \ \\ \
_\__.__/ ))|| ;
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/
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 mat
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. Prob
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
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: <[EMA
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
>mont
- 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
>
>[EMAI
- 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
>
>[
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 kno
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).
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 GRA
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 somethin
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++)
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
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 th
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
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,
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/
-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:
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 ta
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 th
Hi!
I measured the following import speeds with different types of
LOAD TABLE INFILE, which is used by mysqlimport.
Since autocommit does not commit the transaction during
a LOAD TABLE INFILE, there is little difference whether one
uses LOW_PRIORITY or CONCURRENT, or none.
Regards,
Heikki
http
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
>
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'
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
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" o
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 ins
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 i
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
>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 exampl
36 matches
Mail list logo
