Mysql

• Book Review: Learning PHP & MySQL - Step-by-Step Guide to Creating Database-Driven Web Sites by Michele Davis and Jon Phillips

  2008-02-08 17:22:00

  A review I wrote for BlogCritics. First I must say that I was really excited to review Learning PHP & MySQL: Step-by-Step Guide to Creating Database-Driven Web Sites. My HTML skills have grown greatly over time and I am able to maintain a few HTML driven websites with a minimum of hassle and effort. I have limited time and little desire to immerse myself in any web development, but have been enamored by PHP and the database driven MySQL and the website functionality they promise. So when I saw the book described by the publisher as "perfect for newcomers to programming as well as hobbyists who are intimidated by harder-to-follow books," and "If you ... know your way around HTML, Learning PHP & MySQL is the book you've been looking for," I thought this could be the perfect opportunity to learn something useful and write a review at the same time.But after reading the book, downloading the software, and trying to follow what was presented, I know no more about how to use PHP & MySQL
• OScommerce Store Breaks with Mysql5 - MySQL 5.0 Compatibility

  2008-01-18 09:09:00

  Hello Members!I was trying to transfer Open Source Oscommerce from mysql 4 to mysql5 and came to know well known issue of Left Joints!If you face this type of issue while doing Oscommerce Customization with Mysql 5, you can use these steps to make it work with Mysql5, This type of problems can also come in Creloaded and OSCmax which produce error 1064Here are steps to fix the issue in PHP Files as well as some in mysql database!Problem: MySQL 5.0 introduces Server SQL modes as part of its SQL 2003 standards support, and uses a more stricter approach to executing SQL queries. This is performed by default with setting STRICT_TRANS_TABLES as a Server SQL mode. Due to this new setting, MySQL fails on certain SQL queries and produces error messages on the screen. Solution: Lines 213-223 in advanced_search_result.php must be changed from: $from_str = "from " . TABLE_PRODUCTS . " p left join " . TABLE_MANUFACTURERS . " m using(manufacturers_id) left join " . TABLE_SPECIALS .
• Sun going to acquire MySQL for $1 billion

  2008-01-16 19:48:10

  MySQL AB, the Swedish company behind the popular MySQL open-source database management system, has agreed to be bought out by Sun Microsystems for $1 billion in cash and options. The Scandinavian firm's database software has become a cornerstone of the modern Web, and it's often used in conjunction with the Linux operating system, Apache web server software, and PHP web scripting software as part of the so-called "LAMP" software stack. MySQL users range from lone bloggers to firms like Google, Baidu, Nokia, and Facebook. The acquisition is scheduled to be completed in the late first quarter or early second quarter, at which point MySQL AB will be swallowed into Sun's Software, Sales, and Service organizations, and its CEO, Finnish IT industry veteran Marten Mickos, will become part of Sun's senior executive leadership team. Sun will pay a total of $800 million in cash and $200 million in stock options for the company.Thanks to the acquisition, Sun says it will gain a significant footho
• Windows - Take control of your Apache and MySQL startup with batch file

  2007-12-03 02:06:00

  As default, Apache and MySQL are loaded automatically when windows start if you install it on your windows box. Some computer with less memory will have trouble with their start up time caused by many application windows call upon starting up including Apache and MySQL.If you are web designer and your computer not as a web server, you may want to set Apache and MySQL start up by manual (unless your computer are set for a web server), by change it to manual at windows services will increasing windows start up time a little bit, but you will have to start the Apache and MySQL manually every time you want to use it.You can go directly to windows services or can write a command line in a dos prompt for starting Apache and MySQL.dos command:service start apache2
• Windows - Take control of your Apache and MySQL startup with batch file

  2007-12-03 02:06:00

  As default, Apache and MySQL are loaded automatically when windows start if you install it on your windows box. Some computer with less memory will have trouble with their start up time caused by many application windows call upon starting up including Apache and MySQL.If you are web designer and your computer not as a web server, you may want to set Apache and MySQL start up by manual (unless your computer are set for a web server), by change it to manual at windows services will increasing windows start up time a little bit, but you will have to start the Apache and MySQL manually every time you want to use it.You can go directly to windows services or can write a command line in a dos prompt for starting Apache and MySQL.dos command:service start apache2
• Ruby ActiveRecord and MySQL

  2007-08-02 12:52:13

  A lot of you, the readers of my Free Ruby Study Notes, wrote in asking for a simple program and a brief explanation on how to connect to a MySQL database using Ruby and ActiveRecord. I just sat down and added the page Ruby ActiveRecord and MySQL to my RubyLearning site. Have a look. Technorati Tags: [...]
• Ruby MySQL Tutorial

  2007-05-14 05:44:21

  This brief Ruby MySQL Tutorial shows you how you can connect to MySQL in Ruby. MySQL support in Ruby was made possible by Tomita Masahiro. He has developed a pure Ruby binding called Ruby/MySQL. We need to install the same on our PC and the installation (you need to be connected to the internet and it takes some time) is as shown below: C:>gem install mysql Bulk updating Gem source index for: http://gems.rubyforge.org Select which gem to install for your platform (i386-mswin32) 1. mysql 2.7.1 (mswin32) 2. mysql 2.7 (ruby) 3. mysql 2.6 (ruby) 4. mysql 2.5.1 (ruby) 5. Cancel installation > 1 Successfully installed mysql-2.7.1-mswin32 Installing ri documentation for mysql-2.7.1-mswin32... Installing RDoc documentation for mysql-2.7.1-mswin32... C:> This installs mysql-2.7.1-mswin32 driver which is faster and supports MySQL 4.1 and later. The documentation for this driver is here. I will assume that you’ve already installed mySQL 4.1 or above on your PC and that
• Connect JRuby to MySQL using JDBC

  2007-05-05 05:05:29

  JRuby is a 100% pure-Java implementation of the Ruby programming language that runs in the JVM. MySQL is a one of the most popular open source databases around and is used by many prominent organizations from Yahoo to NASA. This brief tutorial demonstrates how to install and configure JRuby to connect to the MySQL database. The tutorial is written for beginners who are familiar with Java code and JDBC. Exposure to Ruby will make the syntax easier to follow. You don’t need any specific integrated development environment (IDE) or tool knowledge. Familiarity with a text editor and setting environment variables is required. The tutorial assumes that your Java, JRuby and MySQL 4.1+ environment is successfully installed and configured. Creating a Database and User Again, I am assuming that you have MySQL running and are familiar with the basics. Run the mysql client program from the command line (as shown below) so that we can execute some administration commands. C:/mysql/bin> mys