Hello.
What about this:
mysql> show variables like 'lower_case_%';
++---+
| Variable_name | Value |
++---+
| lower_case_file_system | OFF |
| lower_case_table_names | 0 |
++
Hi,
Is there any way to check value of of 'lower_case_table_names'? I need
to an equivalent of (MS Sql Server statement)
exec sp_server_info @attribute_id=16
Thank you,
Sunil Vishwas
At 13:23 + 5/1/04, shaun thornburgh wrote:
Hi,
I am trying to set the mysql variable lower_case_table_names to 2,
however I am having serious difficulties!
I understand I need to do this at the command line but I have tried
the following (with many variations) without success:
C:\mysql
Hi,
I am trying to set the mysql variable lower_case_table_names to 2, however I
am having serious difficulties!
I understand I need to do this at the command line but I have tried the
following (with many variations) without success:
C:\mysql\bin>mysqld --SET-lower_case_table_name
experiencing with this new
lower_case_table_names variable introduced in 4.0.17 and modified in 4.0.18.
So much so that I can't upgrade to 4.0.18 at all.
Here is the startup log from a 4.0.18 mysqld:
040227 02:00:22 mysqld started
040227 2:00:22 Warning: Setting lower_case_table_na
There seems to be some issues we are experiencing with this new
lower_case_table_names variable introduced in 4.0.17 and modified in 4.0.18.
So much so that I can't upgrade to 4.0.18 at all.
Here is the startup log from a 4.0.18 mysqld:
040227 02:00:22 mysqld started
040227 2:00:22 Wa
All,
I am trying to set lower_case_table_names to 1 in my RPM
Red Hat installation. I have added the following entry to my.cnf:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
lower_case_table_names=1
However, once that mysqld starts, it dies
) converts all
> table and column names in its SELECT statements to uppercase.
>
> Since MySQL is case-sensitive on Unix, I added the statement
> set-variable = lower_case_table_names=1
> to /etc/my.cnf. However, statements like
> SELECT COLUMN FROM TABLE;
> still fail wit
ppercase.
Since MySQL is case-sensitive on Unix, I added the statement
set-variable = lower_case_table_names=1
to /etc/my.cnf. However, statements like
SELECT COLUMN FROM TABLE;
still fail with error 1146, while
SELECT COLUMN FROM table
works. It seems that lower_case_table_names is not uti
OK, so I'm on a slightly older version for this experiment (3.23.36)..
I tried restarting mysqld with the line
set=lower_case_table_names=1
in my my.cnf (on RedHat 7.1), and have a table called "ipaddr" in my
database (the files are ipaddr.frm, ipaddr.MYD and ipaddr
AIL PROTECTED]]
Sent: Wednesday, June 27, 2001 12:38 AM
To: [EMAIL PROTECTED]
Subject: lower_case_table_names issue
Hi to all,
I'm new to linux and mySql (about 5 days and nights :)), I have mandrake8.0
that provide a version of MySql which I'm trying to use from a VisualBasic
application (o
Did you convert the table/column names to lower case? If
"lower_case_table_names is=1" MySQL will convert all table names to lower
case on storage and lookup ... but you need to first convert your old table
names to lower case before starting mysqld.
If you have not done so, you sho
ich I need to be case
insensitive on queries, after reading the manual I found that I could use
the variable 'lower_case_table_names=1' to this prupose. I set the variable,
but when I try to select something MySQL returns a error 'database.MyTable
does not exist', but she exists w
Hiya,
I'm running MySQL 3.23.36 on my Windows 2000 workstation and I noticed
that all table names are converted to lowercase by default??? After some
going through the docs I found the following setting:
lower_case_table_names
So I figured I add:
lower_case_table_names=0
to my
[EMAIL PROTECTED] writes:
> lrwxrwxrwx 1 root root 11 Jan 19 13:28 /usr/lib/libc.so -> ./libc
> .so.1
> -rwxr-xr-x 1 root bin 1135056 Jul 20 2000 /usr/lib/libc.so.1
> Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Offici
> al MySQL binary'
lrwxrwxrwx 1 root root 11 Jan 19 13:28 /usr/lib/libc.so -> ./libc
.so.1
-rwxr-xr-x 1 root bin 1135056 Jul 20 2000 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Offici
al MySQL binary' --with-extra-charsets=complex --enable-a
16 matches
Mail list logo