int main()
{
mysql_connect();
list_drivers();
list_data_sources();
list_driver_information();
list_tables();
execute_query("select * from junk");
execute_query("select count(*), sum(a) from junk");
execute_query("select a, a+3, 3.141592654 from junk");
execute_query("select j1.a, j2.a from junk j1 natural join junk j2");
mysql_disconnect();
}
/**
* <A short one line description>
*
* <Longer description>
* <May span multiple lines or paragraphs as needed>
*
* @param Description of method's or function's input parameter
* @param ...
* @return Description of the return value
*/
int main(int argc, char* argv[])
{
int ch;
/* keypress character */
printf("Welcome to poorman's db, type ? for help\n");
printf(TABLE_OPERATIONS_PROMPT);
printf("keypress = %08x\n ", ch);
create_table();
return 0;
while((ch = getchar()) != EOF){
switch (ch)
{
case 0x31:
create_table();
break;
case 0x32:
delete_table();
break;
case 0x33:
list_tables();
break;
case 0x34:
select_table();
break;
case 0x35:
return 0;
break;
default:
printf("Command not recognized.\n Type ? for help\n");
continue;
}
}
return 0;
#if 0
struct record rec;
sprintf(rec.field[3], "onurkom\n");
printf("--->%s\n", rec.field[3]);
//printf("size of fx is %d\n", sizeof(rec.field));
return 0;
#endif
#if 0
char fx[4][16] = {"1asdasd\n", "2adsasdas\n", "3asdsadas\n", "4asdadasd\n"};
struct record rec;
sprintf(fx[3], "onur\n");
printf("--->%s\n", fx[3]);
printf("size of fx is %d\n", sizeof(fx));
char S[10][11];
int i,j,k;
char A;
for (i=0;i<=9;i++){
scanf ("%s",A);
for (j=0;j<=10;j++)
{
S[i][j]=A;
}
}
for (i=0;i<=9;i++){
for (j=0;j<=10;j++)
{
printf("i=%d j=%d data=%s\n", i,j,S[i][j]);
}
}
#endif
#if 0
int i,j,k=0;
for(i=0; i<4; i++)
for(j=0; j<4; j++)
{
sprintf((rec.field[j][i]), "y%d\n", k);
printf("field %d %d is now %d\n", i,j,k);
k++;
}
for(i=0; i<4; i++)
for(j=0; j<4; j++)
{
printf("i=%d j=%d field=%s\n", i,j,rec.field[i][j]);
}
#endif
printf("here\n");
return 0;
}
int main(int argc, char **argv)
{
int error;
my_bool first_argument_uses_wildcards=0;
char *wild;
MYSQL mysql;
MY_INIT(argv[0]);
sf_leaking_memory=1; /* don't report memory leaks on early exits */
if (load_defaults("my",load_default_groups,&argc,&argv))
exit(1);
get_options(&argc,&argv);
sf_leaking_memory=0; /* from now on we cleanup properly */
wild=0;
if (argc)
{
char *pos= argv[argc-1], *to;
for (to= pos ; *pos ; pos++, to++)
{
switch (*pos) {
case '*':
*pos= '%';
first_argument_uses_wildcards= 1;
break;
case '?':
*pos= '_';
first_argument_uses_wildcards= 1;
break;
case '%':
case '_':
first_argument_uses_wildcards= 1;
break;
case '\\':
pos++;
default: break;
}
*to= *pos;
}
*to= *pos; /* just to copy a '\0' if '\\' was used */
}
if (first_argument_uses_wildcards)
wild= argv[--argc];
else if (argc == 3) /* We only want one field */
wild= argv[--argc];
if (argc > 2)
{
fprintf(stderr,"%s: Too many arguments\n",my_progname);
exit(1);
}
mysql_init(&mysql);
if (opt_compress)
mysql_options(&mysql,MYSQL_OPT_COMPRESS,NullS);
#ifdef HAVE_OPENSSL
if (opt_use_ssl)
mysql_ssl_set(&mysql, opt_ssl_key, opt_ssl_cert, opt_ssl_ca,
opt_ssl_capath, opt_ssl_cipher);
mysql_options(&mysql,MYSQL_OPT_SSL_VERIFY_SERVER_CERT,
(char*)&opt_ssl_verify_server_cert);
#endif
if (opt_protocol)
mysql_options(&mysql,MYSQL_OPT_PROTOCOL,(char*)&opt_protocol);
#ifdef HAVE_SMEM
if (shared_memory_base_name)
mysql_options(&mysql,MYSQL_SHARED_MEMORY_BASE_NAME,shared_memory_base_name);
#endif
mysql_options(&mysql, MYSQL_SET_CHARSET_NAME, default_charset);
if (opt_plugin_dir && *opt_plugin_dir)
mysql_options(&mysql, MYSQL_PLUGIN_DIR, opt_plugin_dir);
if (opt_default_auth && *opt_default_auth)
mysql_options(&mysql, MYSQL_DEFAULT_AUTH, opt_default_auth);
if (!(mysql_real_connect(&mysql,host,user,opt_password,
(first_argument_uses_wildcards) ? "" :
argv[0],opt_mysql_port,opt_mysql_unix_port,
0)))
{
fprintf(stderr,"%s: %s\n",my_progname,mysql_error(&mysql));
exit(1);
}
mysql.reconnect= 1;
switch (argc) {
case 0: error=list_dbs(&mysql,wild); break;
case 1:
if (opt_status)
error=list_table_status(&mysql,argv[0],wild);
else
error=list_tables(&mysql,argv[0],wild);
break;
default:
if (opt_status && ! wild)
error=list_table_status(&mysql,argv[0],argv[1]);
else
error=list_fields(&mysql,argv[0],argv[1],wild);
break;
}
mysql_close(&mysql); /* Close & free connection */
my_free(opt_password);
#ifdef HAVE_SMEM
my_free(shared_memory_base_name);
#endif
my_end(my_end_arg);
exit(error ? 1 : 0);
return 0; /* No compiler warnings */
}
