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: [EM
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 do
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 you,
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]]
S
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]]
Sent
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 go
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 **
-
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 MySQL
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
per
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]]
S
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"
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
sup
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 He
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
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
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: Decem
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]]
Sent
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 wi
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 = innodb_log_buffer_size=3M
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 runni
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 a
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 p
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]
Sen
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 erro
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 appr
I think this is because a NULL is not and empty string. They are different
things. to match NULL you got to do:
WHERE grp IS NULL or to exclude NULL: WHERE grp IS NOT NULL.
I think that NULL values are excluded from string comparisons.
I might be wrong though!
JFernando
** sql **
-Ori
Create the record for the user in the user table (do not forget to do
password=PASSWORD('pastext'))
Then insert a record in the db table with the db name you want them to
access and the options.
HTH.
JFernand
** sql **
-Original Message-
From: John Meyer [mailto:johnmeyer_1978@;yahoo.com
Why not only do:
conn.beginTrans();
//Statments
conn.commit(); or conn.rollback();
-Original Message-
From: David Shanes [mailto:dshanes@;san.rr.com]
Sent: October 31, 2002 12:12
To: [EMAIL PROTECTED]
Subject: SQL UPDATE question
Filter: SQL, UPDATE
Is there a way to do the following
How about exporting the data to text files and then importing them into
MySql.
Also you can try to write a VBScript (If you are using Win32) that connects
to both databases and select a table from one and run inserts to the other.
HTH.
JFernando
*** sql ***
-Original Message-
From: tosc
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 r
n computer) I specify no user (no
restriction for any 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
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-
From
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 smal
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 ***
---
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 ***
---
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 Mes
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/ (t
You can try this;
mysql>source /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 fro
You can try this;
mysql>source /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 fro
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
datadir=D:/
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 h
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 scripts
42 matches
Mail list logo