RE: Newbie Q: Booleans??

There is a BOOLEAN type, which really is a TINYINT. Any non-zero value is true and zero is false. I use this columnt type with all my checkboxes in Visual Basic. HTH JFernando * sql * -Original Message- From: David Hefford [mailto:[EMAIL PROTECTED]] Sent: January 31, 2003 06:46 To:

RE: sql query using select and row functions

Try ordering the records backwards, e.g ORDER BY id DESC and then limit 0, 5 HTH JFernando * sql * -Original Message- From: Christopher Lyon [mailto:[EMAIL PROTECTED]] Sent: January 28, 2003 11:26 To: [EMAIL PROTECTED] Subject: sql query using select and row functions I am trying to

Red Hat/Mandrake or Other

I would like to know which Linux Distribution is best suited to run MySQL 4.0.9. I was thinking of Red Hat or Mandrake so if someone could tell me which of these is better for a production system or if there is a better distro other than these two Your comments are really appreciated. Thank

RE: mySQL and SQL

MySQL is a relational database managament system (DBMS) that uses the SQL language for doing queries to get the inforamtion stored in it. MySQL is the equivalent as saying Oracel, or DB2. HTH JFernando * sql * -Original Message- From: Poon, Kelvin (Infomart) [mailto:[EMAIL PROTECTED]]

RE: Backups mechanism

You can do the same thing in Win32 using a vb script. Just use the Run command of the shell object to run mysqldump. This is the way I back up our database to text files that get burnt into a CD. HTH JFernando ** sql ** -Original Message- From: David T-G [mailto:[EMAIL PROTECTED]]

RE: Connecting M. Access Forms to insert data into mysql

Have you tried Linking the MySQL tables into access? I do not know why you would still have a memo field. Also if you need it you could map the memo field in Access to a TEXT or a BLOBTEXT in MySQL. If you have access to Visual Basic it could be a bettere option. HTH JFernando ** sql **

RE: Admin/Client GUI - Win32 and Linux

I like SQLyog http://www.webyog.com/ JFercan ** sql ** -Original Message- From: Nilza Lafayette [mailto:[EMAIL PROTECTED]] Sent: January 2, 2003 14:59 To: [EMAIL PROTECTED] Subject: Admin/Client GUI - Win32 and Linux I'm running MySQL onto a Windows Advanced Server. I4m looking for a

RE: start value in table

I believe it is CREATE TABLE{ id AUTOINCREMENT=1000, fld TYPE } HTH JFernando ** sql ** -Original Message- From: Martin Skjöldebrand [mailto:[EMAIL PROTECTED]] Sent: December 27, 2002 16:34 To: MySQL epostlista Subject: start value in table Sorry for this newbie question (my

RE: MyODBC with text files

I think you need the ODBC driver for plain text files to do so. It is generally installed in Win32, but I do not know about Linux. As to use MyODBC for that, I do not think it will work. HTH JFernando ** sql ** -Original Message- From: Nikola Pentchev (ESA) [mailto:[EMAIL PROTECTED]]

RE: What terminates a query?

What about the semi-colon (;) or (\g)? JFernando ** sql ** -Original Message- From: Matt Young [mailto:[EMAIL PROTECTED]] Sent: December 23, 2002 12:53 To: [EMAIL PROTECTED] Subject: What terminates a query? My sql command pipes its result to a perl program (in batch mode) . but the

RE: Using MS Access as front end to mysql database

Just be careful because the connection can be looked at and if there is sensitive data going through someone who wants to can get their hands on it. The data travelling from the server to the client is not encripted and as far as I know there are not any hosts that will offer MySQL with the SSL

RE: ADODB XML Update Recordset

How are you working with them? They are working form me doing the following: In one side this is what I do. Set rst = dbConn.Execute(SELECT STATMENT) strFileName = C:\\Path\file.xml rst.Save strFileName, 1 'adPersistXML Then to read it back I just do this? strFileName = C:\\Path\file.xml

RE: ADO Bulk Inserts

Are the inserts to the same table or different tables and columns? JFernando ** sql ** -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 9, 2002 14:56 To: MySQL List Subject: ADO Bulk Inserts Hi All, Does MySQL allow for Bulk Inserts via ADO? I can get a

RE: ADO Bulk Inserts

Have you try this: dbConn.Execute(INSERT INTO tblname(fld1, fld2) VALUES(val1, val2),(val1,val2),(val1,vla2);) JFernando ** sql ** -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 10, 2002 12:08 To: Fernando Grijalba Cc: MySQL Help Subject: RE: ADO Bulk

RE: ADO Bulk Inserts

Why do you have to do it that way? Could you do it in a loop? Do Until rst.EOF dbConn.Execute(INSERT STATMENT); Loop JFernando ** sql ** -Original Message- From: Michael She [mailto:[EMAIL PROTECTED]] Sent: December 10, 2002 13:55 To: Fernando Grijalba Cc: MySQL Help Subject

RE: MySQL Server

Parece que el user mysql no tiene permiso para escribir en el directorio donde le has puesto que ponga el soket. Asegurate de que el directorio data el dueño sea mysql. Espero que te ayude JFernando ** sql ** -Original Message- From: Vicente Valero [mailto:[EMAIL PROTECTED]] Sent:

RE: MySQL

En que sistema lo instalaste? Yo hice la instalacion en Red Hat 8.0 y lo instalo en /usr/local/mysql(version infor) y luego tuve que crear un link (/usr/local/mysql) que apuntara a ese directorio. JFernando ** sql ** -Original Message- From: Vicente Valero [mailto:[EMAIL PROTECTED]]

RE: Graphical client

I really like SQLyog. You can find it at http://www.webyog.com/ JFernando ** sql ** -Original Message- From: Massimo Bandinelli [mailto:[EMAIL PROTECTED]] Sent: November 27, 2002 10:26 To: [EMAIL PROTECTED] Subject: Graphical client Does anyone know a good graphical mysql client for

RE: getting InnoDB running on windows 2000

In your InnoDB Section you need: innodb_data_home_dir = c:/mysql/innodbdatapath set-variable = innodb_mirrored_log_groups=1 innodb_log_group_home_dir = c:/mysql/innodblogspath set-variable = innodb_log_files_in_group=3 set-variable = innodb_log_file_size=5M set-variable =

RE: why so slow?

What version of MySql? Are you connecting from Access? Are the server and the front end on the same machine? Jfernando ** sql ** -Original Message- From: Weiwei Wang [mailto:[EMAIL PROTECTED]] Sent: November 22, 2002 11:51 To: [EMAIL PROTECTED] Subject: why so slow? Hi,all: I am

RE: SELECT Statement Question

You should write: SELECT postcode FROM TABLE_NAME; This will display the postcode from your table? Jfernand ** sql ** -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: November 20, 2002 16:12 To: [EMAIL PROTECTED] Subject: SELECT Statement Question Hi I am

RE: yo

Hola Roberto, Si tu vas a http://www.free-translator.com/ y le ponse http://www.mysql.com/documentation/mysql/full/ en Systran, traducira la documentacion de MySQL a la lengua que seleciones. Entonces asi lo puedes grabar en to computadora y ya vas a tener por donde empezar. Se va a demorar un

RE: ActiveX error Visual Basic Integration MySQL

Either you are not referencing the correct library for the database access or you cannot doit from the Learning Edition. HTH JFernando ** sql *** -Original Message- From: Oliver Gottwald [mailto:goto1;enteract.com] Sent: November 6, 2002 22:26 To: [EMAIL PROTECTED] Subject: ActiveX

RE: SQL Query

Is this line correct? MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.ContactID WHERE Or should it be: MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.CustID WHERE JFernando ** sql ** -Original Message- From: [EMAIL PROTECTED] [mailto:Sam4Software;aol.com]

InnoDB row level locking?

In the documentation it says that InnoDB supports row level locking. How can I ensure that rows are locked using ADO in a VB Applications communicating with MySQL through MyODBC? I have tried setting my Recordsets to adLockPessimistic, but that does not seam to work. Any help will be really

RE: ODBC problem

How are you connecting your app? DSN, ADO Connection String, DAO, etc... JFercan *** sql *** -Original Message- From: GAY Samuel [mailto:S.GAY;envergure-conseil.com] Sent: October 30, 2002 04:47 To: Mail List MySQL (E-mail) Subject: ODBC problem Hi, To test MySQL I'm migrating a

RE: access2mysql data types

I use TINYINT. it stores 0 for false and 1 for true. I tried with enum, but the communication with MS Access was not happening. In Code you can treat this as a Boolean and in the UI if you have checkboxes the values of 1 or 0 also work. HTH. JFercan *** sql *** -Original Message-

RE: ODBC problem

user), and at work I specify root as user and the password. The open is done without error, except if I close it and reopen. But the first time the bug is on my update request. Sam. -Message d'origine- De : Fernando Grijalba [mailto:fernando;ggtours.on.ca] Envoyé : mercredi 30 octobre

RE: Re[2]: Start Transaction in InnoDB

This is what I think. When Autocommit is set you DO NOT have to enter COMMIT after you update your DB (Update, Insert Delete), but you will be changing the DB after every statement, therefore you cannot change your mind after the command is execute. Now as for BEGIN, it will begin a Transaction

RE: Query and export to a Excel file

If you have Excell you can use the Get External Data to get the data from MySQL using MyODBC. Also you can use MSQuery to query the database and send the result to Excel. Another way would be to write a macro that uses ADO and process the results into the workbook. HTH JFernando *** sql ***

Building MySQL 4.0.4 with Borland 5.0.2

Has anyone had any luck building MySQL 4.0.4 from the win32 source using the Borland 5.0.2 Compiler? Please let me know if it is possible and where can I find some guidance as to what I have to do. Thank you, JFernando *** sql ***

RE: innodb tablespace size

My guess is that you can not operate the db when space is required and you get error message. Like when trying to alter a table it will tell you that the table is full. This is because MySQL will create a temporary table drop the original and rename the new one. HTH JFernando -Original

MySQL 4.0.4 Difference

I would like to know what is the difference between MySQL 4.0.4 MAX PRO. Thank you JFernando *** sql *** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

RE: How to execute sql commands from a file?

You can try this; mysqlsource /path/source.sql or: $mysql -uuser -ppassword DBname filename.sql HTH JFernando ** sql *** -Original Message- From: Andre Kirchner [mailto:sieg1974;yahoo.com] Sent: October 22, 2002 15:58 To: [EMAIL PROTECTED] Subject: How to execute sql commands from a

RE: How to execute sql commands from a file?

You can try this; mysqlsource /path/source.sql or: $mysql -uuser -ppassword DBname filename.sql HTH JFernando ** sql *** -Original Message- From: Andre Kirchner [mailto:sieg1974;yahoo.com] Sent: October 22, 2002 15:58 To: [EMAIL PROTECTED] Subject: How to execute sql commands from a

RE: Which files to download/install - problems running MySQL

Hello, This is the my.cnf that I use in my syste. It is located in C:\. You can use it as guide. Start ## #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=D:/MySql

MySQL 4.0.4 Question

You guy recommend that I download the binaries instead of the source code. In the Win32 version of 4.0.4 is SSL enabled or do I need to download the source code and apply the flags that you mention in your sort version of the SSL Documentation so far. Also I would like to know if the Pro version

Is this possible - Remote Connection with SSL

I would like to know if this is at all possible using MySQL 4.0.4 in Windows. We want to be able to host our web site using either Windows and ASP or Linux and PHP in our service provider server. All the scripts will be in their machine away from our network. Then I would like for those