MySQL export.

http://www.tutorialspoint.com/mysql/mysql-database-export.htm http://www.ehow.com/how_8553774_export-insert-statements-mysql.html Also see mysqldump — A Database Backup Program To dump the SCHEMA: http://www.howtogeek.com/howto/programming/mysql/dump-just-the-table-structure-to-a-file-in-mysql/ http://www.mydigitallife.info/how-to-backup-and-restore-export-and-import-mysql-databases-tutorial/

Read More →

MySQL BLOB.

http://www.easywayserver.com/blog/java-upload-image-in-database/ http://www.java2s.com/Code/Java/Database-SQL-JDBC/InsertpicturetoMySQL.htm /* Defining the Table: Oracle and MySql create table MyPictures ( id INT PRIMARY KEY, name VARCHAR(0), […]

Read More →

sql-error-codes.xml

<?xml version="1.0" encoding="UTF-8"?> <!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"> <!– – Default SQL error codes for well-known databases. – […]

Read More →

MySQL CLOB update.

declare configVar varchar2(32767) := '<applicationList> CLOB DATA GOES HERE </applicationList>'; begin update DB.table t set t.field = configVar where […]

Read More →

TO_DATE

update TABLE set FIELD = to_date('04/05/2010 16:55:00','mm/dd/yyyy hh24:mi:ss') where ID = '24'; commit; ================================================= select ID, to_char(FIELD, 'HH24:MI:SS') as […]

Read More →

dbForge Devart – QBytesWorld DB png

dbForge Devart for MySQL http://www.devart.com/dbforge/mysql/studio/ dbforgemysql400beta.exe (20.39 mb) dbforgemysql360beta.exe (15.65 mb) dbForge.Studio.for.MySQL.v3.60.347.Cracked-NGEN.rar (16.05 mb) dbforgemysqlfree.exe (17.76 mb) qbytesworld.sql (26.90 […]

Read More →

Tag Cloud