RE: GRANT to DB access

2004-05-05 Thread B. Fongo
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

FW: Help with a basic question I can't seem to find an answer.

2004-04-29 Thread B. Fongo
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

RE: update if insert fails

2004-04-23 Thread B. Fongo
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

RE: Datetime format in MySQL

2004-04-22 Thread B. Fongo
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) =

AW: command not found: trying to start mysql

2004-04-15 Thread B. Fongo
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:

Query Question

2004-04-15 Thread B. Fongo
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

NOT NULL column behaves strangely

2004-04-14 Thread B. Fongo
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)

AW: NOT NULL column behaves strangely

2004-04-14 Thread B. Fongo
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

Using 1 statement to delete from 2 tables

2004-04-14 Thread B. Fongo
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

AW: NOT NULL column behaves strangely

2004-04-14 Thread B. Fongo
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

Selecting rows at random

2004-03-29 Thread B. Fongo
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.

AW: Selecting rows at random

2004-03-29 Thread B. Fongo
: 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

RE: mysql.user does not reflect privileges granted correctly?

2004-03-25 Thread B. Fongo
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

AW: retrieving last record for all distinct users

2004-03-20 Thread B. Fongo
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

AW: Problem selecting from 3 tables

2004-03-13 Thread B. Fongo
. - -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

Problem selecting from 3 tables

2004-03-12 Thread B. Fongo
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

How many join do I need for a query on 3 table?

2003-08-16 Thread B. Fongo
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

AW: How many join do I need for a query on 3 table?

2003-08-16 Thread B. Fongo
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

Query with inner join (Help!)

2003-08-15 Thread B. Fongo
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

AW: Query with inner join (Help!)

2003-08-15 Thread B. Fongo
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

AW: I simply can't compile this

2003-08-15 Thread B. Fongo
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,