Re: Recreate Table With Sorted Data

Embarrassingly simple answer to the question why I didn't just use a View ... I haven't gotten to that chapter in the manual yet. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

New Value From Concatenated Values?

Is there a way to update a table so that a column's values can be changed to a concatenation of two other column values? For instance, something like ... UPDATE TABLE tablename SET colA = colB.colC; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Recreate Table With Sorted Data

I have a table with 1600 student locks in random order. I would like them permanently sorted by the locker number they are assigned to. I assumed that ... ~ I would copy the table under a different name ~ Delete all records from this copy ~ Write a statement that would copy the records from the

RE: Find and Add Unmatched Records

ble pickThroughThenDelete; -Original Message- From: Baron Schwartz [mailto:[EMAIL PROTECTED] Sent: Friday, June 01, 2007 10:35 AM To: Kebbel, John Cc: mysql@lists.mysql.com Subject: Re: Find and Add Unmatched Records Hi John, Kebbel, John wrote: > I have a table of middle school students I

Find and Add Unmatched Records

I have a table of middle school students I want to update quarterly. I am only interested in finding and adding new students (not in finding and deleting students who have been dropped from the school district). I'm pretty sure I could put together a PHP script that would do this, but is there a My

RE: Moving Data between Tables

"I hope you're not about to try this for the first time on your production data :-) " I dumped the lockers table before beginning my experiments. If I had trashed lockers2 (my experimental file) in the process, I would have truncated it and re-inserted the 1492 records from my batch file.

Moving Data between Tables

I moved information about our school locks (serial numbers, combinations, student, etc) from FileMaker to MySQL into a table called lockers and wrote PHP pages so our teachers could record the locks returned at the end of the year. Unfortunately, I missed transferring close to 200 locks. I dup

Re: --xml or --html output to file

Dan and Paul, I develop at home on Ubuntu Linux and deploy at work over FreeBSD Unix (an iMac running OS 10.4). The command line tip you suggested worked fine on Linux, so I'm assuming that I can get it to run here at work as well when I get the time to try it. Thanks again. John "Another Brick

Categories of Users and Privileges

Up to this point, I have controlled MySQL privileges from Perl or PHP pages. All connections to the database used the same MySQL login. Ordinary users used pages that strictly controlled selections, insertions, or updates. Administrators/Developers used password-protected pages that all

RE: Permissions and Into Outfile

mysql home directory to some other folder? > -- > From: Gerald L. Clark > Sent: Friday, April 27, 2007 10:09 AM > To: Kebbel, John > Cc: mysql@lists.mysql.com > Subject: Re: Permissions and Into Outfile > > Kebbel, John wrote: > > I

Permissions and Into Outfile

I was trying to write the output of a select statement to a tab-delimited text file. I could not write the file to a folder inside /var/www or to my home file because of permission problems. After a moment's reflection, I realized /tmp had stuff written to it all the time, so its permi

What is /*!40101 SET @...

I've been developing Perl/ PHP and MySQL applications on a small scale for years, reworking my small core of knowledge over and over again. I recently decided to hit the books and shoot for certification as a MySQL CMDEV. Most of my questions have answers in my books and on web sites, but I occa