Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
10 Newer Entries Showing entries 31 to 40 of 71 10 Older Entries

Displaying posts with tag: Technical (reset)

5 useful MySQL Command Options-pager-prompt-rehash-tee-system
+0 Vote Up -0Vote Down

There are set of commands that MySQL itself interprets. You may use “help” or “\h” at the mysql> prompt to list them. Below are the 5 most useful MySQL Command Options. 1. \# OR rehash: Enable automatic rehashing. Do you have long table names, you find it difficult to remember tablenames or you’re just as […]

QA-Testing Definitions-Interview Questions: Part-II
+0 Vote Up -0Vote Down

QA-Testing Definitions-Interview Questions: II (F – S): Data Dictionary: A database that contains definitions of all data items defined during analysis. Data Flow Diagram: A modeling notation that represents a functional decomposition of a system. Data Driven Testing: Testing in which the action of a test case is parameterized by externally defined data values, maintained […]

MyDumpSplitter-Extract split database or tables from mysqldump | MySQL dump splitter
+2 Vote Up -0Vote Down

The Mysqldumpsplitter can extract database, table, all databases, all tables or tables matching on regular expression from a mysqldump. It can produce the compressed output of sqls in specified directories. From version 4.0 it now support compressed source file, bz2 and usage of config file. It has undergone a complete rewrite, please follow GitHub Repository […]

Stored procedure to add-remove prefix by rename table mysql
+1 Vote Up -0Vote Down

Here is one more procedure – (this time) for mass renaming of table. Adding and Removing table-name prefixes A friend of mine was renaming 100+ tables by using replace methods in notepad. I showed em a bit better editor: Editplus and then I thought of rescue rest of those who are still interested in some […]

Oracle query-eliminate duplicate but one using rowid
+0 Vote Up -0Vote Down

Yesterday a friend came across an oracle query problem: Consider below table: cid cname.... cdata 1 x xxxx 1 x xxxx .. 2 xzzz fjnd 3 a evddd Now the problem was cid is repeated and cdata column is having some extra characters but data is considered same (eg. xxxx & xxxx..). so when he […]

Load Delimited Data – CSV to MySQL, Excel to MySQL Database
+1 Vote Up -0Vote Down

Loading csv to MySQL or any delimited data files to MySQL database is a very common task frequently questioned about and almost every-time LOAD DATA INFILE come into rescue. In this article I will explain you about all different scenarios and explain you how to get the data loaded directly from csv to MySQL database […]

MySQL Memory Usage Limits on 32 bit Linux
+0 Vote Up -0Vote Down

I’m having RHEL 5 (32-bit) and MySQL-5. I was trying to check how much is the Memory Utilization limits for MySQL 5 on 32bit OS. We can easily calculate the maximum capacity of the address space is 2^32 bytes and that is where these limits come from. * For MYSQL 5.0: Following are memory (storage) […]

MySQL Certification Free Retake: Get TWO chances to get MySQL Certified
+1 Vote Up -0Vote Down

Recently MySQL has offered MySQL Certification Free Retake on both DBA or Developer Certifications for a limited time. For MySQL Certifications: 1. MySQL 5.0 Data Base Administrator Certification (SCMDBA) – MySQL 5.0 DBA Part I Certification (CX-310-810) – MySQL 5.0 DBA Part II Certification (CX-310-811) 2. MySQL 5.0 Developer Certification (SCMDEV) – MySQL 5.0 Developer […]

Monty: Help Saving MySQL – The Oracle & EC
+0 Vote Up -0Vote Down

And I looked back and thought of updating this post… We all are aware about the acquisition happened to MySQL; Sun and now Oracle. A common understanding tells me that a business will always seek profit; so will Oracle. And thats where worries and fear for existance of MySQL as an open-source and future growth […]

MySQL Stored procedure – Split Delimited string into Rows
+0 Vote Up -0Vote Down

This procedure will split  a “;” separated column in to new fields preserving ids. This is very specific problem, lets check it with example. Consider a sample table test: And we want output as follows: So again I wrote a procedure. Procedure will read a data from “tmp” table and will split data by my_delimiter […]

10 Newer Entries Showing entries 31 to 40 of 71 10 Older Entries

Planet MySQL © 1995, 2015, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.