I don't think there is a limit.
Just as long as your harddisk can contain the data there should be no
problem.
Remco
- Original Message -
From: chandra shekar [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, May 07, 2002 5:21 AM
Subject: Maximum number of rows in the table
Hi
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: SUPPORT PLEASE - Error while running mysql_install_db
Description:
After installing successfully mysql in my sun solaris - sparc machine,
while i am trying to run the script mysql_install_db
system has given the following error
Our MySQL table currently has 2.5million rows, but I have seen this go upto
at least 17 million rows without a single problem.
sql, query
- Original Message -
From: Remco Oosten
To: [EMAIL PROTECTED] ; [EMAIL PROTECTED]
Sent: Tuesday, May 07, 2002 5:08 PM
Subject: Re: Maximum number of
sql, query
Hello Dear Group
I want to use the command LOAD DATA INFILE
I have a table with 18 columns. But to fill the columns unfortunately I
don't have one input file put two.
The first on shall fill 16 of the 18 columns. The second one contains
the data of column 8 and column 12.
How
Hi,
Richard Idalski wrote:
I have before me what seems to be a very daunting task to someone with my
limited SQL knowledge. I'm upgrading our ad server which runs on MySQL
3.22.32 to a newer machine and MySQL 3.23.39. Right now there are 16GB worth
of databases that need to be transferred
I don't think there is a limit.
Just as long as your harddisk can contain the data there should be no
problem.
Yes, I guess this should be the case.
Theoretically, though; the limit would be the number of indexable rows, wouldn't it?
Since the integer length used to store this is 11 digits,
Hi Dvoracek,
I think you forgot to put firstly GROUP BY one.id
so your select statement must be as :
SELECT one.descr, COUNT(two.id) xxx
FROM one LEFT JOIN two USING(id)
GROUP BY one.id, two.id
ORDER BY one.id;
Regards,
Tolga GOZE
Oksijen Teknoloji
www.o2.com.tr
Hi Dvoracek,
I think you forgot to put firstly GROUP BY one.id
so your select statement must be as :
SELECT one.descr, COUNT(two.id) xxx
FROM one LEFT JOIN two USING(id)
GROUP BY one.id, two.id
ORDER BY one.id;
Regards,
Tolga GOZE
Oksijen Teknoloji
www.o2.com.tr
Jeremy at yahoo quoted one with 280 million rows, I think.
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi all
I've been searching for a solution to the following:
Is there an easy way to order by date ( - MM - DD), at the moment my
results are coming back with the *day* ordered but not the whole date
like this:
02 02 2002
03 03 2005
18 02 2003
Hi Mysql Gurus,
We are working a project using Mysql for the database support.
The environment is multiserver. We are using a single table for
all the servers to store server information. We basically want
to know what is the maximum number of rows that we can have
in a table. In our case when
Hello,
Excuse me for my English, but I am French.
I am studing MySQL and particularly replications.
When we have 2 threads which use BEGIN-COMMIT/ROLLBACK (with
Berkeley-db), there is a conflict if we make this schema:
THREAD 1! THREAD 2
!
begin; !
Hello,
Excuse me for my English, but I am French.
I am studing MySQL and particularly replications.
When we have 2 threads which use BEGIN-COMMIT/ROLLBACK (with
Berkeley-db), there is a conflict if we make this schema:
THREAD 1! THREAD 2
!
begin; !
Hello,
Excuse me for my English, but I am French.
I am studing MySQL and particularly replications.
When we have 2 threads which use BEGIN-COMMIT/ROLLBACK (with
Berkeley-db), there is a conflict if we make this schema:
THREAD 1! THREAD 2
!
begin;
Hi.
I have this table (A)
IDJOB ¦ IDKIT
4 ¦ 19
4 ¦ 19
2 ¦ 19
2 ¦ 5
I need to extract IDKIT with IDJOB2 if and only if IDKIT IDKIT when
IDJOB=2
In this case my query should return null
With a subquery I can do this and it works
SELECT idkit from A where
Try to build the following table:
IDJOB | IDKIT | IDJOB2
4 | 19 | 4
4 | 19 | 4
4 | 19 | 4
4 | 19 | 4
4 | 19 | 2
4 | 19 | 2
2 | 19 | 4
2 | 19 | 4
2 | 19 | 2
2 | 5 | 2
(some join)
Then throw lines with
Hello, bon jour
try first with
setAutoCommit off
then TRANSACTION Begin
COMMIT OR ROLLBACK
setAutoCommit ON
younes
Heidi DIAS wrote:
Hello,
Excuse me for my English, but I am French.
I am studing MySQL and particularly replications.
When we have 2 threads which use
In simple terms I need to be able to click a link on a webpage which runs
some SQL to produce a result set and then prompts the user to save this as a
pipe delimited file onto their HDD. Or which does the saving to HDD without
the prompt but it still needs to be triggered from the webpage.
Hi,
Hi.
I have this table (A)
IDJOB ¦ IDKIT
4 ¦ 19
4 ¦ 19
2 ¦ 19
2 ¦ 5
I need to extract IDKIT with IDJOB2 if and only if IDKIT IDKIT when
IDJOB=2
In this case my query should return null
With a subquery I can do this and it works
SELECT idkit
chandrashekar,
Tuesday, May 07, 2002, 12:19:54 PM, you wrote:
cn We are working a project using Mysql for the database support.
cn The environment is multiserver. We are using a single table for
cn all the servers to store server information. We basically want
cn to know what is the maximum
RRamasamymani,
Tuesday, May 07, 2002, 10:11:08 AM, you wrote:
R From: [EMAIL PROTECTED]
R To: [EMAIL PROTECTED]
R Subject: SUPPORT PLEASE - Error while running mysql_install_db
R Description:
R After installing successfully mysql in my sun solaris - sparc machine,
R while i am trying to
Christy,
Monday, May 06, 2002, 8:56:53 PM, you wrote:
CR I've been trying to import text files into MySQL, but I can't get it to
CR work. I'm new to MySQL and am still getting familiar with it, so
CR perhaps I'm missing something. I'm using the LOAD DATA LOCAL command
CR but I keep getting
Azharullah,
Tuesday, May 07, 2002, 4:30:16 AM, you wrote:
AK I am running mysql on solaris. This is a binary release. However, now I
AK would like to start my server with the innodb functionality. But I can't
AK start my server working for this.
AK I am not able to run the ./configure
Nick,
Tuesday, May 07, 2002, 12:06:31 PM, you wrote:
NW I've been searching for a solution to the following:
NW Is there an easy way to order by date ( - MM - DD), at the moment my
NW results are coming back with the *day* ordered but not the whole date
NW like this:
NW 02 02 2002
NW 03 03
Gregg,
Tuesday, May 07, 2002, 12:15:27 AM, you wrote:
Check the manual:
http://www.mysql.com/doc/V/a/Variables.html
GG According to the manual from the above link, where it states:
GG ==
GG You can set a variable with the SET syntax:
GG
Chirag,
Tuesday, May 07, 2002, 6:57:00 AM, you wrote:
C Which header file or library i need to include for strmov ? i have
C mysql v3 and i have included mysqlclient library. But it still tells
C undefined reference.
strmov is defined in m_string.h include:
Dennis,
Tuesday, May 07, 2002, 10:25:25 AM, you wrote:
I want to use the command LOAD DATA INFILE
I have a table with 18 columns. But to fill the columns unfortunately I
don't have one input file put two.
The first on shall fill 16 of the 18 columns. The second one contains
the data of
I have defined some InnoDB tables and try to feed one of them
with 3,000,000 records.
Using a script piped to mysql.
First I tried to insert the rows one by one. It worked very slow. I didn't
wait to see if it ends.
Next try was to fill some temporary table with the numbers 1..3,000,000. I
was
CR I've been trying to import text files into MySQL, but I can't get it
to
CR work. I'm new to MySQL and am still getting familiar with it, so
CR perhaps I'm missing something. I'm using the LOAD DATA LOCAL
command
CR but I keep getting error 1148 The used command is not allowed with
this
CR
[EMAIL PROTECTED] writes:
^^ Oh forgot to ask in the last post, how are you setting the password in the
^^ first place? Are you using a grant statement or inserting values into the
^^ table. I reckon the former is better (and safer) but if you're doing the
^^ later the you need to flush
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Victoria Reznichenko declared
NW I've been searching for a solution to the following:
NW Is there an easy way to order by date ( - MM - DD), at the moment my
NW results are coming back with the *day* ordered but not the whole
Oren,
what MySQL version you are running? What OS?
Send me a copy of your my.cnf, the error log 'hostname'.err, and the exact
sequence of SQL statements you used to crash InnoDB, including the table
CREATE statements. Did InnoDB run out of tablespace?
Regarding the performance, did you set
Hi Mysql Gurus,
We are facing a problem when we start mysql server. It
is giving the error, unable to start mysql, Unable to locate
the mysql.host table. Can anyone tell us how to resolve
this error ?
When we tried to reinstall the mysql package it started
the mysql server with no errors. But
Hello!
May be you are using data as text field or date is being stored in 3 separate columns.
Tell me if I am right. You will
need to store the date as date data type and will be automatically sorted.
Regards
~~~
Tahir Ata Barry
BestPriceHost.com
The Hosting With 3 MySQL Databases
Hi,
I'm having problems porting a working client from Solaris/Linux
to Windows NT (the client uses Paul DuBois' client4.c ideas to
load_defaults() and getopt_long() to get connection parameters
at runtime).
I'm using the gcc compiler, and the compile phase seems to work
fine, but when linking
Hey All,
We recently picked up a box running a web site with mysql on freebsd.
The cpu load gets pegged high realy quickly under its normal load. This
wasnt always the case.My designers do not believe it to be the queries
shown in the slow query log, which return quickly on development
[snip]
NW Is there an easy way to order by date ( - MM - DD), at the moment
my
NW results are coming back with the *day* ordered but not the whole date
NW like this:
NW 02 02 2002
NW 03 03 2005
NW 18 02 2003
NW See what I mean?
[/snip]
If the date is in the format above you can
You may want to use GROUP BY clause to get a count of the results .. See:
http://www.mysql.com/doc/G/r/Group_by_functions.html
For example, to retrieve the number of row where nation is German do:
SELECT COUNT(*) AS mycount, nation FROM memberscopy WHERE nation='German'
GROUP BY nation;
Gurhan
Nick,
Tuesday, May 07, 2002, 4:01:09 PM, you wrote:
What is your column type? Why you don't use ORDER BY your_date_column
in the SELECT statement? It should work, but I can say you exactly
because I don't know your table structure. The other causes of wrong
result might be that something is
Christy,
Tuesday, May 07, 2002, 3:07:25 PM, you wrote:
CR I've been trying to import text files into MySQL, but I can't get it
CR to
CR work. I'm new to MySQL and am still getting familiar with it, so
CR perhaps I'm missing something. I'm using the LOAD DATA LOCAL
CR command
CR but I keep
chandrashekar,
Tuesday, May 07, 2002, 12:22:43 PM, you wrote:
cn We are facing a problem when we start mysql server. It
cn is giving the error, unable to start mysql, Unable to locate
cn the mysql.host table. Can anyone tell us how to resolve
cn this error ?
Did you installed grant tables?
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Jay Blanchard declared
If the date is in the format above you can select a substring
+++
| field1 | rDate |
+++
| 1 | 2002-03-01 |
| 2 | 2002-03-03 |
| 3 | 2002-03-05
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: SUPPORT PLEASE - Error while running mysql_install_db
Description:
After installing successfully mysql in my sun solaris - sparc machine,
while i am trying to run the script mysql_install_db
system has given the following error
Our mysql-server is down and can't start anymore. He can't connect server
through socket '/path/to//mysql.sock' (number)
When I take a look in hostname.err I get this
on www.sin.khk.be/~crashke/error.log you can find the latest error
Jurgen Campforts
Meidoornlaan 2/1
2200 Herentals
Hi Joe,
I'm actually going through this same issue on 4.5 box
right now running Mysql max.. i've submitted ticket into support @ mysql
since i bought it.. I guess this seems to be common thing in Bsd
Hope we can all figure whats wrong with it..
-Frankie
- Original Message -
From: Joe
While I haven't tested this, you might try something like...
mysqldump -h host -u userid -p database | mysql -h newhost -u
new_userid -p database
or, share out and NFS mount the new system's partition to the old system
and do a dump that way.
Just a few thoughts,
Ron
Richard Idalski
Oren,
I did not find any clear crash from the error log. Looks like MySQL somehow
failed in shutdown:
...
020507 9:59:12
/usr/local/mysql-max-3.23.48-sun-solaris2.8-sparc/bin/mysqld: Forcing close
of thread 109 user: 'root'
A mysqld process already exists at Tue May 7 09:59:39 IDT 2002
...
Quoting Nick Wilson ([EMAIL PROTECTED]):
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Victoria Reznichenko declared
NW I've been searching for a solution to the following:
NW Is there an easy way to order by date ( - MM - DD), at the moment my
NW results are
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 07, 2002 9:49 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: Support
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: SUPPORT PLEASE - Error while running
I am having performance problems with my MySQL installation - what would be an
appropriate channel for requesting help to such a problem?
I have posted to this list twice and another one as well. Volumes are very high on
using MySQL/standard SQL questions, but not an single suggestion has been
Hi Dave,
This won't have purely SQL only solution , you can use SELECT .. INTO
OUTFILE .. syntax to create a file and you can zip the file with a random
name and link to that zip file.. This will force the explorer to save the
file. If you just let it stay as a text file, the browser won't
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
* and then Victoria Reznichenko declared
NW and here is my select:
NW $qry=SELECT id, module, week, ;
NW $qry.=DATE_FORMAT(date, \%d %m %Y\) as date, ;
The
[snip]
I am having performance problems with my MySQL installation - what would be
an appropriate channel for requesting help to such a problem?
[/snip]
Repost your original concern and I will see if I can help.
Jay
-
Before
Hi,
I'm using the C API for mysql and i wanna know how can i get the number of
affected rows after a UPDATE statement.
Thank u very much,
Edilson.
-
Before posting, please check:
http://www.mysql.com/manual.php (the
Hi,
is it possible to have a column which does NOT have a default value, i.e.
an INSERT query should fail if no value is given..?
The obvious idea, i.e.
CREATE TABLE foo (bar integer not null default null);
doesn't work.
--
Matthias Urlichs | noris network AG |
Thanks, Egor. I still can't get it to work though. I added those lines
under the [mysqld] and [client] sections - into my four .cnf files, they
are my-small.cnf, my-medium.cnf, my-large.cnf, and my-huge.cnf. I
dind't have a my.cnf like you mentioned. Is there something else I
should be doing?
Hi everybody.
If I start a database using MySQL for Windows, can I later transfer it to
MySQL for Linux by just copying the database directory. Or will I have redo
it from scratch. What about my odcb connections will they continue to work
without modification on the client side.
TIA
Greetings.
I am new to MySQL and am starting to use Apache::Session::MySQL.
I created a table as the instructions mention.
CREATE TABLE sessions
(
id CHAR(32) NOT NULL PRIMARY KEY,
a_session TEXT
)
;
I have also tried a_session as BLOB.
I can set and retrieve values from the
At 11:42 -0300 5/7/02, Edilson Vasconcelos de Melo Junior wrote:
Hi,
I'm using the C API for mysql and i wanna know how can i get the number of
affected rows after a UPDATE statement.
mysql_affected_rows() is probably what you want.
For more info, check the MySQL manual C API chapter:
Our mysql-server is down and can't start anymore. He can't connect server
through socket '/path/to//mysql.sock' (number)
When I take a look in hostname.err I get this
on www.sin.khk.be/~crashke/error.log you can find the latest error
Jurgen Campforts
Meidoornlaan 2/1
2200 Herentals
Christy,
You need to edit the defaults file for your MySQL server. It is by default,
/etc/my.cnf , unless another one is specified when mysqld is started. The
four files that you have mentioned comes with MySQL downloads to be used as
an example...
See:
On Tue, 7 May 2002, George Pitcher wrote:
Date: Tue, 7 May 2002 06:15:28 +0100
From: George Pitcher [EMAIL PROTECTED]
To: [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: JDBC connection to MySQL
Just a guess, but how about an ampersand?
Connection c =
I use mysql to register data in an accounting system, comunications
happen in a 200 Mbit network and database is really fast, so lock
situation ( ie delete after a long select ... ) is really fast and
does not create problems. When I connect from a dialup connection
obviously query take the same
The RAND() syntax does not appear to be working for me.
What version mySQL is required?
At 04:43 PM 1/29/2002 +0200, Michael Widenius wrote:
Hi!
Ulf == Ulf Harnhammar [EMAIL PROTECTED] writes:
Ulf On Sun, 27 Jan 2002, Michael Widenius wrote:
One way to do this is to do as follows:
Hi -
Before I start fiddling with buffer sizes and what not, is there any
documented issue with truncated results of concat_ws() within joined
tables, when using an order by clause?
Using MySQL 3.23.48 on Linux. Will post SQL queries and table structure if
there's not just an answer somewhere
Hi all...
I'm about to start heavy development of an application with MySQL at the
backend. However, I need some help
deciding on what language to approach the project from.
What are the ACTUAL speed comparisons - JDBC vs MySQL++ ?? How is the
speed of ODBC (Win vs Linux?)?
Are there any
You have to have MySQL 3.23 or greater..
http://www.mysql.com/doc/M/a/Mathematical_functions.html
Gurhan
-Original Message-
From: Cummings, Shawn (GNAPs) [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 07, 2002 11:33 AM
To: [EMAIL PROTECTED]; Ulf Harnhammar
Cc: [EMAIL PROTECTED]
Subject:
If you really need the speed than go with C++. However, if it is a web
application I would recommend you go with Java. The performance for JDBC is
very decent. Don't forget, speed is also determined by your network.
I hope this help
-Original Message-
From: Ryan Hatch [mailto:[EMAIL
Hi,
Don't give up.Try againso ... what's your problem?
More details about your problem are welcome.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL
Hi all,
I'm in the process of evaluating MySQL/InnoDB for a big project.
The data is composed from few tens millions of records with foreign keys
used between tables.
In the main table the search will be based on a string key (varchar(32)).
The scenarios in the systems are:
1. Bulk update
Hi,
Yes.
1.You must shutdown mysqld from Windows and from Linux.
2.Copy files from Windows to Linux.
...optional shutdown Windows ... for ever.(Ha,ha,ha...just a joke)
3.Change owner of the files to mysql.
4.Check access permision to files and directory.
Anyway, is recomended to use mysql
Hola y de antemano gracias.
Bien, estoy usando Redhat, C, Mysql.
Desde un programa en C utilizo una base de datos de mysql por medio de las API.
Necesito escribir los bytes de un fichero que puede ser de los siguientes tipos (BMP,
jpg, gij, avi, wav), el campo que estoy utilizando es de tipo
Hi,
My opinion:
For sure is not a bug.
Perhaps the client lock the table for read/write before access the table and
remain locked until retrieve data.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
there are limitations of course but you could also just do a mysqldump of all the data
and re-create the database
-Don
-Original Message-
From: Gelu [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 07, 2002 12:31 PM
To: Yvon Darang; [EMAIL PROTECTED]
Subject: Re: MySQL From Windows to
Hi
When I used the RAND() function (MySQL 3.23.45) I found the results were not
very random, instead I use an extra bit of php code to make sure the results
are more random.
mt_srand((double)microtime()*100);
$sql = select order by RAND(.mt_rand(0,32767).) limit 50
$rs =
Ok, I'm agree with you, someone know how to avoid this?
Why mysql does not retrive data in the buffer before send them on network?
My query is about 400 Kbyte.
Luca
- Original Message -
From: Gelu [EMAIL PROTECTED]
To: Luca Vertua [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, May
Hi,
My opinion:
If you wish to made a very safe application use C/C++ with API function.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
-
Thanks, Gurhan. I don't seem to have a my.cnf - the only cnf files I
have are the four samples - so can I just use one of the sample ones,
change the name, and add the local-infile =1 line?
-Original Message-
From: Gurhan Ozen [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 07, 2002
Hi,
I think it's better to lock the table before to delete.If you offer more
details maybe we can help.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL
The following code does not work because time_to_sec() works on the 24
hour clock and cannot work between 2 days. For example a session
started at 11:59 PM will not carry forward until 12:01 AM based on this
logic.
Does anyone have a better solution for me?
David McInnis
$sql =
At 11:32 -0400 5/7/02, Cummings, Shawn (GNAPs) wrote:
The RAND() syntax does not appear to be working for me.
What version mySQL is required?
3.23.2. Prior to that, use
SELECT something, any_col*0+RAND() AS r FROM sometable
WHERE ... ORDER BY r LIMIT 10
At 04:43 PM 1/29/2002 +0200, Michael
Hi,
Gregg Graubins wrote:
Gregg,
Monday, May 06, 2002, 6:57:55 PM, you wrote:
GG Upon reading into the user variables section of the mysql manual, I
cut
cut
According to the manual from the above link, where it states:
cut
mysql SELECT @t1:=(@t2:=1)+@t3:=4,@t1,@t2,@t3;
are you sure you don't have a my.cnf file in /etc dir? Who has installed,
started MySQL server? If no default files are given, mysqld will read
options from /etc/my.cnf .
Gurhan
-Original Message-
From: Christy Roberts [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 07, 2002 1:00 PM
To:
This question is purely academic, surely you need to investigate what
the system is required to do in terms of processing (Batch/Transaction,
GUI Front-end etc.) and then base your decision against the language
which would suit the type of processing required. Perhaps you will need
to use a bit
Quoted from the manual page I have given below is:
RAND() is not meant to be a perfect random generator, but instead a fast
way to generate ad hoc random numbers that will be portable between
platforms for the same MySQL version.
So it was intentionally built so...
Gurhan
-Original
- Original Message -
From: Ryan Hatch [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED];
[EMAIL PROTECTED]
Sent: Tuesday, May 07, 2002 10:50 AM
Subject: Help! Deciding on Java/C++ ?
Hi all...
I'm about to start heavy development of an application with MySQL at the
backend.
Hi!
I have a little pb with indexes.
when I make an explain on my query I have strange results.
my query looks like this
select *
from LIST l, WIN c
where l.ID_LIST=c.ID_LIST and l.KEY = '421' and l.ACTIF='1';
table LIST :
ID_LIST(primary key), KEY, ACTIF, ...
table WIN
ID_WIN(primary key),
When I do a search on my entire machine, the only 4 cnf files it finds
are those four samples. Where should the file be? I installed and
started MySQL myself but I did it under an administrator account. I'm
now running under my own account...would this make a difference?
-Original
88 matches
Mail list logo
