Recent Posts Tagged With 'database'

• How Do I Get Meta Data From MySQL Using PHP?

  Posted on Tuesday May 20th, 2008 at 12:40 in php, MySQL, tutorials, database

  I know you’ve all asked that question before, right? Well maybe not, but I recently had the need to detect what the DATATYPE for arbitrary columns in arbitrary tables were inside a MySQL database using PHP. Turns out that it isn’t all tha...

• Calling A Stored Procedure In Java With A Blob Field

  Posted on Tuesday April 8th, 2008 at 12:45 in sql, java, tutorials, database, software engineering

  Here is the situation. You are writing a program in Java. You need to access data in a Microsoft SQL Server via stored procedure and the data has an XML field. A what field? SQL Server 2005 introduces a new datatype for XML. It is essentially a blob ...

• How Can I Recover My Lost MySQL root Password?

  Posted on Tuesday April 1st, 2008 at 10:13 in web development, tutorials, database, operating systems

  Many people use the MySQL open source relational database server. Mostly for websites, but I’ve also seen it used elsewhere. One problem that I recently ran into with my local development installation is… “what was my root password ...