At 03:52 2002-01-30, Todd Williamsen wrote:
>If its so urgent and private then why are you spamming a mail list? I
>smell scam, or is that Spam?
It's both.
And please do not quote the *whole* spam - the loss of bandwidth (it goes to every
subscriber!) from the actual spam is
ddy/
ICQ: 56093095
- Original Message -
From: "Karuku Srinivas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 30, 2002 1:12 PM
Subject: Urgent Help needed
> Hi All,
>
> Can anyone please tell me how to alter a table wherin modify a
Hi All,
Can anyone please tell me how to alter a table wherin modify a column
(which is Unique) to a non unique column.
Any help on this would be great .
Thanks
Regards,
K Srinivas
res Ph:6631851
ATS TransLogic Systems
5th Floor Amogh Plaza, Greenlands,
Hyderabad, AP 500 016, India
Tel: +9
On Tuesday 29 January 2002 06:20 pm, Michael Widenius wrote:
> I think we can avoid things like this by adding some extra 'not-
> allowed-on-the-list' words, that a non-subscribe can't use, without
> including an extra keyword in the email.
>
> Sasha, what do you think about this?
The point is t
G'day Michael, (I can't believe I'm _really_ replying to you:-)
> I don't agree that we should make the list subscribers only, as this
> would be a big drawback for newcomers to MySQL.
I'm a classic newcomer to mysql and have only been on the list for a week or
so. It surprised me how much s
If its so urgent and private then why are you spamming a mail list? I
smell scam, or is that Spam?
-Original Message-
From: Engr. Martin Douglas. [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, January 30, 2002 2:28 AM
To: [EMAIL PROTECTED]
Subject: Urgent Business Assistance.
Urgent
Hi!
> "Jonathan" == Jonathan Hilgeman <[EMAIL PROTECTED]> writes:
Jonathan> Call me Ishmael. My whale and I would like to tour Mongolia, but alas, my
Jonathan> whale swallowed a group of Enron executives, including the entire Bush
Jonathan> administration, and now he is too full of money to
Urgent Business Asistance.
Engr Martin Douglas.
No. 16 Kingsway road,
Ikoyi lagos
Nigeria.
Tel/Fax:: 234-1-7742913
30th,January 2002.
Dear sir,
REQUEST FOR URGENT BUSINESS RELATIONSHIP.
First, I must solicit your
Urgent Business Asistan.ce.
Engr. Martin Douglas.
No. 16 Kingsway road,
Ikoyi lagos
Nigeria.
Tel/Fax:: 234-1-7742913
30th,January 2002.
Dear sir,
REQUEST FOR URGENT BUSINESS RELATIONSHIP.
First, I must solicit your
uesday, January 29, 2002 3:27 PM
To: [EMAIL PROTECTED]
Subject: urgent respnse
SOS
Oscar Malaba
oscarmalabaxyahoo.com
Bamako
Mali
Dear sir
I know this will come to you out of the blue as a
surprise. I write this crucial mail to solicit your
assistance in a transaction that will be very
be
SOS
Oscar Malaba
oscarmalabaxyahoo.com
Bamako
Mali
Dear sir
I know this will come to you out of the blue as a
surprise. I write this crucial mail to solicit your
assistance in a transaction that will be very
beneficial to you, with hope that you will never let
me down either now or in fut
ent: Thursday, January 24, 2002 5:46 PM
To: [EMAIL PROTECTED]
Subject: Need very very Urgent help
Hi,
I installed mysql-3.23.47-win version on Win NT 4.0 Workstation, but I cant
start MySQL
service.
When I am trying to start mysql service, I get an error msg like this:
Could not start the My
Hi,
I installed mysql-3.23.47-win version on Win NT 4.0 Workstation, but I cant start MySQL
service.
When I am trying to start mysql service, I get an error msg like this:
Could not start the MySql service on \\SARADHI.
Error 1067 : The process terminated unexpectedly.
I installed mysql once
Guto,
what version of MySQL you are running and on what operating system and
version?
Please upgrade to the latest 3.23.47. Many bugs in earlier versions have
been fixed.
Starting from 3.23.44 you have the following forced recovery option which
you can use to dump your tables from a corrupt dat
Dear folks,
It´s the first time I´m using this list and now I got a really big
problem. It´s the fourth time the error below hapens to my server and
every time it happened I had to process back my backup file. I´ve been
working all day long and I don´t wanna loose the information this time.
How ca
On Fri, Jan 11, 2002 at 04:48:18PM +0530, Manish Mehta wrote:
> Hi,
>
> I am new to test case design in Database.
>
> I wants to know Basically how to calculate the Maximum Database.
A database can consist of several tables. Each table is stored
(essentially) as a file. The size of a that fi
Hi,
I am new to test case design in Database.
I wants to know Basically how to calculate the Maximum Database.
When we have to take backup.?
What are steps to be flow please tell me.
Thanks in advance.
Manish Mehta
E-mail: [EMAIL PROTECTED]
---
Hi!
> "aravindgorthy" == aravindgorthy writes:
aravindgorthy> Hai
aravindgorthy> While setting up the replication environment i am
aravindgorthy> getting the following error in the master ..what might
aravindgorthy> be the problem
aravindgorthy> 020108 13:20:00 Slave thread: error conne
Hai
While setting up the replication environment i am
getting the following error in the master ..what might
be the problem
020108 13:20:00 Slave thread: error connecting to
master: Can't connect to MySQL server on '' (10049)
(0), retry in 60 sec
I followed all the steps correctly given in the
You cold use temp tables?
Simon
-Original Message-
From: amit lonkar [mailto:[EMAIL PROTECTED]]
Sent: 07 January 2002 10:08
To: [EMAIL PROTECTED]
Subject: URGENT
HI!!!
I am trying to execute the following query, in which i
am tring to insert data from the table testtable into
the
: 'testtable'
Please do reply
This is urgent
Thanks
Amit Lonkar
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
-
Before posti
Im's sending this to the list, since I got it in a private
mail and I don't see myself as a substitute for the combined
wisdom, knowledge, and willingness to help that is the MySQL
mailing list.
SHAM SUNDAR writes:
> I won't do sql operations using JDBC like insert,delete,select and update.When
ls on this list, and you risk
having all the people who know the answer skip your mail just
because they don't know what it's about. A subject like "very
urgent" will, at least in me, trigger thoughts along the lines
of "So this person is in a hurry, which means he/she has
Hello sir,
When i cannect from my java program i use to get
error General Error: 22.Can u pls help in this.My
mysql version is 3.23.46
Thanks in advance
Bye
Sham
__
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your un
Hi.
There is no straightforward method to recover deleted entries. The
backup (of course, you have backups, don't you) will be your best
friend.
Theoretically, there is a chance to recover deleted entries, because
they are not really deleted, but only put in a list of records to be
reused. But i
Sasha Pachev <[EMAIL PROTECTED]> writes:
> On Monday 26 November 2001 03:40 pm, Ady Wicaksono wrote:
> > gcc 2.96 has bugs that affect MySQL, what bug ?
> > RedHat 7.1 and RedHat 7.2 comes with gcc 2.96
>
> If we knew exactly what bug we would have given Red Hat a test case to fix
> it. All we
Gordan Bobic <[EMAIL PROTECTED]> writes:
> On Tuesday 27 Nov 2001 04:11, Ady Wicaksono wrote:
> > gcc 2.96 has bugs that affect MySQL, what bug ?
>
> A number of bugs, and they don't just affect MySQL - there is a number of
> packages that break when compiled using GCC-2.96. Some examples that
On Monday 26 November 2001 03:40 pm, Ady Wicaksono wrote:
> gcc 2.96 has bugs that affect MySQL, what bug ?
> RedHat 7.1 and RedHat 7.2 comes with gcc 2.96
If we knew exactly what bug we would have given Red Hat a test case to fix
it. All we know is that strange things happen under load when MyS
On Tuesday 27 Nov 2001 04:11, Ady Wicaksono wrote:
> gcc 2.96 has bugs that affect MySQL, what bug ?
A number of bugs, and they don't just affect MySQL - there is a number of
packages that break when compiled using GCC-2.96. Some examples that I
presonally ran into at some point are:
mPlayer
I
Ady Wicaksono <[EMAIL PROTECTED]> writes:
> On Tuesday 27 November 2001 02:38 am, you wrote:
> > On Monday 26 November 2001 09:55 am, Jonathan Hilgeman wrote:
> > > I have an app that uses about 6-7 databases. But the MySQL server is now
> > > restarting a lot. I was having a problem with this be
On Tuesday 27 November 2001 02:38 am, you wrote:
> On Monday 26 November 2001 09:55 am, Jonathan Hilgeman wrote:
> > I have an app that uses about 6-7 databases. But the MySQL server is now
> > restarting a lot. I was having a problem with this before - I had about
> > 267 restarts in a matter of
geman" <[EMAIL PROTECTED]>
To: "'Sasha Pachev'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, November 26, 2001 2:48 PM
Subject: RE: MySQL - Got Signal 11 - URGENT
> No - it's a FreeBSD binary, I believe. However, I noticed that there
were
>
From: Jonathan Hilgeman <[EMAIL PROTECTED]>
> On a related note, any Perl gurus know how to force a Perl cron job to stay
> below a certain CPU utilization?
Not a Perl thing. Do a man on 'nice'.
---
Rodney Broom
Programmer: Desert.Net
Spam filter: sql database
-
low a certain CPU utilization?
- Jonathan
-Original Message-
From: Sasha Pachev [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 11:39 AM
To: Jonathan Hilgeman; [EMAIL PROTECTED]
Subject: Re: MySQL - Got Signal 11 - URGENT
On Monday 26 November 2001 09:55 am, Jonathan Hilgeman
On Monday 26 November 2001 09:55 am, Jonathan Hilgeman wrote:
> I have an app that uses about 6-7 databases. But the MySQL server is now
> restarting a lot. I was having a problem with this before - I had about 267
> restarts in a matter of a month or two. I shut down the server, ran
> myisamchk o
From: Jonathan Hilgeman <[EMAIL PROTECTED]>
> ...MySQL server is now restarting a lot.
> mysqld got signal 11;
> ...any ideas?
I had something similar, very frustrating. I was advised by an acquaintance at MySQL
to upgrade to 3.23.42. I did and I haven't had the restarting problem since. I don'
I have an app that uses about 6-7 databases. But the MySQL server is now
restarting a lot. I was having a problem with this before - I had about 267
restarts in a matter of a month or two. I shut down the server, ran
myisamchk on the databases and it found a lot of open connections, and I
guess cl
hi,everyone.
i have wrong deleted the records from file; use the
sql : delete from test where treeid like '%';
who knows how i can restore the records from the MYD
file.
i need your help.
sincerely,
zhangyun
__
Do You Yahoo!?
Yahoo! GeoCities - q
Rui Barreiros wrote:
> Hi,
>
> We have several mysql server in production evironment, and most of them
> when they have millions of rows, they all get MyIsam tables corrupted.
>
> One of the servers has ext2 filesystem with scsi harddrives, after the
> myisamchk -r it repairs the table, but after
Hi,
We have several mysql server in production evironment, and most of them
when they have millions of rows, they all get MyIsam tables corrupted.
One of the servers has ext2 filesystem with scsi harddrives, after the
myisamchk -r it repairs the table, but after a few inserts it will
corrupt ag
On 26-Oct-2001 I wrote:
> I have inherited a database built by someone else who was apparently
> very
> stingy. :-)
>
> A primary key was set to 'tinyint(4)' limiting the number of records
> to 128.
>
> I've tried:
>
> alter table my_data modify phyid mediumint unsigned DEFAULT "0";
>
> ...bu
Hi,
> A primary key was set to 'tinyint(4)' limiting the number of records
> to 128.
> I've tried:
> alter table my_data modify phyid mediumint unsigned DEFAULT "0";
> ERROR 1121: Column 'phyid' is used with UNIQUE or INDEX but is not
> defined as NOT NULL
Try:
alter table my_data modify phy
On 26-Oct-2001 Tim Evans wrote:
> I have inherited a database built by someone else who was apparently
> very
> stingy. :-)
>
> A primary key was set to 'tinyint(4)' limiting the number of records
> to 128.
>
> I've tried:
>
> alter table my_data modify phyid mediumint unsigned DEFAULT "0";
>
lumn 'phyid' is used with UNIQUE or INDEX but is not
defined as NOT NULL
This is version 3.22.30, and resolving this is quite urgent. Please and
thank you.
--
Tim Evans |5 Chestnut Court
[EMAIL PROTECTED] |Owings Mills, MD 21117
Hello ,
Please help me (Urgent)
i have two tables
1. tbl_employeeinfo 2. tbl_networkpartloc
In these table i have common field called cCompany_ID.
1.
select count(tbl_employeeinfo.cCompany_ID)
from tbl_employeeinfo,tbl_networkpartloc
where tbl_employeeinfo.cCompany_ID
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, September 12, 2001 8:14 PM
> To: [EMAIL PROTECTED]
> Subject: Urgent Assistance
>
>
> Hi group,
>
> I am in need of assistance with a database and php query we
Hi group,
I am in need of assistance with a database and php query we are trying to
achieve.
Basically we are have a form where one field searches a field in the mysql
database and the other searches for keywords using the MATCH query.
What we need to do is for the user to be able to enter a
Your question is not clear.
Show us what you entered, and what the error message was.
snehalata wrote:
> Hi,
>
> We are facing problem with mysql on linux.
> We are unable to give the password for admin user.
> Can you please give all the list for installation and user creation
> as well
Hi,
We are facing problem with mysql on linux.
We are unable to give the password for admin user.
Can you please give all the list for installation and user creation
as well as for uninstalling?
Thanks,
Sneha
-
Before
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
Date |Tue, 28 Aug 2001 23:43:16 +0200
>From |"Martin Jeremic" <[EMAIL PROTECTED]>
Hello!
MJ> This is really stupid, but I can remember how to save results of "SHOW
MJ> CREATE TABLE tbl_name" and "SHOW COLUMNS FROM tbl_name" in to text file. I'm
MJ> running mysql 23.41 on Win2k.
MJ> Thanks in ad
This is really stupid, but I can remember how to save results of "SHOW
CREATE TABLE tbl_name" and "SHOW COLUMNS FROM tbl_name" in to text file. I'm
running mysql 23.41 on Win2k.
Thanks in advance
--
Martin Jeremic
mailto:[EMAIL PROTECTED]
http://solair
Hi,
I have mysql version 3.32.40 installed on my system. Please let me
know what I need to take care of (besides the db backup) if I need to
upgrade to mysql-max?
I need this on an urgent basis, so please help!
Thanks,
Sheena
On Thu, Aug 23, 2001 at 06:55:42AM -0700, xiyuan qian wrote:
>
> Hi, I am running mysql-3.22.27 for many months. But today, the
> mysqld always core dump. The running platform is FreeBSD3.4.
>
> I checked the dumped core and find that it seems that the core dump
> has something with the /usr/lib/
Hi, I am running mysql-3.22.27 for many months. But
today, the mysqld always core dump. The running
platform is FreeBSD3.4.
I checked the dumped core and find that it seems that
the core dump has something with the
/usr/lib/libc_r.so file when it called the thread
subroutine.
Please help me!
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
On 01 Aug 2001 15:36:55 +0800, Wong Ching Kuen Frederick wrote:
> i am using
> redhat 7.1 (i386-smp)
> kernel 2.4.6
> gcc 3.0
> mysql 3.23.40
>
> ./configure --prefix=/usr/local/mysql --with-charset=big5 --with-mysqld-user
> =mysql
Correct way is:
make distclean
autoheader
aclocal
autoconf
auto
i am using
redhat 7.1 (i386-smp)
kernel 2.4.6
gcc 3.0
mysql 3.23.40
./configure --prefix=/usr/local/mysql --with-charset=big5 --with-mysqld-user
=mysql
i have the following error, could somebody help me?! thank you very much.
c++ -DMYSQL_SERVER -DDEFAULT_MYSQL_HOME="\"/usr
Hello John,
are you sure, that the user "test" with password "test1" exist in your
Grant-Tables and has rights to
INSERT ??? [;-)]
Gruß
Christian
john zie wrote:
>
>
>
> Mysql:
>
> We have installed mysql 3.23.26 beta version to a BSD 4.2 server. It
> works fine, however when we test a
>>> >>I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired
>with both the binary distro and source distro with no luck. The install seems to go
>OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686
>system.
>>>
>>> Please disregard thi
Mysql:
We have installed mysql 3.23.26 beta version to a BSD 4.2 server. It works
fine, however when we test a php file which just function to insert some
data to a table in database, and display all data on the web page. After
run this, the data have been inserted and displayed; however,
At 4:08 PM -0500 7/25/01, MikeBlezien wrote:
>On Wed, 25 Jul 2001 16:04:17 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote:
>
>>>Source distributions don't really come with any table handler enabled
>>>by default, because there are no binaries included in the distribution.
>>>To see what options co
"MikeBlezien" <[EMAIL PROTECTED]> writes:
> Hello All,
>
> >>I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired
>with both the binary distro and source distro with no luck. The install seems to go
>OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Ker
On Wed, 25 Jul 2001 16:04:17 -0500, Paul DuBois <[EMAIL PROTECTED]> wrote:
>>Source distributions don't really come with any table handler enabled
>>by default, because there are no binaries included in the distribution.
>>To see what options control the table handlers, run this command:
>>
>>
At 2:55 PM -0500 7/25/01, MikeBlezien wrote:
>Hello All,
>
>>>I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40
>>>I have tired with both the binary distro and source distro with no
>>>luck. The install seems to go OK, but I can't start the mysql
>>>server. This is on a RH/Linux
Hello All,
>>I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired with
>both the binary distro and source distro with no luck. The install seems to go OK,
>but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel 2.4.6 i686
>system.
Please disregard this
Hello All,
I've been trying upgrade our current MySQL 3.23.39 to the 3.23.40 I have tired
with both the binary distro and source distro with no luck. The install seems to
go OK, but I can't start the mysql server. This is on a RH/Linux 6.2 Kernel
2.4.6 i686 system.
The main problem seems to be,
: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Using InnoDb table type - Urgent help required
At 16:27 Uhr -0700 20.7.2001, Rashmi Mittal wrote:
>innodb_data_file_path=ibdata1:200M
>innodb_data_home_dir=f:/mysql/innodb/ibdata
>innodb_log_group_home_dir=f:/mysql/innodb/iblogs
>
>
At 16:27 Uhr -0700 20.7.2001, Rashmi Mittal wrote:
>innodb_data_file_path=ibdata1:200M
>innodb_data_home_dir=f:/mysql/innodb/ibdata
>innodb_log_group_home_dir=f:/mysql/innodb/iblogs
>
>The directories specified in the above variables exist.
>However when I try to run the service I get the error "C
Hi,
I am using mySQL on Windows 2000. I need to use the InnoDb table type to get
transaction support. I had initially installed mysql and was using the ISAM
table type and everything was working fine. My NT service was configured to
run the mysqld-nt.exe. For using the InnoDb type I un-installed
The following doesn;t make sense... I need the resultset comprising the list
of all the tables in the db...and i wat that as a java.sql resultset...can
somebody help me here!???urgent!!
java code :
String sqlQuery = "show tables";
try {
con = ConnectionPoolManager.get
mysql
settings)
3. Permissions are incorrect.
- Original Message -
From: "Syed Sumair" <[EMAIL PROTECTED]>
To: "Edna Walton" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, July 13, 2001 1:51
Subject: Re: I am facing this error [ Urgent ]
>
>
Have you checked that you've got a musql server running. (ps ax|grep mysqld)
On Fri, 13 Jul 2001 05:51, you wrote:
> Thanks for your replies
> but my problem is still there
> this is the php code iam using for connecting to Database:
>
> $ss_conn = mysql_connect($db_host,$db_usr,$db_pwd);
>
> a
Thanks for your replies
but my problem is still there
this is the php code iam using for connecting to Database:
$ss_conn = mysql_connect($db_host,$db_usr,$db_pwd);
and hosting infos are:
Red hat linux
mysql-3.23
php 4
> From the error message, I'd guess you are using RedHat distribution.
Hi,
What kind of Platform, MySQL Version, etc.?
is the mysql daemon running?
Guus
> -Original Message-
> From: Syed Sumair [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 12, 2001 3:12 AM
> To: [EMAIL PROTECTED]
> Subject: I am facing this error [ Urgent ]
What to do do
I am facing this error !!
Warning: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2) in
/web/sites/188/pisps/www.pisps.f2s.com/signup/index.php on line 372
Warning: MySQL Connection Failed: Can't connect to local MySQL server
through socket '/tmp/mysql.sock
> when you run myisamchk it try to find the .MYI file.
> If you try to run myisamchk on the MYD file, it says that the key definition
> is incorrect (which seems to be normal ;))
The key definition should be part of the .frm file, in my
understanding. Oh, I see, myisamchk is invoked on that very
On Sat, Jul 14, 2001 at 01:04:41AM +0200, Fournier Jocelyn [Presence-PC] wrote:
> Hi,
>
> I'm administrating a machine which has just badly crashed, and a MYI
> file has disappeared for one table. Is this possible to repair this
> table?
Try to touch the file (to create an empty one), and see i
Hi,
I'm administrating a machine which has just badly crashed, and a MYI file has
disappeared for one table.
Is this possible to repair this table ?
BTW, REPAIR TABLE in mysql report a wrong message :
mysql> REPAIR TABLE threadhardwarefr1;
+--++--+---
Original Message -
From: "Robert Vetter" <[EMAIL PROTECTED]>
To: "Ireneusz Piasecki" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, July 05, 2001 4:26 PM
Subject: Re: three tables and count() - Urgent i need it to my job !!
>
&
Ireneusz Piasecki wrote:
>
> Hi my friends !!
>
> Some few days i have problems with count().
> i have 3 tables:
>
> t1 holds:
> +++
> | id | number |
> +++
> | 1 | one|
> | 2 | two|
> | 3 | three |
> | 4 | four |
> | 5 | five |
> | 6 | sixs |
> +-
Hi my friends !!
Some few days i have problems with count().
i have 3 tables:
t1 holds:
+++
| id | number |
+++
| 1 | one|
| 2 | two|
| 3 | three |
| 4 | four |
| 5 | five |
| 6 | sixs |
+++
t2 holds:
++---+-
> I want Execute querys stored in file but from
> phpmyadmin interface, I want to use telnet to execute
> the command :
> # mysql mydb_name < file.sql
> but in telnet prompt its invalid command
So not from phpMyAdmin, right?
Use
mysql -hlocalhost -uUsername -p dbName < file.sql
You will have
hello,
I want Execute querys stored in file but from
phpmyadmin interface, I want to use telnet to execute
the command :
# mysql mydb_name < file.sql
but in telnet prompt its invalid command
Can you help me?
Thanx
___
Do You Yahoo!? -- Pour
Just to point out, you did not describe t2 in this email, but you have
redescribed t1 again, and not table t2.
Also, from looking at your query, I can see the following things: If you
did not have the where condition checking for the timestamp, then you would
get the entry for "four" since th
Just to point out, you did not describe t2 in this email, but you have
redescribed t1 again, and not table t2.
Also, from looking at your query, I can see the following things: If you
did not have the where condition checking for the timestamp, then you would
get the entry for "four" since th
I have 2 tables:
1) t1
mysql> describe t1;
++-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
++-+--+-+-++
| id | int(3) | | PRI | NULL| auto_increme
I have 2 tables:
1) t1
mysql> describe t1;
++-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
++-+--+-+-++
| id | int(3) | | PRI | NULL| auto_increme
chown -R mysql /home/ecom
tpchan wrote:
> Hi all,
>
> I try the solution from David but seem it didn't work.
>
> Here is my steps:
>
> 1) Stop the mysql services.
> 2) Move the ecom database directory from '/var/lib/mysql/ecom' to
> '/home/ecom'
> 3) Make symbolic link in '/var/lib/mysql'
Hi Everybody,
We are using Mysql in Sun5.8 environment. Presently it has installed in
/usr/local/mysql. I want to change this location to /export/home/mysql. What should i
take necessary steps.
Is it work properly if move my Mysql dir to /usr/local/mysql to /export/home/mysql and
chage th
me know.
[EMAIL PROTECTED]
-Original Message-
From: mysql-digest-help [mailto:[EMAIL PROTECTED]]
Sent: Sunday, July 01, 2001 10:37 PM
To: david.patton
Cc: tpchan; mysql
Subject: URGENT! Hard Disk Space limition and Symbolic link
Hi all,
I try the solution from David but seem it didn
Hi all,
I try the solution from David but seem it didn't work.
Here is my steps:
1) Stop the mysql services.
2) Move the ecom database directory from '/var/lib/mysql/ecom' to
'/home/ecom'
3) Make symbolic link in '/var/lib/mysql' using 'ln -sf /home/ecom ecom'
4) Start the mysql services.
5) my
dear sir,
i am a new user to mysql database.
i want to write command in mysqldump for backing up of my database named -testDB.But
this .exe quits off automatically before i write command.will you please give me
suggestions?
regards,
mukul from singapore.
-
Hi.
On Fri, Jun 22, 2001 at 05:31:32PM +0100, [EMAIL PROTECTED] wrote:
> Hi,
> Is there a way to retrieve the field values in the
> same order as during insertions based on something
> like rowid or so??
No. Insertion order is not kept anywhere. Use an AUTO_INCREMENT column
to obtain an key to O
On 22-Jun-01 VVM Ravikumar Sarma Chengalvala wrote:
> Hi,
> Is there a way to retrieve the field values in the
> same order as during insertions based on something
> like rowid or so??
> Eg:
> Insertion order into a table for a text field:
> bbb
>
> abaa
> aa
>
> Retrieval order:
>
Hi,
Is there a way to retrieve the field values in the
same order as during insertions based on something
like rowid or so??
Eg:
Insertion order into a table for a text field:
bbb
abaa
aa
Retrieval order:
I want to have the retrieval order also the same.The
output of the query on tha
301 - 400 of 487 matches
Mail list logo