Visual C++ 6.0 and MySQL
Hi, I have to create with Microsoft Visual C++ a program connected to a database. I am thinking about MySQL, but I have never did it. I have tried to located information about API for C++ on www.mysql.com, but I have not success. Can anybody tell me where I can find a good tutorial and examples? Thank you, Vicente Valero
my.ini
Hi, This is my 'my.ini' file where I specified 'language=spanish' but the sql errors appear in English yet. I don't see another line after this that changes the value. Can somebody help me? # Example mysql config file. # Copy this file to c:\my.cnf to set global options # # One can use all long options that the program supports. # Run the program with --help to get a list of available options # This will be passed to all mysql clients [client] #password=my_password port=3306 #socket=MySQL # Here is entries for some specific programs # The following values assume you have at least 32M ram # The MySQL server [mysqld] port=3306 language=spanish #socket=MySQL skip-locking set-variable = key_buffer=16M set-variable = max_allowed_packet=1M set-variable = table_cache=64 set-variable = sort_buffer=512K set-variable = net_buffer_length=8K set-variable = myisam_sort_buffer_size=8M server-id = 1 # Uncomment the following if you want to log updates #log-bin # Uncomment the following rows if you move the MySQL distribution to another # location basedir = c:/mysql/ datadir = c:/mysql/data/ # Uncomment the following if you are NOT using BDB tables #skip-bdb # Uncomment the following if you are using BDB tables #set-variable = bdb_cache_size=4M #set-variable = bdb_max_lock=1 # Uncomment the following if you are using Innobase tables innodb_data_file_path = ibdata1:400M innodb_data_home_dir = c:\ibdata innodb_log_group_home_dir = c:\iblogs innodb_log_arch_dir = c:\iblogs set-variable = innodb_mirrored_log_groups=1 set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable = innodb_log_buffer_size=8M innodb_flush_log_at_trx_commit=1 innodb_log_archive=0 set-variable = innodb_buffer_pool_size=16M set-variable = innodb_additional_mem_pool_size=2M set-variable = innodb_file_io_threads=4 set-variable = innodb_lock_wait_timeout=50 [mysqldump] quick set-variable = max_allowed_packet=16M [mysql] no-auto-rehash # Remove the next comment character if you are not familiar with SQL #safe-updates [isamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [myisamchk] set-variable = key_buffer=20M set-variable = sort_buffer=20M set-variable = read_buffer=2M set-variable = write_buffer=2M [mysqlhotcopy] interactive-timeout [WinMySQLAdmin] Server=C:/mysql/bin/mysqld-max-nt.exe ___ Yahoo! Móviles Personaliza tu móvil con tu logo y melodía favorito en http://moviles.yahoo.es - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Language errors
Hi, I've tried this, but it hasn't effect. In WinMySQLadmin 1.4, section Variables, language has this value yet 'c:\mysql\share\english' - Original Message - From: "Stefan Hinz, iConnect (Berlin)" <[EMAIL PROTECTED]> To: "Vicente Valero" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, January 27, 2003 12:23 PM Subject: Re: Language errors > Vicente, > > > How can I change my error language in SQL (MySQL)? Have I to introduce > a new > > set-variable in my.ini? > > In the [mysqld] section of my.cnf / my.ini, type: > > language=spanish > > Alternatively, you can start mysqld with the --language=spanish option. > > Regards, > -- > Stefan Hinz <[EMAIL PROTECTED]> > Geschäftsführer / CEO iConnect GmbH <http://iConnect.de> > Heesestr. 6, 12169 Berlin (Germany) > Tel: +49 30 7970948-0 Fax: +49 30 7970948-3 > > - Original Message - > From: "Vicente Valero" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, January 27, 2003 10:31 AM > Subject: Language errors > > > > Hello, > > > > How can I change my error language in SQL (MySQL)? Have I to introduce > a new > > set-variable in my.ini? > > > > Thanks > > > > ___ > > Yahoo! Móviles > > Personaliza tu móvil con tu logo y melodía favorito > > en http://moviles.yahoo.es > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > ___ Yahoo! Móviles Personaliza tu móvil con tu logo y melodía favorito en http://moviles.yahoo.es - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Language errors
Hello, How can I change my error language in SQL (MySQL)? Have I to introduce a new set-variable in my.ini? Thanks ___ Yahoo! Móviles Personaliza tu móvil con tu logo y melodía favorito en http://moviles.yahoo.es - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
question about primary key
Hello, I need help. I want to create a table with a numeric primary key as index in my sql. I want this index will be automatic. I've tried an auto_increment column, but if insert a non-correlative value then all new entries continue from this non-correlative value (1,2,3,4,1026,1027,...). It is possible use the first value not-used in the column automatically (1,2,3,1026,4,5,1000,6,7,...)? Thank you, Vicente ___ Yahoo! Móviles Personaliza tu móvil con tu logo y melodía favorito en http://moviles.yahoo.es - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL
Hola de nuevo, ahi va otra consulta de MySQL Quisiera que una de mis columnas no tuviera valores repetidos, con lo cual creo que deberia utilizar UNIQUE, y a la vez esta columna no pueda ser nula en función del valor de otra columna. ¿Existe alguna posibilidad? Me explico, tengo dos columnas, una 'tipo de usuario' y otra 'numero de habitacion'. Si el tipo de usuario es '1', el numero de habirtacion puede estar vacio, o mejor dicho, deberia estarlo. Si el tipo de usuario es '2', el numero de habitacion debe estar cumplimentado. Gracias ___ Yahoo! Móviles Personaliza tu móvil con tu logo y melodía favorito en http://moviles.yahoo.es - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL y claves foraneas
Hola, Tengo la versión 3.23.54 instalada sobre Windows. He esta leyendo algunos documentos acerca de el soporte de claves foraneas y he visto que para ello dicha versión necesita un patch llamado MySQL-MAX. En la sección de downloads he visto que existe la versión 3.23.54-MAX, ¿es este el patch necesario? En tal caso he visto que no es ningun archivo instalable, sino que en su interior hay carpetas llamadas como "lib", "include", "bin"... ¿Qué debo hacer con ellas, copiarlas sobre la carpeta de MySQL y rearrancar el servidor?. Gracias ___ Yahoo! Móviles Personaliza tu móvil con tu logo y melodía favorito en http://moviles.yahoo.es - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
'Docs/mysqld_error.txt'
Segun el manual de mysql, en los archivos de distribución debe existir un txt 'Docs/mysqld_error.txt' con un detalle de la lista de mensajes de error. En mis archivos de distribución no he sido capaz de hallar dicho fichero. Alguien que lo tenga seria tan amable de enviarmelo? Gracias ___ Yahoo! Sorteos Consulta si tu número ha sido premiado en Yahoo! Sorteos http://loteria.yahoo.es - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL Server
Hola de nuevo, he mirado el log de mysqld, y pone lo siguiente: bind on unix socket : permission denied Donde reside el problema? Gracias ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL
Hola, Tenia instalado MySQL 3.23.53 en mi pc. He reinstalado todo el sistema y lo he vuelto a instalar, pero no consigo arrancar el servidor sql. La instalación la he hecho según indica el manual y tal como la habia hecho en la otra ocasión. Cuando quiero arrancar el servidor (/bin/safe_mysqld --user=mysql &) obtengo el siguiente mensaje: starting mysqld daemon with databases from /var/lib/mysql mysqld ended A qué puede deberse? Gracias ___ Copa del Mundo de la FIFA 2002 El único lugar de Internet con vídeos de los 64 partidos. ¡Apúntante ya! en http://fifaworldcup.yahoo.com/fc/es/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL
Hola, He instalado MySQL 3.23.53a y en numerosos documentos veo referencias a '/usr/local/lib/mysql' cuando dicho directorio en mi sistema no existe, así como a la libreria libmysqlclient.so He hecho algo mal en la instalación? Puedo crear dicho directorio consiguiendo los archivos de algun lugar? Gracias Vicente --- Hello, I have installed MySQL 3.23.53a and I have seen in a lot of places references to '/usr/local/lib/mysql' directory, and this doesn't exist in my system. Also I have seen references to 'libmysqlclient.so' in this directory. Have I made something wrong during the installation? Can I create these directory and copy its files from somewhere? Thank you Vicente ___ Yahoo! Messenger Nueva versión: Webcam, voz, y mucho más ¡Gratis! Descárgalo ya desde http://messenger.yahoo.es - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php