mirror of
				https://github.com/MariaDB/server.git
				synced 2025-11-04 04:46:15 +01:00 
			
		
		
		
	
		
			
				
	
	
		
			60 lines
		
	
	
	
		
			1.6 KiB
		
	
	
	
		
			C
		
	
	
	
	
	
			
		
		
	
	
			60 lines
		
	
	
	
		
			1.6 KiB
		
	
	
	
		
			C
		
	
	
	
	
	
/* Copyright (c) 2000-2004 MySQL AB
 | 
						|
   Use is subject to license terms
 | 
						|
 | 
						|
   This program is free software; you can redistribute it and/or modify
 | 
						|
   it under the terms of the GNU General Public License as published by
 | 
						|
   the Free Software Foundation; version 2 of the License.
 | 
						|
 | 
						|
   This program is distributed in the hope that it will be useful,
 | 
						|
   but WITHOUT ANY WARRANTY; without even the implied warranty of
 | 
						|
   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 | 
						|
   GNU General Public License for more details.
 | 
						|
 | 
						|
   You should have received a copy of the GNU General Public License
 | 
						|
   along with this program; if not, write to the Free Software
 | 
						|
   Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1335  USA */
 | 
						|
 | 
						|
#include <stdio.h>
 | 
						|
#include <stdlib.h>
 | 
						|
#include "mysql.h"
 | 
						|
 | 
						|
#define INSERT_QUERY "insert into test (name,num) values ('item %d', %d)"
 | 
						|
 | 
						|
 | 
						|
int main(int argc, char **argv)
 | 
						|
{
 | 
						|
  int	count,num;
 | 
						|
  MYSQL *sock,mysql;
 | 
						|
  char	qbuf[160];
 | 
						|
 | 
						|
  if (argc != 3)
 | 
						|
  {
 | 
						|
    fprintf(stderr,"usage : insert_test <dbname> <Num>\n\n");
 | 
						|
    exit(1);
 | 
						|
  }
 | 
						|
 | 
						|
  mysql_init(&mysql);
 | 
						|
  if (!(sock = mysql_real_connect(&mysql,NULL,NULL,NULL,argv[1],0,NULL,0)))
 | 
						|
  {
 | 
						|
    fprintf(stderr,"Couldn't connect to engine!\n%s\n",mysql_error(&mysql));
 | 
						|
    perror("");
 | 
						|
    exit(1);
 | 
						|
  }
 | 
						|
  mysql.reconnect= 1;
 | 
						|
 | 
						|
  num = atoi(argv[2]);
 | 
						|
  count = 0;
 | 
						|
  while (count < num)
 | 
						|
  {
 | 
						|
    sprintf(qbuf,INSERT_QUERY,count,count);
 | 
						|
    if(mysql_query(sock,qbuf))
 | 
						|
    {
 | 
						|
      fprintf(stderr,"Query failed (%s)\n",mysql_error(sock));
 | 
						|
      exit(1);
 | 
						|
    }
 | 
						|
    count++;
 | 
						|
  }
 | 
						|
  mysql_close(sock);
 | 
						|
  exit(0);
 | 
						|
  return 0;
 | 
						|
}
 |