Re: running sql commands from a shell

2002-01-17 Thread nod
On Thursday 17 Jan 2002 1:13 am, Mr Aaron Brandis wrote: Hi everyone This is the first time I have posted to this list and I was wondering if someone could answer my question. I know you can run commands from a shell prompt (such as unix...) like: shell mysql -e 'SELECT * FROM table'

Re: Not updating tables with data but no errors either

2002-01-17 Thread nod
On Thursday 17 Jan 2002 4:52 pm, fla wire wrote: Hello, I have a freebsd machine running mysql and php. Yes I am one of those newbies. I have read the FU*K manual. I have a sams learn in 21 day book. also a php essentials and build your own database drive book. I have a brazilian rain

Re: Tergat MySQL Studio

2002-01-17 Thread nod
On Thursday 17 Jan 2002 7:16 pm, Alok K. Dhir wrote: P.S. For those who haven't used Mascon, I highly recommend it. It's a terrific tool for managing MySQL databases the only thing I would say against it, is that it's a client not a server, and a larger organisation that needs to change

Re: MySQL newbie question

2002-01-16 Thread nod
On Wednesday 16 Jan 2002 7:36 pm, you wrote: Hello, and sorry for the bother with what is probaby a very simple problem. I'm new to MySQL. I have just installed RedHat 7.2 Linux, and installed the included distribution of MySQL, which is version 3.23.41 When I try to run the mysql program,

Re: tables_priv not working

2002-01-16 Thread nod
On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote: I can't get table-specific grants to work. snip Have you flush privileges ? - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: tables_priv not working

2002-01-16 Thread nod
On Wednesday 16 Jan 2002 8:50 pm, Hamlin Nicholas-qa568 wrote: On Wednesday 16 Jan 2002 8:35 pm, Hamlin Nicholas-qa568 wrote: I can't get table-specific grants to work. snip Have you flush privileges ? Yes. That didn't change it. I think I've got it, from the manual section 4.2.9 :-