Practice makes perfect. Or in my case, any practice is a start. This article serves as a quick note on how to use regular expressions within SQL statements:
For the following examples, I am pretending to select rows from a table called `STUDENTS`.
A quick reminder on basic regular expressions.
Match Any Character Dot
The dot operator '.' matches any single character in the current character set. For example, to find the sequence--'a', followed by any character, followed by 'c'--use the expression:
I was going to append this to one of my articles on anti-sql injection but as this may undergo some revisions, I'll give it it's own page.
The following PHP code accepts a username and password login and demonstrates how to check against the database without including text that the website visitor submits.
This is an article to remind me how to modify a column in a database table the old fashioned way (as in stop making me use GUI interfaces so poorly programmed when even I've made better DBMS tools).
- -- Add a column to an existing table (giving it datatype char(2) and allowing NULL)
- ALTER TABLE myTable ADD myColumn CHAR(2) NULL
- -- Delete a column
- ALTER TABLE myTable DROP COLUMN myColumn
- -- Reorder a column
- ALTER TABLE myTable MODIFY COLUMN misplacedColumn AFTER otherColumn;
So this is a quick article on how to install the mySQL add-on for Oracle SQL Developer v3.0.04.
I've used various mySQL administration tools to manage mySQL databases over the years, all freeware until someone expresses an interest in using it and then the supplier will implement restrictions and trial based versions. Oracle SQL Developer is currently free at time of print (01-FEB-2013).
I also need to use Oracle databases in my day job so the Oracle SQL developer is already a pre-approved software for our work computers. We have SQL Server Management Studio (SSMS) as well for our SQL Server instances but it wasn't practical to link this to mySQL databases.