You can accomplish it without granting everyone root privileges.
Just create user accounts and grant them the right to create a database
and to have full access to their own (NOT ALL databases on the server!)
databases.
Babs
|| -Original Message-
|| From: Ron Gilbert [mailto:[EMAIL
You will need root privilege in order to install and start MySQL. After
the installation, you may have to edit some confs to get MySQL to start
automatically at every boot. Thereafter, you can access the database
server be creating a user account for Mysql admin (root), plus unlimited
number
Use REPLACE instead. It is similar to the INSERT except that, it will
replace any old record that match - with the new one. A replace
statement may look like this:
REPLACE INTO TestTable (TestId, User) VALUES (007,Bond);
HTH
Babs
|| -Original Message-
|| From: Andy Ford
You can specify the date (Datetime or Timestamp) format when creating
table as follows:
Type=Format
-
DATETIME = -MM-DD HH:MM:SS
DATE = -MM-DD
TIME = HH:MM:SS
YEAR =
TIMESTAMP
---
TIMESTAMP(14) = MMDDHHMMSS
TIMESTAMP(12) =
Try ls to see whether safe_mysqld is in the directory and the run:
Safe_mysqld
Note! You have to be root to run the mysqld demon
HTH
Babs
-Ursprüngliche Nachricht-
Von: Don Dachner [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 15. April 2004 21:48
An: [EMAIL PROTECTED]
Betreff:
It should work if both columns are numerical. Say int, decimal, float,
double and so on.
Babs
-Ursprüngliche Nachricht-
Von: MYSQL [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 16. April 2004 01:50
An: mysql
Betreff: Query Question
Hi,
I am wondering if this is possible:
Say I have a
Why does MySQL accept this insert statement with a warning?
Insert into Sessions (id) values (20de8376640263673ea03938);
Query OK, 1 row affected.
I expected a warning because of the Token column shouldn't be NULL!
I have a table with three columns:
Id # int not null
Token # char (1)
What is NOT NULL good for, if Mysql will insert a default value?
I thought Mysql should warn: Column can't be NULL if no value is
provided.
Thanks anyway
Babs
-Ursprüngliche Nachricht-
Von: Martijn Tonies [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 14. April 2004 17:39
An: B
I'm using an older version of Mysql, and I know it doesn't support
trigger.
What I'm trying to do, is to delete records from 2 tables (Sessions
Cart).
These experimental statements didn't help:
DELETE FROM Sessions INNER JOIN Cart on Sessions.id where Sessions.id
=$id;
DELETE FROM Sessions
column.
Babs
-Ursprüngliche Nachricht-
Von: Michael Stassen [mailto:[EMAIL PROTECTED]
Gesendet: Mittwoch, 14. April 2004 18:21
An: Ruslan U. Zakirov
Cc: Keith C. Ivey; [EMAIL PROTECTED]; B. Fongo
Betreff: Re: NOT NULL column behaves strangely
Ruslan U. Zakirov wrote:
Keith C. Ivey wrote
Does MySQL provide a way of selecting a limited number of rows at
random? From a query that might return several rows, I want MySQL to
return six rows at random at each time.
For instance:
Select * from [table] where [condition];
200 rows (0.0 sec)
Now - I need 6 rows at random.
: Montag, 29. März 2004 14:59
An: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] Mysql. Com
Betreff: Re: Selecting rows at random
B. Fongo [EMAIL PROTECTED] wrote on 29/03/2004 13:54:54:
Does MySQL provide a way of selecting a limited number of rows at
random? From a query that might return several rows, I
Your grant statement give ltm all privileges on LTM and not on user. By
default, ltm is granted usage on user.
To see the privileges the user ltm has, try any of these two:
select * from db where user='ltmuser'\G;
show privileges for [EMAIL PROTECTED]
Select from db should show ltm having all
If I've understood you what I want, then MySQL time functions can help.
It is always possible to substract time with MySQL. So if you substract
the value of your column TIMESTAMP from current time, you will get all
records that are older than now. I can't try it now, but I believe
something in
.
-
-Ursprüngliche Nachricht-
Von: Peter Brawley [mailto:[EMAIL PROTECTED]
Gesendet: Samstag, 13. März 2004 06:40
An: B. Fongo; [EMAIL PROTECTED] Mysql. Com
Betreff: Re: Problem selecting from 3 tables
I'm having
I'm having trouble with sql statement to select from 3 tables.
The first column is in ProductsPics and the rest in Products.
(qq{SELECT PictureName, ProdName, Description, SalesPrice FROM Products
INNER JOIN
ProdCategory USING(CategoryNr) INNER JOIN ProductsPics
USING(ProdNr) WHERE
Hello again!
I was able to extra the information from the first 2 tables yesterday
using following query:
SELECT Customers.Name, Customers.City, Orders.Product,
Order.Price FROM Customers inner join Orders USING (cust_id) WHERE
customers.cust_id = 2
Roger!
Babale
-Ursprüngliche Nachricht-
Von: Roger Baklund [mailto:[EMAIL PROTECTED]
Gesendet: Samstag, 16. August 2003 14:32
An: [EMAIL PROTECTED]
Cc: B. Fongo
Betreff: Re: How many join do I need for a query on 3 table?
* B. Fongo
I was able to extra the information from the first 2
Hello!
I ' m trying to extra some information from 2 tables using inner join,
but receive an error warning. Am newbie so I' m not able to feature out
why my queries don't work.
Scenario:
I have 2 tables: Customers and orders. The have following structures:
Customers
10:14
An: [EMAIL PROTECTED]
Betreff: Re: Query with inner join (Help!)
B. Fongo [EMAIL PROTECTED] wrote:
I ' m trying to extra some information from 2 tables using inner join,
but receive an error warning. Am newbie so I' m not able to feature
out
why my queries don't work.
Scenario:
I
Hi!
I know older versions of MySQL do not support foreign keys. Find out
weather your version do. If not, you may have to do without the foreign
keys in your definitions.
Best regards
Babs
-Ursprüngliche Nachricht-
Von: Morten Gulbrandsen [mailto:[EMAIL PROTECTED]
Gesendet: Freitag,
21 matches
Mail list logo