se.Such that suppose the field name is ID and I want to retrieve
> data
> from another field LAT such that at a time LAT values for ID's 1,2,3 are
> taken then for 3,4,5 then for 4,5,6 so on till table ends.
> --
> View this message in context:
> http://www.nabble.com/need-help
ntext:
http://www.nabble.com/need-help-urgent-tf3491135.html#a9749875
Sent from the MySQL - General mailing list archive at Nabble.com.
this message in context:
http://www.nabble.com/need-help-urgent-tf3491135.html#a9749875
Sent from the MySQL - General mailing list archive at Nabble.com.
The error message says to go to
http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html to learn
how to set the different recovery options for innodb.
On 9/21/06, Sayed Hadi Rastgou Haghi <[EMAIL PROTECTED]> wrote:
Dear all,
our DB server crashed and when I try to start Mysql
/etc/init.d/my
Dear all,
our DB server crashed and when I try to start Mysql
/etc/init.d/mysql/start
I get these lins in my error log
060921 13:00:14 mysqld started
060921 13:00:14 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ib
I wrote this below Query but it shows error how to write
UPDATE table_1
SET col_3 = 'bbb'
WHERE col_1 = (SELECT max(col_1) FROM table_1)
See the docs for Update at
http://dev.mysql.com/doc/refman/5.0/en/update.html. You cannot refer to
the update table in a subquery.
PB
-
Veerabhad
On Monday 20 February 2006 03:27, Veerabhadrarao Narra wrote:
> Hi
>
> i ahve one table table_1 and columns like col_1,col_2,col_3
>
> col_1 col_2 col_3
> 1 aa aaa
> 2 bb
>
> Now i want to update my table table_1 SET col_3 as bbb where max of col_1
>
> I wrote thi
Hi
i ahve one table table_1 and columns like col_1,col_2,col_3
col_1 col_2 col_3
1 aa aaa
2 bb
Now i want to update my table table_1 SET col_3 as bbb where max of col_1
I wrote this below Query but it shows error how to write
UPDATE table_1
SET col_3 = 'bbb'
One thing Jim didn't mention is that mysqldump is not a mysql client
command but a standalone executable. Run it from a shell prompt (DOS
prompt if you are using windows)
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Jim Grill" <[EMAIL PROTECTED]> wrote on 09/09/2004 11:
>
> --
> help please
>
> please tell me how to extract a script file of a database from mysql
commandprompt.
>
> s.deepak
>
>
> This life is a hard fact; work your way through it boldly, though it may
be adamantine; no matter, the soul is stronger
>
> Swami Vivekananda
>
Are you looking for mysql
--
help please
please tell me how to extract a script file of a database from mysql commandprompt.
s.deepak
This life is a hard fact; work your way through it boldly, though it may be
adamantine; no matter, the soul is stronger
Swami Vivekananda
--
MySQL General Mailing List
For list archives: ht
hi,
I have created the COBOL coding to test those C API from
MySQL. Upon executing this COBOL program too hangup the server
but here using mysql_error() I got the error message in a
variable as
*Can't open shared memory. Request event don't create (2)*
These Error I captured after running the
hi,
I wish to provide some more information too regarding MySQL
Server hangup.
Once after I execute the C sample program, WinMySQLAdmin tool
and query commands from *mysql>* console never responds.
During this time if I try to start mysqld from another console
produce the following error mes
Hi,
I have written in intermediate, on the appropriate position in this
discussion, please go thru in full.
--- Michael Widenius <[EMAIL PROTECTED]> wrote: >
> hi!
>
> > "A" == Arunachalam <[EMAIL PROTECTED]> writes:
> A> As per my searching I have found the right C API in libmysql.lib
hi!
> "A" == Arunachalam <[EMAIL PROTECTED]> writes:
A> Hai MySQLians!!!
A> I have established the Successful Connection to MySQL from COBOL.
A> Now from COBOL I can able to query the MySQL and get back the
A> result sets using C APIs under MySQL 4.0.17-max both in windows
A> and Linux. No
Hai MySQLians!!!
I have established the Successful Connection to MySQL from COBOL.
Now from COBOL I can able to query the MySQL and get back the
result sets using C APIs under MySQL 4.0.17-max both in windows
and Linux. Note that my Client is in Windows platform...
Its not enough for my applicat
Hi,
I would like to enquire abt Result datatype in MySql++.
After getting songList,
Result songList=dac.getSong();
1. Is it possible for me to get a specific record out?
2. Is it possible for me to get a random record out?
Regards,
Petty_folly
_
On Tue, 13 Aug 2002, John Wards wrote:
> Hi folks i am in a bit of a panic.
>
> My server began playing up today and after ruling out apache and php it has
> come down to mysql.
>
> I need to find out what queries the database is running that is making it so
> slow. I can't figure out the comma
Hi folks i am in a bit of a panic.
My server began playing up today and after ruling out apache and php it has
come down to mysql.
I need to find out what queries the database is running that is making it so
slow. I can't figure out the command to use and what format it shoudl be in
Thanks for
mysqld --skip-grant-tables
-Original Message-
From: Jesse Angell [mailto:[EMAIL PROTECTED]]
Sent: Saturday, June 22, 2002 3:38 AM
To: [EMAIL PROTECTED]
Subject: mysql help !! urgent
Hello,
In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do
anything as phpmyadmin
Hello,
In phpmyadmin I accidentaly gave root no privlegaes.. Now I cannot do
anything as phpmyadmin wont work because root can't do anything at all... I
have complete ssh access etc to the server, Please help me out what do i do
to give root full privs again?!? please help me make mysql work a
Eugene wrote:
>
> Hello...
>
> I got a big problem in MYODBC. I am using myodbc-2.50.31-win95. When I use any MySQL
>Administrator to query the database that I had created for example:- SELECT * FROM
>dbname, they come out error like:=
>
> Your command could not be completed. MySQL returned t
Hello...
I got a big problem in MYODBC. I am using myodbc-2.50.31-win95. When I use any MySQL
Administrator to query the database that I had created for example:- SELECT * FROM
dbname, they come out error like:=
Your command could not be completed. MySQL returned the following error:
Got erro
t;
>delete * from TABLE where TIMESTAMP='date, interval 3 day'
>
>I'm new to this as well but I think this might be closer
>
>let me know the answer
>
>-C
>- Original Message -
>From: "hassan el forkani" <[EMAIL PROTECTED]>
>To
On Mon, 13 Aug 2001 02:47:32 +0200, hassan el forkani <[EMAIL PROTECTED]>
wrote:
>>hello;
>>can someone please help me with this query:
>>
>>"delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day) < now()"
>>
>>what i'm tryng to do is to delete all records that are 3 (or more) days o
On 13-Aug-2001 hassan el forkani wrote:
> hello;
> can someone please help me with this query:
>
> "delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day) <
> now()"
>
> what i'm tryng to do is to delete all records that are 3 (or more) days old
> i've looked around in the manual b
hello;
can someone please help me with this query:
"delete from TABLE_NAME where TIMESTAMP_COLUMN(date, interval 3 day) < now()"
what i'm tryng to do is to delete all records that are 3 (or more) days old
i've looked around in the manual but couldn't find a "working answer", date
functions are
Hello ramamurthy,
rr> hi,
rr> We are using mysql as back end in our server.We are getting an problem with Mysql
.the problem is mysqld is going down wiht out any error messages.in the log file it
has writted as mysql deamon
rr> ended no other messages is thr.but we are getting problmem recentl
You have provided absolutely no useful information for anyone who may
wish to help you.
ramamurthy rajeshkumar wrote:
>
> hi,
>
> We are using mysql as back end in our server.We are getting an problem with Mysql
>.the problem is mysqld is going down wiht out any error messages.in the log file
hi,
We are using mysql as back end in our server.We are getting an problem with Mysql
.the problem is mysqld is going down wiht out any error messages.in the log file it
has writted as mysql deamon ended no other messages is thr.but we are getting problmem
recently previously it was working
>
> Connection myConn =
> DriverManager.getConnection("jdbc:mysql:///test_db1?user=Username&password=pas
> sword");
>
Try with:
Connection myConn =
DriverManager.getConnection("jdbc:mysql://localhost/test_db1,"user","passwor
d");
===
Saludos,
Enric Badia
SONRIE,
LA
Marko Sarunac wrote:
>
> I am running mySql 3.23.32 on Redhat 7, with Apaache and Tomcat Jakarta 3.2.1
> and for database connection i use mm.mysql.jdbc-1.2c
> Here is my problem
>
> I have got MySql to run fine but when i try to interfaec it over the web i get
> te follwoing error
>
> error 50
I am running mySql 3.23.32 on Redhat 7, with Apaache and Tomcat Jakarta 3.2.1
and for database connection i use mm.mysql.jdbc-1.2c
Here is my problem
I have got MySql to run fine but when i try to interfaec it over the web i get
te follwoing error
error 500
javax.servlet.ServletException: Ser
33 matches
Mail list logo
