hi guyz
i have downloaded phpmyadmin
& i have configured it by the book
but i dont know how to use it for mysql database
:$
will someone pleez tell me how to
thnx a million
toby .
_
MSN Photos is the easiest way to
SEND-PR: -*- send-pr -*-
SEND-PR: Lines starting with `SEND-PR' will be removed automatically, as
SEND-PR: will all comments (text enclosed in `<' and `>').
SEND-PR:
From: root
To: [EMAIL PROTECTED]
Subject: [compiler error]
>Description:
< make all-recursive
make[1]: Entering
Hi,
I'm sort of glad we're not the only one having this problem.
Yesterday we had kind of the same error message on an Solaris 8 machine with
512Mb of ram.
Our buffer_pool_size was set to 250Mb, because the other 250Mb is used by
the orion-web-server.
Today I will perform crash-tests on another
I think u just have to create exactly the same table in another database,
and then copy
the .frm file to the one where you lost the original one.
CB
-Original Message-
From: Jonathan Stockley [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, June 26, 2002 00:20
To: [EMAIL PROTECTED]
Subject: H
ORDER BY whatever DESC LIMIT 100
Mark S Lowe wrote:
>Is there a nifty way to select just that last 100 records with MySQL? In
>Oracle I use Maxrows and date to accomplish this. Can¹t seem to figure this
>out with MySQL.
>
>Please advise! Thank you!
>
>Mark
>
-
In the last episode (Jun 25), Mark S Lowe said:
> Is there a nifty way to select just that last 100 records with MySQL? In
> Oracle I use Maxrows and date to accomplish this. Can?t seem to figure this
> out with MySQL.
You mean "select the 100 most-recently-inserted records" ?
SELECT * FROM tab
SELECT * from table ORDER BY column DESC, LIMIT 100
This will get the last 100 in descending order. If you have a date field
you can use a WHERE clause with ORDER BY date field with the LIMIT parameter
to achieve an ascending order.
I hope this helps.
Pat...
- Original Message -
From:
Use Limit is one way
On 6/25/02 12:19 PM, "Mark S Lowe" <[EMAIL PROTECTED]> wrote:
> Is there a nifty way to select just that last 100 records with MySQL? In
> Oracle I use Maxrows and date to accomplish this. Can¹t seem to figure this
> out with MySQL.
>
> Please advise! Thank you!
>
> M
Mark S Lowe wrote:
>
> Is there a nifty way to select just that last 100 records with MySQL? In
> Oracle I use Maxrows and date to accomplish this. Can¹t seem to figure this
> out with MySQL.
>
> Please advise! Thank you!
>
> Mark
SELECT * FROM SOME_TABLE
ORDER BY SOME_KEY
LIMIT 0,100
Van
--
is there a place to download a copy of the manual that uses the same format
as on MySQL's website(http://www.mysql.com/doc/T/a/Table_size.html)? vs the
one that comes out of the manual-split.tar.gz, which is just split into 8
large html files
--
mysql, sql, query
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
i have an application that will allow me to rotate mysql table using
date variable substition. in other words
table=tblname.%m%d%Y
if i am using a remote system to host the application, what
permissions to i need to give the remote application use
>Description:
No suffix list.
../../extra/comp_err czech/errmsg.sys
Usage: ../../extra/comp_err [-?] [-I] [-V] fromfile[s] tofile
*** Error exit code 255
>How-To-Repeat:
CFLAGS="-D_REENTRANT " CXX=aCC \
CXXFLAGS="-D_REENTRANT" CPPFLAGS="-D_REENTRANT" \
./configure --with-pthread --wi
At a certain time, now past, Emma Grant spake thusly:
> Hi All,
>
>First of all I want to thank you all for all the help that you have given me
>throughout the last week.
>
8<--snip
> I need to be able to insert images into the database through a FILE FIELD on a
At 11:08 -0400 6/25/02, walt wrote:
>Does anyone know if version 4.0 will support formatted date queries.
>
>Example:
>select create_date from what_ever where create_date >
>date_format('03/01/2002','%m/%d/%Y')
Why not just write the date correctly? That is, what does
this gain you?
>
>
>sql, q
Hi,
My machine (linux if it matters) is named "naif". In my
/usr/local/mysql/var directory, in addition to what I expect to see,
there are a number of files named naif-bin.001, naif-bin.002, ...,
naif-bin.009. Some of these files are quite large, nearly 100
megabytes. What are they? There
You can easily upload images using just your web browser - an FTP
program is not needed.
You'll need a form with it's encoding set to multipart/form-data, e.g.
...
...
...
and then within your receiving script you'll need something similar to:
$image_filename = $HTTP_POST_
Hiho hiho!
Paul DuBois wrote:
> At 15:14 +0200 6/25/02, Julien OIX wrote:
>
>> hi everyone,
>>
>> I have the line "no-auto-rehash" in my /etc/my.cnf ( [mysql] section of
>> the global config file)
>> and I'd like to use completion with the command-line tool ...
>>
>> I think I can overwrite this
At 16:31 +0200 6/25/02, Gary Colman wrote:
>Hi
>
>Every few seconds, my mysql server generates a new binary log file
>with an incremented id number "${hostname}-bin.x"
>According to the logs, this should happen only when a reload or flush
>type command is issued ...
>
>mysql variables:
>flush
At 10:40 -0400 6/25/02, Peter M. Perchansky wrote:
>Greetings:
>
>Thanks to Jay from this list and doing some reading, I resolved the
>insert issue when trying to insert records using a select where the
>tables are the same.
>
>Now I'm trying to clean up the old records, and no matter what
>del
Is there a nifty way to select just that last 100 records with MySQL? In
Oracle I use Maxrows and date to accomplish this. Can¹t seem to figure this
out with MySQL.
Please advise! Thank you!
Mark
Synopsis: When installing on Win 98, using the InstallShield installer
provided,
the installation of MySQL hangs and the GUI freezes. This turned out to be
an interaction
with another program (RealPlayer and AOL). Removing RealPlayer let
us proceed with the install.
I'm sending this to the lis
Pradeep.C.Pangi,
Tuesday, June 25, 2002, 5:02:38 PM, you wrote:
PCP> I am getting a following error message when I do the GRANT SELECT,
PCP> INSERT, DELETE, UPDATE ON .* TO
PCP> ERROR 1044: Access denied for user: '@localhost' to database
PCP>
PCP> Please Help me regarding this.
To set u
Careri,
Saturday, June 22, 2002, 12:37:29 PM, you wrote:
>> >> i have a problem with an index of a BerkeleyDB table because this is corrupted
>> >> and crashes Mysql (v. 3.23.49).
>> >>
>> >> The size of table file is correct 8Mb for 15.000 records but from a select
>> >> I view only the first
On Tue, 2002-06-25 at 10:54, Roger Baklund wrote:
> Like Heikki said: your problem is probably that you don't have indexes on
> the foreign keys.
Setting an INDEX on each of those columns does fix the problem. It then
does allow me to remove the NOT NULL from the tracks table as I
originally ha
>Description:
Making all in sql
Making all in share
No suffix list.
../../extra/comp_err czech/errmsg.sys
Usage: ../../extra/comp_err [-?] [-I] [-V] fromfile[s] tofile
*** Error exit code 255
>How-To-Repeat:
CFLAGS="-D_REENTRANT " CXX=aCC \
CXXFLAGS="-D_REENTRANT" CPPFLAGS="-D_REENTRA
Does anyone know if version 4.0 will support formatted date queries.
Example:
select create_date from what_ever where create_date >
date_format('03/01/2002','%m/%d/%Y')
sql, query
--
Walter Anthony
System Administrator
National Electronic Attachment
Atlanta, Georgia
1-800-782-5150 ext. 1608
Hi,
It's obvious that MySQL development team use BitKeeper like Source Code
Manager.
Are more details at :
http://www.mysql.com/doc/I/n/Installing_source_tree.html
Regards,
Gelu
_
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTE
* Andy Dustman
> On Mon, 2002-06-24 at 17:50, Roger Baklund wrote:
> > * [EMAIL PROTECTED]
> > [...]
> > > The referred to keys are the same type and are indexed (they are
> > [...]
> > > CREATE TABLE genres (
> > > genre_idSMALLINT NOT NULL PRIMARY KEY,
> > [...]
> > > genre_id
At 15:14 +0200 6/25/02, Julien OIX wrote:
>hi everyone,
>
>I have the line "no-auto-rehash" in my /etc/my.cnf ( [mysql] section of
>the global config file)
>and I'd like to use completion with the command-line tool ...
>
>I think I can overwrite this parameter within a .my.cnf.
>what do I have to
Greetings:
Thanks to Jay from this list and doing some reading, I resolved the insert
issue when trying to insert records using a select where the tables are the
same.
Now I'm trying to clean up the old records, and no matter what delete
statement I try, it fails:
DELETE FROM Customer_Equip
Hi
Every few seconds, my mysql server generates a new binary log file
with an incremented id number "${hostname}-bin.x"
According to the logs, this should happen only when a reload or flush
type command is issued ...
mysql variables:
flush off
log_bin on
max_binlog_size 107
Hi all
I have installed mysql 3.23.25 on solaris 7. It was
installed in /usr/local/mysql. When I run the
safe_mysqld scritp, the mysql daemon starts withouut
any error and the ps command shows that mysql is
running. However from localhost when I try to connect
to server through /usr/local/mysql/bi
Hi,
I download a Mysql++ patch for MySQL 1.7 version to allows compiling with 3.*
GNU compiler series.
The problem is that I don't know how to install the patch file.
Can anyone help me ?
Thanks
--
Emmanuel POIZOT
CNAM/INTECHMER
B.P. 324
50103 Cherbourg Cede
Hi All,
I am getting a following error message when I do the GRANT SELECT,
INSERT, DELETE, UPDATE ON .* TO
ERROR 1044: Access denied for user: '@localhost' to database
Please Help me regarding this.
Thanks in advance
Pradeepp
- Original Message -
From: <[EMAIL PROTECTED]>
To: Pr
Hi,
I have setup successfully a mysql master / slave
configuration however I would like to setup a system
whereby updates could be performed on either system
and then propagated to the other server (a
master/master configuration) -- is this possible with
mysql 4, or has anyone built any hacks t
On Tue, 2002-06-25 at 01:08, [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,
On 24 Jun 2002, at 18:36, Emma Grant wrote:
> I know that many of you are about to tell me to store the images on my
> server, and reference the location from my database field. As I have
> read many times throughout my research. But I want the ability for the
> user to choose the images they wan
hi everyone,
I have the line "no-auto-rehash" in my /etc/my.cnf ( [mysql] section of
the global config file)
and I'd like to use completion with the command-line tool ...
I think I can overwrite this parameter within a .my.cnf.
what do I have to write in the ~user/.my.cnf to use completion ?
I
Hi
I'd like to download
mysql-3.23.51-sun-solaris2.8-sparc.tar.gz
from mysql.com, but the server doesn't allow me
to get the file.
What's wrong with it?
Thanks in advance!
Regards;
Istvan
-
Before posting, p
how to remove a foreign key constraint without recreating the innodb table ?
thanks,
Pierre
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t
I am using the mysql++ , along with another library (matlib)
I am getting quite many errors of the type:
/usr/include/g++-2/stl_function.h:55: previous non-function declaration `template
struct minus'
/usr/local/src/matcom/matlib.h:2385: conflicts with function declaration `class Mm
minus(con
I want to use the LOAD DATA FROM MASTER feature from 4.0, but I cannot use
4.0.1 because of the bugs in FULLTEXT. I believed that these bugs are now
fixed but 4.0.2 seems to be an awfully long time coming, so I thought I
would try to build a later version from the CVS sources. Can anybody give
me
harish,
Thursday, June 20, 2002, 9:52:37 AM, you wrote:
hv> I am using mysql-4.0.1-alpha on windows 2000 professional
hv> How to exceute nested query in MySql
hv> select aeVcharEventId from alarmescalation where aeDtimeTimeStamp = (select
hv> max(aeDtimeTimeStamp) from alarmescalation)
hv> Thi
Thomas,
Monday, June 24, 2002, 7:05:21 PM, you wrote:
TS> I came across this problem:
TS> where the manual describes Fulltext Fine-tuning it says:
TS>* Minimal length of word to be indexed is defined by MySQL variable
TS> `ft_min_word_length'. *Note SHOW VARIABLES::. Change it to the
testacct,
Monday, June 24, 2002, 3:37:37 PM, you wrote:
t> I am comparing songnames from two tables to find a match.
t> My query looks like this:
t> $querymvideo = "select movietable.id, movietable.songname
t> from movietable where TRIM(movietable.songname) LIKE
t> '__$foo' ";
t> The above quer
>Description:
- I have "bk pulled" the last version of 4.0.2 as of 6/6. After each "new" mysql build
I have done an 'alter table document set type=myisam' to rebuild the indexes.
- Use of phrases in boolean mode doesn't seem to work properly. It seem that it in
addition to match the correct phra
I am getting a table is full error but a show table status on the table specified in
the error, which I assume is a temporary table, comes back as the empty set.
I did the same for the two tables being merged and they are way under the limit as far
as pointer size and table size (both having av
* [EMAIL PROTECTED]
> I'm new in MySQL.anyone out there can help please?
> I'm actually experimenting with the mysqlimport utility to import
> data from
> a text file.however i'm always getting this error upon the command
>
> c:\mysql\bin>mysqlimport - - local - -fields-termi
you don't need space between dashes
"--local" instead of "- -local"
Borus
> Hie
> I'm new in MySQL.anyone out there can help please?
> I'm actually experimenting with the mysqlimport utility to import data
from
> a text file.however i'm always getting this error upon the c
Hello,
I've tried to install mysql 4.0.1 Alpha.
The configuration did not give me any error's
The "make" also worked just fine.
But when I run "make test" I get the following error:
ERROR: /down/new/mysql-4.0.1-alpha/mysql-test/var/run/master.pid was not
created in 30 seconds; Aborting
make: **
Hiho hiho!
BORUSKUNG wrote:
>Hi all,
>
>I have a SQL question.
>If I want to delete all the duplicated record in a table,
>how can I do that in MySQL?
>I am using MySQL 3.23.49 on AIX 4.3.3
>
>there is a key field in the table
>
>what I want to do is check all the duplicated record by
>select or
Hie
I'm new in MySQL.anyone out there can help please?
I'm actually experimenting with the mysqlimport utility to import data from
a text file.however i'm always getting this error upon the command
c:\mysql\bin>mysqlimport - - local - -fields-terminated-by="," test
newtest.t
On Mon, 24 Jun 2002, Phil Schwarzmann wrote:
> I want to copy the structure of a table to a brand new table, but I
> don't want to use phpmyadmin or some other program. I'm looking for the
> command line code.
>
> Anyone have a link to where I can find it? Or, anyone wanna send me
> the code?
Hi all,
I have a SQL question.
If I want to delete all the duplicated record in a table,
how can I do that in MySQL?
I am using MySQL 3.23.49 on AIX 4.3.3
there is a key field in the table
what I want to do is check all the duplicated record by
select order_no, count(*)
from order
group by orde
[EMAIL PROTECTED] schrieb
am 24.06.02 16:38:01:
> Hi! This is the ezmlm program. I'm managing the
> [EMAIL PROTECTED] mailing list.
>
> To confirm that you would like
>
>[EMAIL PROTECTED]
>
> added to the mysql mailing list, please send
> an empty reply to this address:
>
>[EMAIL PROT
Hi,
I'm a newbie in MySQL and it's developement
I tried to run examples of MySQL++ API and compile with g++ 2.96.
It seems that this version of compiler is not supported.
I found a patch of MySQL++ to make it working with g++ 3.0, but I don't know
how to apply this patch. I tried patch -pl < patc
Hi!
NOT NULL does not prevent the creation of a foreign key constraint. I think
the problem was that Andy did not create an index explicitly on the foreign
key (he created only on the referenced key).
Regards,
Heikki
Innobase Oy
- Original Message -
From: ""Roger Baklund"" <[EMAIL PROT
On Tue, 25 Jun 2002 15:49:41 +1000
"Danny" <[EMAIL PROTECTED]> wrote:
> Besides using Phpmyadmin to edit the data. I actually prefer to use
> something like webmin to manage my data.
>
> Do a search on Webmin on the internet.
actually, i also created my own tools ... saintSQLadmin
http://saint
58 matches
Mail list logo
