hallo
i want to change the name of a table. what must i do?
--
Gruß & bye
Michael Ott
-
- Siemens AG - I&S IT PS 51 ERL -
- Werner-von-Siemens-Strasse 60 -
- 91050 Erlangen-
- Tel. +49 91 31 7 42 0 54 -
- [EMAIL PROTECTED] -
-
Hi!
Does anybody know how do i change the 'root' password for mysql server?
I installation guide they say that it's done by typing
'/usr/local/bin/mysqladmin -u root -p password new-password', but how
would i know the old passsword?
Am i mising anything?
Thanks for helping!
By the way, i'm fre
Hi,
I have a problem when I shall delete some records (more than one) from a
couple of tables which has relations between each other.
One whay to do this and it's to select all elements I want to delete from
the "primary table" and then delete from the "secondary table" and then
later on delete
DELETE FROM mbtable WHERE timecolumn < DATE_SUB(NOW(), INTERVAL 3 MONTH);
> Hello,
>
> I've a messageboard. Now, I want to delete all messages older than 3
> months. Can I use a MySQL query to delete all messages or do I have to use
> mktime()?
--
Hello,
I've a messageboard. Now, I want to delete all messages older than 3
months. Can I use a MySQL query to delete all messages or do I have to use
mktime()?
Thanks,
Wilko Miletic
-
Before posting, please check:
http://w
Try logging on as root.
- Original Message -
From: "LinuxTech Inc" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 27, 2001 14:16
Subject: Beginners Query
> hi
>
> I am new user to mysql
> I want to create a new database on my machine where mysql is installed at
linux
Probably you run mysql without user: mysql
try: mysql -u -p
or check perms(guest logins, user logins) for creating new databases
and RTFM.
Almost root (superuser) have access to table mysql, where are
permissions stored.
Michal Dvoracek [EMAIL PROTECTED]
-
For best performance i prefer this way (it's faster):
SELECT MAX(price) FROM shop;
rather than
SELECT price FROM shop ORDER BY price DESC LIMIT 1;
--
In second case MySQL must select all records from table, sort it and then apply
LIMIT (it's must be logicaly slower than first one)
Michal D
hi
I am new user to mysql
I want to create a new database on my machine where mysql is installed at linux
platform
I am using CREATE DATABASE
but it is giving me error 1044: Access denied for user: '@localhost' to database
''
How should I create a new user in it and from the new tables as we
Her you go, this one Reads the Database table, Change the DB parts to yours
and have fun.
Here is a good start as well
http://www.devshed.com/Server_Side/PHP/DB_Basics/
";
echo "UserSite
#1Site #2Site
#3";
// with a while loop
// this loop will iterate as many times as there are recor
Yee Chuan Loh <[EMAIL PROTECTED]> writes:
> The document at
> http://www.mysql.com/doc/T/a/Table_size.html
> seems to suggest that the reason why there's a limit to the table size is
> because of the number of bytes used by the file system to store offsets,
> so its more or less file system depe
Could someone post some sample code to get me started on loading records
into an HTML form using PHP and SQL so that I can update or delete a record.
Regards, Steve
-
Before posting, please check:
http://www.mysql.com/man
On Wed, 27 Jun 2001 12:34, Marco Bleeker wrote:
> For the first time developing a PHP-MySQL system, I am experiencing
> strange things. Perhaps it is the off-line mode (Localhost) I am
> running Apache in, or my Wintel 98SE Pentium3. So I create and populate
> 3 small tables in a database with a s
Hi,
You are using an aggregate function (MAX) in a condition which requires
you to use the HAVING statement instead of the WHERE statement.
Your query should look something like:
SELECT price
FROM shop
HAVING price=MAX(price);
Regards,
Jorge
For technical support contracts, visit https://ord
Why bother when the following works:
mysql> SELECT price FROM shop ORDER BY price DESC LIMIT 1;
On Tue, 26 Jun 2001, R Talbot wrote:
> Following the Tutorial
> Creating and populating the table Shop in the db Test..
> Why won't the following syntax work?
>
> mysql> select price
> ->
Following the Tutorial
Creating and populating the table Shop in the db Test..
Why won't the following syntax work?
mysql> select price
-> from shop
-> where price=Max(price) ;
ERROR : Invalid use of group function
Bob T
Thanks! I was able to work on the query today, and manually assemble a query
that did the same thing. And thus, was a lot faster. The main contention
MySQL seems to have is the "nested" joins, such as when Access does this:
FROM (((leg_version_hist RIGHT JOIN (leg_comm_hist RIGHT JOIN
leg_ac
For the first time developing a PHP-MySQL system, I am experiencing strange
things. Perhaps it is the off-line mode (Localhost) I am running Apache in,
or my Wintel 98SE Pentium3. So I create and populate 3 small tables in a
database with a standard little PHP script. Then I start working on my
For the first time developing a PHP-MySQL system, I am experiencing strange
things. Perhaps it is the off-line mode (Localhost) I am running Apache in,
or my Wintel 98SE Pentium3. So I create and populate 3 small tables in a
database with a standard little PHP script. Then I start working on my
The document at
http://www.mysql.com/doc/T/a/Table_size.html
seems to suggest that the reason why there's a limit to the table size is
because of the number of bytes used by the file system to store offsets,
so its more or less file system dependant (pls correct me if i'm wrong).
It also wrote t
At 12:11 27/06/2001 +1000, Jonathan Arthur wrote:
Hi,
Take a look in the err file and if you see an error like
this:
Innobase: error: table dbname/tablename already exists in Innobase data
dictionary
Means maybe you had created before the table in InnoDB and made a
drop database command, which
As a student CGI programmer, I've been working on an online questionnaire.
I have been working so hard to design the mysql db part, still I'm not
sure if I've done it right. Still somethings seem to be awkward.
Here I'm DESCRIBing the tables for you, then i'm explaining how I
inteded to use i
I have a database with a mix of myisam and innodb tables. I want to
create a copy of this database (ie the database name is different but
the table names and structures are the same) on the same server.
When I issue the "create table" command I get the following error:
ERROR 1005: Can't create t
I wrote a perl script that will parse slow_queries logs, and output some
useful information. It's kind of hard to explain, but I'll try. I wanted to
see what queries were taking a lot of time, and how often they were
happening. I wrote a perl script that parses the log files, ignores queries
As it is such a big query, I don't have time to look at it for you but it
may be easier if you convert the RIGHT JOINS to LEFT JOINS for starters.
The manual does recommend LEFT JOINS, mainly for portability.
First part would be something like
(leg_activity LEFT JOIN leg_comm_hist ON (leg_comm_h
Did you convert the table/column names to lower case? If
"lower_case_table_names is=1" MySQL will convert all table names to lower
case on storage and lookup ... but you need to first convert your old table
names to lower case before starting mysqld.
If you have not done so, you should run an ALT
> I have used optimize table on several tables however it has not
> affected the
> speed of the queries or the large amount of processor resources that are
> being used.
>
> Have you heard of a way to rebuild a table more efficiently?
Go back and do this:
myisamchk -o *MYI
myisamchk -a *MYI
myisa
On Tue, 26 Jun 2001 22:29, Sinisa Milivojevic wrote:
> David Robley writes:
> > I came across this discussion from April 2001 on the archives, but
> > nothing more recent. I also have encountered the problem, and thought
> > I could submit a bit more information.
> >
> > OS - Linux 2.4.3
> > X
And what is the command you are using to connect?
- Original Message -
From: "Jason Brunk" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 27, 2001 7:00
Subject: Newbie
hello all,
I am kind of new to all the unix OS stuff. Lately i have been doing
alot of work in
Don't know what a COPY RECORD command is but my best guess is that you are
looking for a create table with a select clause.
- Original Message -
From: "Klein, Tracy ISTA:EX" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, June 27, 2001 0:11
Subject: Copy Record command
> He
Hi to all,
I'm new to linux and mySql (about 5 days and nights :)), I have mandrake8.0
that provide a version of MySql which I'm trying to use from a VisualBasic
application (on win2000), I connect to my database on MySQL using MySqlODBC,
and everyting goes OK, except the table names wich I need t
hello all,
I am kind of new to all the unix OS stuff. Lately i have been doing alot of work
in FreeBSD, and i have started playing with mysql. I got it to install and
everything, the only problem i am having, is i can't seem to connect from anywhere off
the machine, i run the "grant privi
I'm not an expert, but I've never heard of a db getting slower after an
index rebuild. It's possible that's just a red herring.
You've been speaking generally about things being slower, I'd suggest you
get specific. Track down the queries are slow now, use EXPLAIN on them to
see what indexes
On Tue, Jun 26, 2001 at 05:20:25PM -0400, Sherzod Ruzmetov wrote:
>
> Can someone explain me why is it waste of space???
No support for emulating autoincrement fields.
No support for mysql specific types.
No support for mysql specific functions.
No support for ...
In fact no support for almost
-- Original Message --
From: Pete Kuczynski <[EMAIL PROTECTED]>
Date: Tue, 26 Jun 2001 14:02:08 -0500
>My primary key field is a auto incremented index, the field I want to
>make unique, or to say, prevent duplicates in, is the hostname field,
>which has, h
Is their a C++ API library which is able to work on BOTH Windows (2K)
and Linux.
I need the SAME library to work on both platforms. I take it neither of
the top two will work (list below): Borland or MS libraries. What are
the other two.
I need to write a program which is portable to both wind
Ok,
The message set that I noticed this morning sparked my interest in this.
Currently I'm developing a search engine that will utilize mysql's
fulltext match technology. The problem that i've run into is, I can't
seem to find any documentation on how to force an AND search with in
MATCH AGAIN
Can someone explain me why is it waste of space???
Thank you
-sherzodR
On Tue, 26 Jun 2001, Tim Bunce wrote:
> On Tue, Jun 12, 2001 at 04:42:42PM -0700, Jeremy Zawodny wrote:
> > On Tue, Jun 12, 2001 at 05:06:59PM -0500, Zhu George-CZZ010 wrote:
> > >
> > > Is there a way/tool to migrate th
But how about TIMESTAMP?
For example:
CREATE TABLE time_test (creation_date TIMESTAMP, info VARCHAR(100));
This should work fine too,doesn't it?
-sherzodR
On Tue, 26 Jun 2001, Paul DuBois wrote:
> At 2:43 PM -0400 6/26/01, Richard Bates wrote:
> >How do I get a default date time in the cre
On Tue, Jun 12, 2001 at 04:42:42PM -0700, Jeremy Zawodny wrote:
> On Tue, Jun 12, 2001 at 05:06:59PM -0500, Zhu George-CZZ010 wrote:
> >
> > Is there a way/tool to migrate the Application from MySql to Oracle
> > 8i?
>
> Oracle has one available on their web site...
Mostly a waste of space.
Ti
At 2:43 PM -0400 6/26/01, Richard Bates wrote:
>How do I get a default date time in the create table clause...
The MySQL Reference Manual states that DEFAULT values must be constants.
Insert NOW() into the field when you create new records.
>
>I have tried
>
>Create table(
> CreationDate
At 3:05 PM -0300 6/26/01, Augusto Cesar Castoldi wrote:
>It's possible get the number of years between two dates in a mysql
>function?
That kind of depends on what you mean by the number of years between
two dates. For example, do you define the number of years between 2000-12-31
and 2001-01-01
hi.
check out the TIMESTAMP column type...maybe TIMESTAMP(14) as the column
type?
you can then format the date accordingly with...uh...DATE_FORMAT() in your
select statements...
hth.
-ravi
-Original Message-
From: Richard Bates [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, June 26, 2001 3:
I have used optimize table on several tables however it has not affected the
speed of the queries or the large amount of processor resources that are
being used.
Have you heard of a way to rebuild a table more efficiently?
-Original Message-
From: Steven Roussey [mailto:[EMAIL PROTECTED]
Has anyone ever attempted, or succeded in converting a Btrieve database to a
MySQL database?
Peter Marchetti
Media Visions, Inc.
[EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
If you are using Cold Fusion server, yes they will work..
You have to download MyODBC from www.mysql.com install it.. and then set it
up in the ODBC control panel (assuming you are using windows).
Then you should be able to see the mysql databases as a datasource in the
Cold Fusion admin page.
There are many ways to do this - I'm assuming you want to do this on an
Windows box.
One way is through MyODBC. It's an ODBC driver that you can install on your
server, available from the MySQL web site. From there, all you have to do is
create a new DSN, either through the CF Admin or Windows. Y
Install an ODBC for MySql...
- Original Message -
From: "Wade DeWerff" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 26, 2001 2:57 PM
Subject: CF and MySql?
> Can Cold Fusion querys work with MySQL? What would I have to do if
> anything to make it work?
>
> WD
>
>
> --
My primary key field is a auto incremented index, the field I want to
make unique, or to say, prevent duplicates in, is the hostname field,
which has, hostnames of devices. Is the key word UNIQUE then?
Not all of the devices have hostnames assigned to them, like terminals,
so the hostname field
(sql, to fool lame filter)
ryc <[EMAIL PROTECTED]> writes:
> The OS may not have a 2GB limit, however the table MAY. If you do a
> myisamchk on the table it will tell you if you are running out of space in
> the table. If you are.. you need do something like "alter table tablename
> max_rows=100
Can Cold Fusion querys work with MySQL? What would I have to do if
anything to make it work?
WD
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list ar
I ran run-all-test with the following options.
---
run-all-tests --server=mysql --user=test --password=test --log
-
I got the following :
Can't locate DBI.pm i
hallo!
i have a backup-problem:
when i use
mysqldump -u michael -p --opt --all-databases > backup
i get the following error:
USE backup;
mysqldump: Got error: 1017: Can't find file: 'title.MYD' (errno: 2) when
using LOCK TABLES
but when i use
mysqldump -u michael -p --opt --database books >
Hi,
i found a method to do this:
try
extract(year from date1) - extract(year from date2)
I hope it will work
Michael
-Ursprüngliche Nachricht-
Von: Augusto Cesar Castoldi [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 26. Juni 2001 19:06
An: [EMAIL PROTECTED]
Betreff: Getting
How do I get a default date time in the create table clause...
I have tried
Create table(
CreationDateDATETIMEDEFAULT NOW(),
Infovarchar(100)
);
Create table(
CreationDateDATETIMEDEFAULT "NOW()",
Infovarchar(100)
);
Create table(
Creat
Hi... I downloaded the mysql binary for HPUX10.20 and when I run
script/mysql_install_db I got the followin message:
---
$> scripts/mysql_install_db
Preparing db table
Preparing host table
Preparing user table
Preparing func table
Preparing tables_priv table
Preparing columns_priv table
How do I get a default date time in the create table clause...
I have tried
Create table(
CreationDateDATETIMEDEFAULT NOW(),
Infovarchar(100)
);
Create table(
CreationDateDATETIMEDEFAULT "NOW()",
Infovarchar(100)
);
Create table(
Creat
Hello,
I was wondering, how can I lookup how much memory MySQL is currently allowed
to use, and how can I change this value?
Thanks in advance,
Leon Mergen
[EMAIL PROTECTED]
BlazeBox, Inc.
ICQ: 55677353
-
Before posting, plea
Yes, I've read the docs on JOIN syntax, and search the list archives for
similar information.
I have this query:
SELECT leg_activity.activity_date, leg_transitions.trans_desc,
leg_text.leg_version, body_list.body_name
FROM (((leg_version_hist RIGHT JOIN (leg_comm_hist RIGHT JOIN leg_activity
It's possible get the number of years between two dates in a mysql
function?
thanks,
Augusto
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list arc
-- Original Message --
From: Pete Kuczynski <[EMAIL PROTECTED]>
Date: Tue, 26 Jun 2001 13:19:02 -0500
>I want to prevent duplicate entries into my mysql database which holds
>invertory of all network eqpt at my site. Engineers access it thru
>netscape and t
The OS may not have a 2GB limit, however the table MAY. If you do a
myisamchk on the table it will tell you if you are running out of space in
the table. If you are.. you need do something like "alter table tablename
max_rows=1000".. (its in the manual)
ryan
> > I have a Linux machine (Linux
I searched the archives but couldn't find an answer...
Am I the only who has noticed that MySQL fails to
install properly on Solaris platforms? (at least Solaris 7).
Specifically the files under...
$(srcdir)/Data/ATIS/*.*
$(srcdir)/Data/Wisconsin/*.*
$(srcdir)/Results/*-*
$(srcdir)/Results-win3
I appreciate that this might be a bit off topic but any help would be
appreciated.
I need to port this program (attached) to the Linux environment. This
is the first program I have attempted to port.
Has anyone ever had to port from Windows to Linux\Unix, and if so how
did it go and what tools
I want to prevent duplicate entries into my mysql database which holds
invertory of all network eqpt at my site. Engineers access it thru
netscape and the query insert is done via pdp [below].
I will place the script into php, any pointers on this would be
appreciated.
THX!
Pete
At 1:49 PM +0200 6/26/01, Gunnar von Boehn wrote:
>Hello everybody,
>
>
>I thing, that I have a problem that needs a sequence and that
>auto-increment can't do the job this time.
>
>I already consulted the manual and the mailarchive.
>I saw several different proposals, now I'm a bit confused and d
> Recently the index files became corrupted and I ran the
> myisamchk *.MYI -r -S to repair them.
Try an OPTIMIZE TABLE or ANALYZE TABLE. Your queries may be using the
incorrect indexes since the statistics have not been updated.
You can also do this: myisamchk *.MYI -a
Sincerely,
Steven Rouss
NUMBER(8,5). You'll need around 5 digits after the decimal point. (Think GPS
accuracy == 10 meters for high-grade, 100 m for dumbed-down civilian use. At
the equator, that's 0.9 or 0.0009 degrees respectively. At higher
latitudes, that'd be correspondingly less.)
If you value accuracy, DON'T
On Tuesday 26 June 2001 04:49, Gunnar von Boehn wrote:
> Hello everybody,
>
>
> I thing, that I have a problem that needs a sequence and that
> auto-increment can't do the job this time.
>
> So, I think the only way to solve this is a sequence table.
>
> Lets take a single row, integer value for h
I had the same problem last night,
eventually grant all to root on *.* identified by 'yourpass' got me in
I must have mucked up the permissions at
(the problem was with mysqlgui not mysqlshow though)
Sean
-Original Message-
From: Peter Matulis [mailto:[EMAIL PROTECTED]]
Sent: Tuesday,
Hi, I don't know if you can use 2.7+ in a 2.6.
However I downloaded and compiled the source without no problems. Until now it's
running ok.
Please, tell me if I can help!
{}S
Jose Vilmar Estacio de Souza
MailTO: [EMAIL PROTECTED]
+ 55 21 7894-3041
INFORMAL INFORMATICA
http://www.informal.
Hi Tom,
The solution to your problem could be simple if the redundancy is across all
fields. Then you could simply issue a
CREATE table distinct_records
SELECT distinct field_1,.field_last
FROM table_duplicate_records
WHERE 1=1;
Or
CREATE table distinct_records
SELECT field_1,.field_la
Hi Gunnar,
Why don't you keep the key out of the business rule and create a column to
identify the type of customer?
How are you going to handle the application when your business reaches more
than vip customers???
This is an issue that can be avoided by creating a type column .
Siomara
You must have an rpm installation of mysql and your source installation.
Check to see if there are mysql* commands within /usr/bin directory. It's
going to search there first, then /usr/local/bin. The commands within
/usr/bin are going to look for the mysql-everthing within /var/lib/
Jonathan
---
Could it be that you have two mysql client binaries accessing two different
config files - some remainders of a previous MySQL installation?
Hannes
On 6/26/01 9:02 AM, "Peter Matulis" <[EMAIL PROTECTED]> wrote:
> Just installed 3.23.37 on Red Hat 7.0 from source. I've done this a few
> times
I have a MySQL myISAM database that has about 300 MB of information.
Recently the index files became corrupted and I ran the myisamchk
*.MYI -r -S to repair them.
Ever since then mySQLd process has been using up a ton of processor time.
And some of the queries that I run have started taking a lon
Hello, I cannot find a COPY RECORD command in www.mysql.com - is it to be
found under another name? I have a 49 field record I have to create this
morning. Ugh.
-
Before posting, please check:
http://www.mysql.com/manual.php
> The above only implies that your program exited without calling
> mysql_close(). Nothing to do with your problem.
>
But.. why would the console be reporting this? Ie, I'm getting the same
result (same error in the error log, same truncation) when I manually
pipe the query to the mysql console.
Just installed 3.23.37 on Red Hat 7.0 from source. I've done this a few
times but this time I encountered a mysterious problem.
a) server is started and runs under my designated user (mysqladm:mysqlgrp)
b) /usr/local/mysql/bin is in PATH of both root and mysqladm
c) using either of these users,
Slight correction in the query...
> The query just looks like:
>
> REPLACE into reflectivity.measurement_extended_data set content_typeID =
> 7, contentID = 121529, arrayID = 0, positionID = 1, testID = 1,
> iteration = 0, test_locationID = 1, date_added = 993165848, added_by = 18,
> data =
Try
SELECT robotId, max(startTime) as crit
FROM RobotRun
WHERE startTime >= '2001-06-26 00:00:00'
AND endTime IS NOT NULL
GROUP BY robotId
This should return the robotId and the most recent startTime labeled 'crit'
for all records specified in the where clause. And have a look in the manual
for
A simple question...
I noticed that the newer MySQL binaries are listed as being for Solaris 2.7+
(mysql-3.23.39-sun-solaris2.7-sparc.tar.gz)
I want to run it on Solaris 2.6, will this run OK??
There didn't seem to be any docs relating to this (would be nice to see
these kind of comments in the
Try PhPMyadmin
http://phpwizard.net/projects/phpMyAdmin/index.html
Simon
-Original Message-
From: Mike Schwartz [mailto:[EMAIL PROTECTED]]
Sent: 26 June 2001 16:33
To: [EMAIL PROTECTED]
Subject: Simple Graphical Interface
I am administering a MySQL database that needs to be access
I am administering a MySQL database that needs to be accessed by people who
don't know SQL. They need to be able to add and delete records, but they
don't need to be able to alter the structure of the database. Does anyone
know of a simple Windows app or web interface that I can throw on my
How do I define cursors in mysql as in Oracle?
Here is an example in Oracle:::
Cursor CurPerson is
Select Arstall_Godkj_Stkomp
From Person
Where Fodselsdato = inFDato And
Personnr = inPNr;;
Begin
Open curPerson;
Fetch CurPerson i
Please send relevant pieces of code!
> Hello,
>
> I am developing a data application using wxWindows 2.2.7 on Redhat
> Linux 7 with MySQL at back-end. When I try to connect to MySql
> Database sometimes it says Segment fault (Core dumped) error.
>
> Pls help.
>
> Sudheer.
---
Sudheer Palapparambil <[EMAIL PROTECTED]> writes:
> I am developing a data application using wxWindows 2.2.7 on Redhat
> Linux 7 with MySQL at back-end. When I try to connect to MySql
> Database sometimes it says Segment fault (Core dumped) error.
Which version of mysql?
--
Trond Eivind Gl
Hello,
I am developing a data application using wxWindows 2.2.7 on Redhat
Linux 7 with MySQL at back-end. When I try to connect to MySql
Database sometimes it says Segment fault (Core dumped) error.
Pls help.
Sudheer.
-
B
Hello,
I am developing a data application using wxWindows 2.2.7 on Redhat
Linux 7 with MySQL at back-end. When I try to connect to MySql
Database sometimes it says Segment fault (Core dumped) error.
Pls help.
Sudheer.
-
B
lipp & maimone wrote:
> is someone abble to tell me how can i do for running an sql database with windows98
>without crashing my systeme?
> Also, using asp ( activex server page ), is it possible with mysql version3,23?
>
>
Its most likely that you don't have enough memory on your system. If
Running Unix, Apache, MySQL and PHP, should I worry about delay times, and
will the server always present the user with the latest database update
(after a possible delay)?
Suppose a user can add a new row to a database in a PHP page with a form,
and after submit, the next page he will see is
Guðmundur Ólafsson <[EMAIL PROTECTED]> writes:
> Hi,
>
> I have a Linux machine (Linux cartman 2.4.2-2smp #1 SMP Sun Apr 8
> 20:21:34 EDT 2001 i686 unknown) that is running MySQL 3.23.38-log and
> now I have a table that is getting VERY near to the ext2 filesystem
> limitation of 2gb.
Ext2 does
Ok
Each Status ID is a thread and you can kill them with KILL "thredidnumber".
Delayed insert is just a sql insert command that has low priority.
Sleep is a thread that is kept open incase you would like to use it agene.
Question: How many thread do you allow on your set-up?
You have hit 102 thr
Hi,
what does mean following ...
mysql> show processlist;
++--+---+--++---+-+--+
| Id | User | Host | db | Command| Time |
State | Info |
++--+---+--
According to the MySQL documentation, it doesn't currently support full
outer joins and won't do in the immediate future. Does anyone have any
suggestions for a workaround?
I need to join three tables, only one of which has a common identifier with
the others, and produce a result which shows
At 13:49 +0200 2001-06-26, Gunnar von Boehn wrote:
>Lets take a single row, integer value for holding the sequence:
>CREATE TABLE sequence(
> id int4;
>);
That works, though I would use a single table for all sequences, not
a new table per sequence.
The other solution would be to do check the
On Mon, Jun 25, 2001 at 06:52:34PM +, patrick ward wrote:
> Hello Mr. Ziegler,
>
> I'm sorry if I'm intruding and promise not to do so again without your
> consent but our db replication has come to a grinding halt with the error
> 'bad magic number, fire your magician'. I'm at my wits en
[EMAIL PROTECTED] writes:
> Any idea when we'll be able to get our grubby little paws on VCC?
> I was trying out mysqlgui last night, and i found it did'nt add much
> to using the command line client, So i'd be interested to see where you
> are going with it.
>
> Thanks
>
> Sean
Regarding mysq
Peter Volke writes:
> hi everybody,
> i have a problem with installation of mysql ++ api 1.7.9.
> os: sun solaris 5.6
> mysql version 3.23.33
>
> after unpacking the archive with tar, autorun and autoconf i started configure.
> everything was working fine ,
> but "make " gave me the following me
David Robley writes:
>
>
> I came across this discussion from April 2001 on the archives, but
> nothing more recent. I also have encountered the problem, and thought I
> could submit a bit more information.
>
> OS - Linux 2.4.3
> XFree - 4.0.2
> KDE- 2.1.1
>
> The problem is not exa
1 - 100 of 128 matches
Mail list logo
