Best I can come up with is something like
2 words:
SELECT c1.id
FROM crossref c1, crossref c2
WHERE c1.word='word1'
AND c2.word='word2'
AND c1.id=c2.id
3 words:
SELECT c1.id
FROM crossref c1, crossref c2, crossref c3
WHERE c1.word='word1'
AND c2.word='word2'
AND
I can install other moduels successfully. But when it comes to DBI, and
DBD::mysql, it keeps throwing out the following error:
make - not ok
make returned bad status
I am lost :-(. What could that be?
-sherzodOR
-
Before
Try to use PPM utility (if you use ActivePerl).
Dmitri Lubinski
-Original Message-
From: sherzod ruzmetov [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, July 11, 2001 10:23 AM
To: MySql Mailing List
Subject: Installing DBI
I can install other moduels successfully. But when it comes to
On Wed, Jul 11, 2001 at 01:31:15PM +1000, pak wrote:
So is MySQL not suitable for large corporate database ?
It often depends on the corporation and who makes the decisions. In
many corporations, it's the folks who know little about the
technology. In the minority of them, it appears to be
What didn;t work,,,what happened?
Ken
- Original Message -
From: Brad Lipovsky [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, July 10, 2001 11:24 PM
Subject: [PHP-DB] cookie problems
can anyone help me with this code? i cant believe it wont work, it seems
pretty simple!
Hi,
I am a just a solaris newbie. I tried installing mySQL
3.23.39 on solaris 8 (intel). I followed these steps(I
used GNU tar):
#groupadd mysql
#useradd -g mysql mysql
#cd /usr/local
#gunzip /path/to/mysql-VERSION-OS.tar.gz | tar xvf
-
#ln -s mysql-VERSION-OS mysql
#cd mysql
Hi Ken,
Here's you answer :
Common Pitfalls:
a.. Cookies will not become visible until the next loading of a page that
the cookie should be visible for.
b.. Cookies must be deleted with the same parameters as they were set
with.
Check out :
Hello!
I'm new at this list, but as far as I could search through the archives,
I didn't find the reason of my problem.
Here it is:
I manage a list of mailing-list members with approx. 8000 records in
this table:
+---+--+--+-+-++
| Field |
At 22:41 10/07/2001 +0200, you wrote:
after reading the excellent docs, I was just a little confused as to the
actual length of the TEXT datatypes. Are they really as long as you like?
See http://www.mysql.com/doc/n/o/node_180.html
And does anyone have any tips for indexing (searching)
perhaps give a little more info as to what is on your screen before the
error?
ryan
- Original Message -
From: sherzod ruzmetov [EMAIL PROTECTED]
To: MySql Mailing List [EMAIL PROTECTED]
Sent: Wednesday, July 11, 2001 1:22 AM
Subject: Installing DBI
I can install other moduels
can any one help me. I am trying to connect to mysql database via a c
program. The program compiles fine but I keep on getting the following error
when I try to run my a.out file
./client: error while loading shared libraries: libmysqlclient.so.10: cannot
load shared object file: No such file
Good Day,
I need few technical information abaut mysql database like max tables, max
columns in table, max rows. max database size, etc. for Windows NT or
Windows 2000. I can't find it in your internet pages. I interested alsow in
coporate mysql with Lotus Notes. Please send me infotrmation
On 11-Jul-01 Nelson Goforth wrote:
I'm trying to return several pieces of information from a small table.
Table is 'tickets':
idCHAR(50)
group CHAR(50)
issuedDATE
used DATE
'issued' and 'used' are NULL until a date is entered. The found set
is
Hi;
Does mySql run under Dos? I have an old dos database written in Clipper. with simple
user interface. I am looking for a language which can programe a new database in
combination with mySQL. On condition is that: It must be in text-mode enviroment.
mySql run under Linux. It seems that I
Hello all,
using mysqlversion 2.23.30
I have the problem that mysql doesn't want to use an index.
I tried USE INDEX() but that doesn't help either.
I have a tables with 250k rows
person(
idint, (indexed)
name varchar(40),
fatherid int,
I create a table, one field is integer type.
I don't know why the following statements work :
select * from table1 where field1 = 3;
select * from table1 where field1 = '3';
In the second case, MySQL automatically casts '3' to 3.
I have Mysql 3.22 and PHP4 installed with RedHat 7.0 linux distribution.I created a
script connecting my html page with mysql database(function mysql_pconnect).Everything
was working just fine one day but on the next day I saw a message on my screen "Call
to undefined function
Hi,
I'm a little bit new here, so I don't know this has been asked before.
Anyway..MySQLGUI 1.7.4 and 1.7.5 (Win32) both crash if you select
Administration-Set Password:
The statement in 0x77f74d8a points to memory in 0x1fe1 ...
This shouldn't happen. What am I doing wrong here?
Regards
Hi,
i have installed mysql on windowsNT.
as i testing the Example program for testing of libmysql.dll
i got error while compiling with vc++
as: Output Window
Linking...
e:\mysql\lib\debug\libmysql.dll : fatal error LNK1136: invalid or corrupt
file
Error executing link.exe.
how can this
r I was not aware of placeholders, and the benifits of using them instead of
r using $dbh-quote(). It doesnt make sence that the DBI version of quote isnt
r as thorough as having the code behind placeholding do it.
I'm not DBI guru but I've seen that quote() doesn't quote some data
correctly.
Is it better to let mysql handle logins or to create a table with this
info?
I'm setting up a db that has faculty and students. Currently, all access
to the db is through user root. I read the General Security issues and
this seems to be a problem.
The db will be accessable on the web, but I
Hi
Well if you are using PHP, what we do is have one user e.g. 'PHPLOGON' that
conects to the DB.
Then when the user logis on thay enter a user name and password, php looks
this up in a table on MySQL (useing user PHPLOGON) and looks in table
faculty (username,password).
This way users do not
Hello
I have Linux Red Hat 7 server with MySQL database server
I would like to connect a win 2000 computer via IP throught MyODBC
When I try to connect ODBC driver return host unable to connect this
MySQL server
I have create an user with host with all
access on mysql database
What's
I wouldn't advise accessing databases using the root user through the web.
Pieter
Channon Quillen wrote:
Is it better to let mysql handle logins or to create a table with this
info?
I'm setting up a db that has faculty and students. Currently, all access
to the db is through user root.
Greg Cope wrote:
Pete Kuczynski wrote:
Hi,
I've posted this question before, and some were kind enough to respond
with suggestions to my question [replication], but I'm looking for
something more difinitave.
Background: I'm running a production mysql database/php4/Apache on a NT4
man ldconfig
If you are running Linux, add the library directory to ld.so.conf
and run ldconfig.
Your linker does not know about the libraries.
my limp wrote:
can any one help me. I am trying to connect to mysql database via a c
program. The program compiles fine but I keep on getting the
[EMAIL PROTECTED] writes:
Hi,
I'm a little bit new here, so I don't know this has been asked before.
Anyway..MySQLGUI 1.7.4 and 1.7.5 (Win32) both crash if you select
Administration-Set Password:
The statement in 0x77f74d8a points to memory in 0x1fe1 ...
This shouldn't happen.
Gilbert C Healton wrote:
I've been attempting to create a mySql database while granting
administration user permissions on just that database to a
particular user. I suppose I'm overlooking something simple, but I
just can't get it after a full day of playing. My root user and its
Description:
I have two MySQL servers (version 3.23.39) configured for two-
way replication; call them server A and server B. When a large
row (~ 3Mb) is entered into a mediumblob field in a table on server A,
this row is replicated to server B. Since the servers
Hi;
Does mySql run under Dos? I have an old dos database written in Clipper. with simple
user interface. I am looking for a language which can programe a new database in
combination with mySQL. On condition is that: It must be in text-mode enviroment.
mySql run under Linux. It seems that I
Use another table to hold these values.
This table contains the ID that you are searching on and the key
to the other table that contains the rest of the data.
t1 : mykey , field1, field2, field3, field4 .
t2 : mykey , ID
Select * from t1,t2 where t1.mykey = t2.mykey and t2.ID=IM34485;
You would be better off having one table that contains
userid, productid, catagory, comment.
Then if you add a catagory you don't have to add a table.
You can select based on any combination of the above fields.
MeTeX wrote:
Hi right now I am just developeing a complex listing for 500+
Gerald,
You lost me on the second table, t2?? The t1 table would store a 'mykey' and the
multiple values(ID's) and table t2 would have the reference 'mykey' to table t1
and the ID column,... this is where you loose me??
On Wed, 11 Jul 2001 08:26:11 -0500, Gerald Clark [EMAIL PROTECTED]
I agree that answer was rude, and uncalledfor, but you won't inspire
others to help by being rude in return.
The RPM files age generated by people using Linux.
If Solaris has a packaging routine, and someone compiles if for your
version of Solaris, it will probably be found on mysql.com.
If
If you are using 'replication', and trying to do bi-directional
replication, you will ( unless you are very careful ) have this problem.
The auto increment id is passed with the rest of the data to the slave.
If you are inserting on both masters and each assigns the same id, the
replication
3.22.38
Hello guys
I figured out how I can set up different user that are able to work
on their own dbs.
here is my command to add a db and a user;
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP ON bernddb.* TO
bernduser@LOCALHOST IDENTIFIED BY '1234'
But a questions:
when I have added
Use
mysqladmin shutdown
to stop the server.
You should have run myisamchk to fix the tables.
When you copied the tables from backup you probably changed the user
and permissions.
Ransom wrote:
I was updating a database and my database got corrupted ( I'm not sure
what coused this) but ever
Hi all
I' wondering if someone can help me out here.
I need to do a three table join. Normally not a problem but in this case I have to
select usernames from a users table twice. One for each of two other tables. I'll need
to use a user_id (int) to do the select and then join on the name
Hi everyone.
Please see below, I cannot login as the root user in MySQL. Access-Denied
... any ideas anyone?
My System = RedHat Linux 7.0 (all latest patches applied) Intel Pentium III
MySQL rpm's installed =
MySQL-3.23.39-1.i386.rpm
MySQL-client-3.23.39-1.i386.rpm
Hi,
is it true that dots were legal in MySQL 3.22.32?
Thanks
Marc Delisle
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request
Hi
I've installed mysql 3.23.39 on a rh 7.1 machine.
i followed every possibl step and yeah it dumped it in the correct locations
for all.
Is it possible to migrate/re-install mysql in another location, say
/usr/bin/sql instead of the 7.1 convention of /usr/local/bin.
Is this a possibility?
Hi!friend
I use win2000 and IIS as web server.and I have a Freebsd mysql
server.I want to connect the mysql server under the win2000.What shall I do?
and how the web page (in win200) can use the my mysql server(on freebsd)??
Thanks!!
zosen
Hi everyone.
Please see below, I cannot login as the root user in MySQL. Access-Denied
... any ideas anyone?
My System = RedHat Linux 7.0 (all latest patches applied) Intel Pentium III
MySQL rpm's installed =
MySQL-3.23.39-1.i386.rpm
MySQL-client-3.23.39-1.i386.rpm
Mike Sosteric wrote:
Hi all
I' wondering if someone can help me out here.
I need to do a three table join. Normally not a problem but in this case I have to
select usernames from a users table twice. One for each of two other tables. I'll
need to use a user_id (int) to do the select
Looks like there's a set of mysql binaries on www.sunfreeware.com. I'd
guess they should install fairly easily.
James
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/
On Wed, 11 Jul 2001, Gerald Clark wrote:
On Wed, 11 Jul 2001, Gilbert Healton wrote:
The key commands are:
grant all privileges on Baseball.* to gilbert identified by first
with grant option;
cut cut cut
try to 'gilbert'@'%'
or replace % with localhost or
Maybe it's about time you stopped being a fuckwit and read the whole message
dip shit.
file://Kris
-Original Message-
From: Gerald Clark [EMAIL PROTECTED]
To: Breughel Macabuhay [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED] [EMAIL PROTECTED]
Date: Thursday, 12 July 2001 12:36
Subject: Re:
is it true that dots were legal in MySQL 3.22.32?
i think they were legal.. but it's a very good question - because this leads
to an error:
show tables from test.db
- You have an error in your SQL syntax near '.db' at line 1
If there is a db with a dot in it, you have only the chance to get
No, I don't do such things, the 'replication' means only that I download
from an other machine some text files, with e-mail addresses and insert
them into the table. So no id nor other fields are replicated, just the
email field from a text file. (a perl script reads and inserts them).
The
Try
mysql -u root -p
Or just restart mysql with --skip-grant-tables
and see what is up...!
Simon
-Original Message-
From: Neil Barnes [mailto:[EMAIL PROTECTED]]
Sent: 11 July 2001 15:19
To: [EMAIL PROTECTED]
Subject: Cannot Login as ROOT
Hi everyone.
Please see below, I cannot
I was wondering if anyone had any suggestions on the following problem. I have a
table with about 7 million rows, and I'm using the following join:CREATE TABLE
badge_history_resolved SELECT badge_history.id AS id, badge_history.xact_date AS
xact_date, badge_history.xact_time AS xact_time,
Still traveling very slowly down the newbie road with PHP and mysql.
I finally succeded in getting the INSERT function to work, although I
secretly susoect it was a permissions issue witth my ISP, but their not
talking, lol. It was a good lesson though.
Todays problem, ladys and gents is that
--On Wednesday, July 11, 2001 13:44 +0300 Sinisa Milivojevic
[EMAIL PROTECTED] wrote:
William M. Quarles writes:
Not sure if this sent properly before, but when I try to unzip the
static pacakge, it says that it is not in gzip format.
--
William M. Quarles
Vice Pres, Society of
Neil Barnes
[EMAIL PROTECTED]To: [EMAIL PROTECTED]
Should people without a clean mouth or hands be expelled from the list?
A mouse (or anykind) shit can ruin a whole dinner!
Kris Amy wrote:
Maybe it's about time you stopped being a fuckwit and read the whole message
dip shit.
file://Kris
-Original Message-
From: Gerald Clark
Hi List,
Can anyone tell me how do i create a search engine
query.?
I am new to Mysql and know how to use a simple
select * from where = ;
but what about if I need to
create a query for a search engine that looks for Every word.
Thanks in Advance
Pradeep Dsouza
(Aspbyte Creations)
Rodney -
You can't execute a query across two connections simultaneously.
If you must split the tables between two hosts, network then together
at the file system level so that the database directories are accessible
by one instance of MySQL. Then connect and query that instance...
Neil Barnes wrote:
Hi everyone.
Please see below, I cannot login as the root user in MySQL.
Access-Denied any ideas anyone?
My System = RedHat Linux 7.0 (all latest patches applied) Intel
Pentium III
MySQL rpm's installed =
MySQL-3.23.39-1.i386.rpm
Dear pals,
Could anybody help me to tell me where I can download
MyVbQL. I am an absolute new bie of MySQL. Please help
me.
I am also so glad and thank you if somebody send me
the software to my mailbox directly.
Thanks so much in advance.
__
Do
UNIX version of Y2K problem...
\\|//
(@ @)
---oOO---(_)---OOo
||
| Fred Dinkler |
| SVP Technology |
| DFII Atlanta |
| Office: 01.770.596.1443|
||
J Lan wrote:
Hi;
Does mySql run under Dos? I have an old dos database written in Clipper. with simple
user interface. I am looking for a language which can programe a new database in
combination with mySQL. On condition is that: It must be in text-mode enviroment.
mySql run under Linux.
Gilbert C Healton wrote:
On Wed, 11 Jul 2001, Gerald Clark wrote:
On Wed, 11 Jul 2001, Gilbert Healton wrote:
The key commands are:
grant all privileges on Baseball.* to gilbert identified by first
with grant option;
cut cut cut
try to 'gilbert'@'%'
Hi there,
We have a Redhat 6.2 machine running Mysql version 3.22.32 (RPM package)
With this the machine also has Apache installed toghether with a static module of PHP
(version 4.0.4 if I remember correctly...)
This machine now alsmost has an uptime of 1 year (currently it is 344 days..)
First, I'd like to say that it's great that a Solaris for Intel version
of the binaries are now available (or was it my poor eyesight that hadn't
seen it before).
There's a possibility that the fact that you've used a 'symbolic' link for
/usr/local/mysql is causing a problem (though it works on
zosen wrote:
Hi!friend
I use win2000 and IIS as web server.and I have a Freebsd mysql
server.I want to connect the mysql server under the win2000.What shall I do?
and how the web page (in win200) can use the my mysql server(on freebsd)??
Thanks!!
zosen
Assuming your web
One real-world example:
RBOC changes an area code for certain prefixes.
If you haven't decomposed the phone number into separate fields,
e.g. your phone number is a single field ala
country code-area code-local number you have a really
interesting job ahead of you to accomplish the update.
Where is mysql.sock located on your system?
What are its privileges?
What are the privileges of the directories leading up to it?
You can use my.cnf to tell the server and clients where the mysql.sock
is to be.
They must all agree.
Markus Eppler wrote:
Hallo
I have always thsi error
Yes, compile it from source.
Riyaad Miller wrote:
Hi
I've installed mysql 3.23.39 on a rh 7.1 machine.
i followed every possibl step and yeah it dumped it in the correct locations
for all.
Is it possible to migrate/re-install mysql in another location, say
/usr/bin/sql instead of the 7.1
t2 has a line for each of the multiple IDs
MYKEY ID
---
key1 IM34456
key1 IM34457
key1 IM34458
key2 IM34457
key2 IM34567
...
t1 would have lines like ( using your fields instead of name,addr,city )
MYKEY NAME ADDR CITY
- - - -
key1 name1 addr1 city1
mysqladmin variables
I believe it is safe_show_database or some-such.
Marco Kammerer wrote:
3.22.38
Hello guys
I figured out how I can set up different user that are able to work
on their own dbs.
here is my command to add a db and a user;
GRANT SELECT, INSERT, UPDATE, DELETE,
Gerald,
God, it getting scary now, I'm actually starting to grasp all this stuff now.
this is exactly what I came with last nite, but just didn't understand what your
idea was when I first read it. :) This appears to be the best solution.
Thanks for your help,
Cheers,
On Wed, 11 Jul 2001
Hey folks,
I'm looking for a great relational (or ordbms) database modeling design
book. I wouldn't mind supplementing that with a book or other resources on
some example industry/application specific data models. I've perused Amazon,
but thus far, nothing really stands out for either of
Actually you are not indexing on a text or blob field solely if you are
indexing a fixed length 20 char or said field. Building key fields to
index on is a good approach I often when I would like to index on a text
or blob, I instead index on a unique hashing routine instead.
As far as the later
According to Bruce Perens (who came to speak at my office), the 2038 Bug is cured by
redefining time_t as a 64 bit value and recompilingthen we'll be all set until
the heat death of the universe :))
Regards,
Gary Huntress
Code 4113
Naval Undersea Warfare Center
Newport, RI 02841
Hi
I am using Paul Dubois' book MySQL to teach myself. He has sample data base data
which one can load using his scripts.
However, the book doesn't say where the scripts have to be loaded to inorder for them
to work ie which directory?
Also can someone just confirm the syntax for a create
I want to do a dump of my mysql database so that I can reinstall it but I'm
getting the following error:
/usr/local/mysql/bin/mysqldump: Can't get keys for table blast (Lost
connection to MySQL server during query)
Any idea what might be causing this?
Also I've suddenly not been able to create
[EMAIL PROTECTED] wrote:
I have Mysql 3.22 and PHP4 installed with RedHat 7.0 linux distribution.I created a
script connecting my html page with mysql database(function
mysql_pconnect).Everything was working just fine one day but on the next day I saw a
message on my screen "Call to
In my experience, most large corporate databases
are not implemented with RI enabled. The RI constraints
often interfere with user workflows (incomplete data or
data entered out of sequence) and adds processing overhead
that adds up to serious cycle drain for lengthy runs.
\\|//
What is mysql-VERSION-OS.tar.gz? Breughel, did you really type that exact
thing on the command line, because if you did, I believe the instructions
you followed intended for you to replace the VERSION-OS with your actual
VERSION and OS. For example:
gunzip mysql-3.23.39-pc-solaris.tar.gz |
Hi Try:
http://www.icarz.com/mysql/index.html
For the latest versions, news and documentation.
Ken
- Original Message -
From: Prabu Subroto [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 11, 2001 1:12 PM
Subject: MyVbQL
Dear pals,
Could anybody help me to
Hi all!
Having some problem with a binary install on an AIX 4.3.3 machine.
When I try to start mysql with:
# sh ./bin/safe_mysqld --log-update=/var/MySQL/log00/update.log
I get this:
# exec(): 0509-036 Cannot load program ./bin/my_print_defaults because of the
following errors:
I am sure you can change the base if you can compile it.
Have you verified that the relocated RPM install works properly?
I have not.
Mike Baranski wrote:
Well, you could also use these switches with the rpm command:
--prefix path
This sets the installation prefix to
On 11-Jul-01 Mike Baranski wrote:
I was wondering if anyone had any suggestions on the following problem. I
have a table with about 7 million rows, and I'm using the following
join:CREATE TABLE badge_history_resolved SELECT badge_history.id AS id,
badge_history.xact_date AS xact_date,
Awsome answers! I'll clear a few things up where appropriate
Don Read wrote:
On 11-Jul-01 Mike Baranski wrote:
I was wondering if anyone had any suggestions on the following problem. I
have a table with about 7 million rows, and I'm using the following
join:CREATE TABLE
Greetings,
A few questions -
*regarding trying to determine how to use stored procedures with Mysql, 1
approach I have heard is to put all your sql in a text file -how does this
compare to just embedding the SQL in your program/business logic ?
*when is the release data of 4.0, and what is
Nope, but it'll take all of 30 secs to verify, and it's easier than re-compiling
(IMHO) No offense intended, I just wanted to point out some more avalible
oppurtunities that might save some time and effort...
Plus, as robust as mysql tries to be, don't you think they would include this...
just do:
mysql -f script_name.extension
That'll do it.
Mike B.
-- Original Message --
From: Sara [EMAIL PROTECTED]
Date: Wed, 11 Jul 2001 19:31:48 +0100
Hi
I am using Paul Dubois' book MySQL to teach myself. He has sample data base data
which one can
Check out http://www.icarz.com/mysql/index.html ... Eric
Cal Evans wrote:
What is MyVbQL?
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: Prabu Subroto [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 11, 2001
OK, another one here...
On the very large table (at least 5 million rows) I need to index several columns.
The mysqladmin -i60 processlist
lists the state of the query as
Repair with keycache
for a very long time. I imagne it's sorting the indexes somehow.
My question is what variable
Can't you set that in the my.cnf file, the data directory?
Mike.
-- Original Message --
From: Trond Eivind Glomsrød [EMAIL PROTECTED]
Date: Wed, 11 Jul 2001 16:25:52 -0400 (EDT)
On Wed, 11 Jul 2001, Mike Baranski wrote:
Mine's in /usr/bin/mysql...
On 11-Jul-01 Dinkler, Fred wrote:
UNIX version of Y2K problem...
No, it is not, RTFM (message).
mysql select unix_timestamp(2038-01-01 00:00:00);
+---+
| unix_timestamp(2038-01-01 00:00:00) |
+---+
|
Title: Blank
How did some of you load balance your mysql servers.
Vien HuynhleClearsail Communications
Figured it out. mySQL wasn't down and it's been functioning well for weeks
because it stores the information for my forums. Come to find out it was
FreeBSD. Our ISP rebooted the server today to patch something, once it came
back up, everything was working as it normally should. It was just
Hi Cal,
This is a MySQL visual basic class that interfaces directly to
MySQL using the dll rather than ODBC. It has documentation and an
example query tool (in VB) that uses it. It can be found at
www.icarz.com/mysql/index.html
Ken
- Original Message -
From: Cal Evans [EMAIL
On 11-Jul-01 Joshua Stewart wrote:
umm when i declare a unique constraint on 2 fields in a table like so
unique (col1,col2),
if i insert data into the table will it check them individually or as a
composite?
Composite
(1,1)
(1,2)
(2,1)
(2,2)
(1,2) error duplicate
(2,1) error
On 11-Jul-01 Marc Johnson wrote:
I want to do a dump of my mysql database so that I can reinstall it but I'm
getting the following error:
/usr/local/mysql/bin/mysqldump: Can't get keys for table blast (Lost
connection to MySQL server during query)
Any idea what might be causing this?
I decided just to creat a new database and import my old data using a
csv but I found another problem, I can now no longer create new
datadases and I can not add any data to any of the databases stored on
this machine. I was searching the logs and found this:
010708 0:37:02 Aborted connection
Are there any online resources out there for uploading files and storing
them as BLOB objects in mySQL?
I'm using VBScript.
Thanks,
Dave
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
What is MyVbQL?
Cal
*
* Cal Evans
* Senior Internet Dreamer
* http://www.calevans.com
*
- Original Message -
From: Prabu Subroto [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, July 11, 2001 12:12
Subject: MyVbQL
Dear pals,
Could anybody help me to tell me where I can
Don't know your where, but you probably want to something like ...
select USERS.name as name1, USERS.user_id as id1, USERS.name as name2,
USERS.user_id as id2 ...
where id1 = USERLIST.user_id and id2 = STUDENTLIST.user_id ...
4 tables join?
Mike Sosteric wrote:
Thanks Dibo but I don't
1 - 100 of 146 matches
Mail list logo