Re: SELECT MAX makes MYSQL Crush

hello, i got a really long text to put in mysql n when i use longtext field, it isnt enuff Can u help me pls ?? thx in advance feroze - Before posting, please check: http://www.mysql.com/manual.php (the manual)

Re: Newbie Question about working with datetime column

I'm fairly certain now() runs off system time...so you can adjust your system time on the server to reflect your time zone... if thats not possibly, or not wanted, in place of now, you can use.. DATE_SUB(NOW(), INTERVAL 2 HOUR) cheers! On January 7, 2002 11:53 pm, Kevin Campbell wrote:

Tru64 UNIX V5.1A Build Instructions (gcc) ?

Hi All. Has anybody from the MySQL source distribution successfully build a working MySQL ? I have done it using Compaq's C and C++ compiler - But I would like to have build instructions when using GNU C. Regards and thanks, Karsten Elgaard Sørensen Compaq Computer ApS Denmark

Re: SELECT MAX makes MYSQL Crush (??)

Rezal writes: hello, i got a really long text to put in mysql n when i use longtext field, it isnt enuff Can u help me pls ?? thx in advance I'll do my best to decipher your message... you have something that's bigger than the maximum size of a LONGTEXT and you want to put in in the

Re: Lost connection, C API

Heikki Tuuri wrote: Hi! Are you running mysqld under the safe_mysqld script, which automatically restarts mysqld after a crash? Yes, mysqld started with safe_mysqld script If yes, look at the 'hostname'.err file and send its contents to me. Nothing happens in the hostname.err (I

RE: INSERT value from another table

* matt I was wondering how I would insert a value which is present in another table, specifically, this is a member_id field from a main members table which acts as a foreign key in this table (Although I know this not truly possible in MySQL). I think this attempted, although non

Re: Lost connection, C API

Bernard Chambon wrote: 020107 11:45:08 Warning: setrlimit couldn't increase number of open files to more than 1024 Bernard: How come you're not giving your OS more file descriptors? ulimit problem, perhaps. Van database,sql,query,table --

Re: Newbie Question about working with datetime column

Brian Snopek writes: I'm fairly certain now() runs off system time...so you can adjust your system time on the server to reflect your time zone... The computer should know what timezone it's in. You can unset TZ before running safe_mysqld to get MySQL to run on UTC, but that is a kludge,

RE: RE: Mysql connection problem

Ok. Bring down server: Find the process by useing ps command. Then use the kill command and then send a TERM signal to the server to see if it will respond by shutting down normally. Check tables using myisamchk and isamchk. Restart server with --skip-grant-tables option. Set new root

adding users (reference from O'reilly book)

I was reading about adding/managing users. I understand hat the user table holds user information. the example I will give is taken from the oreilly book. insert into user (host, user, password, select_priv, insert_priv, update_priv, delete_priv) values ('%', 'bob', password('mypass'), 'Y',

Re: adding users (reference from O'reilly book)

1.) the % IS a wildcard and the user bob CAN connect from any host. 2.) the string 'mypass' will be inserted into the table. but the user bob can not logon because he doesnot know the unencrypted password of 'mypass'. -- Zu Zhihui [EMAIL PROTECTED] - Original Message - From: Matthew

RE: adding users (reference from O'reilly book)

Hi If you have a new copy of MySQL use GRANT. If you have an old copy update it. If you can not do this then Yes % is a wild card. Yes bob can use any host at user table is global. Yes you can use clear text passwords. Hope this helps. Simon PS I like using desc tablename PPS Get the new

[Bug in replications] set character set don't work

Description: Using set character set cp1251_koi8 before updates insert right data on master server (cp1251 from client recode to koi8 on server), but replication on slave server wrong (data dosn't recode from cp1251 to koi8). How-To-Repeat: Setup

text file insert

Hi, I prefer to used load data infile command to insert text file (CSV format) to MySQL. I wonder that Could load data use with pure text file (no delimiter)? if not how to insert text file in to MySQL faster than read every line? SF

RE: adding users (reference from O'reilly book)

thanks for your help on this, I would like to use the grant sql command as I am using the latest version 3 of mysql, however I am find problems finding good usage guide for grants. I will update the oreilly mysql book. I need to do this with my bind and apache book too. Matt. -Original

Importing of text fails on incompatible date fields.

I have a flat text file that is about 820mb I need to import into a database that has the dates in the format MM-DD-. MySQL requires dates with the year first and when I try importing test chunks of the data all I get is zero's in the date field because of the dates being in the wrong

Re: Lost connection, C API

Hi! Then it looks like a problem in the communication or in your client test program. The following error Commands out of sync; You can't run this command now (85 occurences) means that you have issued C API commands to a single MySQL connection in a wrong order. If your application has

OleDB

Hello Im using OleDB from my ASP pages and I have a problem with queries with count(*) and group by statement. I had the same problem with ODBC but i Solved it by setting the Change BigInt to Int and the Return all rows option. Now I changed to OleDB for better speed but I don't know how to

Corrupt table

Hi! I have a most peculiar problem with a corrupt table. My situation: I have a mysql server running with several databases, one of them a log database that only have one table with several attributes. I have lots of inserts into this table which grows continuously, now the table size is about

Business opportunity

Dear mysql, Join today for FREE and a chance to win a $100 Shopping Spree at The DHS Club Outlet Center! A FREE membership in the DHS Club means saving money on everything you buy at The ClubShop Mall Affiliate Stores because you receive REBATES on ALL your purchases! FREE Members also save

Equivalent for 'prompt'.

Hi, Is there any MySQL equivalent command for the Oracle 'prompt' command (which writes out some text). Thanks in advance, -- Sebastien Guillemin - Before posting, please check: http://www.mysql.com/manual.php (the

Re: mysql client exits with core dump segmentation fault

Bill Kurland writes: Thanks for the reply. gcc and g++ are both version 2.95.3 I've tried installing three different binaries, one from the mysql site and two different versions from the Bull site. All failed with different problems on this machine so I tired them all on a different

Re: Unknown compiler errors (gcc 3.0.1 / 3.1)

Johan Wahlström writes: Hello Everyone! This happens when i try to compile with gcc 3.1 (redhat) on my redhat 7.2 installation. (yes i have upgraded to 3.1 from the default 2.96 version). I get the same result with 3.0.1 also from Redhat. any ideas ? regards, Johan Just change CXXLD

Re: Unknown compiler errors (gcc 3.0.1 / 3.1)

Johan Wahlström writes: Hello Everyone! This happens when i try to compile with gcc 3.1 (redhat) on my redhat 7.2 installation. (yes i have upgraded to 3.1 from the default 2.96 version). I get the same result with 3.0.1 also from Redhat. any ideas ? regards, Johan Just change CXXLD

RE: OleDB

Hi, I think that adding .;Extended Properties=OPTION=16400 to your ADO connection string should do the trick. Cheers, Bruce -Original Message- From: Mattias Persson [mailto:[EMAIL PROTECTED]] Sent: 08 January 2002 13:29 To: [EMAIL PROTECTED] Subject: OleDB Hello Im using OleDB

timestamp column

Hi, My table has 3 columns: id, name, timestamp. When I use the MySQL command line client, (a) insert into table values(1,'xxx') fails for insufficient number of values. (b) insert into table values(1,'xxx',null) succeeds. 1. The MySQL manual states that The column is not

Wishing you Happy new year

HTML HEAD TITLE/TITLE style type=text/css !-- .ms {font-family:arial; font-size:10pt} .rj {font-family:arial; font-size:8pt} //-- /style /HEAD BODY form action = http://www.essencomp.com/unsubscribe.asp; method=post table border=0 cellpadding=0 cellspacing=0 width=50% align=center

replication :Slave thread: error connecting to master..urgent

Hi! aravindgorthy == aravindgorthy iso-8859-1 writes: aravindgorthy Hai aravindgorthy While setting up the replication environment i am aravindgorthy getting the following error in the master ..what might aravindgorthy be the problem aravindgorthy 020108 13:20:00 Slave thread: error

Re: mysqlgui - my.cnf or my.ini

jds writes: hi! i'm running 3.23.47 w/ mysql gui1.7.5-2 on win2k to config innodb, i edited the my.ini (with some help from heikki...thanks!) and learned on win my.cnf and my.ini cannot co-exist. now i'm ready to install mysqlgui to set up my admin, users, etc... my question is:

RE: timestamp column

* Osnat Rabi My table has 3 columns: id, name, timestamp. When I use the MySQL command line client, (a) insert into table values(1,'xxx') fails for insufficient number of values. I don't know if this will help you, but this is valid: insert into table set id=1, name='xxx'; --

Re: MySql Gui connecting to remote server problem

Matthew Darcy writes: Hi, my laptop is running windows 2000 and is called jaguar. I have mysql running on a linux server called jordan. when I fire up mysqlui and tell it to connec to jordan as root I get prompted for a password. I enter the password (that I have tested and is

About spam

[EMAIL PROTECTED] writes: HTML I'm getting seriously sick of the amount of spam on this list. I don't know what MySQL employee is responsible for managing this list, but assuming that there is such a person, could he/she _please_ do something about the problem? When every other list owner can

Re: Installing Static MySQLGUI on Solaris 7

EDA Peach writes: Hi Gerald, Sorry ... the OS is Solaris 7, running on a Sun Ultra Sparc 5. I downloaded the Sun Solaris 2.7 Sparc static binary of MySQLGUI 1.6 (mysqlgui-solaris-2.7-sparc-static-1.6.gz). I gunzipped the file and attempted to execute it and got this error message:

Location of databases

We run MySql on our Freebsd server, and on our Win2K server. We have several clients, and would like to store the databases in the clients' root directory. Is this possible? Thanks! - Before posting, please check:

Re: MySQL Book

I prefer 'MySQL' by Michael Kofler (Apres ISBN 1893115577) D Bamud wrote: Which is the **best, easy, compact** book available on MySQL. Delhi India. - Before posting, please check: http://www.mysql.com/manual.php

Com_select larger than questions bug?

From show status (in mysql 4.0.1) | Com_select | 192446| | Questions| 121881| Why are there more selects than the total number of questions? Is that correct? There are of course Insert, deletes and other Com_ variables as well. I can provide the whole

RE: Location of databases

There are two things you can do when running MySQL for other people. One: Use GRANT and let every one know about but not see each others databases. Two: Run more than one copy of MySQL on your sever...this also means that they can be set up for each persons needs Hope this helps... Simon

Re: SELECT MAX makes MYSQL Crush

Rezal wrote: hello, i got a really long text to put in mysql n when i use longtext field, it isnt enuff Can u help me pls ?? thx in advance feroze Sheesh! Over 4 GB in a single row? That doesn't make much sense. Why not store the text in a file on the filesystem instead? And just a

Assertion failure in thread 54 in file trx0undo.c line 1316

Bonjour, Any idea ? I will try to make the server crash one more time and tell you if I find the query. Regards, Alex. 020108 9:43:58 InnoDB: Started /opt/mysql/libexec/mysqld: ready for connections InnoDB: Error: undo-id is 2860816 InnoDB: Assertion failure in thread 54 in file

Re: Location of databases

Thanks - but my real question is where is this data stored on my system? Do I have control to locate the databases for each client in different locations? Mike Simon Green wrote: There are two things you can do when running MySQL for other people. One: Use GRANT and let every one know

Re: About spam

Reported to SpamCop.net At 15:54 2002-01-08, Carl Troein [EMAIL PROTECTED] [RegSoft/mysql] wrote: [EMAIL PROTECTED] writes: HTML I'm getting seriously sick of the amount of spam on this list. I don't know what MySQL employee is responsible for managing this list, but assuming that there is

Prevent WinMySQLAdmin from auto startup when windows 98 reboots

Each time that I reboot and logon to my windows 98 server, WinMySQLAdmin starts and then starts mysqld. I do not want this behavior (acting like a service). What do I need to do to prevent this, including uninstalling WinMySQLAdmin, which I have not figured out how to do? When I remove my.ini

RE: Prevent WinMySQLAdmin from auto startup when windows 98 reboots

Just take the shortcut out of the startup menu -Original Message- From: Dan Jordan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 10:04 AM To: [EMAIL PROTECTED] Subject: Prevent WinMySQLAdmin from auto startup when windows 98 reboots Each time that I reboot and logon to my

Time and dates with Access.

I'm having difficulty handling data and time with access. I'm using the ODBC driver from the MySQL site to link the tables, and I can view and manipulate the data. the problem comes when I save a time, it is displayed incorrectly in access. Is this a known problem? If so, how do I work around

General Query time question

Hello all. I have a database which is around 10million rows. The structure is as follows: id int(11) NOT NULL- Auto Increment address char(90) NOT NULL status char(2) NOT NULL country char(2) state char(2) areacode char(3) ...about 40 char(1) fields. I have an unique index on address,

Re: Assertion failure in thread 54 in file trx0undo.c line 1316

Alex, looks like a memory overwrite. A trx undo log object contains a random field. Did you do anything special with the database when this happened? Regards, Heikki Innobase Oy . Bonjour, Any idea ? I will try to make the server crash one more time and tell you if

Different instances of mysqladmin

Can I have different instances of winmysqladmin start instanciating different mysql's? i want to run one for the stable version, and one for mysql 4.0 - Before posting, please check: http://www.mysql.com/manual.php (the

RE: General Query time question

Correction on the query: SELECT count(*) as count FROM userdata WHERE status = 'A'; Sorry. -Original Message- From: Greer, Darren (MED) Sent: Tuesday, January 08, 2002 10:20 AM To: '[EMAIL PROTECTED]' Subject: General Query time question Hello all. I have a database which is around

Re: General Query time question

Greer, Darren (MED) writes: Correction on the query: SELECT count(*) as count FR OM userdata WHERE status = 'A'; Ah. That does make a difference. MySQL is of course forced to go through all of your data, counting the number of rows with status 'A'. I don't believe an index would do you much

Re: About spam

Personnaly I found no particular spam on this list, in the beginning of the year I found article dated to the 01/01/2003 and not the 01/01/2002, this message was refused cause it doens t contain words like sql I thinks that my mail client wich doesn work well (hum outlook). a+.

RE: General Query time question

You are correct, they are simple Y/N fields. I am not familiar with the process you mentioned, but will do some digging. If you have any information you could give me that doesn't require too much of your time, I would appreciate it. Thanks, Darren -Original Message- From: Bogdan

General mySQL setup question

Hi, Would like to know if there is a preferred way of setting up the data directory for mySQL. The default for a database would be in C:\mysql\data. Is this the preferred way or should this be set up in another directory outside of the mysql directory? Does moving the data directory affect

Stability problems on 4-way server

Hi, We are running MySQL version 3.23.43 on one of our servers and have some stability problems the occur about every 1-2 days. When it happens everythings keeps working but the load goes up to about 80. After stopping and restarting MySQL everything goes back to normal (load average about 0.5).

Re: General Query time question

I didn't think/read far enough. One more attempt is due. Correction on the query: SELECT count(*) as count FR OM userdata WHERE status = 'A'; I didn't see that it was on that column you had an index, so forget I said 'of course'. Have you used EXPLAIN to figure out if the index is

Re: MySQL authentication using PAM

On Mon, Jan 07, 2002 at 10:43:57PM -0600, Jeff Williams wrote: We have been using LDAP for our user database for some years. We are now getting into MySQL, and I would like to be able to grant or deny access within MySQL based on LDAP user information, rather than having to maintain a

Re: Importing of text fails on incompatible date fields.

#!/your/path/to/perl open(OLD, yourbigfile.txt); open(FIXED, newfile); while ($line = OLD) { $line =~ s/(\d{2})-(\d{2})-(\d{4})/$3-$1-$2/g; print FIXED $line; } Michael On Tue, 8 Jan 2002, Jeremy Johnstone wrote: I have a flat text file that is about 820mb I need to import into a

Debian and MySQL

Hi all, I'm doing some experimenting with debian, has anybody created any .deb packages for MySQL? TIA, John - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Re: variable descriptions missing in the documentation

Jean-Luc Fontaine writes: I would need those to finish the on-line help in my mystatus and myvars moodss modules for the 4.0.1 server. Please let me know if this is not the right place to post this. [skip] I also take this opportunity to wish a very successful new year to the MySQL

count(distinct

SELECT count(distinct ip) FROM pole_voti It does'nt work. Why ? PhpMyAdmin says: You have an error in your SQL syntax near 'distinct ip) FROM pole_voti' at line 1 Why ? Where is the error ? Ilic. - Before posting, please

RE: Prevent WinMySQLAdmin from auto startup when windows 98 reboots

is WinMySQLAdmin in your Windows START folder? -Original Message- From: Dan Jordan [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 10:04 AM To: [EMAIL PROTECTED] Subject: Prevent WinMySQLAdmin from auto startup when windows 98 reboots Each time that I reboot and logon to my

Re: Tru64 UNIX V5.1A Build Instructions (gcc) ?

Elgaard Sorensen, Karsten writes: Hi All. Has anybody from the MySQL source distribution successfully build a working MySQL ? I have done it using Compaq's C and C++ compiler - But I would like to have build instructions when using GNU C. Regards and thanks, Karsten Elgaard Sørensen

Kylix frustrated me...!!!

Dear Friends, I am trying to develop an application with Kylix ver.1, MySQL ver.11.15 distrib 3.23.41 for suse linux (i686). I am using MySQLConnection object to connect my MySQL database server (and with so : libmysqlclient.so.10.0.0). But I found some ridiculous problem : 1. Have

Re: [SLE] Kylix frustrated me...!!!

Hello Prabu, Is it really nessesary to use proprietary Kylix environment (is it using Pascal as a core language?) to write your application? I'm not a specialist in Kylix but why don't you look into possibility of using open source programming languages and editors? For example, using just a

Re: MySQLgui fails

Roel Van den Bergh writes: After a long day of trying and reading all sorts of manuals and faqs and newsgroups I still can't create tables with the mySQLgui (1.7.5.2 windows) running in win 2000 pro standalone feature I can read the test database (empty of course)and the users dbase in

Re: Installing Static MySQLGUI on Solaris 7

Hi, gcc and the libstdc++ are already loaded. libstdc++ is in /usr/local/lib should it be somewhere else? Please advise. Thanks. Regards, Mike --- Sinisa Milivojevic [EMAIL PROTECTED] wrote: EDA Peach writes: Hi Gerald, Sorry ... the OS is Solaris 7, running on a Sun Ultra

RE: General Query time question

If I move the status to another table, and then wanted to get a count of everyone who is of status 'A', how would that be any quicker? Would I join the tables? -Original Message- From: Carl Troein [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 11:34 AM To: [EMAIL PROTECTED]

Re: Com_select larger than questions bug?

Ken Menzel writes: From show status (in mysql 4.0.1) | Com_select | 192446| | Questions| 121881| Why are there more selects than the total number of questions? Is that correct? There are of course Insert, deletes and other Com_ variables as well.

Re: Debian and MySQL

%% John Cichy [EMAIL PROTECTED] writes: jc I'm doing some experimenting with debian, has anybody created any .deb jc packages for MySQL? Go to http://www.debian.org, on the left menu bar pick Debian Packages, then in the search box enter mysql (make sure the distribution is set correctly

Re: Com_select larger than questions bug?

Hi Back! Hi! This is a bug that we shall soon sort out ... OK Great, just wanted to make sure you knew about it, or that find out what I did not understand. (So which is the correct number?) You are evidently using our BK tree ... Well, not on that one, that is 4.0.1-alpha from

Re: count(distinct

I don't have MySQL on the computer I am on to test this but you might try rewriting it this way: select count(distinct(ip)) from pole_voit Original Message Follows From: Ilic [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: count(distinct Date: Tue, 8 Jan 2002 18:47:43 +0100 SELECT

Re: How Huge of your mySQL database or table in your former Instance

On Sun, Dec 16, 2001 at 09:49:29AM -0600, Philip Molter wrote: On Sun, Dec 16, 2001 at 02:00:58AM -0800, Jeremy Zawodny wrote: : On Mon, Dec 10, 2001 at 01:25:07PM +0800, Ares Liu wrote: : : So, could you give me some advice that if it is feasible ? Or show : me your successful cases of

Re: Stability problems on 4-way server

Dennis Jacobfeuerborn writes: Hi, We are running MySQL version 3.23.43 on one of our servers and have some stability problems the occur about every 1-2 days. When it happens everythings keeps working but the load goes up to about 80. After stopping and restarting MySQL everything goes

Re: Installing Static MySQLGUI on Solaris 7

EDA Peach writes: Hi, gcc and the libstdc++ are already loaded. libstdc++ is in /usr/local/lib should it be somewhere else? Please advise. Thanks. Regards, Mike It could be anywhere you like as long as that directory is in LD_LIBRARY_PATH. -- Regards, __ ___ ___

Thanks for the help with MyODBC

Through the responses, links, and a little concern (and a really smart and helpful web Host, he did most of the hard stuff), I got MyODBC working like a charm. Made up a file DSN and can use it in Visual C++, Visual Basic, and Access. Also thanks to whomever put MyODBC out there...

RE: count(distinct

The syntax is: SELECT DISTINCT http://www.mysql.com/doc/S/E/SELECT.html Xi2 -Original Message- From: Ilic [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 9:48 AM To: [EMAIL PROTECTED] Subject: count(distinct SELECT count(distinct ip) FROM pole_voti It does'nt work. Why ?

Re: RE: RE: Mysql connection problem

Hi Simon, I appreicate your help. Our server is a Solaris 5.6 server. After I cd to the mysql bin directory bindir=/usr/local/bin and connect to mysql server by using mysql or mysqladmin, the server shows me mysql not found and mysqladmin not found. Can you give my some clue? You have

Re: Prevent WinMySQLAdmin from auto startup when windows 98 reboots

At 09:04 08/01/2002 -0700, Dan Jordan wrote: Hi! Go to start Menu and remove the Icon of WinMySQLAdmin. Regards, Miguel Each time that I reboot and logon to my windows 98 server, WinMySQLAdmin starts and then starts mysqld. I do not want this behavior (acting like a service). What do I need

Re: Syncronization between two databases

On Mon, Jan 07, 2002 at 11:36:54PM +0100, Marco Frazzoli wrote: Hi! I need to syncronize two indentical MySQL databases. The A database is on a server permanently connected to the Internet trough an ADSL connection, while the B database is on a server equipped with an ISDN connection.

RE: RE: RE: Mysql connection problem

from your bindir type: ./mysql -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 08, 2002 12:07 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: RE: RE: Mysql connection problem Hi Simon, I appreicate

Re: Mysql connection problem

The server is not telling you that mysql is not found. The shell is telling you that mysql is not found because the the current directory is not included in the PATH searched by the shell. try ./mysql or /usr/local/bin/mysql. Cindy Yu wrote: Hi Simon, I appreicate your help. Our server is

Re: Stability problems on 4-way server

Dennis Jacobfeuerborn [EMAIL PROTECTED] writes: We are running MySQL version 3.23.43 on one of our servers and have some stability Where did you get that? The MySQL site? Some info about the system: Dell PowerEdge 8450 4 x Xeon 700 4GB of RAM Intel GBit ethernet

Re: Importing of text fails on incompatible date fields.

Jeremy, Apart from this perl of wisdom, how about defining two columns: one a 'temporary' text field and the other the 'real date column - as proposed, and importing the date-data into MySQL in the temporary-text field (and leaving the other/real one empty). Then copy the data out of the

MySQL + InnoDB + fereign keys

Hi. I am using MySQL 3.23.44-MAX. with InnoDB I have create two tables (one of them parent, other child). All seems Ok. But when I am trying to insert new record into the table I am getting key violation. It happened when I am trying insert null value into field that have foreign key. (column

Re: Different instances of mysqladmin

At 09:31 08/01/2002 -0700, John Meyer wrote: Hi! Can I have different instances of winmysqladmin start instanciating different mysql's? i want to run one for the stable version, and one for mysql 4.0 Unlucky no. By the way the Windows Server currently doesn't have support for to run several

complicated select

Hi, I have a table that contains something like follows: id prop_name status action_date prop_type address 1 name1 ok 2001-12-12 1 addy1forname1 2 name2

Re: RE: RE: RE: Mysql connection problem

Hi Gary, Finally I can access the server. You are my hero. I am new to mysql. It takes me a month to try it. Thank you very very much! Cindy [EMAIL PROTECTED] 01/08 11:14 AM from your bindir type: ./mysql -Original Message- From: Cindy Yu [mailto:[EMAIL PROTECTED]] Sent: Tuesday,

Not in Another Table

Is there a way I can filter OUT records referenced in another table? With Subselects it would be this, but I'm using 3.23: select a.* from a where a.id not in (select id from b) You get the idea. - Before posting,

Macintosh mySQL clients

Hi everyone, I yould like to write a database server using MySQL. Before I begin, I would like to know: 1. Is this possible to write, in C, a Macintosh client to this MySQL server application? 2. Even if we already use Linux and Windows NT servers, is this a good alternative to write the MySQL

Re: Location of databases

On Tue, Jan 08, 2002 at 10:04:40AM -0500, Michael D. Stackhouse wrote: We run MySql on our Freebsd server, and on our Win2K server. We have several clients, and would like to store the databases in the clients' root directory. Is this possible? Under UNIX, all of the separate databases

Re: Macintosh mySQL clients

Serge Thibault writes: Hi everyone, I yould like to write a database server using MySQL. Before I begin, I would like to know: 1. Is this possible to write, in C, a Macintosh client to this MySQL server application? 2. Even if we already use Linux and Windows NT servers, is this a

Re: Lost connection, C API

Hello, No there's no thread in my application, the program use fork but of course a new connection is create after each fork() Today before running another test I do the following - drop then create the tables - increase the limit for opened file from 1024 to 4096 I run a test for

synopsis of the problem (one line)

Description: Empty table returned when qureying for show databases; right after installation. It shows a table with 10 rows, with empty fields in each, and writes in the total, 11 databases. When using a newly created database, doesn't show created tables (on show tables), what can be the problem

Re: General mySQL setup question

At 16:50 08/01/2002 +, Los Morales wrote: Hi! Hi, Would like to know if there is a preferred way of setting up the data directory for mySQL. The default for a database would be in C:\mysql\data. Is this the preferred way or should this be set up in another directory outside of the mysql

Re: Not in Another Table

select a.* from a left join b on a.id = b.id where b.id is null; Ken Kinder wrote: Is there a way I can filter OUT records referenced in another table? With Subselects it would be this, but I'm using 3.23: select a.* from a where a.id not in (select id from b) You get

Re: count(distinct

Ilic writes: SELECT count(distinct ip) FROM pole_voti It does'nt work. Why ? What's your MySQL version? Check the docs to see what version is required for count(distinct). I think it was added in 3.23.early, so it might be time to upgrade. //C -- Carl Troein - Círdan /

Re: General Query time question

Greer, Darren (MED) writes: If I move the status to another table, and then wanted to get a count of everyone who is of status 'A', how would that be any quicker? Would I join the tables? Communication error - reattempting. I meant that if you want to get the count of the number of 'A's

Table crashing

Hi, I've got a table with a 5 milion records and with 10 records adding every day. My problem is that when I try to delete old records from this tables at some point I receive the following error ERROR 1034: Incorrect key file for table: 'logs'. Try to repair it. and the query execution

Re: synopsis of the problem (one line)

make sure mysql owns the database directory and all its files. [EMAIL PROTECTED] wrote: Description: Empty table returned when qureying for show databases; right after installation. It shows a table with 10 rows, with empty fields in each, and writes in the total, 11 databases. When using a

Re: Syncronization between two databases

Jeremy Zawodny wrote: On Mon, Jan 07, 2002 at 11:36:54PM +0100, Marco Frazzoli wrote: Hi! Have you looked at MySQL's built-in replication? Yes. But it seems to be created for a permanent connection between two databases... or can I make a replica using a dial-up connection (such as

auto_increment, creating table

what is wrong with this statement? mysql create table message (messageId AUTO_INCREMENT, timePosted VARCHAR(25), - userEmail VARCHAR(30), messagePosted MEDIUMBLOB); ERROR 1064: You have an error in your SQL syntax near 'AUTO_INCREMENT, timePoste d VARCHAR(25), userEmail VARCHAR(30),

  1   2   >