Skip to main content

Home/ Software Tutorials for Visual Learners/ Group items tagged mysql

Rss Feed Group items tagged

Filter: All | Bookmarks | Topics Simple Middle
adie afton

MySQL 5.5 Milestone 2 improves replication and stored procedures - 0 views

sqlserver-guide.blogspot.com/...l-55-milestone-2-improves.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    The MySQL developers have released milestone 2 of MySQL 5.5, on the path to a general release in mid-2010. The new milestone release incorporates semi-synchronous replication in MySQL 5.5 based on patches to InnoDB developed by Google.
adie afton

MySQL 5.0 New Features: Data Dictionary - 0 views

sqlserver-guide.blogspot.in/...-features-data-dictionary.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    MySQL now has a new "database" named INFORMATION_SCHEMA. It is a virtual database only; there will never be a need to create a file by that name, and the MySQL server itself creates and populates the tables therein.
adie afton

How To Process MySQL Timestamp in PHP - 0 views

sqlserver-guide.blogspot.com/...ss-mysql-timestamp-in-php.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    Many of us do not realize that MySQL's Timestamp is not the timestamp which PHP date() understands. In fact if you try to use MySQL timestamp directly in php date() function then you will get totally wrong dates. There is a simple way to use MySQL timestamp data in php.
adie afton

MySQL 5.0 New Features - 0 views

sqlserver-guide.blogspot.com/...mysql-50-new-features.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    MySQL user who wants to know "what's new" in version 5. The short answer is "stored procedures, triggers, views, and information schema". The long answer is the MySQL 5.0 New Features series, and this book is the third in that series.
adie afton

MySQL SQL Delete Notes - 0 views

sqlserver-guide.blogspot.in/...mysql-sql-delete-notes.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    To delete duplicates from a MySQL database table I normally copy the duplicate data first to a temporary table and then use the copied id's to delete from the original table.
adie afton

Stored Procedures in MySQL 5.0 - 0 views

sqlserver-guide.blogspot.in/...ed-procedures-in-mysql-50.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    MySQL 5.0 introduced Stored Procedures which allow us to automate or program our way out of many tasks on directly on the server rather than having to write external scripts to do complex manipulation of data.
adie afton

MySQL 5.0 New Features: Triggers - 0 views

sqlserver-guide.blogspot.in/...-50-new-features-triggers.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    Whenever I want to show actual code, such as something that comes directly from the screen of my mysql client program, I switch to a Courier font, which looks different from the regular text font.
adie afton

mySQL 5.0 New Features - 0 views

sqlserver-guide.blogspot.in/...mysql-50-new-features.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    MySQL user who wants to know "what's new" in version 5. The short answer is "stored procedures, triggers, views, and information schema".
adie afton

How To Export MS Access Database To MySQL Database - 0 views

sqlserver-guide.blogspot.in/...ort-ms-access-database-to.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL
adie afton

Stored Procedures in MySQL 5.0 - 0 views

sqlserver-guide.blogspot.com/...ed-procedures-in-mysql-50.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    MySQL 5.0 introduced Stored Procedures which allow us to automate or program our way out of many tasks on directly on the server rather than having to write external scripts to do complex manipulation of data.
adie afton

MySQL 5.0 New Features: Triggers - 0 views

sqlserver-guide.blogspot.com/...-50-new-features-triggers.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    Whenever I want to show actual code, such as something that comes directly from the screen of my mysql client program, I switch to a Courier font, which looks different from the regular text font.
adie afton

MySQL 5.0 New Features: Data Dictionary - 0 views

sqlserver-guide.blogspot.com/...-features-data-dictionary.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    Whenever I want to show actual code, such as something that comes directly from the screen of my mysql client program, I switch to a Courier font, which looks different from the regular text font.
adie afton

MySQL Tip: How To Check, Repair & Optimize All Tables in All Databases - 0 views

sqlserver-guide.blogspot.com/...-to-check-repair-optimize.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    Here is a simple command to auto repair, check and optimize all the tables in all databases running on a MySQL server:
adie afton

MySQL SQL Delete Notes - 0 views

sqlserver-guide.blogspot.com/...mysql-sql-delete-notes.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    To delete duplicates from a MySQL database table I normally copy the duplicate data first to a temporary table and then use the copied id's to delete from the original table.
adie afton

MySQL Tip: How To Check, Repair & Optimize All Tables in All Databases - 0 views

sqlserver-guide.blogspot.in/...-to-check-repair-optimize.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    mysqlcheck uses the SQL statements CHECK TABLE, REPAIR TABLE, ANALYZE TABLE, and OPTIMIZE TABLE in a convenient way for the user.
adie afton

How to start/stop MySQL server on Linux - 0 views

sqlserver-guide.blogspot.in/...top-mysql-server-on-linux.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    This will kill the mysqld process. However the best way to stop (because it stops properly) is obviously
adie afton

How To Export MS Access Database To MySQL Database - 0 views

sqlserver-guide.blogspot.com/...ort-ms-access-database-to.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    Here are few tips (with undocumented features) to help you export huge MS Access database (production database with real data) to MySQL.
adie afton

SQL Server 2005 - Service Broker - 0 views

sqlserver-guide.blogspot.in/...erver-2005-service-broker.html

sql db2 database design structured query language database 'mysql opensource server 2000 ms microsoft programming mySQL guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    The process of sending and receiving asynchronous messages by different processes in SQL Server 2005 is enabled by the Service Broker.
adie afton

How to start/stop MySQL server on Linux - 0 views

sqlserver-guide.blogspot.com/...top-mysql-server-on-linux.html

Sql db2 data base design structured query language sql database my sql open source sql server2000 ms sql server microsoft sql server sql programming SQL Server

shared by adie afton on 29 Jan 11 - No Cached
  • adie afton on 29 Jan 11
     
    This will kill the mysqld process. However the best way to stop (because it stops properly) is obviously:
adie afton

SQL Perl/PL Overview - 0 views

sqlserver-guide.blogspot.in/...sql-perlpl-overview.html

sql db2 database design structured query language database opensource sql database sql server 2000 ms sql server microsoft sql server sql programming programming mySQL sql server sql server guide

shared by adie afton on 20 Aug 12 - No Cached
  • adie afton on 20 Aug 12
     
    The following examples make use of PostgreSQL's implementation of PL/Perl, but the examples should be relevant and similar to other procedural language extensions in most databases that support such additions.
1 - 20 of 47 Next › Last »
Showing 20▼ items per page