Showing posts with label MySql. Show all posts
Showing posts with label MySql. Show all posts

Thursday, December 28, 2006

Mysql Decimal Precisin Scale - Doesn't work

In Rails Migration scripts if a table column is defined as
t.column :my_decimal_column, :decimal, :precision =>8, :scale =>2, :default =>0.00, it would result with a column decimal(10,0) in Mysql db. The problem is with the current stable rails. With Edgerails, it will work.

Visit EdgeRails at http://wiki.rubyonrails.com/rails/pages/EdgeRails

A work aroung for this could be, in your migration script use:

execute "alter table my_table modify column my_decimal_column decimal(8,2)" instead.

Monday, December 25, 2006

Parallels Windows TOAD + Ubuntu - MySql


1. Install SSH server for remote access
sudo apt-get install ssh

2. Install MySql database server
sudo apt-get install mysql-server

3. Install Apache HTTP Server
(as super user, otherwise you might get into problem with domain name as at after installation it says:
Could not determine the server's fully qualified domain name, using 127.0.1.1)
sudo apt-get install apache2

3.1 Test apache installation by pointing browser at http://localhost or http://yourcomputername

4. Install PHP for Apache HTTP server
sudo apt-get install php4

5. MySql for Apache HTTP server
sudo apt-get install libapache2-mod-auth-mysql
sudo apt-get install php4-mysql