By the way, I am using 4.0.18-log on i686.linux2.6.10.
Greetings,
I did the following two explain select ... According to whether I put
the single quotation mark or not, I will get totally different results:
1. Without single quotation mark:
explain SELECT * FROM test T1 force index
Greetings,
I did the following two explain select ... According to whether I put
the single quotation mark or not, I will get totally different results:
1. Without single quotation mark:
explain SELECT * FROM test T1 force index (idx_test)
WHERE *T1.STUDID = 099 AND T1.Prog_link =
Hello,
I have a question about column name case sensitive. Currently, we use
MySQL 3.23.32 running on Linux.
I am trying to use JDBC to get email from table T1
T1(
id char(3),
name varchar(12),
Emailvarchar(16)
)
Now If I say,
try{
...
String email =
getString(email);
Hello,
I have a question about column name case sensitive. Currently, we use
MySQL 3.23.32 running on Linux.
I am trying to use JDBC to get email from table T1
T1(
id char(3),
name varchar(12),
Emailvarchar(16)
)
Now If I say,
try{
...
String email =
Hello all,
I have a datatype question.
When there is column named ID, users are able to give it either char(11)
or int(11).
Please advise, which type is better such as more secure, save space,
etc? Or it dose not matter at all?
Kind regards,
Ying
--
MySQL General Mailing List
For list