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
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
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 that
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:
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
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
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
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]
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 file
Hi!
aravindgorthy == aravindgorthy iso-8859-1 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
: 'testtable'
Please do reply
This is urgent
Thanks
Amit Lonkar
__
Do You Yahoo!?
Send your FREE holiday greetings online!
http://greetings.yahoo.com
-
Before posting, please
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
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
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 hasn't
done any research or tried to solve the problem. And probably
the problem
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
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
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 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 know is
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
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 on
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
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
two perl scripts running that got stuck in infinite loops and were
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 a
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 before - I
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
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
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
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 a few
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;
...but
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 phyid
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
http://www.tkevans.com/tkevans.html
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
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
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
-
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 as
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
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 advance
mysql
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]
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
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!
, 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
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
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
automake
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 php file
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,
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
At 2:55 PM -0500 7/25/01, MikemickaloBlezien 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 6.2
MikemickaloBlezien [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 Kernel
At 4:08 PM -0500 7/25/01, MikemickaloBlezien 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 control
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;
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 posting,
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 Could
To: [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
The directories
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
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.getConnection
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.
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);
and
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 ]
Thanks for your replies
but my problem is still
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 if
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
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 ]
cut
Warning: Can't
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:
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 |
+++
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
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
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 to
I have 2 tables:
1) t1
mysql describe t1;
++-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
++-+--+-+-++
| id | int(3) | | PRI | NULL|
I have 2 tables:
1) t1
mysql describe t1;
++-+--+-+-++
| Field | Type| Null | Key | Default | Extra |
++-+--+-+-++
| id | int(3) | | PRI | NULL|
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
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't
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
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' using 'ln
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)
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,
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
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:
I want to
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
MySQL newbie question here!!
I have MySQL installed on Red Hat Linux 7. I have a Test, Backup and Live
environment. All with the same installations of Linux, MySQL and CF. The
problem that I am having is that I am trying to create a new database user
in the table user in MySQL. It works find in
PROTECTED]
Subject: Re: URGENT MySQL user table
is read only...
06/20/01
php@elvandarTo: [EMAIL PROTECTED]
.de cc: [EMAIL PROTECTED]
Subject: Re: URGENT MySQL
: Nessi [EMAIL PROTECTED],
[EMAIL PROTECTED]
Subject: Re: URGENT MySQL
user table is read only...
06/20/01 01:53 PM
Check the permissions on the directories you are using for data, as well as
checking the user the MySQL deamon is running as.
j- k-
On Wednesday 20 June 2001 06:55, [EMAIL PROTECTED] wrote:
MySQL newbie question here!!
I have MySQL installed on Red Hat Linux 7. I have a Test, Backup
Hi,
I am facing the following problem in pattern matching:
I want to check the pattern matching using LIKE on a
field that is declared as Binary and also contains
back slashes.
eg:
ID INT,
NAME VARCHAR(128) BINARY
I am using C-API of mysql to escape the characters
like '\' for this field.
The
Hi,
Can someone get back to me at the earliest regarding
mysql's support for backslash characters in pattern
search.I am not able to search based on the string
which contains a backslash character even after
escaping..
Regards,
Ravi
Do
i,
I have to write simple mysql script. I need folowing things:
Number of people logged in previous 0 to 24 hours
Number of people logged in previous 24.5 to 48 hours
Number of people logged in previous 48.5 to 72 hours
Number of people logged in previous 72.5 hours to 7 days
Number of people
i,
I have to write simple mysql script. I need folowing things:
Number of people logged in previous 0 to 24 hours
Number of people logged in previous 24.5 to 48 hours
Number of people logged in previous 48.5 to 72 hours
Number of people logged in previous 72.5 hours to 7 days
Number of people
Hi all,
I need to convert the records from mysql database into MS.Access.
I don't have ODBC.The mysql is in different machine(stand alone).So i need
to convert that into a flat file then put into MS-Access.
Can u pl.help me in this regard.
It's very urgent.It'll b very much useful if i get a
We have a table whose entries seem to be disappearing at random. We are accessing
our MySQL 3.22.32 database with PHP4 on a Linux 6.0 586 machine. Up until yesterday,
we would lose about one entry per week in a single table. The rest of the tables seem
fine. However, yesterday one of
13:09
To: [EMAIL PROTECTED]
Subject: URGENT Disappear - Reappear Problem
We have a table whose entries seem to be disappearing at random. We are
accessing our MySQL 3.22.32 database with PHP4 on a Linux 6.0 586 machine.
Up until yesterday, we would lose about one entry per week in a single
PLEASE if anyone can help!! We are past deadline
Object: Retrieve rows from table D.
GIVEN:
1. MySQL ver 3.23.33 (but must run on 3.22.25!)
2. Table D is connected to tables E,F,K through tables dE,dF,dK.
3. Table D is connected to table L through tables dK then Lk.
D - dE - E
D - dF - F
D -
Bruce,
Thanks for your reply!
1- Yes I've tested using MySQL GUI 1.7.4 with the same results
2 - Don't know, will have to find out
3 - I'll find and check that too
Paul,
Have you tried the SQL from mysql to see wht it does outside of PHP? IS
the MySQL server configured to log all queries?
-
From: Paul Wilkinson [EMAIL PROTECTED]
To: Help MySQL List [EMAIL PROTECTED]
Sent: Tuesday, May 29, 2001 1:08 PM
Subject: URGENT !! Hanging query
PLEASE if anyone can help!! We are past deadline
Object: Retrieve rows from table D.
GIVEN:
1. MySQL ver 3.23.33 (but must run on 3.22.25!)
2
.
any help would be helpful,
Thanks
Selvin
P.S. this is urgent i need this very quickly
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
going to have to be the best way.
HTH
Jon
-Original Message-
From: Selvin Sakal [mailto:[EMAIL PROTECTED]]
Sent: 24 May 2001 12:43
To: [EMAIL PROTECTED]
Subject: characters - URGENT!!
Hi,
i have a mysql database, can anyone tell me any characters that cannot be
entered into mysql (like
PROTECTED]]
Sent: Thursday, May 24, 2001 7:43 AM
To: [EMAIL PROTECTED]
Subject: characters - URGENT!!
Hi,
i have a mysql database, can anyone tell me any characters that
cannot be
entered into mysql (like !@#$%, etc).
Also i have a string and i would like to remove html tags,
characters (like
301 - 400 of 456 matches
Mail list logo
