Re: newbie question.

2002-04-16 Thread Craig Ostrander
to the security tables. If you have full access, check out: http://www.mysql.com/doc/P/r/Privilege_system.html and http://www.mysql.com/doc/U/s/User_Account_Management.html Hope this helps! Craig Ostrander At 10:30 AM 4/16/2002, you wrote: >Hi everbody, > >Super newbie question here, &g

Re: Newbie question: Create table from query or export query

2002-04-15 Thread Craig Ostrander
INTO TABLE existingtablename; There are many variations on these themes, but this should get you pointed in the right direction. Hope it helps. Craig Ostrander At 06:38 AM 4/15/2002, you wrote: >Hi > >Is it possible to create a new table from the results of a query, or export >the result d

Re: Transferring Databases

2002-04-13 Thread Craig Ostrander
hat's it! Hope it helps. Craig Ostrander At 07:56 PM 4/13/2002, you wrote: >Hi-- > >I'm trying to transfer information from a MySQL database on one server to a >MySQL database on another server. > >I am using PHPMyAdmin. > >For small tables in the database, n

Re: search pattern matching

2002-04-10 Thread Craig Ostrander
would all cause problems using this simplified method (not to mention terms in other languages). select * from TABLENAME where if(right(SEARCHFIELD,1)='s',left(SEARCHFIELD,lenth(SEARCHFIELD)-1),SEARCHFIELD) like '%SEARCHTEXT%' Hope this sheds some light on it! Craig Ostra