 | | | MySQL on Win32 | | I installed mysql 4.0.24 on my windows xp sp2 box and was able to do some
simple testing following the documentation. I was wondering where I can find
more thorough test suite for mysql on windowsI wish to store keywords for a fulltext search in one table to search against another table. Is this possssible
SELECT *
FROM items search
WHERE search.id 'xxx '
AND MATCH (title desctexI 'm having problems with the syntax for entering data. I 'm using
objRS.AddNew
objRS( "Name ") name
objRS( "Address ") address
objRS( "City ") city
objRS( "State ") state
objRS( "Z04202005 1131 GMT-6
Would some one please explain to me what this line of code means
mysql_result($result 0 0)
Wade
i cant seem to get anything over 16 Meg into a table?
How are you trying to see the value after setting it and how are you setting it?
Be aware that we have two scopes the session (local) and the GLOBAL
one each one with different values.
On 4/19/Hi
Thank You for you answer but I need to store a .Zip file.
Any other suggestion ???
Thank You.
Regards.
for those having problem in connecting to my sql using borland c++
>i m using Borland C++ ver 6.0 and i m trying to connect to mysql ver 4.01
>when i place a connection control in my form it give mHi!
Greetings to all from the MySQL Users Conference 2005 in Santa Clara! The
conference has just kicked off with tutorials and will last till Thursday.
Close to 1000 people are expected to atHello
anyone know how to store a file into a table field???
Thank You.
Regards.
Hi
I am using MSSQL4.1.
This is my first time compiling a mysql client
program. Below is my very simple source file
#include <stdio.h >
#include <mysql.h >
int main(int argc char *argI 'm using MySQL 4.1.7 and InnoDB tables. I 'd like to lock some tables for
(write and) read of other users during a transaction like this
START TRANSACTION
LOCK TABLES T1 T2
...
...
UNLOCK
i m using Borland C++ ver 6.0 and i m trying to connect to mysql ver 4.01
when i place a connection control in my form it give me the following error message unable to load libmysql.dll
copying04142005 1704 GMT-6
Ok. I just said I couldnt find the code on control center but I did find
it. Now I want to get the code into the hosted db.
I receive this error
You have an error 04142005 1620 GMT-6
I have just finished working on a project and I need to get the sql code
that creates all the tables in my db and upload it through phpMyAdmin.
I have mysqlControlCenter buGreetings
I am using version 4.1.7 at XP Athlon XP 2.0 512 RAM 80GB HD
accessing MySQL using VBMySQLDirect.dll at VBA (Word) the app crashes
when I use LIMIT queries at win98 the error repoI have a db on my development server. I am ready to move this DB into production. Can I just copy the files into the production server 's mysql/data folder and have it work.
I am trying to avoid nHi All
I 'm having some odd problems with my server. About once a week it seems to stop responding to all queries or taking a very long time to respond. (an hour or more.)
Under normal circumstanHas anyone run into the situation using mysql where set wait_timeout X
and set interactive_timeout x do not work. I 've tried them from inside
the client under root user and in the my.ini file befoCan someone please remove lpinaud@(protected) from the list? Every time I
post I get one.
---------- Forwarded message ----------
From postmaster@(protected) <postmaster@(protected) >
Date Apr 12 2005 Hi All
Found that when I executed my DDL script on a Win32 installation of MySQL
(v4.0.18) it converted all of my table names to lowercase.
The problem was that after I had filled the newly crHello
This is a silly question at least for those of you who know about MySql. I
am building a db for my site and to get to nf3 have created a table for
each room in a house. The question is I have a mySQL database on my server that clients will need to access to run
reports regarding their specific data. I 'd like to set up a menu system
with restricted access based on their logon infoHello
Building a db for my site. Visitors will be able to upload their property
details into the db but I need their username and password to expire after
a set period can this be done? Or ca
send table definitions and copy of statement and error message.
It seems like an error in a smal detail.
mit freundlichen Gr??en
Thomas Treffehn
Hans Brochier GmbH & Co KG
AbteiAccording to the online manual the syntax is
INSERT [LOW_PRIORITY | HIGH_PRIORITY] [IGNORE]
[INTO] tbl_name [(col_name ...)]
SELECT ...
[ ON DUPLICATE KEY UPDATE col_name expr ... ]Time is stored in a 24 hour format in the database but I need to translate
to a normal 12 hour am/pm format. I am looking through the documentation
for an easy solution to this but I am not having Hi
I want to have two instances of mysql server on one PC.I need to have both servers to listen on port 3306 so I have configured the NIC to have two IP addresses.
10.10.100.11 and 10.10.100.13There is a simple way to get a working MySQL import library for
Mingw. The particular flavor of the library (for example
libmysqlclient.a) depends only on how you edit a .def file for Mysql
dll.Well I have already installed on my PC NuSphere PHPEd and MySQL 5.0.3. When I try to use one of the functionalities of NuSphere that interacting with MySQL Server the system return this error
Co |
|
|
