QUICK QUESTION: Referencing MySQL

What year was the web page http://www.mysql.com/doc/S/t/Standards.html created/updated. Exact month and day would be helpful if it is available. I am referencing this page in an assignment and a year would be useful. Your thoughts. Thanks lots David Ayliffe ICQ# 125646758 Query, table

RE: MySQL security

Are MySQL really going to give you details of their past security 'issues'? Think about it. Try going underground and looking on some exploit sites. DA > Hi, I'm working on security breaches in MySQL. Can someone guide me in this. To be precise can you tell me about some literature, some

OT: Relational Algebra Trees

query uses a left join after projecting id in both tables. If anyone can help me understand this a bit better, I would REALLY appreciate an email from you. Sorry for posting off-topic. Thanks lots David Ayliffe ICQ# 125646758 MySQL, query, dat

RE: Mysqld as service

Try mysqld --remove >From the MySQL\bin directory. I assume you mean a service on NT Alternatively you can just stop the service in MMC and set it to manual so it never starts. But I'm guessing this isn't what you want Let me know -Original Message- From: [EMAIL PROTECTED] [mailto:[

RE: Unicode in 4.1

So how (forgive me if this is a simpleton's question), how will UTF-8 and UCS2 be used? Can you elaborate a bit. DA Hi, Unicode in 4.1 will use UTF-8 and UCS2 with a possibility to recode between them (as well as between any supported character sets). > Some (VERY) technical documentation

Unicode in 4.1

v4.1 will Unicode suddenly arrive? I need to know if MySQL will use UTF-8, UCS or whatever both for use internally and externally. Some (VERY) technical documentation on this subject would be appreciated. Thanks lots David Ayliffe ICQ# 125646758 Query,

What type of Unicode?

I hear MySQL 4.0.3 will support Unicode. But what sort of Unicode do you mean UTF-8 encoding or UTF-16 or UCS or what? Will the same sort be used internally as externally (UI) what is used at the moment - standard ASCII? Can anyone clarify? Thanks lots David Ayliffe ICQ# 125646758

RE: Unicode support for MySQL

When you say: "Unicode will be supported in 4.0.3 version of MySQL." What do you mean - UTF-8 encoding or UTF-16 or what? Can you clarify -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: 11 March 2002 09:24 To: [EMAIL PROTECTED] Subject: Unicode support

RE: Dual Languages??

Doesn't version 4 support Unicode? - isn't this a solution or am I missing something? DA -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]] Sent: 06 March 2002 14:48 To: [EMAIL PROTECTED] Subject: Dual Languages?? bipin, Wednesday, March 06, 2002, 9:56:53 AM,

Does the MySQL-API support MySQL v4 databases?

n the windows (vc/bcpp) api would be beneficial also. Thanks lots David Ayliffe ICQ# 125646758 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

OT: Installing QT client libraries

must be able to help a bit. So I need some way of installing qt 2.2.2 or above on a LM 7.1 machine with NORMAL USER privileges. Can anyone tell me if this can be done, and if so how? Thanks lots David Ayliffe MySQL, query -

Windows Version of MySQL licensing question?

only. This seems not to be the case I have had my server 3.23.43-nt up and running now for some months. I only use the server for my own uni work but I am curious as to what is the real deal. Anyone? Thanks lots David Ayliffe ICQ# 125646758 Query table dat

BLOB Help Please (Loading into table)

is not working? - I just need to load an image to test things. ALSO can images be loaded without using the set statement? - IMPORTANT Thank you. Thanks lots David Ayliffe ICQ# 125646758 - Before posting, please check: http:

OT: Unix Internals?

ut are my fundamentals correct? Any gems you would like to offer gratefully received Sorry for an off-topic post. I've been on this list a while and you appear willing to help. Wish me luck Thanks lots David Ayliffe ICQ# 125646

I'm having trouble with End-Of-Record markers

I'm having trouble bulk-loading data into a table. I have a file which contains: AYL01ôAYL01-1ôChloeô1979-12-1 0:0:0ôF*END* AYL01ôAYL01-2ôMelissaô1985-3-2 0:0:0ôF*END* AYL01ôAYL01-3ôDavidô1979-1-12 0:0:0ôM*END* COL01ôCOL01-1ôSimeonô1989-12-14 0:0:0ôF*END* DAV01ôDAV01-1ôMurialô1990-2-2 0:0:0ô

I'm having trouble with End-Of-Record markers

I'm having trouble bulk-loading data into a table. I have a file which contains: AYL01ôAYL01-1ôChloeô1979-12-1 0:0:0ôF*END* AYL01ôAYL01-2ôMelissaô1985-3-2 0:0:0ôF*END* AYL01ôAYL01-3ôDavidô1979-1-12 0:0:0ôM*END* COL01ôCOL01-1ôSimeonô1989-12-14 0:0:0ôF*END* DAV01ôDAV01-1ôMurialô1990-2-2 0:0:0ôF*EN

RE: Strange LOAD DATA problem

Yeah useful but that still doesn't solve my problem -Original Message- From: Maciek Dobrzanski [mailto:[EMAIL PROTECTED]] Sent: 06 January 2002 17:43 To: David Ayliffe; 'MySQL' Subject: Re: Strange LOAD DATA problem > Also I use the field delimiter ô (ALT+147) be

Strange LOAD DATA problem

255), Fee DECIMAL(20,2), Per VARCHAR(255), Days VARCHAR(255), Location VARCHAR(255), Coach VARCHAR(255) ); Both client and server ar on the same machine (running on WinXP) Thanks lots David Ayliffe - Before posting,

RE: OK - Simple Timestamps problem getting the better of me!

NO, not originally but I have now and it seems to make no difference! Any other ideas? -Original Message- From: Bogdan Stancescu [mailto:[EMAIL PROTECTED]] Sent: 05 January 2002 00:12 To: David Ayliffe Cc: 'MySQL' Subject: Re: OK - Simple Timestamps problem getting the be

OK - Simple Timestamps problem getting the better of me!

I have created a test table with: CREATE TABLE TimeTest ( Time1 TIMESTAMP(4), Time2 TIMESTAMP(8), Time3 TIMESTAMP(10), Time4 TIMESTAMP(12), Time5 TIMESTAMP(14)); This works fine! No problemo Now ALL I am trying to do is insert the current time and date into each field in the table!! That's al

RE: Are there any openly-accessible MySQL server [I can use for testing]?

can use for testing]? Umm, why not just install a copy locally? You can get a binary for just about any OS. And a local copy would be much faster than working over the internet. j- k- On Thursday 27 December 2001 06:31, David Ayliffe wrote: > I am writing a conversion tool for My

Are there any openly-accessible MySQL server [I can use for testing]?

xist and I only need select privileges on the server itself. Hope you can help. Thanks lots David Ayliffe - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

MySQL Field Names

Can I assume that you can't have a field in a table which is named 'Integer' or 'Datetime' or 'Byte' Any input? I've had a quick look but I can't see much Thanks lots David Ayliffe --

Can field names be longer than ONE word?

As subject what do I do if I want a field called (for example) Competition ID? I have looked (http://www.mysql.com/doc/C/R/CREATE_TABLE.html) but to no avail. I have tried enclosing it in "quotes" and 'single quotes' but neither work. Can this be done? Thanks lots David Ayl

Automatically adding the date to a record.

n't work I just get about 14 0's. Any ideas please Thanks lots David Ayliffe ICQ# 125646758 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

RE: HOW: Getting a list of connected users?

Thank you -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Sent: 02 October 2001 21:38 To: David Ayliffe Cc: [EMAIL PROTECTED] Subject: Re: HOW: Getting a list of connected users? On Tue, Oct 02, 2001 at 09:21:03PM +0100, David Ayliffe wrote: > > Is it possi

HOW: Getting a list of connected users?

Is it possible to get a list of all users currently connected to a mysql server? Preferably the login name they use? Any ideas? I would like any commands which work on both windows and linux MySQL Thanks lots David Ayliffe ICQ# 125646758

RE: Client-side developing

Delphi 6 is very good It has the advantage that you can use dbexpress and write an app which will run under windows AND linux This is what I am using (along with Visual C++ and VB) -Original Message- From: Rodney Broom [mailto:[EMAIL PROTECTED]] Sent: 25 September 2001 22:50 To: [EMAIL P

RE: Problems getting into MySQL.com

Seems dead from where I am in the UK, Was up earlier (3PM GMT). Strange -Original Message- From: Philip Daggett [mailto:[EMAIL PROTECTED]] Sent: 29 August 2001 17:51 To: [EMAIL PROTECTED] Subject: Problems getting into MySQL.com Is anybody else not able to get onto mysql.com???

Adding that MySQL queries stats stuff to the bottom of emails?

I'm always seeing stuff like: MySQL 3.23.41-max: up 9 days, processed 115,312,654 queries (140/sec. avg) On the bottom of emails. My question is HOW do you add this to emails? Thanks lots David Ayliffe ([EMAIL PROTECTED]) Running Windows 2000 Advanced Server (SP2) Also running Suse

Can anyone help me with this Liinker error

./lib/libmysqlclient.a = library to be used -lsqlplus = library to be used. I am trying to compile the example simple1.cc which comes with the mysql++-1.7.9 package for Linux. I am trying to compile it under Suse Linux 7.1 Prof. Please help!!! Thanks in anticipation. David Ay

PLEASE help me!! MySQL Linux Problem

nu.linkonce.t.(MysqlResUse const *)+0x4d): undefined reference to `FieldTypes::init(MysqlResUse const *)' collect2: ld returned 1 exit status Please please someone help. This is REALLY starting to get on my nerves now!! Thanks lots David Ayliffe ([EMAIL PROTECTED]) --

Loading data into a remote server from csv file?

For arguments sake we can assume that the csv file is in the correct format. One for the MySQL guru's? Thanks Thanks lots David Ayliffe ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/man

C++ API Library for Windows AND Linux

A Patch for MySQL++ for use with the STLport-4.0 library (contributed by Bert Hubert <[EMAIL PROTECTED]>) MySQL++ 1.7.6a Source tarball for Tru64 Compiler (version 6.*) (contributed by Steffen Neumann <[EMAIL PROTECTED]>) <-- end from site --> Sorry for two posts in one day!

PLEASE READ: Porting Windows VC++ MySQL Proggie to Linux\Unix

proficient with this program I can move on to bigger and greater projects. ***I would appreciate ANY input*** Sorry once again if this is off topic!! Thanks lots David Ayliffe ([EMAIL PROTECTED]) - Before posting, please chec

EXPORTING DATA: OK, this might be a bit general but..

ed with MySQL because the host I'm connecting to could be Windows, Linux, Unix Sparc etc... Have a think and I'll appreciate any input you have to offer. Please bear in mind that all operations MUST BE AUTOMATED.

MYSQL++: Any ideas why this code causes the program to crash?

; row[4] << endl; } cout << endl << "Records Found: " << res.size() << endl; return 1; } <--END OF CODE--> ANY INPUT APPRECIATED Thanks lots David Ayliffe ([EMAIL PROTECTED]) ---

Just a quick question about data conversions?

In order to add data to mysql, using LOAD INTO, am I right in thinking that this file has to be local to the machine. Therefore I have to ftp the file I want inserted to the machine running the MySQL server; Correct? Thanks lots David Ayliffe ([EMAIL PROTECTED

What's the easiest way to export MySQL table structure and data AUTOMATICALLY using MySQL++?

27;s to do this? Any ideas Thanks lots David Ayliffe ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this

This is a bit off topic but...

this or are recordsets in VB the favorite? Eventually I want to add the data to a MySQL database of the users choice; but one step at a time. ALL input appreciated. Thanks lots David Ayliffe ([EMAIL PROTECTED]) - Before

RE: MYSQL++: List of databases, then tables in each database

for a second time - I didn't get much of a response from the plusplus mailing list. I assure you I have checked the web site and manual Thanks lots David Ayliffe (mailto:[EMAIL PROTECTED]) - Before posting, please check:

MySQL++ API Help

y and then exits. I'm getting linker errors all over the shop (attatched) ANY ADVICE FOR C++ DEVELOPMENT USING MYSQL++ API APPRECIATED !! Sorry if you get this more than once !! Thanks lots David Ayliffe ([EMAIL PROTECTED]) Deleting intermediate files and output files for project 'my

Microsoft Access <-> MySQL Data Conversions

(Using C++ API to get data from a mysql table. then I get stuck. How could I automatically import it into MS Access DB of users choice, formatting etc??) ANY ideas appreciated Thanks lots David Ayliffe ([EMAIL PROTECTED])

Do I need special libraries to write C++ client programs

t // and insert the table into a microsoft access database of the users choice // // Command line version of the program currently being investigated // i.e. c:\this_proggie -h host -u user -p pass -po port // // Start of development: 24th May 2001 // Date modified: 27th May 2001 // Author

Error MYSQL.H 107 Too many types in declaration

gated // I.e. c:\this_proggie -h host -u user -p pass -po port // // Start of development: 24th May 2001 // Date modified: 27th May 2001 // Author: David Ayliffe // Version: 0.1 #include #include // libraries

Simple C++ question

Its been a while since i've last touched c++ and i'm trying to include two files stdio.h and mysql.h I know that to include stdio.h I enclose it in <> but mysql.h is in the same folder as the project I know I can't use <> but what do I use instead? Thanks lots David Ayliffe ([EMAIL PROTECTED])