Hi,
PHP Version 4.3.1
Mysql Version 4.0.13
When I try and run the following query
CREATE TEMPORARY TABLE temptable AS SELECT * FROM permtable;
on each database, the first one will run it with no problems at all. The
second returns the error:
[server] ERROR 1044: Access denied for user:
Does the ip address of where you are trying to access the mysql database
from (client), change?If you have a dynamic ip address
your ISP should have a grant something to the effect of:
grant all on database.* to [EMAIL PROTECTED] identified by 'password';
This would allow your client to be
Hello list,
I'm really new to mysql and databases in general. I have a select form
that contains a very long list of options, and what I want to do is
store the selected item as a number instead of the items name in order
to speed up searches. My problem comes when a search is done and I can't
I'm new, too, so someone correct me if I'm wrong, but...
if you make it an ENUM field in a table you can store it using the
value in the selection, retrieve it as the same value, and still get
all the advantages of numeric storage.
Todd
On Sunday, July 6, 2003, at 02:38 PM, Dan Cox wrote:
Another option is to have another table with the item name and number
using that as a lookup table.
IMHO it all depends on the data if the select is static (or rarely
changes) an enum would be best. If is changes a lot then I would use
another table to store it in.
-Michael
I protect you,
I'm running this query to get a count of categories I have in a field that contains
aircraft categories.
SELECT substring(category,10), count(*)
FROM `links` where category like 'Aircraft/Sales%'
group by category order by category
and getting these results:
---
Hello,
I apologize if this is a very simple question but I have spent the last half hour
searching for an answer to it and have thus far been unable to find one. I am pretty
new to mysql so please be easy on me if this is painfully obvious :)
I am trying to determine the primary field in a
I just assumed your question was for mysql data only..
If you want total I use:
OS - raid 1 (2 X 18.2gb - 10kRPM)
DATA - raid 0+1 (# X 18.2gb - 15kRPM)
usually a dataset is comprised of 6-10 disks.. you could go larger with
the drive size.. but more spindles = more thruput
Swap isn't much of
you mean the primary key (also called primary index), do you?
just query 'SHOW INDEX FROM yourtable' and read all rows with Key_name = 'PRIMARY'.
you can play around with this in the mysql commandline. you'll get all column names
that belong to the primary key in the Column_name field of the
my coulmn (id) is an auto_increment coulmn and lets say that i have 100 entries, so
the problem is that when i delete all entries on my table, the column (id) starts from
101 ,shouldn't is starts from 1 again!
please i need help with this
The IP address CAN change, but doesn't change on such a basis that it would
cause a problem. You see the issue also appears whether I am [EMAIL PROTECTED]
or [EMAIL PROTECTED] it doesn't matter where I am coming from.
Thx
- Original Message -
From: Stephen March [EMAIL PROTECTED]
To:
I am new to SQL and was wondering if there was a query that would allow
me to print to my printer. I have tried the TO PRINTER, TO FILE, |lpr,
and others, but get the syntax error. I am running MySQL on a WIndows XP
Home system. My company has asked me to transfer a clients file to forms
for
my coulmn (id) is an auto_increment coulmn and lets say that i have 100
entries, so the problem is that when i delete all entries on my table, the
column (id) starts from 101 ,shouldn't is starts from 1 again!
please i need help with this
Use truncate table, it will reset the auto_incement.
Is there any way to seed a column set to autoincrement? Say I wanted it to
begin at 1.
- Original Message -
From: Greg Donald [EMAIL PROTECTED]
To: wael fareed [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Sunday, July 06, 2003 4:42 PM
Subject: Re: need help
my coulmn (id) is
Is there any way to seed a column set to autoincrement? Say I wanted it to
begin at 1.
alter table table_name auto_increment = 1;
--
Greg Donald
http://destiney.com/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi Vince,
I assume you want to print to your printer from the mysql client (command
line) here is what I do:
0) set up a lp queue (line printer) and make sure it works then proceed to 1)
1a) mysql pager /usr/bin/less
mysql \P lp;
PAGER set to lp;
mysql SHOW INNODB
Hi Kevin,
try this:
1) stop the mysql server
2) mysqld_safe --skip-grant-tables
3) mysql -u root
4) mysql SHOW GRANTS FOR root;
5) GRANT ALL ON *.* TO 'root'@'%';
6) restart the server (without --skip-grant-table option) and try to login
Best regards
Nils Valentin
Tokyo/Japan
2003 7 5
2003 7 7 10:28Nils Valentin :
Hi Kevin,
try this:
1) stop the mysql server
2) mysqld_safe --skip-grant-tables
3) mysql -u root
4) mysql SHOW GRANTS FOR root;
5) GRANT ALL ON *.* TO 'root'@'%';
GRANT ALL ON *.* TO 'root'@'%' IDENTIFIED BY 'secret' WITH GRANT OPTION;
sorry for the
Hi,
This may be a stupid question but can I still just ask it?
Why do you want to disable the use of InnoDB tables? If you don't
use it, couldn't the files still be there? It's not like it's a security
risk (or is it?) or that it takes up lots of space? (maybe this is true as
Post the code
Martin
- Original Message -
From: marvc [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, July 05, 2003 7:08 PM
Subject: RE: Possible OT: ADONewConnection Error
I take it no one is familiar with particular error? Didn't get anything
on google.
-Original
Hi, Nils
I can't get the mysql server to stop! If I try service mysqld stop I
get a FAILED error. If I try mysqladmin -u root -p shutdown, I get:
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: YES)'
[EMAIL PROTECTED]
Hi Kevin,
There is a way to sop the server on OS level. However I am not sure if you
want to do it this way. You can use the kill command, but be aware that it
might damage a data file if the database is accessing it in just this moment.
Having said this warning, here is what you can do:
1)
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Jim,
What would be the ideal RAID configuration for a dedicated MySQL db
server running on FreeBSD?
We're also running some MySQL databases on Windows 2000 Servers. What
about the best configuration for a dedicated W2k server running MySQL?
David Lloyd wrote:
What would be the ideal RAID configuration for a dedicated MySQL db
server running on FreeBSD?
We're also running some MySQL databases on Windows 2000 Servers. What
about the best configuration for a dedicated W2k server running MySQL?
That depends on what your
Jim McAtee wrote:
David Lloyd wrote:
What would be the ideal RAID configuration for a dedicated MySQL db
server running on FreeBSD?
We're also running some MySQL databases on Windows 2000 Servers. What
about the best configuration for a dedicated W2k server running MySQL?
Hi,
I want to save image files into BLOB fields?? How do i do
it?? And how to retrieve it back from database??
___
Click below to experience Sooraj R Barjatya's latest offering
'Main Prem Ki Diwani Hoon' starring Hrithik, Abhishek
Kareena
26 matches
Mail list logo