Splitting a table is not realy difficult, you could use:
Create table user_info select fieldname1,fieldname2,... from
large_table_name;
But you'll probably want a connection between the new tables.
you could add a ID-record first by doing:
alter table large_table add ID int unsigned auto_increm
Sorry for the confusion. I have not checked www.MySQL.org in such a
long time.
I was referring to the period of time when NuSphere (Progress) had owned
MySQL.org and appeared to be falsely representing themselves as the
MySQL developers.
I'm sure you now know what I intended.
Regards,
-Rya
Jurgen--
Strange thing is, I had been able to build MySQL 4.0 - up until 3 days
ago - without any problem. All from the same Mysql development tree.
At some point, the whole thing just fell apart after a source update.
Also, there's no problem building v3.23 on the same box!
It actually looks
Hi!!
I used BACKUP TABLE command to take the backup of a table...but when i say
RESTORE TABLE, i get the following ::
mysql> restore table rs from '/tmp';
+---+-+--+--+
| Table | Op | Msg_type | Msg_text |
+---+-+
Hi All,
mysql newbie here, this may be a silly question, but I couldn't figure out
how to word it for a google search
I want to take a table that someone created, a break it up so that one
table is NOT 125 fields large. I want to separate the table into user
info, product info and product defin
hello to all mysql list subscribers ,
I have a problem which I think can be solved by SELF
JOIN but I can't figure out how to do it
here is table definition
CREATE TABLE first (
firstcolumn int(11) default NULL,
secondcolumn int(11) default NULL
) TYPE=MyISAM;
INSERT INTO first VALUES (0
Well, assuming the time is in seconds (as in a UNix timestamp), you
could use rounding function:
select 600 * round(time_in_seconds/600)
(600 being # of seconds in 10 minutes).
Read the docs for the round() function -
http://www.mysql.com/doc/M/a/Mathematical_functions.html
-
Hi Tim,
On Fri, 2002-05-10 at 11:53, Tim Johnson wrote:
> I'm not usually this lucky, but it seems that the trick is
> to let mysql do more of the work, and I'm happy to go
> along with that:
> What I needed is
> CREATE TABLE EurCount SELECT DISTINCT Country FROM EUR;
>
Hello Again:
I'm not usually this lucky, but it seems that the trick is
to let mysql do more of the work, and I'm happy to go
along with that:
What I needed is
CREATE TABLE EurCount SELECT DISTINCT Country FROM EUR;
(with EurCount being nonexistant)
I would appr
Good evening all,
I have a strange situation which I cannot think myself out of. To make
it simple my db looks like this
(hr db, emp_master table)
++---+
| emp_id | last_name |
++---+
| 1 | smith |
| 3 | wesson|
|
As bizarre as it sounds, it works now.
I thought just on a whim I would try it again. I scrolled up and used the
exact same commands as before (without retyping them) and it worked fine.
I don't know what was wrong, but I suspect it may have had something to do
with the amount of activity of
Hello:
Am using Ver 11.15 Distrib 3.23.41, for redhat-linux-gnu (i386)
on RH 7.2.
I would like to construct a mysql command that select a unique
set of data from one table and creates a table with that
data.
I think I'm close here, but am still getting errors:
The query string i
Windows 2K MySQL V ? (recent). Sorry, I'm not at my own machine at present,
can't check actual version number.
Installed, running and everything is ok, except I created a database called
'xyz' as a test then decided to delete it.
I used the command: DROP DATABASE 'xzy';which returns a mes
Hi Vadim, I don't know but have you read the instructions on the
Mysql-website?
To determine if you should be concerned about this compiler issue, execute
gcc -v from the command prompt on your system. If the compiler reports
version 2.96, then there is a problem (this is the case, for example on
Well, My hat's off to MySql 4
I finally got around my slow query problem... :-)
Mysql has beat any other database I have used for this specific
purpose...
I wrote a quick little app to directly import records to the MYD file.
I then run "myisamchk -r -q v:\Data\...\..\MyDataFile" to
reindex t
How do i do that?
Tried :
CC=gcc3 CXX=gcc3 ./configure
make -j2
but it does not work.
Gives this error :
gcc3 -O3 -DDBUG_OFF -rdynamic -o .libs/mysqltest mysqltest.o
../libmysql/.libs/libmysqlclient.so -lz -lcrypt -lnsl -lm -lz -lcrypt -lnsl
-lm -Wl,--rpath -Wl,/usr/local/lib/mysql
mysqlbinlog
The command
> mysql -u root -p mysql
is what I used to get in. That is why I am confused. I have always gotten
into MySQL that way before, and done the "granting" with no problems.
I can't get to a shell just now, but I will checkthe myisamchk command as
soon as I can.
Thanks.
Mark
> Hmm
>
>Does your master table have a list of table names and the table's
>characteristics? How is the search called?
currently i have a master table called "files", the primary key is id and
the data tables are called filedata1 filedata2, etc.
where 1 and 2 correspond to the file id. Each of the f
Hmm, I am kinda new at this, but what happens if you specifically log into
the user database first?
mysql -u root -p mysql
It could perhaps also mean your database is corrupted somehow; what do you
get when you are running this below?
/usr/local/bin/myisamchk /var/db/mysql/*/*.MYI
(adjust path
ECT MAX(id) FROM table WHERE DATE = '20020509' LIMIT 100
> No matter what, I will always get the max for the column for the whole
> tableadding and removing the "LIMIT" command changes absolutely
> nothing...
As Paul wrote, LIMIT is applied after everything else.
Bas
SELECT MAX(id) FROM table WHERE DATE = '20020509' LIMIT 100
>
>No matter what, I will always get the max for the column for the whole
>tableadding and removing the "LIMIT" command changes absolutely
>nothing...
That's how LIMIT works. It's applied after t
Hi Michael,
On Fri, 2002-05-10 at 02:27, Michael Davis wrote:
> I'm trying to allow an attribute to hold multiple value. I know you can use
> varray in oracle but I cant find anything in mysql. I found SET but you
> must set the possible choices from the beginning. This is not good for what
>
Hi Andrew,
IT is working as it is supposed to , MAX() only returns one row with the
highest value. IF you wanna get 100 highest values, just order the rows by
id and limit the result set to 100.
SELECT id FROM table WHERE DATE = '20020509' ORDER BY id LIMIT 100
Gurhan
-Origin
Hi Pete,
Thanks for the answer, I will search a bit better in the MySQL manual for
info about the .cnf files.. (Already did, but couldn't 123 found the
information you gave me.)
What I understand is that changing the packet size doesn't have a very
negative impact, sounds that it works as a prot
Yep...
I am in as root, so I should have rights to everything.
Yep, I have confirmed that the dbname is right, but doublechecking it
multiple times. Plus, this happens even on db that I did the same thing to
only a week ago. The * just says "all tables" as I understand it.
And, that is what
Hmmm -
Off the top of my head, how about:
select
order, if(SUM(cat1+cat2)=0, '-', SUM(cat1+cat2)) as sum
from
tbl
group by
order
Although you might need to quote the column name 'order', since that
is a reserved word:
select
'order', ...
group
At 03:57 PM 5/9/2002, you wrote:
>Dear mysql:
>
>You may ask yourself
> >How to make people respect you
> >How to win friends
> >How to make your life smoother and happier
> >How to do whatever you like without being unpleasant to other
> people
Speaking o
check freshmeat.net There are several time recording tools. You may find
one that works for you. Some of them use MySQL as a backend and some don't.
While The idea of using MySQL as the backend for a program like this is
good, you can't do it with MySQL alone. (Well, and keep your sanity)
=C=
SELECT main.id
FROM MainTable main OUTER JOIN MapTable map ON main.id = map.id
WHERE map.id = null
Does this work? Give it a whirl.
Another solution could be to do it like this:
SELECT col1, col2, coln
FROM MainTable
WHERE id IN (
SELECT id
FROM MainTable
WHERE id NOT IN (
S
Correction. I can see a mistake in my syntax. the correct statement to
pull the list of name in MainTable that ARE in mapMainTable is:
select MainTable.Name from MainTable inner join MapTable using (ID);
this works. but how can I pull the list of names that ARE NOT in the
map table?
Augey
You can do this with a pretty simple left join as follows:
SELECT MainTable.ID from MainTable LEFT JOIN MapTable ON
MainTable.ID=MapTable.ID where MapTable.ID IS NULL;
Because it is a left join, it will pad all MainTable entries that don't
appear in MapTable with NULL's. Hence we can check if t
Has anyone on this list used MySQL for time recording?
I am a lawyer considering using it for recording time spent on cases where
there are many to many relationships between cases, caseworkers, and
charge-out rates.
I posted to the list under the subject "lookup" and I learned that one
cannot d
Are you trying to load data FROM a text file, or are you trying to load data
INTO a textfile?
You said "I just created a database and tried to LOAD 1 line of data from a
text file." but then you stated "i need to INTO OUTFILE" ...
If you wanna load data from a text file into a table, look at:
ht
SELECT MAX(id)
FROM (SELECT MAX(id)
FROM table
WHERE DATE = '20020509'
LIMIT 100)
Dunno if this works in MySQL, I can't access a MySQL database from here to
test it out.
This should return the value that you want but I would be interested to
learn th
I have two tables. One table, which (to protect the innocent :-)) we'll
call MainTable, has a list of names with user info like address, etc..
and an auto-incrementing unique id for each. The other, which we'll
call MapTable, is simply a key mapping table with ids from MainTable
that just bas
Here is a bit of text I copy/pasted from the documents.
The `\' directory character
Pathname components in Win95 are separated by the `\' character, which is
also the escape character in MySQL. If you are using LOAD DATA INFILE or
SELECT ... INTO OUTFILE, you must double the `\' character:
mys
Just tried building Mysql-3.x.x cloned from the Development Tree on the same
machine - works like a charm. Still no luck with 4.0.2
Is there any known issue regarding building 4.0.2 under RedHat7.2?
Thanks,
Vadim.
"Vadim P." wrote:
>
> The Dev. Tree Source MySQL 4.0 no longer builds on t
Maybe the poster of the message is an imposter developer too?
MS
-Original Message-
From: Steve Buehler <[EMAIL PROTECTED]>
To: mysql <[EMAIL PROTECTED]>
Cc: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Date: Thursday, May 09, 2002 3:01 PM
Subject: RE: newbie help
>What makes you think that i
What makes you think that it is an imposter site? They both have the same
IP address, they are both the same site.
# nslookup mysql.org
Name:mysql.org
Address: 64.28.67.70
# nslookup mysql.com
Name:mysql.com
Address: 64.28.67.70
>-Original Message-
>From: Ryan Hatch [mailto
Dear mysql:
You may ask yourself
>How to make people respect you
>How to win friends
>How to let your conduct help your health, work, job, career, relationships,
spirit, mind, well-being, ...
>How to make your life smoother and happier
>How to
"Mysql.org is an IMPOSTER's site." What?
They are one in the same.
-Original Message-
From: Ryan Hatch [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 1:31 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: newbie help
"bd"...
Two things here:
1.) Mysql.org is a
I'm trying to allow an attribute to hold multiple value. I know you can use
varray in oracle but I cant find anything in mysql. I found SET but you
must set the possible choices from the beginning. This is not good for what
I'm doing because these choices will change. The only other thing that
Here is download for Very Simple UDF example for MySQL 4 and
Delphi 6. This is by ni means perfect...
mike
http://www.tctelco.net./~mmgrover/udf.zip
-
Before posting, please check:
http://www.mysql.com/manual.php
I want to select say 100 of 1,000 records and get the highest value for
"id" in that query, however the MAX command always gives me the MAX for
the whole table, not just my query.
Here's my expression:
SELECT MAX(id) FROM table WHERE DATE = '20020509' LIMIT 100
No m
"bd"...
Two things here:
1.) Mysql.org is an IMPOSTER's site. www.MySQL.com is the real site.
and
2.) You haven't given us the warning / error message you received.
-Ryan Hatch
[EMAIL PROTECTED] wrote:
>I just created a database and tried to LOAD 1 line of data from a text file.
>
>I h
Wrong. Windows uses \ for their paths, so MySQL should use the same
thing.
Matthew Walker
Senior Software Engineer
ePliant Marketing
-Original Message-
From: Bob Ryan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 1:59 PM
To: 'ali hafiz'; [EMAIL PROTECTED]; [EMAIL PROTECTED];
I think you have to use a forward slash in your path instead of a backslash.
C:/ as opposed to C:\
even in windows operating environments I believe you need to use /.
-Original Message-
From: ali hafiz [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 09, 2002 2:23 PM
To: [EMAIL PROTECTED];
MySQL is running as a Service in Windows 2000, as one might expect. Tried to
get the logs up and running with a my.cnf file in multiple locations,
including C:/ and DATADIR\my.cnf, then restarted service, tried logging in,
a few inserts, etc - no luck. Flushed logs using mysqladmin too. Here's my
I just created a database and tried to LOAD 1 line of data from a text file.
I have only 9 coloums , most varchar, one char, one smallint (autoincrement)
when i load the data (tab de-limeted) it goes fine but i get one Warning.
I found on mysql.org that i need to INTO OUTFILE and look for erro
Peter
This might not be exactly the kind of answer you are looking for(or it
might not even be what you are really asking), but
you can do Transactions programmatically in Cold Fusion. I
doubt Ultradev can do that, so you would probably have to code it
yourself.
there is a good example in t
Using MySql 3.23
Using Perl, I have a table that I feed data into. I then retrieve the
data and order it to write to arrays for use further on.
All works fine. Data remains in proper order (e.g. head[1] is in the
same array position as graf[1], etc.
The problem occurs now that I am trying to on
Hi Jack,
For question1, I think you need to use insert with set:
insert into table ABC
set column3 = "",
column4 = "",
column5 = "";
I think that should do it.
Have you managed to find an answer to question2? Please let me know.
Ali
>From: "Jack" <[EMAIL PROTECTED]>
>To:
- Original Message -
From: "Hisseine Dj." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 2:40 PM
Subject: Re: link problem
> > > gcc simple1.cc -c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient
> > > -lm -tz ->
>
> Replace the -c option with -o
>
> Hisse
On Thu, 9 May 2002 [EMAIL PROTECTED] wrote:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> sql,query
>
> If you just reply to this message, and includ
[snip]
I have 2 tables with RecordDate in them, one has millions of records, one
has hundreds of records. If I perform the following query on the table with
hundreds;
mysql> select RecordDate
-> from tblInfo
-> WHERE RecordDate BETWEEN '2002-03-04' AND '2002-03-06'
-> GROUP BY RecordD
I don't want to doubt you :-) but can you show us a select including the
time component? I don't know how date comparison works in MySQL but here is
a test I ran in Oracle. I inserted some dates into a table using sysdate
which include time information and inserted more records using
to_date('20
> > gcc simple1.cc -c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient
> > -lm -tz ->
Replace the -c option with -o
Hisseine
- Original Message -
From: "Sinisa Milivojevic" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 1:43 PM
Subj
>
> Hi
> below is a small sub I wrote. It works, but mixes up the updates for
> several fields.
> The update query should take every value and update the assigned column.
> But every time it happens, that after the columns are omitted or added
> so that the columns are not correctly updated.
>
>
Hi
I am looking for help with a problem I haven't figured out how to do.
Below is a
query which gives me a count of the number of applicants registered for
courses. With that I can get when the course is full, and how many are on
the waiting list.. Now what I would REALLY like is all this info,
adelpfe writes:
> hi every body
> i have succeed to compile source examples given with mysql++1.7.9. but i
> can't link them.
> i used
> gcc simple1.cc -c -I/usr/include/mysql -L/usr/lib/mysql -lmysqlclient
> -lm -tz ->all rigth
> but , i didn't succeed to link
> can you help me
>
HI!
First o
On Thursday, 9. May 2002 18:43, ">>> Soilant ! wrote:
> Dear mysql,
> I just got one simple table. The PHP-Script ist ok (tested on another
> server), but trying to get data over my server, nothing comes back.
> So, I put up the lines:
> ".mysql_errno()." - ".mysql_error()."
> It gives back: " 0 -
>Description:
i installed the binaries of mysql 3.23.49 (tried both tar.gz and rpm) but cannot
execute any (neither the deamon mysqld nor the monitor mysql). i can execute scripts
but they will fail as they are calling mysqld
>How-To-Repeat:
execute mysqld on my particular machine ;-)
>Fix:
[snip]
Perhaps the time component of the date is different, hence you are getting
back what looks like duplicate rows but they're not really?
[/snip]
The time components are all the same. And if I say this in my query;
WHERE RecordDate = '2002-03-04' , it works (returns one row of data)
or if I
At 11:57 -0400 5/9/02, Luc Foisy wrote:
>It may not make any sense to you, but it makes perfect sense to me
Okay. Then it would seem that either:
- I understand what you want to do, in which case you can't do it, because
you're using SQL variables in a self-contradictory way.
- I don't unders
Hi,
I've an AlphaServer 1200 with dual EV56 533MHz processors and I'm
looking for a precompiled MySQL binary (any of the four release trees, I
don't mind which). In running the benchmark tests distributed with
MySQL on the source distribution of 3.23 I found the results were worse
than that of a
At 12:19 -0400 5/9/02, Luc Foisy wrote:
>hmm. ok i see what you are getting at
>but you do that every time you use a where clause, do you not?
No, not really
>
>SELECT value FROM table WHERE value = 5
In this case value is used in the WHERE clause to determine which records
to select. Once sel
Perhaps the time component of the date is different, hence you are getting
back what looks like duplicate rows but they're not really?
- Max
Martin Anderson
QA Engineer
ProfitLogic
Eleven Cambridge Center
Cambridge, MA 02142
t: 617.218.1946
-Original Message-
From: Jay Blanchard [mailt
[snip]
mysql> GRANT ALL
-> ON dbname.*
-> TO username@localhost
-> IDENTIFIED BY 'password';
[/snip]
A. Do you have GRANT capability as the user that you are logged on as?
2. Is dbname.* right? Shouldn't it be just dbname?
III. Is user set up as username@localhost?
Jay
The Dev. Tree Source MySQL 4.0 no longer builds on this machine, giving lots
of errors. Had been able to build from the same source w/o any problems up
until a few days ago, when I 'bk resync'ed the source. Any ideas?
Thanks for your help!
I hope that someone can help with this. I am trying to install
mod_auth_mysql as a DSO, but I get errors.
Here are the errors when compiling mod_auth_mysql:
/usr/local/src/mod_auth_mysql-2.20# cp config.h auth_mysql_config.h
/usr/local/src/mod_auth_mysql-2.20# /usr/sbin/apxs -i -a
-I/
Dear mysql,
I just got one simple table. The PHP-Script ist ok (tested on another
server), but trying to get data over my server, nothing comes back.
So, I put up the lines:
".mysql_errno()." - ".mysql_error()."
It gives back: " 0 - "
What does it mean? Is there maybe NO connection to MySql?
Sor
71 matches
Mail list logo