Re: disconnecting from server

[Carl Fretwell]

exit; ?

- Original Message - 
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, June 21, 2004 10:12 AM
Subject: disconnecting from server


 Hi,
 
 I am using the command ./mysqld_safe --user=mysql  to connect to the
 server but how does one disconnect?
 
 Thanks in advance
 
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
 
 
 


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: C Client compil error

[Carl Fretwell]

 try...

 #include windows.h
 #include mysql.h

 int main(void)
 {
 MYSQL *database;

 database = mysql_init(database);

 return(0);
 }


 - Original Message - 
 From: [EMAIL PROTECTED]
 To: [EMAIL PROTECTED]
 Sent: Monday, April 26, 2004 8:25 AM
 Subject: C Client compil error


 Hello all,

 I try to compil a very simple client, but i get multiple error from my
 compiler
 Windows XP, DevC++, MySql installed : mysql --version = mysql  Ver 14.3
 Distrib 4.1.1a-alpha, for Win95/Win98 (i32)

 The prgram :

 #include mysql.h

 int main(void)
 {
 MYSQL *database;

 database = mysql_init(database);

 return(0);
 }


 The error from the compiler :

 Compilateur: Default compiler
 Exécution de  gcc.exe...
 gcc.exe D:\al\Working_code\connection.c -o
 D:\al\Working_code\connection.exe   -Wall -pedantic -g3
 -IC:\Dev-Cpp\include  -Id:\al  -ID:\MySql   -LC:\Dev-Cpp\lib
 -Ld:\MySql
 In file included from C:/Dev-Cpp/include/sys/types.h:38,
  from D:/MySql/mysql.h:33,
  from D:/al/Working_code/connection.c:1:
 C:/Dev-Cpp/include/stddef.h:6:2: warning: #include_next is a GCC extension
 In file included from D:/MySql/mysql.h:57,
  from D:/al/Working_code/connection.c:1:
 D:/MySql/mysql_com.h:145: parse error before SOCKET
 D:/MySql/mysql_com.h:145: warning: no semicolon at end of struct or union
 D:/MySql/mysql_com.h:172: parse error before '}' token
 D:/MySql/mysql_com.h:172: warning: type defaults to `int' in declaration
of
 `NET'
 D:/MySql/mysql_com.h:172: ISO C forbids data definition with no type or
 storage class
 D:/MySql/mysql_com.h:249: parse error before '*' token

 D:/MySql/mysql_com.h:250: parse error before '*' token
 D:/MySql/mysql_com.h:251: parse error before '*' token
 ...
 In file included from D:/al/Working_code/connection.c:1:
 D:/MySql/mysql.h:113: warning: ISO C89 does not support `long long'

 In file included from D:/al/Working_code/connection.c:1:
 D:/MySql/mysql.h:215: parse error before NET
 D:/MySql/mysql.h:215: warning: no semicolon at end of struct or union
 ...

 And so on.


 Could anybody point me where i can search/solve the problem?

 Thank's a lot
 --
 Vincent



 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: msvcr70.dll was not found error when double click on desktop icon

[Carl Fretwell]

hi,

msvcr70.dll is part of the Microsoft(r) C Runtime Library v7.

You can download this file free of charge from:
http://www.dll-files.com/cgi-bin/cgiwrap/dll-files/topdown/download.pl?file=msvcr70.zip==

(Copy and paste the above URI into your browsers address bar)

Carl

- Original Message - 
From: Joe Audette [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, March 30, 2004 8:54 AM
Subject: Re: msvcr70.dll was not found error when double click on desktop
icon


 d r wrote:

 I am a personal user who just downloaded the version
 4.0 and
 mysql
 
 
 administrator. The first time I clicked on the
 Administrator icon
 on my desktop I get an error that says failed
 
 
 to start because
 
 
 msvcr70.dll was not found. Try to reinstall.  I
 
 
 did remove the
 
 
 program and then reinstalled it and got the same
 
 
 error. I just
 
 
 purchased a lern mysql book and need to download
 
 
 the
 
 
 program so I can
 learn it.
 
 
 
 
 
 

  I had this same error and i searched my hard drive and found that file
  and put it in the bin folder where MySqlAdministrator is installed and
  it fixed it. I found it in a folder related to MS Outlook. Hope that
  helps, if you don't find it let me know and I'll send you mine.


 Best Regards,

 Joe Audette

 
 
 





-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

MYSQL Row Size

[Carl Fretwell]

Hi,

Does anyone know of the fastest way to get the size of a single table row in
bytes?

Im currently using the following query: (this query takes 7 seconds which is
not efficient).

SELECT
SUM(LENGTH(CONTACT(view_stat_id,account_id,project_id,contact_id,timestamp))
) as size FROM table1 WHERE account_id='10043';

THIS IS TO DETERMINE HOW MUCH DISK SPACE THE ROW IS TAKING UP!

Any help will be appreciated.

Thanks

---
Carl Fretwell - Web Developer - Doctor Net
t. 0870 770 4990 - f. 0870 770 4991

Visit www.doc-net.com - let us be your key to the web
Visit www.eMailCampaigner.com - discover the power of permission based
marketing
---
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. If you received this in error, please contact the sender and
delete the material.



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]