[Author: Dingyu] [Thu, 2015-01-15, 11:16] [1319 views]
Please click below link to see details:
http://dev.mysql.com/doc/refman/5.7/en/storage-requirements.html ... see full article
[Author: lzhang] [Wed, 2014-04-09, 15:21] [2425 views]
1 Java connection to MySQL
To start, let us work on a simple java application(no web) connected to MySQL database(other database will be similar).
Software needed:
Java http://www.oracle.com/technetwork/java/javase/downloads/jdk7-downloads-1880260.html
MySQL http://dev.mysql.com/down ... see full article
[Author: Dingyu] [Sun, 2013-10-20, 15:03] [1820 views]
# Start MySQL Service on Windows with Windows Command Prompt
net start MySQL
# Stop MySQL Service on Windows with Windows Command Prompt
net stop MySQL
# Start and Stop other Windows Service with Windows Command Prompt
net start ServiceName
net stop ServiceName ... see full article
[Author: ming.lian] [Sun, 2013-08-11, 17:47] [3731 views]
In ruby on rails, if you need to set a column with auto-increment, you have to execute a SQL command in your model.
Alter table Tablename modify column ColumnName int(11) auto_increment; ... see full article
[Author: ming.lian] [Sun, 2013-08-11, 17:47] [2431 views]
MySql默认是以primary key作为clustered index,如果没有primary key的话,就以第一个unique index column作为clustered index,不需要单独建clustered index。
但是Ruby on Rails默认以自动生成的id作为primary key。所以如果你不想用自动生成的id作为primary key,则需要在ruby on rails里手动声明primary key。
代码如下:
create_table :table_name, :id => false do |t|
t.integer :column_1 ... see full article
[Author: Dingyu] [Sun, 2013-08-11, 17:46] [1577 views]
If you wish to change your password by yourself but you don't have the SUPER privilege, below process may help you.
Suppose that:
Your MySQL username is Nickname
Your current MySQL password is OldPassword
You wish to change your password to NewPassword
1. Log into the MySQL
If you are logging into ... see full article
[Author: Dingyu] [Sun, 2013-08-11, 17:44] [2682 views]
I know two ways to find records with non-printable characters in T-SQL. The first way, use the "like" statement to do it:
SELECT * FROM tableName
WHERE (columnName COLLATE Latin1_General_BIN2) like '%[^' + CHAR(32) + '-' + CHAR(126) + CHAR(9) + CHAR(10) + CHAR(13) + ']%'
The second way, use the "PAT ... see full article
[Author: Dingyu] [Sun, 2013-08-11, 17:43] [4120 views]
In Rails 3, the primary key in a database table is very important. Rails model ActiveRecord functions, like save, destroy, update_attributes, and so on, require it to invoke callbacks. Rails 3 uses the column 'id' as a default primary key in a database table. However, in MySQL, only the primary key ... see full article