User Login

Please enter user name and password into following boxes!

If you are not registered yet, please click

Forget Password

If you forget your password, please click

mysql

  • Managing Hierarchical Data in MySQL And Php

    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

    Spring, Hibernate, Ehcache, C3P0 And Hibernate Search Configuration

    <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>

    Change MySQL default character set to UTF-8

    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

    Mysql Replace Function Usage

    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

    How To Embed Mysql Database Into Java Application

    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

    Transaction Isolation Levels

    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