mysqldump

ent below: mysql> SELECT VERSION(); +---+ | VERSION() | +---+ | 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 Bioinfor

mysqldump

ump: 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

Re: MySQL Truncated returns

length issue). > I 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 - Befor

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

Reuse MYSQL object instead of multiple connections?

object 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 Linu

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 more info

production and I'd like to put 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 u

Losing data

le handler 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 ___

Re: mysql_real_query and escaping a semicolon

ompt_8, allow_0, 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: >

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 DuBo

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: > > >> > > > >

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

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? > >

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

mysql_real_query and escaping a semicolon

o escape it? Thanks 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 &l

How to send multiple SQL statements using C API mysql_query?

ls 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 re

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.ph

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

Re: table locking and priorities

Hi, The username field is text and number so you I can't autoincrement a username like "abc003434" ... - Original Message - From: "Mohammad Shoja" <[EMAIL PROTECTED]> To: "anna soobrattee" <[EMAIL PROTECTED]> Sent: Wednesday, June 1

table locking and priorities

aorund this ? Please write back soon! Anna

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

emails to 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 P

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]>; <[EMA

bug? no work on new version MySQL-3.23.33

l. 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

where do i get an authcode from ?

please tell how to get an auth code - i want to unsubscribe but i can't without an authcode. emailing the unsubscribe address doesn't work...i've been trying for weeks! thanks - Before posting, please check: http://www.mysql

Re: mysql/php

.. (although I did not try it!) > I have found this doesn't work. If $RESULT_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

Re: Linking MYSQL to web sites

Many Thanks > > Sunit > Look around http://www.php.net 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 --

Re: Please HELP easy ANSWER

for the ID, which according to another poster, has a maximum limit of 127. So it can't auto_increment above the maximum limit. Use int. It can do into the thousands. Anna - Before posting, please check: http://www.mysql.

Re: Matching escaped characters

ith the slash? If you use a command like addslashes(), the slash doesn't actually make it into the database. You would have to add Mel\\\'nikova to get Mel\'nikova into the database. Anna - Before posting, please ch

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

Re: PHP - working with two MySQL serwers

nce for any comments. > > Mariusz Brzezinski No. As long as you give them different names. :-) $connectionLocal=mysql_connect(bleah, bleah, bleah); $connectionOther=mysql_connect(bleah, bleah, bleah); Then in any mysql_query you must, of course, specif

query questions

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

Re: Large text searches

eturn all permutations of the remaining words (a b c, c a b, b c a, etc). Insert each of those permutations into the word table and relational table. My question now is, this is going to get very big very fast. Should I worry about that at all? Or as lo

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

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

how many colums can i create before it becomes unusable?

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

large tables?

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

mysqldump of one table?

but all these result in an error ... i can dump the whol database but not the table studenttable thanks anna