Posts Tagged ‘database’
How to find the Mysql database engine type
Posted by: Purab on: October 9, 2009
- In: MySql
- Leave a Comment
You need to use this command for checking the engine type:
SHOW TABLE STATUS WHERE Name = ‘users’;
Or Use this command for checking the all table’s engine type.
SHOW TABLE STATUS;
Or You can use this command for database:
mysqlshow –status db_name;
I used following URL for creating this commands:
http://dev.mysql.com/doc/refman/4.1/en/show-table-status.html
5 SHOW TABLE STATUS WHERE Name = ‘xxx’
ActiveRecord-JDBC is for use with JRuby only….
Posted by: Purab on: September 8, 2009
Few days back when i tred to run my rails project. I got an error saying
ActiveRecord-JDBC is for use with JRuby only
jdbc-mysql is only for use with JRuby
/usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:76:in `establish_connection’: Please install the jdbcmysql adapter: `gem install activerecord-jdbcmysql-adapter` (no such file to load — java) (RuntimeError)
from /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:60:in `establish_connection’
from /usr/lib/ruby/gems/1.8/gems/activerecord-2.3.2/lib/active_record/connection_adapters/abstract/connection_specification.rb:55:in `establish_connection’
from /usr/lib/ruby/gems/1.8/gems/rails-2.3.2/lib/initializer.rb:417:in `initialize_database’
from /usr/lib/ruby/gems/1.8/gems/rails-2.3.2/lib/initializer.rb:141:in `process’
from /usr/lib/ruby/gems/1.8/gems/rails-2.3.2/lib/initializer.rb:113:in `send’
from [...]
Mysql table types
Posted by: Purab on: February 15, 2008
- In: MySql
- Leave a Comment
As of MySQL 4.1, the list of table types is available directly through the SHOW TABLE TYPES statement:
mysql> SHOW TABLE TYPES;
+——–+———+———————————————————–+
| Type | Support | Comment [...]
Add This page
Recent Comments