mirror of
				https://github.com/MariaDB/server.git
				synced 2025-11-04 12:56:14 +01:00 
			
		
		
		
	
		
			
				
	
	
		
			11 lines
		
	
	
	
		
			281 B
		
	
	
	
		
			Text
		
	
	
	
	
	
			
		
		
	
	
			11 lines
		
	
	
	
		
			281 B
		
	
	
	
		
			Text
		
	
	
	
	
	
drop table if exists t1;
 | 
						|
CREATE TABLE t1 (a int, unique (a), b int not null, unique(b), c int not null, index(c));
 | 
						|
replace into t1 values (1,1,1),(2,2,2),(3,1,3);
 | 
						|
select * from t1;
 | 
						|
a	b	c
 | 
						|
2	2	2
 | 
						|
3	1	3
 | 
						|
check table t1;
 | 
						|
Table	Op	Msg_type	Msg_text
 | 
						|
test.t1	check	status	OK
 | 
						|
drop table t1;
 |