MySQL doesn't support foreign keys. Did you bother checking the manual?
http://www.mysql.com/doc/M/i/Missing_Foreign_Keys.html
Hello
Does mysql support creating and dropping of foreign key constraints?
i tried it.While creating foreign key constraints it doesn't dive
any error
but while
Is there any way I can delete in one table with information from another
table without doing as the following example?
SELECT column_name FROM table_1
result = 1,2,3
DELETE FROM table_2 WHERE column_name = 1
DELETE FROM table_2 WHERE column_name = 2
DELETE FROM table_2 WHERE column_name = 3
i don't know how to change registry for ODBC DSN settings in
Clarion but in Visual Basic you may easily do it via WINAPI functions.
If you interested i may send you the required vb codes.
Yusuf INCEKARA
- Original Message -
From: Amanda [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
try
echo file.sql mysql -u username -p password databasename
or on dos
type file.sql mysql -u username -p password databasename
That should execute the scripts on the db in question,
or you can download a a tool like mysqlgui/mysqlfront and
use it to load and run the queries.
Sean
[EMAIL PROTECTED] wrote:
try
echo file.sql mysql -u username -p password databasename
You mean:
^
cat file.sql | mysql -u username -p password databasename
^
Or, better:
mysql -u username -p password databasename file.sql
--
Jack Challen
whoops,
yip,
**blush**
-Original Message-
From: Jack Challen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 10:23 AM
To: [EMAIL PROTECTED]
Cc: Sean O'Donnell
Subject: Re: Hello please help me out
[EMAIL PROTECTED] wrote:
try
echo file.sql mysql -u username -p
Hi!
Cristian == Cristian Paslaru [EMAIL PROTECTED] writes:
Cristian The case for this patch is that you can do sql queries with 1.1e+1 to say,
Cristian or 1.1e01, but if you try 1.1e1 will give you an error.
Cristian I try it on MySQL 3.23.39 and 3.23.33. I think this is a very old and not
At 10:38 27/06/2001 -0700, you wrote:
Sorry, for quoting the manual but this might be just another example where
it could have the answer right away:
Hannes
http://www.mysql.com/doc/D/A/DATETIME.html
On my own mysql version :
Date TIMESTAMP default now(),
Works correctly, the date is
Hi!
ryc == ryc [EMAIL PROTECTED] writes:
ryc snip
Heikki Well, mystery solved :). Except that why MySQL uses hours to
Heikki sieve away the extraneous rows in the first query.
To be able to answer the question why:
SELECT COUNT(*) FROM table1 WHERE col1=0 and col2=0
Is slow, I would
Hey there -
I think maybe you need to attach the port number as well.
In my applications I use the URL:
jdbc:mysql://hostname:3306/databasename
Insert the correct hostname, databasename and your userId/password.
Hope it works.
Regards
Thomas
-Original Message-
From: flag
Hi,
I am running mysql 3.23.38-log with the my-huge.cnf and I saw that one table was
getting pretty close to the 2gb's so I decided to recompile the mysql with the
--with-raid parameter. And I do so, the compile goes fine and when I tried to run up
the server it did this:
root 15677 1.0
Seth Northrop writes:
Re: large replaces truncating...
I'm still trying to figure out what's going on here.. I've now tried it in
PHP and am getting the same response... Ie, given this simple script:
cut
---
Seth Northrop
Manager of Information Technology
Reflectivity, Inc.
3910
Johan Nilsson writes:
Is there any way I can delete in one table with information from another
table without doing as the following example?
SELECT column_name FROM table_1
result = 1,2,3
DELETE FROM table_2 WHERE column_name = 1
DELETE FROM table_2 WHERE column_name = 2
DELETE FROM
Hi all,
I don't know how many times this question has come up
in discussion, but I am new to the group, so please
forgive. More over, I am very new to SQL itself.
I have a small program, that connects to a database,
and tries to retrieve a part of a table. The program
is as follows:
/*
*
You also need to link in libz, so make it -lmysqlclient -lz
mysql novice wrote:
Hi all,
I don't know how many times this question has come up
in discussion, but I am new to the group, so please
forgive. More over, I am very new to SQL itself.
I have a small program, that connects to a
Doing a SELECT and then an INSERT without LOCK TABLE doesn't seem very
robust to me.
I agree. (Blush)
Why don't you simply try to INSERT and if it fails due
to a duplicate sid generate another session ID?
Good idea. (Again: blush) Thanks.
--
Herzlich
Werner Stuerenburg
Make sure mysql owns all the directories and files in its database
directory.
If you have never seen host.ISM on your .22 server, then you never looked.
It sounds like you also ran mysql_install_db and overwrote your
privilege tables. That is why they are now .MYD and .MYI.
You also probably
Hi!
I checked that in the COUNT(*) below InnoDB does
not fetch the whole row if it does the query through
a secondary index. It may sometimes have to
fetch it to determine if the row should be visible
in the current consistent read, the trx id is
stored in the whole row in the primary key index.
That makes sense, sound like I'm redoing in PHP what the UNIQUE column
already does.
So all I need to do is modify my PHP trap using mysql_affected_rows() =
0, retun a error messagu to the used indicating a rcord already exists.
Will try it, THX!
Pete
Paul DuBois wrote:
At 5:46 PM -0500
Hello everybody,
I have to create a table on a MySQL-Server with fieldnames like a35#70.
if I ty it that way
create table test (
a35#70 char (70));
on the mysql - prompt, the creation fails. Even brackets like in MsSQL
or '`' doesn't help.
Can anybody tell me what to do?
thank
Dirk
Hi!
How do you know that row is truncated ??
Filesizes for one. With just this single query the database is ca. 65K,
the update log with just this query in it is ~600k.
If you have binary data in the blob field, when you retreive a result
set, you will get it back in the binary,
I'm not getting any errors at all and the program runs just fine, except
that it's not inserting! :) selects work and everything else. Am I
missing a function or structure? Thanks...
James Gosnell
[EMAIL PROTECTED]
#include stdio.h
#include mysql/mysql.h
#include sys/time.h
int main (void)
Hi!
Thank you for the bug report. 3 lines of code had been omitted
from mysql/sql/ha_innobase.cc and that causes the timestamp
not to be updated in a row update.
If you compile yourself you can use the patch below.
Add the lines marked with '+' to function ha_innobase::update_row.
Best
why not... it improves speed and removes the overhead and limitations of
the FS.
-Original Message-
From: David Patton [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 9:20 AM
To: Wyly Wade
Subject: RE: thoughts on raw file systems
I certainly hope not :)
-Original
create table test (
a35#70 char (70));
Looks like the reason is # is the remark sign like // in php
Why don't you call the columns any name? Then you write
INSERT INTO table
(col1, col2)
VALUES ('a35#70', 'id')
or whatever.
--
Herzlich
Werner Stuerenburg
Carlos - si - las imagenes se pueden almanecer en mysql - el typo de
campo es 'blob'.
Nicole
[EMAIL PROTECTED] wrote:
Hola,
para un desarrollo en java con acceso a una base de
datos en MySQL, necesitaria saber si alguien ha
implementado imagenes con MySQL? . ¿Se pueden almacenar
Because our company works with a standard - tabledefinition in
many enviroments like db2, mssql ... So I got no choice but to use
those crazy fieldnames.
And because the fieldnames work fine on the other db-systems we
use, I hoped there is a trick that lets even MySQL work with these
names.
Mit
I would greatly appreciate your posting of a Solaris package
of the MySQL 3.23 distributions in order to simplify installations
on a Solaris platform. Please cc me directly in your response
if this would be possible.
many thanks for your help,
Bryan
Bryan J. Byerly
[EMAIL PROTECTED]
At 11:57 AM +0200 6/28/01, Kaneda K wrote:
At 10:38 27/06/2001 -0700, you wrote:
Sorry, for quoting the manual but this might be just another example where
it could have the answer right away:
Hannes
http://www.mysql.com/doc/D/A/DATETIME.html
On my own mysql version :
Date TIMESTAMP default
WW Can you use a raw partition with MySQL much like you can with Oracle or
WW Sybase?
Probably tables with InnoDB type can work on raw devices.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)
Is there an easy way to restore just one table from a mysqldump of all the
tables?
Dave
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Quick question - just signed up for this list and I was wondering if it
would be possible to put a [MySQL] tag in the subject line?
There doesn't seem to be a standard identifier in the messages and
although I am filtering the entire header looking for instances of
mysql my reader (
if you just need to call your field a35#70
for retrieval purposes
why don't you call it something else and alias it in your select statements.
select col1 as 'a35#70' from test;
if this doesn't help perhaps explain why you absolutely need your field
named a35#70.
it will make it easier to
I get this error on my mysql client
(filter): error in loading shared libraries
libmysqlclient.so.10: cannot open shared object file: No such file or directory
Vien Huynhle
Clearsail Communications
On 28-Jun-01 Dave Brown wrote:
Is there an easy way to restore just one table from a mysqldump of all the
tables?
If the (empty) table already exists:
grep INTO table VALUES backup.dmp | mysql dbname
If it doesn't then use awk to create it:
awk '/^CREATE TABLE table/,/^);/' backup.dmp |
Hi,
I'm having a very annoying and elusive problem. You probably won't be able
to help me, but any guess or pointer would be appreciated nonetheless.
The main table in the db contains some 50 fields, mostly of type varchar
and tinyint. This table is updated through php.
Now the problem is:
Hello,
I am just learning Mysql and was reading a general SQL book. The book talks
about creating views for joins (CREATE VIEW ...)that you regularly use. I
can not find out if Mysql supports this and if it does, how do I perform
this.
Thank you in advance,
Bob
Dear friends,
I'd like to know how to compile my own 'errmsg.txt' to 'errmsg.sys'. I know that
there is an utility called 'comp_err' but i dind'nt find it in the Windows
distribution of MYSQL.
The matter is that the error message file for spanish language in the last
distribution
Hope you can find the problem in the following SQL command:
delete from alarms where raiseTime = ( select MIN(raiseTime) from alarms)
limit 1 ;
raiseTime is of type BIGINT.
I'm attempting to do a select via PHP where I want to get a list of unique
records for example if my table is as follows
+-+--+
| bluefish| blah|
+-+--+
| bluefish| blah|
+-+--+
| redfish | blah|
On 28 Jun 2001, at 8:44, Dave Halliday wrote:
Quick question - just signed up for this list and I was wondering if it
would be possible to put a [MySQL] tag in the subject line?
Please - no, those take up to much room and remove from the Subject area. I *hate*
those tags, they're
Here's a messy hack that would let you use your column names like
'a35#70' to select and insert.
Set up a table like this:
col1a35#70
col2a35#71
col3a35#72
...
Then make a routine in your middleware that select * from this
table and returns the results in a named array or hash
server version 3.23.35
-Original Message-
From: Khan, Jawad [COLE:6S34:EXCH]
Sent: Thursday, June 28, 2001 1:13 PM
To: '[EMAIL PROTECTED]'
Subject: I get SYNTAX ERROR 1064 with mySQL 3.2.3 when using delete
as shown
Hope you can find the problem in the
On 28-Jun-01 Dave Halliday wrote:
Quick question - just signed up for this list and I was wondering if it
would be possible to put a [MySQL] tag in the subject line?
You just signed up want everybody to accomodate your broken mailer.
There doesn't seem to be a standard identifier in
ryc snip
Heikki Well, mystery solved :). Except that why MySQL uses hours to
Heikki sieve away the extraneous rows in the first query.
To be able to answer the question why:
SELECT COUNT(*) FROM table1 WHERE col1=0 and col2=0
Is slow, I would need to get an EXPLAIN for this query.
On 28-Jun-01 Matt \TrollBoy\ Wiseman wrote:
I'm attempting to do a select via PHP where I want to get a list of unique
records for example if my table is as follows
+-+--+
| bluefish| blah|
+-+--+
| bluefish| blah|
When you delete a row from a table that may be referenced in another
table... you must delete all references to it from the other tables. This is
done in the same way in which you deleted the first row...
ryan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
As long as MySQL doesn't manage the
--- Stoyan [EMAIL PROTECTED] wrote: hi,
why don't you try to use this:
SELECT * FROM BOOK WHERE author LIKE '%charles%dickens%';
That query takes 6.4 seconds. My query (MATCH author AGAINST ('charles')
and match author against('dickens')) takes 1.3 seconds. Fulltext searching
is MUCH
On 28-Jun-01 Jawad Khan wrote:
Hope you can find the problem in the following SQL command:
delete from alarms where raiseTime = ( select MIN(raiseTime) from alarms)
limit 1 ;
That is a sub-select, currently unsupported in MySQL.
try :
delete from alarms order by raiseTime limit 1;
Hi,
We have been running MySQL for a while accessing it with the MM driver
and in applications everything works well. I'm a newbie in trying to
build an applet, and when I try to access the driver to make a connection,
I get a notinited error in the browser. In the Apache error_log
is a
At 18:18 28/06/2001 +0200, PABLOSKY® wrote:
Hi,
Thanks for the bug report.
Sorry for the inconvenience with the partial translation of
the errmsg.sys file. I will the translation and send you the
new errmsg.sys as fast as possible.
Regards,
Miguel
Dear friends,
I'd like to know how to
I will give this a shot - thanks!!!
Dave
There doesn't seem to be a standard identifier in the messages and
although I am filtering the entire header looking for instances of
mysql my reader ( Pegasus ) doesn't always catch it.
[snipped to conserve bandwidth]
Type of rule:
Hello everyone,
I am a beginner, can you please put me through setting up
MySql database downloaded from the site http://www.mysql.com .
I could have downloaded the wrong thing.
Thanks.
Dots.
-
Before posting, please check:
I am running mysql version 3.22.32 on freebsd version 4.2 I am running a
high traffic BBS on an Apache web server (PERL) that connects to the
database server through DBI. MySQL is crashing every two minutes or so.
- My file descriptors and max files are set high, per process and for the
Jon Haworth wrote:
Hi list,
Sorry if this appears twice, our mail server is playing up at the moment.
We've got an sql file that was created using mysqldump on an NT box. The
info in this file needs to be imported into MySQL on a Linux box. When I run
/usr/local/mysql/bin/mysql
Hi...
I am new to MySQL and trying to write some database queries.
(Basically, I am developing a WEB application using Pearl script. The data
is stored in MySQL database. Pearl scripts access the database via Pearl
DBI)
I could not find any info about cursor definitions in MySQL
On Thu, 28 Jun 2001 15:30:14 -0300, Alejandro Ralla [EMAIL PROTECTED]
wrote:
You would need to reformat the input date first, within your middleware, like
Perl or PHP. Then you would be able to enter it into your db.
Hi guys, does anyone help me with this simple thing ??
I have a date format
Hi!
Heikki == Heikki Tuuri [EMAIL PROTECTED] writes:
Heikki Hi!
Heikki I checked that in the COUNT(*) below InnoDB does
Heikki not fetch the whole row if it does the query through
Heikki a secondary index. It may sometimes have to
Heikki fetch it to determine if the row should be visible
Hi All,
I am new to MySQL and have a problem using winmysqladmin. MySQL is working fine,
which I can access the database from my Java apps. However, when I tried to use
winmysqladmin to obtain my db and table info, winmysqladmin never connects with MySQL
and I can't obtain the info.
http://www.mysql.com/manual.php (the manual) Your New Friend
-Original Message-
FROM: [EMAIL PROTECTED]
TO: [EMAIL PROTECTED]
DATE: Thu 6/28/01 13:21
SUBJECT: setting up MySql database
Hello everyone,
I am a beginner, can you please put me through setting up
MySql database downloaded
Hi!
Peter == Peter Zaitsev [EMAIL PROTECTED] writes:
Peter Hello Michael,
Peter Thursday, June 28, 2001, 1:52:09 PM, you wrote:
Peter I started to often get the followings in a log file:
Peter 010628 13:49:28 Aborted connection 627619 to db: 'counter' user: 'titan' host:
`pan.local' (Got
What programming language are you using?
Hi guys, does anyone help me with this simple thing ??
I have a date format problem, I need a spanish format please read the
following lines:
Receive from input 28/06/2001
Want to change it to 2001-06-28 to write the Database
Use to do it DATE_FORMAT
James Gosnell writes:
I'm not getting any errors at all and the program runs just fine, except
that it's not inserting! :) selects work and everything else. Am I
missing a function or structure? Thanks...
James Gosnell
[EMAIL PROTECTED]#include stdio.h
#include mysql/mysql.h
#include
Michael Tam writes:
Hi All,
I am new to MySQL and have a problem using winmysqladmin. MySQL is working
fine, which I can access the database from my Java apps. However, when I tried to
use winmysqladmin to obtain my db and table info, winmysqladmin never connects with
MySQL and I
At 12:28 28/06/2001 -0700, Michael Tam wrote:
Hi,
WinMySQLAdmin only shows for you the db and table info,
when is able to do a connection using an user name and
his password which are edited at first start and when
the my.ini file exist.
So, if you are not using my.ini file, then the tool doesn't
How did you get MySQL up and running on your PC?
I am trying to get MySQL running on my PC and I cannot find out how to even
start it. Is there an installation manual in the files? Is there a manual on
how to use MySQL in the files?
Bomber Steel
-Original Message-
From: Michael Tam
On Thu, 28 Jun 2001 21:49:57 +0200, Sebastiaan J.A. Kamp [EMAIL PROTECTED]
wrote:
if your using perl, heres a real simple way to format your date:
my $date = 28/06/2001;
my($mn,$day,$yr) = split '/',$date;
my $db_date = join('-',$yr,$mn,$day);
# Your output should now be $db_date = 2001-06-28
hi all together!
i'm turning to your mailinglist as last chance to find s.o. helping me with my problem.
the situation is as follows:
i got a table on a mysql-database, queriing it by php4. the table consists of all
planets of the planetarion.com-system. these information consists of each 3
Description:
I am trying to get the next record given a key (numeric or string),
What is the best way to do this. I am currently using:
SELECT * from wk004.slsf01 where ___RecNo 3000 limit 1;
table typepossible_keys key key_len ref rowsExtra
Hi All,
My unix client process got blocked at the reconnect attempt when the
Linux box running MySQL server went down. I don't know how to set
timeout value on the mysql_connect() call. Anyone know a good way to
stop the function from blocking forever without killing the process ?
I am using
Hi,
Where would I find the logs files from Mysql on a NT4 server? I have
Nusphere Mysql installed with Apache/PHP and Mysql
I monotor the Apache Error and Access logs, but should'nt there be logs
generated by Mysql?
I don't want to run out of disc space cause I neglected to clear them
out.
Does any body know how to open a x.tar.gz.asc file?
I know what a tar file and gz but i can't find anything on how to open a tar.gz.asc
file.
Pete:
Check the config file (C:\MY.CNF or C:\WINNT\MY.INI) ... you should see a
line like:
log=d:/mysql/mysql.log
If the line if commented out (# log=d:/mysql/mysql.log), then logging is
off. Remove the #, shutdown and restart the mysqld server.
Gerald Jensen
- Original Message
NOTE: I replied off-list
First note: I like the e-mail address. Really great.
Secondly: The best VB/DLL documentation you could find MIGHT be a project
that has done what you want. If you download the source classes for the
MyVbQl VB API http://www.icarz.com/mysql/index.html it will tell
I have seen the smart way to insert data into tables based on a select
statement posted recently on this list. Is this also possible for an update
query?
I want to do something like:
UPDATE TABLE foo
SET foo.field1 = SELECT bar.field1
FROM bar
WHERE foo.field2 = bar.field2;
Thanks in advance
On Thu, 28 Jun 2001, wkd wrote:
Does any body know how to open a x.tar.gz.asc file?
I know what a tar file and gz but i can't find anything on how to
open a tar.gz.asc file.
.tar.gz.asc is an ascii file containing the signature of the .tar.gz in
question - either generated by md5sum
Hi, 8 -)
I'm a newbe to mySQL. So, please excuse me if I ask a question whose answer
appears obvious to you.
How can I get mySQL to create a table for a IIS web logfile (*.log) ? The
file is very long (maybe 1 million records +) and there are 16 space
separated data fields (17 if you include
Hello.
Views are not supported (yet). I tried to search for VIEWS in the
online manual and it came up with the following section as first link:
http://www.mysql.com/doc/M/i/Missing_Views.html
Bye,
Benjamin.
On Fri, Jun 29, 2001 at 02:44:44AM +1000, [EMAIL PROTECTED] wrote:
Hello,
- Original Message -
From: Charles Henderson [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 28, 2001 4:33 PM
Subject: MS IIS web logfiles
How can I get mySQL to create a table for a IIS web logfile (*.log) ? The
file is very long (maybe 1 million records +) and there
Hello.
On Thu, Jun 28, 2001 at 10:48:23PM +0200, [EMAIL PROTECTED] wrote:
[...]
the user inserts some wished dates (the lowest score, the searched
planet may have, the highest, the highest number of roids and the
lowest..) and the number-interval in wich the _galaxy-score_ may be
included.
I do aggree with dave's point. Could we do that, please
On Thu, 28 Jun 2001, Dave Halliday wrote:
Quick question - just signed up for this list and I was wondering if it
would be possible to put a [MySQL] tag in the subject line?
There doesn't seem to be a standard identifier in the
On Fri, 29 Jun 2001 01:14, Dave Halliday wrote:
Quick question - just signed up for this list and I was wondering if it
would be possible to put a [MySQL] tag in the subject line?
There doesn't seem to be a standard identifier in the messages and
although I am filtering the entire header
I'm filtering on List-ID header contains mysql.mysql.com Works great.
j- k-
On Thursday 28 June 2001 17:05, Sherzod Ruzmetov wrote:
I do aggree with dave's point. Could we do that, please
On Thu, 28 Jun 2001, Dave Halliday wrote:
Quick question - just signed up for this list and I
I have a Perl script that I use to parse and insert all my Unix logfiles
into a MySQL server. I can post the script if you would like to have / view
/ steal of whatever.
-Paul
- Original Message -
From: Dennis Salguero [EMAIL PROTECTED]
To: Charles Henderson [EMAIL PROTECTED]; [EMAIL
Dear Sir:
The Version of Mysql is mysql-3.23.38. The OS is Win NT SP 5.
I have a problem with below SQL Statement
Select Sum(Cost) as TotalCost from Item
All the entries for Cost Field has the Value Null. The result of this Query
is TotalCost = 0.
But is not it suppose to be Null
hi all together!
i'm turning to your mailinglist as last chance to find s.o. helping
me with my problem.
the situation is as follows:
i got a table on a mysql-database, queriing it by php4. the table
consists of all planets of the planetarion.com-system. these
information consists of each 3
I am trying to connect to MySQL using a connection string using VB6. The
read part is great but I don't seem to be able to add records. Can anyone
steer me in the right direction?
[EMAIL PROTECTED]
-
Before posting, please
How can I increase the packet size used in mySQL i.e. increase the value of
'max_allowed_packet' to a larger number from a script.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
All of the suggested methods for filtering mail from MySQL list is
great...for those using an actual mailer program. For people sitting on
web based email services, they don't have that capability (except for
maybe sorting based on subject, receive date, or something like that),
and having
- Original Message -
From: Robert Skinner [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 28, 2001 7:44 PM
Subject: Connecting to MySQL w/VB
I am trying to connect to MySQL using a connection string using VB6. The
read part is great but I don't seem to be able to add
Hello
I had installing mySQL as well myODBC, but when I run mysqld it has given an
error
C:\mysqld
error: Found option without preceding group in config file: c:\my.cnf at
line: 1
Program aborted
Next time I had write a file my.cnf as
innodb_data_file_path =
At 7:08 PM + 6/28/01, Yamuna Vallipuram wrote:
Hi...
I am new to MySQL and trying to write some database queries.
(Basically, I am developing a WEB application using Pearl script.
The data is stored in MySQL database. Pearl scripts access the
database via Pearl DBI)
I could not find any
i know i am definitly knew at this, but his permissions could be set more or
less for read only.
i am just spitting junk out, i am new, but i don't like sitting idle in a
group. i have been watching this thread closely, because i do developement
on a large scale in ASP and VB.
so just ignore
- Original Message -
From: Jason Brunk [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, June 28, 2001 8:18 PM
Subject: Re: Connecting to MySQL w/VB
i know i am definitly knew at this, but his permissions could be set more
or
less for read only.
Yes, it's possible that the
just curious, how do you connect to mysql through ASP? i have tried
connecting with MyODBC, i installed myodbc and then i create the
connection string in asp like this
set conn=server.createobject(adodb.connection)
conn.open
driver={mysql};server=192.168.0.1;user=user;pass=pass;database=db1
i
i have a database and a table:-
mysql describe phone;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| name | blob | | | | |
| add1 | blob | | |
[EMAIL PROTECTED]
WWW.SSZGO.COM
SSZGO International is back, introducing its new website WWW.SSZGO.COM v4
IT IS RANDOM...IT IS MODULAR... a new level in flash actionscripting...
ARE YOU IN NEED OF CREATIVE WEBWORK?
DONT MISS THE OPPORTUNITY :
GREAT CUSTOM DESIGNS AT GREAT PRICES,
On 29-Jun-01 Kris Amy wrote:
i have a database and a table:-
mysql describe phone;
+---+--+--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-+---+
| name | blob | | | | |
yes i search on phone number. it's indexed(7) and the format of the phone
data is (XX) .
is there anyway this could be optimized. I will eventually remove the spaces
and the first 4 characters from the input data and reload it in
Kris Amy
-Original Message-
From: Don Read
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I've searched through the archives, and while some things were slightly
similar, I couldn't find anything that matched well.
I'm using the Linux Debian packages for MySQL 3.23.39.
The problem I'm having is this: While the program i'm developing is
1 - 100 of 106 matches
Mail list logo