On Thu, Jul 12, 2001 at 01:51:29AM +0200, Werner Stuerenburg wrote:
>
> Im my understanding, you are storing images. AFAIK, images should
> not be stored in the db but in the filesystem.
There's nothing wrong with doing it, as long as you understand what
you're doing. After all, images are (from
Corin Hartland-Swann wrote:
> SELECT * FROM foo WHERE char_field = '96' AND int_field = 1;
>
> SELECT * FROM foo WHERE char_field = 96 AND int_field = 1;
>
> Is it the expected behaviour for the second query to perform a numerical
> equivalence test on every row in the table in turn? It is
Hi,
Is it possible for mysql to store simpify and tranditional chinese.
Thanks
Mark
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
Hi Nirzari
Please visit the following link, for the work around solution and let us
know whether this solves your problem.
http://lists.mysql.com/cgi-ez/ezmlm-cgi?9:mss:10836:200106:jnlcikigopenhfhco
bba
Also, for ODBC related postings/queries, please use ODBC discussion group
[EMAIL PROTECTED]
Hi,
try complete your query by adding word 'AS' syntax:
field AS name
so:
select USERS.name AS name1, USERS.name AS name2, USERLIST.user_id AS
id1, STUDENTLIST.user_id AS id2 student_id
from USERS, USERLIST, STUDENTLIST
WHERE
Michal Dvoracek [EMAIL PROTECTED]
hi,
I have installed mysql 3.23.39 on windowsNT
when i try to establish connection by odbc using vc++
in that while selecting the datasource for userDSN
if i give host address as local it coonects to the datasource
but i give name or the IP address of the databsase server it doesnot
Hello,
I have made an access database in MSAccess 2000 and I am trying to
export tables into mySQL database. The problem is, I can export tables with
numbers but cannot export table with "text" or anything. When I try to
export the table with a "text" column, I get the following error:
OD
Hi,
I just solved my problem. I just installed the solaris
package version(the older one 3.23.37) which I
downloaded from the site that my japanese friend had
referred.
Sorry again for the trouble I caused you guys...
Breughel
--- Breughel Macabuhay <[EMAIL PROTECTED]> wrote:
> Kenneth, thanx.
Don, thank you. The SELECT statement worked perfectly just as you
suggested. Though the books I have on MySQL are pretty good, trying
to figure more and more esoteric statements out is a bit of a
challenge, even just in terms of syntax.
Nelson
>
> > In looking via SELECT * FROM tickets, th
Well, dunno about that, but I've got a system here which I designed round
the fact that MySQL *doesn't* have RI.
When a customer gets deleted (or changes it's reference id), the data for
the old id has to remain in the system. I know that if I was using a
product which enforces RI I'd design it d
> I said "without doing another query" :-) Sure you can do count(*)
> beforehand...
Oh, sure, sorry! Too late, I guess.
--
Herzlich
Werner Stuerenburg
_
ISIS Verlag, Teut 3, D-32683 Barntrup-Alverdissen
Tel 0(049) 5224-997 407 · Fax
As I said earlier, I have troubles with 3 tables from over a
hundred. In my quest to find out what happens, I converted those
3 from isam to myisam. Hence I am able to check from my program
if the tables are corrupt and then try to correct them.
The most important table is the session table. This
Interesing,
so when they need to delete a customer from the system,,they just turn the
RI back on,,maybe at night when the 'regular' people have gone home?
how do they do it?
Ken
- Original Message -
From: "Dinkler, Fred" <[EMAIL PROTECTED]>
To: "pak" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROT
Hi Zosen,
I am not 100% sure but this what I believe would work.
You need MyODBC install in your win2k machine, then setup the DSN. Then
your IIS/ webserver can use windows naming to locate MySql server in your
linux box.
Regards,
Michael
- Original Message -
From: "zosen" <[E
> > He wants to know the maximum, like on a search for mysql at
> > google it says "Results 1 - 10 of about 2,580,000." He wants
> > to know that 2,580,000 number without doing another query.
> > I don't think that's possible.
>
> Of course it is. That's what I do all the time. That's what I was
>
What error did you get? Did you try using NULL for the id, or leaving the
auto_increment column out of the insert (insert into table (PartNumber, ...,
StatusQtyWorked) values (...))?
> Hello,
> When I submit data it will not submit data into the
> database unless I put some kind of number in the
http://marc.theaimsgroup.com/?l=mysql&m=99257445520048&w=2 may help
> 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 ver
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 12, 2001 7:20
Subject: HELP! How to set root password?
>
>
> I've been reading the documentation for the last 3 hours in search for
> the answer to this question, to no avail. To preserve th
Or you could use MS Access ... set up an ODBC connection to each server,
then 'Get external data' and 'link tables'.
You still need to translate your MySQL create/alter scripts to MSSQL7
Transact-SQL, and create the databases amd tables on the MySQL server. Once
that is done, link the tables with
If you do ps -ef | grep mysql, I think you'll find that the server is
already running.
- Original Message -
From: "Michael" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 12, 2001 8:03
Subject: mysql-3.23.35
Hi,
I have just installed mysql-3.23.35 on a linux - mandrak
Sorry, I made a mistake it's password not --password
ie. [root@mail mysql]# mysqladmin password FalsePass
not
[root@mail mysql]# mysqladmin -password FalsePass
- Original Message -
From: "Rolf Hopkins" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTE
Hi!Gerald Clark
How does the web server support MySQL???What shall I do for my
win2000 or IIS???Thanks!!
- Original Message -
From: "Gerald Clark" <[EMAIL PROTECTED]>
To: "zosen" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, July 12, 2001 1:24 AM
Subject: Re: How
In what way doesn't it work? Works fine for me.
- Original Message -
From: "Mike Mike" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 12, 2001 5:18
Subject: auto_increment not incrementing
> Hello,
> When I submit data it will not submit data into the
> database unles
Kenneth, thanx. I also wanted to say the same.
Sorry if I made all of you a bit confused but I would
just like you people to know that this part:
#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
> [root@mail mysql]# mysqladmin -password FalsePass
This is not as per documentation. Documentation says --password.
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Thursday, July 12, 2001 0:26
Subject: Re: Root Login Problem
>
>
Hi,
I have just installed mysql-3.23.35 on a linux - mandrake 7.2 box. When I try to run
it in usr/bin/safe_mysql & I get a "mysql process already exist". Please tell me why
this is. I would Appreciate feed back as soon as possible.
MIKE
Im my understanding, you are storing images. AFAIK, images should
not be stored in the db but in the filesystem. You store only the
filename and other data (time etc.) in the db. There are some
remarks on this at php.net and other places, as this question is
posed often.
Sie schrieben am Mittwoch
Well, there's the hard way, but it insures your data will be intact and
you'll have proper documentation of your old and new environments
1) take your create table scripts and translate them in the Transact-SQL
dialect
2)Create tables in MS SQL Server with scripts
3)Export data from MySQL int
> >
> >I'm writing in as to how I can contribute in the development in Parallel
> >databasing. I understand MySQL currently supports replications which is a
> >nice way of keeping live backups of a mysql server, however is hardly the
> >"preferred" method when dealing with load-balancing and re
I don't know if I understand your question, but you may want to
SELECT * FROM table
WHERE fieldname LIKE '%searchterm%'
Also, search at mysql.com for FULLTEXT in
http://www.mysql.com/doc/C/R/CREATE_TABLE.html
and learn what you can do with this and when this will be good.
Sie schrieben
> Todays problem, ladys and gents is that I have a sinple form page that
> updates a database. The form is in PHP, the databse is mysql (obviously)
> heres the rub, when I submit the form it adds the info to the page as it
> should but does not reset the form, the original datat entered is still
>
You may want to have a look at PHPLIB. They have a really fine
security module with all kinds of grants and privileges for
purposes like you need. Also, those guys know what security
means. They would never use root to operate a system.
Sie schrieben am Mittwoch, 11. Juli 2001, 14:37:23:
> Is it
I've been reading the documentation for the last 3 hours in search for
the answer to this question, to no avail. To preserve the little
eyesight I have left, I've decided to post it.
I've been trying to install mysql-max-3.23.39 on a Linux system
(pc-linux-gnu-i686). The daemon runs fine, bu
>> 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 mysql
> 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 abaut li
Does anyone know the best compiler for installing and
configuring MySQL on RedHat 6.2?
I have to update my c compilers in order for
./configure... otherwise it won't go.
--
Rob Sochor
IS Manager
[EMAIL PROTECTED]
Ie Solutions - RAPS
The Recruiting and Applicant Processing System
Visit a lis
> He wants to know the maximum, like on a search for mysql at google it says
> "Results 1 - 10 of about 2,580,000." He wants to know that 2,580,000 number
> without doing another query. I don't think that's possible.
Of course it is. That's what I do all the time. That's what I was
talking about.
Does anyone know how to export from a MySQL database to SQL Server? Thanks
in advance.
Brian
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archi
I'm writing in as to how I can contribute in the development in Parallel
databasing. I understand MySQL currently supports replications which is a
nice way of keeping live backups of a mysql server, however is hardly the
"preferred" method when dealing with load-balancing and redundancy, just
be
[EMAIL PROTECTED] writes:
> Your message cannot be posted because it appears to be either spam or
> simply off topic to our filter. To bypass the filter you must include
> one of the following words in your message:
>
> database,sql,query,table
>
> If you just reply to this message, and include
Hi,
I am trying to store fax images in mysql (they are about 1K per page), which
comes in as binary data. I am able to use mysql_escape_string(data, fax,
sizeof(fax)) to get the data into mysql, as well as only escaping ' and \
for the query string. I have tried both longblob and longtext mysql
At 7:31 PM +0100 7/11/01, Sara wrote:
>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
Hi there,
I am performing the following queries on a pretty large table (51 million
rows, myisampacked, couple of gigs):
SELECT * FROM foo WHERE char_field = '96' AND int_field = 1;
SELECT * FROM foo WHERE char_field = 96 AND int_field = 1;
Is it the expected behaviour for the second quer
Well, you could also use these switches with the rpm command:
--prefix
This sets the installation prefix to for
relocatable packages.
--relocate =
For relocatable packages, translates the files that
would be put in to
On 11-Jul-01 Mike W. Baranski wrote:
> Awsome answers! I'll clear a few things up where appropriate
>
> Don Read wrote:
>>
>>
>> Why the LEFT JOINS ?
>> They're (mostly) used for finding set membership; whenever you see
>> 'LEFT JOIN b' without s following 'b IS [NOT] NULL' clause 'tis t
Hello,
When I submit data it will not submit data into the
database unless I put some kind of number in the ID
field. This is not supose to be. Here is what my
schema looks like.
CREATE TABLE Parts(
PartNumber INT(6) NOT NULL,
QtyOnHand INT(2) NOT NULL,
QtyOnOrder INT(2) NOT NULL,
DateNextQtyCo
> 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?
>
> for example if i inserted the values
> col1 | col2
>1, A
>1, B
>2, B
>
Riyaad Miller <[EMAIL PROTECTED]> writes:
> 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 conv
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?
for example if i inserted the values
col1 | col2
1, A
1, B
2, B
2, A
if t
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 d
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 ca
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)
htt
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 19
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 th
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)
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 PROTEC
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 wei
Title: Blank
How did some of you load balance your mysql servers.
Vien HuynhleClearsail Communications
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") |
+---+
|
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..
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 wil
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,
just do:
mysql -f
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 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
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...
---
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 the
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 badge_h
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, ba
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
> This sets the installation prefix 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:
0509-13
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 anybo
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 | t
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.
\\|//
[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 undef
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
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 ta
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
1-8
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
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
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 12
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,
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
ke
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
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
>
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
"--" you have a really
interesting job ahead of you to accomplish the update.
Especially if you are a telecom
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 we
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
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..)
We
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
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 L
UNIX version of Y2K problem...
\\|//
(@ @)
---oOO---(_)---OOo
||
| Fred Dinkler |
| SVP Technology |
| DFII Atlanta |
| Office: 01.770.596.1443|
||
-
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
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
> MySQL-client
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...
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)
--
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
Neil Barnes
<[EMAIL PROTECTED]To: [EMAIL PROTECTED]
--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
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 I
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, badg
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 logi
1 - 100 of 146 matches
Mail list logo
