Latest Added Tutorials
17-02-2018
We can
Category Table
CREATE TABLE category
(
id INT AUTO_INCREMENT PRIMARY KEY,
name VARCHAR(50) NULL,
url VARCHAR(50) NULL,
parent INT NULL,
created_at TIMESTAMP NULL,
updated_at TIMESTAMP NULL,
deleted_at TIMESTAMP NULL,
resim VARCHAR(255) NULL,
kisaltma VARCHAR(255) NOT NULL,
CONSTRAINT category_category_parent_fk
FOREIGN KEY (parent) REFERENCES category (id)
ON DELETE SET NULL
)
ENGINE = InnoDB
COLLATE = utf8_unicode_ci;
CREATE INDEX category_category_parent_fk...Continue Reading
<tx:annotation-driven transaction-manager="transactionManager"/>
<bean id="transactionManager"
class="org.springframework.orm.hibernate4.HibernateTransactionManager">
<property name="sessionFactory" ref="sessionFactory"/>
</bean>
<bean id="sessionFactory"
class="org.springframework.orm.hibernate4.LocalSessionFactoryBean">
<property name="dataSource" ref="dataSource"/>
<property name="packagesToScan" value="com.codesenior.telif.local.model"/>
<property name="hibernateProperties">
<props>
22-01-2015
To set the default to UTF-8, you want to add the following to my.cnf or my.ini for Windows
[mysqld]
collation-server = utf8_unicode_ci
character-set-server = utf8
If you want to change the character set for an existing DB, you can use following code:
ALTER DATABASE databasename CHARACTER SET utf8 COLLATE utf8_unicode_ci;
ALTER TABLE tablename CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;...Continue Reading
23-12-2014
If you want to change some string content of a column, you can use REPLACE function as follow:
UPDATE urls
SET url = REPLACE(url, 'domain1.com/images/', 'domain2.com/otherfolder/')
urls: Table Name
url: Column Name
REPLACE function first parameter is column name, second parameter string value to be changed, and third parameter is new string value....Continue Reading
Embedding mysql into java application is not straightforward. Therefore, I will try to explain necessary operations step by step.
1. Download this library file then extract jar files into a folder.
2. Create a Java application and add downloaded jar files into the application lib folder
If you use maven application add following dependencies into pom.xml file......Continue Reading
24-06-2014
The transaction isolation levels in JDBC help us to determine whether the concurrently running transactions in a DB can affect each other or not. If there are 2 or more transactions concurrently accessing the same DataBase, then we need to prevent the actions of the transactions from interfering with each other. The above is achieved using the isolation levels in JDBC....Continue Reading