Problem with Creating table With MYSQL

Rails
1

I have one question

Shall I create a table with uppercase in Mysql from ruby on rails.

becoz whatever iam giving the tablename only table creation format like
1.lowercase
2.underscore
3.plural

example

tab_names .

shall i change tab_names—>TABNAME…??

is it rails default or possible to change???

please provide the answer…

2

On 13 July 2015 at 13:23, Sasi R. [email protected] wrote:

tab_names .

shall i change tab_names—>TABNAME…??

is it rails default or possible to change???

If you are using Rails why would you want to do that? Rails performs
a lot of its magic by having default rules that allow it to work out
what you want without you having to tell it all the details. For
example, if you want to handle comments then the model class is
Comment, the table name is comments, the controller is
CommentsController, etc. It is possible to override all these but if
you want to get the maximum out of Rails then don’t, unless you have a
specific problem that you need to address.

Colin

3

There is no technical issue.

becoz my client asking need to set all the database tablename with
uppercase letter thats’y we are asking.

4

On 13 July 2015 at 14:40, Sasi R. [email protected] wrote:

becoz my client asking need to set all the database tablename with
uppercase letter thats’y we are asking.

When replying please quote the previous message so that we can see
what you are replying to. This is a mailing list not a forum, though
you may be accessing it via a forum like interface. Thanks.

Have you asked why he/she wants to do that?

As far as I know you can just use, in the migration,
create_table :ANYNAMEYOULIKE
but I have not tried it.

Colin

5

9.2.2 Identifier Case Sensitivity (MySQL documentation)
https://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
Read about 'lower_case_table_names
https://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_lower_case_table_names
’

6

ok thanks

7

Maybe, table name aliasing might come in handy. The main problem that I
foresee is that when migrating from mysql to some other, you have to be
conscious about the aliases. The same holds true when you are creating a
table. But then, rails migration dsl might provide you with a
consistent
way of doing this.
Hope this helps.

Vineeth.