When trying to create an index on
Table ANSCHLUSS:
| ID | int(11) | | PRI | NULL| auto_increment |
| TELEFON | varchar(20) | | MUL | ||
| REGION | int(11) | | | 0 ||
| LAND | int(11) |
Is there primary key on field Value? Or any index?
Daniel
At 14:37 2002.10.04._ +0800, you wrote:
> > Hi,
> >
> > My tables is something like this
> >
> > Value Count
> > B 10
> > C 20
> > A 15
> > D 8
> >
> > When I query using "SELECT Val
> Hi,
>
> My tables is something like this
>
> Value Count
> B 10
> C 20
> A 15
> D 8
>
> When I query using "SELECT Value, Count FROM Table", the data is
appearing
> exactly at the order above, however when I select only a single column
>
>Subject: Re: MySQL/InnoDB-4.0.4 is released
>...
>Subject: Re: MySQL/InnoDB-4.0.4 is released
>...
> > Subject: Re: MySQL/InnoDB-4.0.4 is released
> >...
> > > Subject: Re: MySQL/InnoDB-4.0.4 is released
> > >...
> > > > > Subject: Re: MySQL/InnoDB-4.0.4 is released
> > > > >...
> > > > > > Subje
On Friday 04 October 2002 11:04, Paul DuBois wrote:
> At 10:43 +0800 10/4/02, Niclas Hedhman wrote:
> >If I have a table,
> >
> >Name VARCHAR(100)
> >L DOUBLE
> >a DOUBLE
> >b DOUBLE
> >
> >and execute the incredible
> >
> >SELECT * FROM Colors WHERE
> >SQRT(
> > SQ(
> > ABS( L - 45.5 )
> >
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 04, 2002 12:17 AM
To: Dragos Madalin Popa
Subject: Re: RE: how can I turn on query log on Windows? (mysql-3.23.38)
Your message cannot be posted because it appears to be either spam or
simply o
How would one go about changing the key block size for a
table/database/server? As I understand it, key blocks are 1024 bytes (1k)
by default. I am creating an ext2 partition with 16k blocks for a database
with tens of millions of records and would like to optimize the key block
size to the fs bl
hi all:
i am attempting to connect to a mysql database from php, using the following
syntax in the php:
$dsn = "mysql://webuser@localhost/doug" ;
$db = DB::connect( $dsn ) ;
if ( DB::isError($db) )
{
print $dsn."\n" ;
die( $db->getMessage()."\n" ) ;
}
i get this message:
mysq
On Thu, 2002-10-03 at 23:26, Chris Becker wrote:
>
> Your right - Max is a server, thank you.
>
> Directories you listed do not exist. That rpm is all honked up. Is there an
> UN-install flag for rpm? I would like to cleanly reverse what was done w/
> the rpm and install from the binary, is th
Hi, I am trying to use mysqldump to dump the structure of a single database
and want the output to make create table commands that include the IF NOT
EXISTS switch so that when the file is imported into an existing database it
does not write over tables with the same name. Does anyone know if this
>
> I don't by the "less functionality" argument any more than "if
> you have a good
> emailer". I think I have a good emailer, and on the "munging"
> lists, I press
> Reply-All, it will also send to the original author, but >95% of
> the case I
> want the list, and original author doesn't want t
Your right - Max is a server, thank you.
Directories you listed do not exist. That rpm is all honked up. Is there an
UN-install flag for rpm? I would like to cleanly reverse what was done w/
the rpm and install from the binary, is this possible? The workaround
provided below does not seem to
At 10:43 +0800 10/4/02, Niclas Hedhman wrote:
>If I have a table,
>
>Name VARCHAR(100)
>L DOUBLE
>a DOUBLE
>b DOUBLE
>
>and execute the incredible
>
>SELECT * FROM Colors WHERE
>SQRT(
> SQ(
> ABS( L - 45.5 )
> ) +
> SQ(
> ABS( a - 13.2 )
> ) +
> SQ(
> ABS( b + 23.4 )
>
Max is a server.
your install directory out of an RPM should be /var/lib/mysql if you are
root su to root and see if it's there. It should tell you this in
/usr/share/doc/packages/Mysql
thwere's a manual there or it should be.
John Coder
On Thu, 2002-10-03 at 21:55, Chris Becker wrote:
> Thank
If I have a table,
Name VARCHAR(100)
L DOUBLE
a DOUBLE
b DOUBLE
and execute the incredible
SELECT * FROM Colors WHERE
SQRT(
SQ(
ABS( L - 45.5 )
) +
SQ(
ABS( a - 13.2 )
) +
SQ(
ABS( b + 23.4 )
)
) < 2.5 ;
Could MySQL benefit in any way by indexing the L,a,
On Thursday 03 October 2002 22:33, Michael T. Babcock wrote:
> Franz Alt wrote:
> From one site: "Reply-To munging does not benefit the user with a
> reasonable mailer. People want to munge Reply-To headers to make ``reply
> back to the list'' easy. But it already is easy. Reasonable mail
> pro
I did it again!!!
-- Forwarded Message --
Subject: Re: OT: Reply-Adress in this list
Date: Fri, 4 Oct 2002 10:31:28 +0800
From: Niclas Hedhman <[EMAIL PROTECTED]>
To: Dan Nelson <[EMAIL PROTECTED]>
On Thursday 03 October 2002 22:23, Dan Nelson wrote:
> In the last episode (O
I have a table with millions of records, lots of fields, and lots of
indexes. It appears I break every rule for table efficiency...but there is a
reason! I needed to do summarized data on *lots* of the fields at once, and
the savings in time & simplicity far outweigh any performance hits I may
hav
Thanks Praveen,
So Max is not a server version, it sure is difficult to determine that on
the download page:
MySQL database server & standard clients:
· MySQL 3.23 -- Stable release (recommended) latest version is 3.23.52
· · 3.23 -- Default package (use this if you are unsure
Hi Mike,
I hope you are on linux machine, What are versions on
old and new machines, is there any difference?.
just tar the data dir /var/lib/mysql (in most of the
cases) and untar on the new machines by moving the
existing mysql directory by this old data.
I don't think this will fail, I have
well - I can't telnet to that port, but I have a web server up & running,
and I cannot telnet to port 80 either, but my web browser does work. I am
also connecting to it on port 3306 locally.
- Original Message -
From: "Jeremy Tinley" <[EMAIL PROTECTED]>
To: "'Jeff Bluemel'" <[EMAIL PROT
Hi,
Where is the Mysql-server version. you have installed
only client and mysql-max, but no mysql-server. Use
rpm -Uvh for your installations, so that you can
easily know the progress of installation.
regards,
Praveen
--- Chris Becker <[EMAIL PROTECTED]> wrote:
>
> RedHat6.2 install (everything
Hi,
Some of the old mysqldump apps have a bug where they're missing quotes on
long rows. Try the dump the other way - i.e. use the mysqldump client on
the new machine and pipe it from the old machine back to the new machine
(make sure the new machine has permissions to grab from the old one...).
Hello All;
I am having a problem using the mysqldump application. I have an old server
that I am trying to move to a faster machine. No matter what I do, about 90
queries in the connection ceases and the old meachine gets a server has gone
away error. I have tries runnig mysql dump piped to the m
Ahem, have a look at the bottom of any post to the list:
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
:)
HTH,
William.
> -Original Message-
> From: Chris Becker [mailto:[EMAIL PROTECTED]]
> Sent:
Yep, It's here
http://www.mysql.com/documentation/searchlists.html
Cheers,
Andrew
Sql,query
-Original Message-
From: Chris Becker [mailto:[EMAIL PROTECTED]]
Sent: Friday, 04 October 2002 00:43
To: [EMAIL PROTECTED]
Subject: Archive of this mysql list
>Is there an archive of
>Is there an archive of all posts to this mysql list that I can search
>somewhere?
>
>Chris Becker
>MCDBA MCSE
>http://www.PrismSoftware.com
>[EMAIL PROTECTED] sql
-
Before posting, please check:
http://www.mysql.com/manu
We have a 4.0.4-beta master and slave.
The slaving process starts correctly, but randomly (and frequently) has
issues.
When the server starts, it will slave, but eventually will hit one of
two conditions:
- Duplicate key insert error (we re-sync'd the slave by hand during the
install, copying
On Fri, Oct 04, 2002 at 12:51:16AM +0300, Heikki Tuuri wrote:
>
> only successful queries are written to the binlog and replicated. It is a
> bug in MySQL replication if a duplicate key error in the master is
> propagated to the slave.
Or someone accidentallly muged data on the slave. We've had
Hi,
In my experience (assuming that you are using mysql for all of these
operations) the best way is to separate your tables into read-heavy and
write heavy and put each into separate databases. Put the write-heavy logs
database onto a separate disk/spindle and use delayed inserts (so that the
a
Send me create-table scripts and population scripts and I'll do this for
you. But on rereading your message I'm guessing that your normalization is
wrong. You have more than one multi-valued dependency. Your example
description is either wrong or insufficient.
T1 (presumably the parent of all par
Thanks John,
I looked through your web site, it seems to me that corereader is
microsoft based product. I'm on Linux RedHat 7.2.
thanks
[EMAIL PROTECTED] wrote:
> corereader will help you do a point&click join of up
> to four tables.
>
> you can operate corereader without it, but reading
Here is the query that I had in a PhP script that joins a bunch of
tables (I'll try to make this look readable). If you're curious, it's for
a motorcross site (www.springcreekmx.com):
SELECT standings.rank, race.race_date, class.class_name,
racer.racer_name, cycle.cycle_desc, race_event.racer_
James,
- Original Message -
From: "James Kelty" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Friday, October 04, 2002 12:13 AM
Subject: Slave server and InnoDB
> sql,query
>
> Hello.
>
> Is there an option for the slave server to NOT stop when an error
> inducing query i
> Josh Trutwin wrote:
>
>>SELECT table1.bunch, table2.of, table3.stuff FROM table1
>> INNER JOIN table2 ON table2.some_id
>> INNER JOIN table3 ON table3.some_id
>>WHERE table1.some_id = table2.some_id AND table1.some_id =
>> table3.some_id;
>>
> Your where is sort of in the wrong place ...
>
Wayne,
the bug found and fixed.
If SHOW INNODB STATUS or innodb_monitor printed several hundred
transactions, and the output was truncated, it forgot to release the
'kernel' mutex, causing the hang.
Also the main thread was hung. That is why it claimed to be doing a
background table drop.
The
Yes there are. First do as you have written, although your syntax is a bit
wrong but the email compiler forgives such stuff :-)
> SELECT table1.bunch, table2.of, table3.stuff FROM table1
>INNER JOIN table2 ON table2.some_id
>INNER JOIN table3 ON table3.some_id
> WHERE table1.some_id = tab
Josh Trutwin wrote:
>>SELECT table1.bunch, table2.of, table3.stuff FROM table1
>> INNER JOIN table2 ON table2.some_id
>> INNER JOIN table3 ON table3.some_id
>>WHERE table1.some_id = table2.some_id AND table1.some_id = table3.some_id;
>>
>
>
Your where is sort of in the wrong place ...
SEL
Once you understand the logic of joins the rest is pretty straightforward,
since in terms of execution the sequence in which you do the joins is
irrelevant. (Performance is another issue, quickly resolved by specifying
the smallest tables first.)
Supposing that you have tables Products, Suppliers
corereader will help you do a point&click join of up
to four tables.
you can operate corereader without it, but reading
the documentation is strongly recommended.
> Is there a document that compiles examples on different ways of joining
> two or more tables? I found a few on
> http://www.
Hi Arthur,
Thanks for your answer and your example. Your example is very good but I
can't map to what I'm trying to do. As you suggested I have to
understand how inner join is implemented in MySQL. The query that I'm
working on selects fields from three tables, in this way,
Table_1 ha
Perl was installed from my RedHat 6.2 install media, I remember a problem
of installing MySQL using the binaries would cause conflicts with a rpm
installed Perl. That is what someone in this newsgroup told me about a year
ago. Is this true?
I couldn't get the MySQL to install with the RPM's.
sql, query
I have a dilemma and maybe you can help. I'm wanting to improve my disk
performance and I'm wondering if I should go with Raid 10 or if I should
simply mirror the drives so that I have redundancy and then put some of my
tables on one drive and some on the other. Or the third
sql,query
Hello.
Is there an option for the slave server to NOT stop when an error
inducing query is run on the master?
For instance, if someone tries in insert a duplicate entry, and the
master shows the error, but updates the binlog, how can I keep the slave
from seeing the same error, and NO
> Is there a document that compiles examples on different ways of joining
> two or more tables? I found a few on
> http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more
> than two tables.
>
> Thanks for any suggestions.
I wish there were more examples as well!
I use this fo
Is there a simple way to duplicate one or more rows in a table?
I tried:
INSERT INTO table SELECT * FROM table WHERE criteria
but apparently INSERT...SELECT cannot function on the same table.
- filter fodder, ignore -
sql query (I swear, I'm gonna put that in my .signature soon... :-
Pass Filter: sql,query
- Original Message -
From: "William Martell" <[EMAIL PROTECTED]>
To: "MySQL Main List" <[EMAIL PROTECTED]>
Sent: Thursday, October 03, 2002 1:48 AM
Subject: Three Tables
> Hello All,
>
> I have three tables in my database
> t1, t2, and t3. Each table has records
Sorry but I'm sure one of you guru's knows about the best software (ltl)
to migrate informix database to Oracle, I need to link then oracle to
MySQL, and then to report via crystal reports.
EJB
-
Before posting, please check:
Hello,
Been using mysql on w2k for a couple years now and never used the DSN ODBC
connection. See a lot of articles (google/archives/etc) on how to use it ..
but none on why. Any particular reason I would even want to use ODBC for a
mysql connection as opposed to just directly connecting to it
Wayne,
please send me the whole MySQL error log.
Looks like some thread, which had reserved the InnoDB 'kernel' mutex to
access the InnoDB lock table, got stuck.
This is interesting:
"
5 queries inside InnoDB, 0 queries in queue; main thread: doing background
drop tables
"
If you drop a table
On Wed, 2002-10-02 at 20:51, mos wrote:
> At 09:40 PM 10/2/2002, you wrote:
> >For science fair I'm doing a project on MySQL. For my introduction, I
> >need some articles, benchmarks, or anything else credible that I can put
> >in the bibliography. If anyone can help me out, I'd be extremely
> >ap
i just tried, and it came right up.
the server is located in the southern u.s., so
perhaps the hurricane is effecting it.
> I seem to be having problems trying to get to http://www.corereader.com ...
> Anyone else?
>
> +--+
> | ___ _
If you just reply to this message, and include the entire text of it in the
reply, your reply will go through. However, you should
first review the text of the message to make sure it has something to do
with MySQL. Just typing the word MySQL once will be sufficient, for example.
You have written
Gelu,
- Original Message -
From: "Gelu Gogancea" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; "Puiu Hrenciuc"
<[EMAIL PROTECTED]>; "Philip Molter" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 03, 2002 7:48 PM
Hi Heikki and all friends,
You quite right.If OS_THREAD_MAX_N is 100 or 1000 all it's ok and svr_init()
works well.
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[
hi everyone,
i have just installed mysql.i was able to start the mysqld
process.howeveri am unable to set password for root using the following
command sequence :
./bin/mysqladmin -u root -password 'abcd'
I get the following output :
./bin/mysqladmin: connect to server at 'localhost' f
On Thu, 03 Oct 2002, Andrew Braithwaite wrote:
Please can you post an explain of this query? As a first guess try:
alter table publicinfo add index location (x,y,class_code);
Nigel
-
Before posting, please check:
http://www
John Ragan wrote:
I have a select where I want to get ID 15 && id 25
Can I do something like WHERE ID = 15,25
Or do I have to do WHERE ID = 15 && ID = 25
>>
>>
You've got your boolean definitions wrong ... if you want two values,
you want the rows where t
I cannot find a fix for this (only a couple of mentions on upgrading glibc,
i think i have the latest). I get this during make
mkdir .libs
gcc -DDEFAULT_CHARSET_HOME=\"/usr/local\" -DDATADIR=\"/usr/local/var\" -DSHA
REDIR=\"/usr/local/share/mysql\" -DUNDEF_
THREADS_HACK -DDONT_USE_RAID -I./../in
hi,
i've downloaded and unpacked both the 3.2.3 and 4.0.4 binaries for solaris. neither
create a var directory, so i create the var directory myself and give mysql ownership
of it. yet when i run mysqld it still won't write the pid file. what gives?
tia,
j
---
Hi!
I believe the following patch fixes the startup problems on Win 95/98/ME in
InnoDB versions which have been released after July 2, 2002.
Looks like Win XP can easily create 40 000 event semaphores, but for
95/98/ME it is too much.
This should be in upcoming MySQL-3.23.53 and MySQL-4.0.5.
T
> HI all
> I'm trying to do the following
>
>---
> # want to select (just preparing) every thing from the table PERSON
> where i don't know the deptID y
On 3 Oct 2002, at 15:33, Mark Colvin wrote:
> The problem I am having is with the DATE_FORMAT. Running the above query
> returns the following for the width column.
>
> 94.40 DATE_FORMAT(d1.created, '%d-%m-%Y'): NULL DATE_FORMAT(d1.amended,
> '%d-%m-%Y'): 03-10-2002
Show your PHP code. How ex
I seem to be having problems trying to get to http://www.corereader.com ...
Anyone else?
+--+
| ___ ___ |
| //_/_/_/_/_/ //_/_/_/ |
|//_/ //_/ _/ |
| //_/ //_/
Hi All,
First thanks to all who worked on InnoDB, it is truely exciting to get its
features in an open-source DB. We've had an excellent experience thus far
with a few exceptions. Any help on solving the problem below is greatly
appreciated ...
We experienced a hard lockup a few days ago with my
äÏÂÒÙÊ ÄÅÎØ.
sql
> Andrey,
> Tuesday, October 01, 2002, 11:53:41 AM, you wrote:
>
> AK> Why is temporary tables replecated?
> AK> Is it true?
>
> Yes, temporary table are replicated properly since 3.23.29:
> http://www.mysql.com/doc/en/Replication_Features.html
Hmm... What is the reason?
If
Gelu,
- Original Message -
From: "Gelu Gogancea" <[EMAIL PROTECTED]>
To: "Puiu Hrenciuc" <[EMAIL PROTECTED]>; "Heikki Tuuri"
<[EMAIL PROTECTED]>; "Philip Molter" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 03, 2002 2:40 PM
Hi all,
I wonder if anyone could help me speed up the following query (it works fine
and produces the result I want but it's very slow...)
Here is a typical query (will be executed quite often on a reasonably busy
system (about 50% idle doing other stuff that is not using the below
tables..)):
I run the following query from a php script -
select d1.code, d1.type, d1.descr, d1.grouptype, d1.cusref, d1.stock,
d1.minstock, d1.appmeth, d1.supplier, d1.suppref, d1.leadtime, d1.price,
d1.reorder, d1.code1, d1.code2, d1.notes, d1.usr, d1.usr, d1.cusname,
d1.colours, d1.stitchcount, d1.height,
Franz Alt wrote:
> I use some mail-lists for mysql, php and security with Outlook Express.
>
> When I "reply", some lists set their list-adress automatically, some the
> adress of the person originally posting. The second version may not so good
> IMHO, because I think so many replies are not goi
if you have an ms. windows machine for a front end,
i recommend that you download corereader from
http://CoreReader.com/ . ( it's free. ) it does
point&click queries, so you can quickly experiment
with them until you get what you want.
it installs at the novice level, so set it to the
pro
People,
I'm running a postfix server with mysql on a FreeBSD machine. This mail
server holds about 500 virtual domains and 6000 virtual accounts.
Using the command mysql -e "show processlist;"|wc -l I get the current
amount of mysql conns. It floats at about 150-200 simultaneous
connections o
Can the two machines ping each other?
-Original Message-
From: Jeff Bluemel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 9:11 AM
To: [EMAIL PROTECTED]
Subject: MySQL and ODBC prolbme
I have mysql on a linux box (IP 192.168.0.1), and I've got a windows
2000
box that I am
Dean,
Thanks for you reply.
You are almost correct in our system layout but the MySQL database
server is on a seperate machine (currently running Windows 2000 AS with
all the databases on a separate drive and soon to be updated to Linux).
The inserts would need to take place over the network
Franz Alt wrote:
>When I "reply", some lists set their list-adress automatically, some the
>adress of the person originally posting. The second version may not so good
>IMHO, because I think so many replies are not going to the lists.
>mysql++ and mysql do not automatically reply to the list
>m
This is what I thought. Thanks. I think we are almost there!
Chris
-Original Message-
From: gerald_clark [mailto:[EMAIL PROTECTED]]
Sent: Thursday, October 03, 2002 8:51 AM
To: Chris Couture
Cc: [EMAIL PROTECTED]
Subject: Re: Need Driver to connect Unix SCO 5.2 Open Server to MySQL
DB
In the last episode (Oct 03), Franz Alt said:
> I use some mail-lists for mysql, php and security with Outlook
> Express.
>
> When I "reply", some lists set their list-adress automatically, some
> the adress of the person originally posting. The second version may
> not so good IMHO, because I th
Best to check out InstallShield's product forums at
http://community.installshield.com. Their users and support staff troll it
and assist persons in need.
Kelly
SQL,MySQL
At 11:52 AM 10/2/2002 +0800, Alice Tan wrote:
>Hi, i am doing a project and it is almost nearing release version.
>i planne
I have mysql on a linux box (IP 192.168.0.1), and I've got a windows 2000
box that I am trying to connect to with with odbc. I am getting the
following error message
[MySQL AB][MyODBC] ERROR : Can't connect to MySQL server on 192.168.0.1
(10061)
I'm not sure how to go about correcting this prob
I use some mail-lists for mysql, php and security with Outlook Express.
When I "reply", some lists set their list-adress automatically, some the
adress of the person originally posting. The second version may not so good
IMHO, because I think so many replies are not going to the lists.
mysql++ an
Hello,
I found an other table type for transaction :
"The simplicity of ACID transactions is especially important in a
distributed database environment where the transactions are being made
simultaneously. Learn more about the Gemini table type that supports ACID
Transactions."
Find in nusphere
You keep bringing up ODBC like it is some magic charm.
Why do you think you need ODBC?
Does your client software require it?
You have not told us what the client is, or what it is written in.
The 'mysql' client on any platform talks natively to the 'mysqld'
server on any platform.
PHP does not n
Is there a document that compiles examples on different ways of joining
two or more tables? I found a few on
http://www.mysql.com/doc/en/JOIN.html but they do not cover joining more
than two tables.
Thanks for any suggestions.
FYI..I use MyDNS here, and i really like it. has a nice little contribed
PHP interface included in it too.
be aware, it's only an authoritative name server, if you want to do
recursive/cache, you need something like djbdns dnscache along side it.
-Tony
-
System Administra
Keith C. Ivey wrote:
>MySQL AB appears to be in the midst of changing the names for the
>various versions, and the information on the various pages doesn't
>seem to be consistent yet.
>
>
I had replied to the original as well (and it got spam filtered for not
containing "SQL"!), but I'll say
Andrey,
Tuesday, October 01, 2002, 11:53:41 AM, you wrote:
AK> Why is temporary tables replecated?
AK> Is it true?
Yes, temporary table are replicated properly since 3.23.29:
http://www.mysql.com/doc/en/Replication_Features.html
--
For technical support contracts, goto https://order.mysq
Hi,
You have right, in the new version (4.0.4) on Windows 9x are the same
symptom.
I research a little in this morning and i found where is the problem when
the innodb is initialised.
The problems is in the function:
sync_array_create()
...when it must initialise a lot of "cells"(n_cells=aprox. 6.
David Durham wrote:
> Hi,
>
> I have heard of some Linux based DNS services that use MySQL as the
> bases for zone files. Is there anyone who could point me in the right
> direction or has experience in using these tools. The is my
> understanding that queries can be created that allow much ea
Hi,
I have heard of some Linux based DNS services that use MySQL as the bases
for zone files. Is there anyone who could point me in the right direction
or has experience in using these tools. The is my understanding that
queries can be created that allow much easier maintanence of the DNS syst
* [EMAIL PROTECTED]
> Hi, I woud like to ask for help with sql select.
> I have table -> visitor, arrival, departure. (Time is in timestamp
> in sec. from 1970) I need select top of concurrently present
> visitors, between 00.00 and 29.59. So my boss want know when was
> shop most full and how man
Joseph,
Thursday, October 03, 2002, 3:47:21 AM, you wrote:
JS> Just built a fresh RedHat 8.0 Server and tried to install the latest
JS> MySQL from source.
[skip]
JS> Here is the error
JS> /usr/local/mysq/usr/local/mysql/bin/safe_mysqld: line 273: 24640
JS> Segmentation fault $NOHUP_NICEN
Hello Iago,
Tuesday, October 1, 2002, 11:54:44 AM, you wrote:
IS> Any of MySQL AB team could explain the options used in the compilation of
IS> rpm packages for Linux?
IS> Thanks in advance.
You can download the corresponding src.rpm and see.
IS> Iago.
--
For technical support contracts,
Norman,
Wednesday, October 02, 2002, 5:25:36 PM, you wrote:
NWJ> Downloaded Win32 static binary of MySQLGUI 1.7.5-2 , but it would not
NWJ> unzip.
NWJ> Error message "Cannot open file: it does not appear to be a valid
NWJ> archive. If you downloaded this file, try downloading the file again."
Damien,
Thursday, October 03, 2002, 4:25:56 AM, you wrote:
DB> Hi, I have just started out using MySQL and have had no end of trouble
DB> getting it started. I am running Redhat 7.2 and MySQL 3.23. I found that I
DB> had to modify my.cnf to point to the path /var/lib/mysql/mysql instead of
D
to load files into mysql:
create a table:
create table newtable (column1 int(10),column2 varchar(250));
import the data:
load data infile '/path/to/file/file.csv' into table newtable
fields terminated by ',' lines terminated by '\n'
Alia Mikati wrote:
>Hello everybody
>I hope u can help me
Puiu,
- Original Message -
From: "Puiu Hrenciuc" <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>; "Philip Molter"
<[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Thursday, October 03, 2002 1:46 AM
Subject: Re: MySQL/InnoDB-4.0.4 is re
Hi,
You should use LAST_INSERT_ID() function, check the manual for details:
http://www.mysql.com/doc/en/Getting_unique_ID.html
Regards
Joseph Bueno
Poizot Emmanuel wrote:
> Hi,
> I'm writing a c++ program using MySQL++.
> I insert in a table a new line. This table has an autoincrement field ca
Just wanted to drop a patch on if it hasnt been fixed yet.
Cheers
--- mysql-3.23.52/include/global.h-orig Wed Aug 14 00:08:16 2002
+++ mysql-3.23.52/include/global.h Thu Oct 3 09:22:49 2002
@@ -201,8 +201,11 @@
#include
#endif
#ifdef HAVE_ATOMIC_ADD
+#include
#define __SMP__
+#ifnde
Hello
I'm trying to connect a Lotus Server through DECS, to a MySQL db.
The Lotus and the MySQL servers are installed on the same linux machine.
I installed iodbc, myodbc, successfully tested them with odbctest from
Linux, and with ndctest (or smth like that) from a Windows system.
Anyway, I'm
luoya,
Thursday, October 03, 2002, 9:01:22 AM, you wrote:
ll> I just install mysql 3.23.52-max-nt on two computers. One is Win2K and
ll> another is winXP. It seems all right. I use the following commands on
ll> both.
ll> C:\mysql\bin>mysql ¨Chlocalhost ¨Curoot ¨Cp
ll> Mysql prompt:
ll> Welcom
1 - 100 of 104 matches
Mail list logo
