Search Results

Content Management Systems (CMS) are web programs that make it easier to add and update content on web sites. Instead of learning HTML, FTP and web server commands, once a CMS is set up and a template “look” is defined, others can usually add material very eas...

MySQL is a free, open-source relational database that has been used in thousands of websites, large and small. This is a contributed collection of resource links on MySQL. Feel free to add your favorites. Mike Franks – SSC Collection of Mysql links and arti...

Although phpMyAdmin is an excellent tool for administering MySQL databases, you don’t want to expose your MySQL usernames and passwords to sniffing over the wire by sending them “in the clear.”The solution, if you are running https, is to simple edit the confi...

mysqlshow has a tricky feature that interprets SQL wildcard characters (*,?,%,_) as wildcards if they appear in the last argument you give it. While the first 3 characters don’t get used much (if at all) in naming databases, the underscore is a common word sep...

mysqlshow is a command-line tool included with standard MySQL distributions, similar to mysqladmin or other tools. mysqlshow is used to show summary information about databases and tables.Here is its basic usage:mysqlshow [OPTIONS] [database [table [field]]]Th...

MySQL lets you replace all occurrences of a character or string of characters in a table with some other character or string.UPDATE table SET field1 = REPLACE(field1, 'replace_that', 'with_this'), field2 = REPLACE(field2, 'and_that', 'with_this')As an example,...

Unfortunately, DBDesigner4 is written in Delphi, which is practically Windows-only, so there is not and probably will not be a Mac OS X version. Also, no other applications are able to show diagrams in this format.DBDesigner is replaced by MySQL workbench. It ...

addslashes() escapes single quote (’), double quote ("), backslash (\) and NUL (\x00).mysql_escape_string() and mysql_real_escape_string() escapes the characters above plus: CR (\r), LF (\n) and EOF (\x1a). Apparently (according to the manual), MySQL wants the...

By default MediaWiki uses MySQL and the default FULLTEXT indexing uses built-in stop words and a minimum word length of four. A list of the stop words is available but are the usual thing (the, and, one_, etc.). You can set your own stop words by setting the f...

We were in search of a good survey tool, and after some research came upon LimeSurvey (www.limesurvey.org). We found it extremely easy to set up and use and allowed for professional surveys with features commonly found in commercial products.The following lis...

What are they and why using oneInformation retrieval libraries are software libraries that provides functionality for searching within databases and documents within them. In particular, this often refers to searching text document for combinations of words an...

Using ODBC it is possible to connect Microsoft Access (or OpenOffice) to a MySQL database. Access or OpenOffice can even be used as “front end” to MySQL.The “MySQL Connector/OBDC” drivers are available at: <http://dev.mysql.com/doc/refman/5.0/en/connector-o...

Useful survey of NoSQL (and SQL) technologies and a summary of the philosophy…http://blog.heroku.com/archives/2010/7/20/nosqlTaken from email by Jose Hales-Garcia to Campus Web Publishers List

Please add other helpful links:SQL joins: a visual explanationhttp://www.codinghorror.com/blog/2007/10/a-visual-explanation-of-sql-joins.html

By default, if you make any changes to table rows, there is an annoying 2-step confirmation dialog when you click Apply. It also prevents you from doing many mass UPDATEs and DELETEs (this is called ‘Safe Updates’).Safe Updates is a good idea in principle, sin...

My name is Alex Podobas and I’m a member of the UCLA IT Security Office. My IT security work at UCLA involves an ample amount of code review and writing web applications and I use OS X as my primary, day-to-day operating system. Recently, I wiped my computer a...

Many popular Content Management Systems (CMS) run in a php/mysql environment. Their dynamic nature makes traditional develop on workstation and upload less useful, and editing live on the server is not always desirable. Luckily there are straightforward ways...