I have a table like:
create table registrations( id int not null auto_increment primary key, name varchar(50), mobile_number varchar(13)) engine=innodb partition by range(id) ( partition p0 values less than (10000), partition p0 values less than (20000), partition p0 values less than max value);
Not exactly like above but similar to that….
Now assume that my table has 200000 rows and now I want to remove partitions on the table and reorganize them in accordance to requirement without MAX VALUE in it.
Can any one help me to rearrange partition without dropping data or dropping table and recreating it ?
Related Posts:
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- Case statement in MySQL
- Error Code: 2013. Lost connection to MySQL server during query
- MySQL equivalent of DECODE function in Oracle
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- What is the difference between “INNER JOIN” and “OUTER JOIN”?
- ORA-00904: invalid identifier
- Unknown column in ‘field list’ error on MySQL Update query
- Unknown column in ‘field list’ error on MySQL Update query
- Self Join to get employee manager name
- MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
- MySQL create table if not exists and insert record only if table was created
- How do I use properly CASE..WHEN in MySQL
- Why do we need “Relationships” between tables at all?
- MySQL query String contains
- What’s the difference between VARCHAR and CHAR?
- How to declare a variable in MySQL?
- How to split the name string in mysql?
- Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
- MySQL: Invalid use of group function
- How can I return pivot table output in MySQL?
- Compare dates in MySQL
- MySQL syntax for Join Update
- Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
- 1052: Column ‘id’ in field list is ambiguous
- 1052: Column ‘id’ in field list is ambiguous
- MySQL combine two columns into one column
- Simple way to calculate median with MySQL
- Creating a search form in PHP to search a database?
- The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
- Error 1046 No database Selected, how to resolve?
- What is it exactly a BLOB in a DBMS context
- MySQL Error 1264: out of range value for column
- Remove duplicate rows in MySQL
- How to SUM and SUBTRACT using SQL?
- The backend version is not supported to design database diagrams or tables
- Create mysql table directly from CSV file using the CSV Storage engine?
- Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
- How do you force mysql LIKE to be case sensitive?
- MySQL – UPDATE multiple rows with different values in one query
- Postgres Error: More than one row returned by a subquery used as an expression
- How to create a MySQL hierarchical recursive query?
- ERROR 1148: The used command is not allowed with this MySQL version
- How to round down to nearest integer in MySQL?
- How do I reset a sequence in Oracle?
- MySQL starts with searching issue
- Query to convert from datetime to date mysql
- Is it possible to GROUP BY multiple columns using MySQL?
- MySQL error: key specification without a key length
- Best way to test if a row exists in a MySQL table
- Check if MySQL table exists without using “select from” syntax?
- mysql update column with value from another table
- The used SELECT statements have a different number of columns
- what is the difference between triggers, assertions and checks (in database)
- How to delete from multiple tables in MySQL?
- How to copy a row and insert in same table with a autoincrement field in MySQL?
- Equivalent of explode() to work with strings in MySQL
- How to do a batch insert in MySQL
- ROW_NUMBER() in MySQ
- Solutions for INSERT OR UPDATE on SQL Server
- MySQL OPTIMIZE all tables?
- MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
- MySQL – Get row number on select
- MySQL error: Unknown column in ‘where clause’
- “select * into table” Will it work for inserting data into existing table
- MySQL LIKE IN()?
- Error: Duplicate entry ‘0’ for key ‘PRIMARY’
- Getting wrong relationship value in $args in wp_Query?
- Inserting Post Meta From SQL
- How to Join two tables from separate databases within WordPress
- Would manually deleting the dumping data fix a “#1062 – Duplicate entry ‘1’ for key ‘PRIMARY'” phpMyAdmin error?
- How to execute mulitple statement SQL queries using $wpdb->query?
- Delete duplicate rows from wordpress database where a column is duplicate in phpmyadmin
- Query WordPress database by registered date and role
- wpdb_prepare with multiple or condition
- How do I find which articles are missing a featured image in The WordPress database?
- SQL Error wp_commentmeta – incorrect table definition
- WordPress and MySQL: how to transfer Meta_key and Meta_Value from one post_id to another
- How do I get the posts within a certain year/date(with sql query)?
- Database Tables Lost Indexes? How to Recover?
- Create table from array with prepare
- Why this query is not showing any result on wordpresss home page?
- Why does changing Database Table Prefixes result in loss of content?
- SQL query to set posts in bulk based on the post content
- WP MultiSite: Can’t select database error after changing to new domain
- $wpdb->get_var – What value is returned when zero records are found?
- DB prefix not updating
- Performing CRUD operations on front end in wordpress
- I wanted to Know that how can I give ingore to 0000-00-00 in my config file
- Bulk find & replace on WordPress posts/pages (minus image paths)
- How to create index (sql) to a meta_key?
- The function is deprecated; use mysql_real_escape_string() instead
- Delete all users meta that named: user_avatar
- The MySQL Connection could not be established., before it was joomla but i have change it into worpress
- can’t delete a row from post_meta table
- Migrated to Namecheap, now Trouble with Database & wp-config [closed]
- SQL query : Select a thumbnail for a media
- why you don’t Implement PDO for access every thing to database
- SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta