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.
://www.nabble.com/need-help-urgent-tf3491135.html#a9749875
Sent from the MySQL - General mailing list archive at Nabble.com.
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-urgent-tf3491135.html#a9749875
Sent from the MySQL
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
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
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'
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 this below
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
-
--
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:
--
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 mysqldump?? If
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
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
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
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 from
A MySQL
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. Note that my
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
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
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
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 command to
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
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...
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
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 the
, 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: [EMAIL PROTECTED]
Sent: Sunday, August 12, 2001 5:47 PM
Subject: help (urgent!!!) with a query
hello;
can someone please
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 only
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 but
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 old
i've looked
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 it
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 recently
Connection myConn =
DriverManager.getConnection("jdbc:mysql:///test_db1?user=Usernamepassword=pas
sword");
Try with:
Connection myConn =
DriverManager.getConnection("jdbc:mysql://localhost/test_db1,"user","passwor
d");
===
Saludos,
Enric Badia
SONRIE,
LAS
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:
31 matches
Mail list logo