-- Replace a word or string in a column UPDATE my_table SET my_column = REPLACE(my_column, 'Old string', 'New string'); --
Category Archives: MySQL
Convert CSV to SQL
This tool is fantastic!
It saved me many hours of work, when I had complex CSV files I needed to turn into SQL tables
http://www.convertcsv.com/csv-to-sql.htm
(PHP) Simple gallery with thumbnail generation
This is an enhanced version of this
It’s a VERY simple php gallery. You could develop it in any direction. This one only supports jpg, but that could be augmented as well.
Here’s what it does:
- Allows the user to choose an image and enter a title (or caption).
- Uploads the image to a folder on the server.
- Creates a thumbnail
- Enters the filename and caption in a MySQL database.
- Output all the images.