Menu

Primary Menu

Skip to content
  • Home
  • Talks
  • Software
  • About
  • Disclaimer / Impressum
    • Privacy Tools
    • Privacy Policy
Show Header Sidebar Content
GitHub LinkedIn

Carsten Windler

Don't just code - develop with passion

Category: MySQL

Display content of blob column as plain text

Posted onApril 23, 2014

Reading Time: < 1 minutes Sometimes it can be useful to have the content of MySQL blob columns displayed as plain text. There’s a pretty easy way to do this: [sql]SELECT CONVERT(my_blob_column USING utf8) AS plain_text_from_blob FROM my_table; [/sql] Yes, Read More …

CategoriesMySQL, UsefulTagsBlob, MySQL, Plain Text

How to use the MySQL GUI client HeidiSQL with a remote DB server

Posted onJanuary 27, 2014January 27, 20143 Comments

Reading Time: < 1 minutes Most IDEs nowadays work nicely with remote servers. But how about MySQL? phpMyAdmin is ok when you only have to use it once in a while, but a pain in the a… for everyday work. Read More …

CategoriesMySQL, PHPTagsMySQL SSH HeidiSQL

Helpful MySQL shell tricks

Posted onSeptember 18, 2013Leave a comment

Reading Time: < 1 minutes Although I’m Windows user most of the time, I have to take care of some projects on Linux boxes, so it’s good to have at least a little knowledge of what you’re doing there. The Read More …

CategoriesLinux, Webservers etc., MySQLTagsLinux shell, MySQL

Cover of the book Clean Code in PHP by Carsten Windler
Clean Code in PHP
Expert tips and best practices to write beautiful, human-friendly, and maintainable PHP

My first book—get your copy at

Amazon
Packt Publishing

Categories

  • Articles
  • Books
  • Climate change
  • Composer package
  • Extbase
  • Flow3
  • Gear
  • Green IT
  • isset($theRest[$i])
  • JavaScript
  • Linux, Webservers etc.
  • MySQL
  • PHP
  • Podcasts
  • Software Development
  • Software Quality
  • Software Testing
  • Talks
  • Tools
  • Typo3
  • Uncategorized
  • Unit Tests
  • Useful
  • Windows
  • Zend Framework 2

Recent Posts

  • How to write Coding Guidelines in PHP
  • Clean Code in PHP – My first book
  • Coding against climate change // code.talks 2022
  • New articles about Green IT
  • International PHP Conference Munich 2021

Tags

apache Cache Climate change composer Conference Console cwenvbanner cwmobileredirect Extbase Extension Frameworkless Frameworks Linux Linux shell Module MySQL Node.js Notebook OOP ownCloud PhantomJS PHP phpStorm PHPUnit php_admin_flag php_flag Podcast Profiling Refactoring Refurbished Routing ServiceManager Software Development Software Quality Talk Talks Technical Debt Typo3 Unit Tests vhost WAMP Windows XAMPP XDebug ZF2

Get connected!

GitHub LinkedIn
Copyright © 2023 Carsten Windler. All Rights Reserved. Privacy Policy
Clean Box by Catch Themes
Scroll Up
  • Home
  • Talks
  • Software
  • About
  • Disclaimer / Impressum
    • Privacy Tools
    • Privacy Policy