mirror of
				https://github.com/MariaDB/server.git
				synced 2025-11-04 12:56:14 +01:00 
			
		
		
		
	
		
			
				
	
	
		
			9 lines
		
	
	
	
		
			225 B
		
	
	
	
		
			Text
		
	
	
	
	
	
			
		
		
	
	
			9 lines
		
	
	
	
		
			225 B
		
	
	
	
		
			Text
		
	
	
	
	
	
create table t1 (a int(10) auto_increment primary key, b int(11));
 | 
						|
insert t1 values (null,1);
 | 
						|
insert t1 values (null,2), (1,-1), (null,3) on duplicate key update b=values(b);
 | 
						|
select * from t1;
 | 
						|
a	b
 | 
						|
1	-1
 | 
						|
2	2
 | 
						|
3	3
 | 
						|
drop table t1;
 |