If its one time .. i will suggest to take a mysqldump of table structure
only and drop the database import the backup .
[EMAIL PROTECTED] wrote:
Hi All,
How do I delete all the rows of all the tables(but not
table) in the database at one shot.
Regards,
Ravi K
The informat
[EMAIL PROTECTED] wrote:
Hi All,
How do I delete all the rows of all the tables(but not
table) in the database at one shot.
Regards,
Ravi K
Hi -
Please see http://dev.mysql.com/doc/refman/5.0/en/truncate.html
Thanks
-dant
--
MySQL General Mailing List
For list archives: h
Okie there might be a entry in mysql.user table having username and
password column as blank .
That might result in Access denied when u use password .
Try this ,
use mysql ; select * from user where user='';
if so , Delete those entries .
[EMAIL PROTECTED] wrote:
I can connect using Putty
Hi All,
How do I delete all the rows of all the tables(but not
table) in the database at one shot.
Regards,
Ravi K
The information contained in this electronic message and any attachments to
this message are intended for the exclusive use of the addressee(s) and may
contai
If you are running a script from the command line, try
mysql -BNe "select 'some text to print'"
-Original Message-
From: Jesse [mailto:[EMAIL PROTECTED]
Sent: Friday, 25 August 2006 2:39 a.m.
To: Wai-Sun Chia; Dan Buettner
Cc: MySQL List
Subject: Re: Outputting text in a
You still get
Hi,
The 3.23.49 is the version of the client that php is using.
This may been what it was compiled with, or what it is getting from an external
library.
If it is compiled that way, you'll need a new compile of php including the
newer client library. If its a runtime load, you may get away with
No, I don't think it is.
I think you want to have a query that will return 'n' rows where the sum of
Total is >= 100
If your table is
ID Total
1 10
2 20
3 30
4 40
5 50
it would return
1 10
2 20
3 30
4 40
(sum total = 100)
but if your table was
ID Total
>>Does it mean the port 3306 is blocked?
Not necessarily - it could mean that MySQL didn't respond as your telnet client
expected (which is not surprising!).
The "Access denied for [EMAIL PROTECTED]" message comes from the server, so
there will be something wrong with your mysql.user or mysql.d
Server version: 5.0.24
This query is working OK for me. I'm using FROM_DAYS() to avoid errors
due to leap years.
SELECT extract(YEAR FROM from_days(datediff(curdate(), dateofbirth))) AS
age, SUM(extract(YEAR FROM from_days(datediff(curdate(), birth_date
AS total_age FROM user_inf
I have a group of updates that need to be done using LOAD DATA INFILE.
Within this file there are some INSERTS. Is there anyway that after
an INSERT happens I can use the auto-increment ID that was just
generated in the next statement. Similar to PHP's mysql_insert_id()
function.
Thanks,
Michae
I can connect using Putty to the server using port 22.
When I try to connect to the server using port 3306 and got "Connection
timed out"?
Does it mean the port 3306 is blocked?
-afan
> U can chk firewall by doing a telnet to the remote host on 3306 (
> default ) port .
>
> Error message looks
U can chk firewall by doing a telnet to the remote host on 3306 (
default ) port .
Error message looks like username/password might be wrong .
[EMAIL PROTECTED] wrote:
hi,
I'm trying to access to mysql on dedicated web server (hosted by hosting
company) using MySQL Administrator. Right now I'
I don´t think it´s a problem with firewall.
The error figured out below seems it´s been a username or password problem.
<[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
> hi,
> I'm trying to access to mysql on dedicated web server (hosted by hosting
> company) using MySQL Admin
hi,
I'm trying to access to mysql on dedicated web server (hosted by hosting
company) using MySQL Administrator. Right now I'm getting error message
2003 (Can't connect to the server...).
On users table I can see in user column 'root' and 'admin' as users and
both have for host 'localhost' (root ha
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Markus Fischer wrote:
> Before I re-invent the wheel I'ld like to know if there are tools/helper
> like this available ... ?
Being impatient and in need of this I've written my own version. Maybe
it is valuable to others.
http://markus.fischer.name/l
2006/9/19, Peter Van Dijck <[EMAIL PROTECTED]>:
Hi all,
trying to figure out if there is a query I can use for this, or if I
have to write a php script to loop tru each row...
table1:
entryid int(11)
itemid int(11)
table2:
object_id int(11)
The situation is: table2.objectid is populated w
Actually is this possible with simple SQL command in Mysql ?
On 9/19/06, Price, Randall <[EMAIL PROTECTED]> wrote:
I tried it also with 5.0.24-community-nt and it still didn't work!
Randall Price
Microsoft Implementation Group
Secure Enterprise Computing Initiatives
Virginia Tech Information T
I tried it also with 5.0.24-community-nt and it still didn't work!
Randall Price
Microsoft Implementation Group
Secure Enterprise Computing Initiatives
Virginia Tech Information Technology
1700 Pratt Drive
Blacksburg, VA 24060
Email: [EMAIL PROTECTED]
Phone: (540) 231-4396
-Original Mess
Hi all,
trying to figure out if there is a query I can use for this, or if I
have to write a php script to loop tru each row...
table1:
entryid int(11)
itemid int(11)
table2:
object_id int(11)
The situation is: table2.objectid is populated with the values of
table1.itemid, but they have to
I tried it also with 4.1.21-log and still didn't work !
On 9/19/06, Ahmad Al-Twaijiry <[EMAIL PROTECTED]> wrote:
I tried that before and it also doesn't work, is it because I'm using
mysql version 4.1.19 ?
On 9/19/06, Edward Macnaghten <[EMAIL PROTECTED]> wrote:
> Ahmad Al-Twaijiry wrote:
>
> >
You ought to conect on localhost and create a new user with the specific ip
in the Host field.
<[EMAIL PROTECTED]> escreveu na mensagem
news:[EMAIL PROTECTED]
> what I have to do to be able to access to mysql on my web server from
> other computer?
> e.g., I want to access to web server using My
what I have to do to be able to access to mysql on my web server from
other computer?
e.g., I want to access to web server using MySQL Administrator?
I have root access to web server.
As far as I know, mysql server is set up by edfault to be acessed only
through "localhost" and I have to add permis
Hi,
I am using apache2.0+php4.3.4+mysql 4.1.1 in windows. If I type
phpinfo(); , in mysql section it is coming as "Client API version
3.23.49" . Is the installation correct?. Will the php connect to the
mysql 4.1.1 server?. If i need to see "Client API version 4.1.1" in
mysql section, wh
I tried that before and it also doesn't work, is it because I'm using
mysql version 4.1.19 ?
On 9/19/06, Edward Macnaghten <[EMAIL PROTECTED]> wrote:
Ahmad Al-Twaijiry wrote:
> Hi everyone
>
> SELECT * FROM tbl_name WHERE SUM(Total)=100 ORDER BY ID
>
>
SELECT ID FROM tbl_name GROUP BY ID HA
Hi,
I have a bit of a weird question. A couple of rows in a table I'm
importing with data has WW_D_D_D style row content which is
different from the usual WW_DD format data which many millions of
rows contain. During the process of normalising the data is there any
way to distinguis
> > But you can't get a group by from an alias.
>
> That surprises me. I tried putting the calculation of age in a
> subquery but that didn't work, either. And I've never quite
> figured out how to create a temporary table for intermediate
> results. There has _got_ to be a way to do this, e
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
we've enabled /var/log/mysql.log on our server (5.0.24a on Debian
testing). However I only want to log commands from certain application,
or better say, certain users.
When I look at some log output, it looks like this:
060919 9:53:38
15945 Con
Hi,
I am trying to use php4.3.4 with mysql 5.0.24 in windows. Where
can I get the mysql connector for php4.3.4 or How do I connect to mysql
in php4.3.4. If I try phpinfo(); it is giving only the mysql client API
3.23.49 version. Can somebody help me?.
Thanks,
Muthu.
--
MySQL General Ma
28 matches
Mail list logo
