mysqldump

() | +---+ | 3.23.45 | +---+ 1 row in set (0.00 sec) Can anyone help me with this problem? Thanks! Regards Anna Henricson --- Anna Henricson, MSc, PhD student Center for Genomics and Bioinformatics (CGB) Karolinska Institutet S-171

mysqldump

: mysqldump: Couldn't execute '/*!40100 SET @@SQL_MODE= */': Query was empty (1065) Can anyone help me with this problem? Thanks! Regards Anna Henricson Anna Henricson, MSc, PhD student Center for Genomics and Bioinformatics (CGB) Karolinska Institutet S

Re: MySQL Truncated returns

tried changing the column type to text to no avail. I searched the documentation and couldn't figure it out. Can someone provide some insight for me? Thanks- Anna - Before posting, please check: http://www.mysql.com

Reuse MYSQL object instead of multiple connections?

is created once for the database that I'm working with in the constructor for MyDatabase, and reused for subsequent queries. Has anyone else tried this? Any other ways to do this? I'm using the C API and MySQL 3.23.48 on RedHat Linux 7.2. Thanks, Anna

Re: Does mysql_real_connect allocate memory?

Hi, I tried taking out the new MYSQL, and my application dumps -- it doesn't look like mysql_init is actually allocating memory for the MYSQL object because then mysql_real_connect is called with a NULL pointer. Is that supposed to happen? --Anna Ben Goodwin wrote: Hi! mysql_init

Does mysql_real_connect allocate memory?

Hi, Does the MySQL C API function mysql_real connect allocate memory or do I need to do it? This is what my code currently does: MYSQL *mysql; mysql = new MYSQL mysql_init(mysql); mysql_real_connect(mysql, host, user, password, dbase, 0, 0, 0); Thanks, Anna

Losing data

error code 127. But I have no idea what that means. Has anyone experienced anything like this!? It's just to weird! I have no idea what to do and are ready to give up and export it all to linux and postgreSQL instead. Anna

Losing data more info

the rest in production to, but I don't dare do that until I've found out why this db is misbehaving. Anna This message was sent using SkyBURST Mail Center. http://www.skyburst.net

Re: mysql_real_query and escaping a semicolon

Gerald Clark wrote: The semicolon does not belong there. Where? At the end of the query or in the string? --Anna Anna Fowles-Winkler wrote: Anna Fowles-Winkler wrote: Paul DuBois wrote: Paul DuBois wrote: At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote: Well, the function

Re: mysql_real_query and escaping a semicolon

, allow_1, allow_2, allow_3, allow_4, allow_5, allow_6) VALUES ('Eye Movement Time',1,NULL,'per',0,'.1;',0,0,0,0,0,0,0,0,0,1,1,1,1,1,1,1,1,1,-1,-1,-1,-1,-1,-1,-1,-1,-1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,0,0,0,0,0,1) Paul DuBois wrote: At 8:37 -0600 4/29/02, Anna Fowles-Winkler wrote

mysql_real_query and escaping a semicolon

very much, Anna [EMAIL PROTECTED] - 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

Re: mysql_real_query and escaping a semicolon

Well, the function is called like this: mysql_real_query( mysql_connection, query_string, strlen( query_string )); Wouldn't that pass the correct length? --Anna Paul DuBois wrote: At 14:03 -0600 4/26/02, Anna Fowles-Winkler wrote: Hi, I have an insert command that I'm executing through

Re: mysql_real_query and escaping a semicolon

Paul DuBois wrote: At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote: Well, the function is called like this: mysql_real_query( mysql_connection, query_string, strlen( query_string )); Wouldn't that pass the correct length? Not necessarily. Uhm... why not? Wouldn't strlen return

Re: mysql_real_query and escaping a semicolon

Paul DuBois wrote: Paul DuBois wrote: At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote: Well, the function is called like this: mysql_real_query( mysql_connection, query_string, strlen( query_string )); Wouldn't that pass the correct length? Not necessarily. Uhm

Re: mysql_real_query and escaping a semicolon

Anna Fowles-Winkler wrote: Paul DuBois wrote: Paul DuBois wrote: At 14:37 -0600 4/26/02, Anna Fowles-Winkler wrote: Well, the function is called like this: mysql_real_query( mysql_connection, query_string, strlen( query_string )); Wouldn't that pass the correct

How to send multiple SQL statements using C API mysql_query?

to mysql_query? Thanks in advance for your help, Anna Winkler [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request

Beginner question - getting last inserted ID

get this ID? I guess I cannot use SELECT MAX(id) FROM Table since old, deleted id's are reused for new rows. Please, help me! Regards, Anna - Before posting, please check: http://www.mysql.com/manual.php (the manual

DISTINCT AND NON DISTINCT #2

Hi All, I've been reading up on how to do joins on the mysql site. Is there not an inverse function for DISTINCT, so that I can pull out duplicate data as opposed to DISTINCT data...or will I have to get this information by using joins? Thanks very much for your help. Anna

DISTINCT AND NON DISTINCT

Hi All, I've been reading up on how to do joins on the mysql site. Is there not an inverse function for DISTINCT, so that I can pull out duplicate data as opposed to DISTINCT data...or will I have to get this information by using joins? Thanks very much for your help. Anna

table locking and priorities

aorund this ? Please write back soon! Anna

Re: where do i get an authcode from ? - PLEASE GET ME UNSUBSCRIBED OFF THIS LIST....

nothing at all i'm afraid.. i think this requires a little shouting ... PLEASE GET ME UNSUBSCRIBED OFF THIS LIST thanks anna - Original Message - From: "Brian McDonough" [EMAIL PROTECTED] To: "anna soobrattee" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wedne

http://lists.mysql.com/php/unsubscribe.php

this list... anna - Original Message - From: "Phillip Vamplew" [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: "Arne Claassen" [EMAIL PROTECTED]; "Heikki Tuuri" [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Monday, March 26, 2001 11:48 AM Subjec

bug? no work on new version MySQL-3.23.33

very well. the /etc/hosts content as below: 127.0.0.1 local localhost.localdomain localhost 192.168.0.99linux 192.168.0.2 anna the 192.168.0.99is my local linux server and 192.168.0.2 is windows 98 which I used to connect local linux and internet. any suggestion? th

Re: mysql/php

ESULT_SET is null or equal to nothing, that means that there was a problem with the query. You have to use mysql_num_rows($RESULT_SET) to find out if 0 rows were returned. Anna - Before posting, please check: http://www.mysql.com/m

Re: Linking MYSQL to web sites

and http://www.phpbuilder.com for info on PHP (a good language for interfacing with databases) Look around http://www.mysql.com and http://www.devshed.com , among others, for tutorials and info on using databases. Anna - Before posting, pl

Re: Finding Duplicates and Deleting

- Original Message - From: "Linsen Limsico" Does anyone know how to find duplicates in a table and deleting them. I can't figure out how to structure the query. Linsen Exact duplicates or where only one field is duplica

query questions

='2' LIMIT $counter+$pageStart, $pageEnd Hope this makes sense. Anna

how do i store complex data in the most efficient way?

y quicky. has anyone got any ideas on the best way to store this information ?? thanks for your help. anna

large tables?

will be updated very frequently - will access time degrade severely even though i use mainly ints in this table? thanks for your help. anna