In my MySQL I have 3 tables like this and I have a pblm. in setting the foreign
key.Pls. help
EMPLOYEE_DETAILS
EMP_ID - PKint(10)
EMP_FIRST_NAMEvarchar(25)
EMP_LAST_NAMEvarchar(25)
EMP_CURR_ADDRvarchar(100)
EMP_PERM_ADDRvarchar(100)
EMP_PHONEvarchar(20)
EMP_DOJ
Does anyone have a list of manufactures of financial packages that will run with MySQL?
We need to move from Intuit Quickbooks to something that can potentially scale to as
many as 200 users. Greatplains and Solomon appear to only run on SQLServer.
Any suggestions or past upgrade experiences wo
Having a bit of a sticky wicket here... I'm sure the answer is simple
but I'm just not seeing it.
Basically I want to return all the TargetRanges and ScannerIDs. You
would think it's simple, here's the snag. See how ScannerID has 0 in
some rows. Well, we used 0 to mean "any scanner" in our PHP cod
So I have been reading a lot lately about replication but I can't find a
good summary/explanation of MySQL's replication features regarding InnoDB
tables and how their transactional properties may cause problems in
replication.
I have seen suggestions that InnoDB tables should be converted to M
Maybe I'm a bit naive in saying this but. . .
SQL joins are damn slow! I have a simple database of about 37,000
records in [Court Cases] and 2,000,000 records in [Defendants] (soon to
be more). When I do a search on [Defendants] (the big table) alone, a
saerch can go in like .7 seconds. But if
Stephen Tiano wrote:
The manual I was able to download, I now notice, is for version
4.0.3-beta of MySQL. So that's the official tutorial I'm working. That
and Kevin Yank's Building a Database-Driven Web Site Using PHP and
MySQL--a '10-week course' that I also was able to download.
Problem has
Is there a maximum size to a SQL statement in mySQL? Just wondering.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this t
Steve,
> SQL joins are damn slow! I have a simple database of about 37,000
> records in [Court Cases] and 2,000,000 records in [Defendants] (soon
to
> be more).
Please post the structures of your 2 tables (at least, the relevant
parts), and the join query that gets so slow. Otherwise, we can only
Hi there,
My hosting company tells me that they need to take down the MySQL server
every day for 30 to 60 minutes to make a backup. This is the quote:
"Please note that mysql is shutdown daily sometime between 3am and 9 am
US eastern for 30 minutes to an hour. This is get a good backup of all
mysql
Hi
I have two questions about replication on MySQL.
One: How far behind can a SLAVE get on reading the BIN log before not being
able to catch up?
My SLAVE was off for 4 days and it just seams as if it can not catch up.
Two: On SHOW SLAVE STATUS one of the fields in called Skip_conunter. Due to
an
There are two ways I use to dynamic backup.
One lock table can copy it. Use some think like hotcopy. The only down side
can be that if the table is very big the lock can queue two may questions.
The other way it to use replication can make the backup from the slave.
If it is taking up to an hour
On Mon, 20 Jan 2003 13:01:55 -0700
Zak Greant <[EMAIL PROTECTED]> wrote:
> On Mon, Jan 20, 2003 at 01:14:53PM +0100, Rafal Jank wrote:
> > Hi,
> >
> > I've just downloaded version 4.1 from bk and have problem with building
> > it. What version of automake is needed? Because after
> > > aclocal
>
Jannie,
- Original Message -
From: ""Jannie Qu"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, January 21, 2003 1:30 AM
Subject: Is rename table to another database safe for INNODB tables
> sql, query,
>
> Hi, all,
>
> As you may knew, mysql will implement "rename
i know this may be an impatient ask , when will mysql 5 maybe release ? , i
was hoping to check out the stored procedures features, php 5 is on dev and
has started to use OO handling which is good to start coding for the future
rollover.
---
* Steve Quezadas
> Is there a maximum size to a SQL statement in mySQL? Just wondering.
It's 16M in version 3.23.x, unlimited in 4.0.x, according to:
http://www.mysql.com/doc/en/Packet_too_large.html >
--
Roger
-
Before
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Victoria, et al --
...and then Victoria Reznichenko said...
%
% On Monday 20 January 2003 16:16, David T-G wrote:
% > create table pieces
% > (
...
% > words text (4095) ,
% > fulltext index (words(4095))
% > ) ;
%
% David, "words text (
Hi everybody,
I am new on mysql. I use phpadmin for adminstration.
My problem:
I have "Database 1", table "userdata", field "username"
I need to copy the above mentioned data to:
"Database2", Table "chat_data", field "nick"
I have no clue how to do it! Can anybody tell me the string? Thanks f
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Thomas, et al --
...and then Thomas Spahni said...
%
% On Mon, 20 Jan 2003, David T-G wrote:
%
...
% > create table pieces
% > (
% > # ID number
% > id smallint unsigned not null default 0 auto_increment primary key ,
% > title char(
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Sam --
...and then [EMAIL PROTECTED] said...
%
% Hi list,
Hi!
%
% I have migrated to SQLServer, so I wonder if some one can direct me how to
unsubscribe please.
No problem. Take a left out of your office, go to the end of the hall,
turn right,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Clemente --
...and then Clemente said...
%
% Hi there,
Hi!
% My hosting company tells me that they need to take down the MySQL server
% every day for 30 to 60 minutes to make a backup. This is the quote:
% "Please note that mysql is shutdown daily
Hi everybody,
I am new on mysql. I use phpadmin for adminstration.
My problem:
I have "Database 1", table "userdata", field "username"
I need to copy the above mentioned data to:
"Database2", Table "chat_data", field "nick"
I have no clue how to do it! Can anybody tell me the string? Thanks f
You might find something at
http://www.linuxapps.com/
Doug
On Tue, 21 Jan 2003 00:06:32 -0800, Ed Reed wrote:
>
>Does anyone have a list of manufactures of financial packages that will run with
>MySQL?
>We need to move from Intuit Quickbooks to something that can potentially scale to as
>many
Tom,
> I have "Database 1", table "userdata", field "username"
> I need to copy the above mentioned data to:
> "Database2", Table "chat_data", field "nick"
in phpMyAdmin 2.3.3pl1 you can accomplish this as follows:
1. Choose "Database 1" in the left frame.
2. Click table "userdata" in the left f
* Tom Nickels
> I have "Database 1", table "userdata", field "username"
>
> I need to copy the above mentioned data to:
>
> "Database2", Table "chat_data", field "nick"
>
> I have no clue how to do it! Can anybody tell me the string?
If the destination table already exist, something like this:
IN
Hello all,
I wonder if anyone has set up a MySql database to mirror one running on MS
Sql Server. Although this sounds like an odd requirement, I have
a project where this would be extremely useful. Can anyone give me any
suggestions as to where to find out more information on this subject.
I have
Hi,
When I try the hoagie_mysql exploit from http://void.at/releases.html
on a 3.23.54a MySQL server (witch sould be safe) then i can crash the
database with this.
How did I do it?
I start hoagie_mysql with a valid db user (not root). Then press ctrl-c
(abort) and start the tool again. Now the t
I have a Mysql-table with a field of type double. when i retrieve very small
numbers from this table I get them allways in a scientific notation:
i.e. 8.34e-05. what i have to do, that i get the same number in normal
notation: 0.834?
thank you for any hints in advance!
philipp
* Philipp Sutter
> I have a Mysql-table with a field of type double. when i retrieve
> very small
> numbers from this table I get them allways in a scientific notation:
> i.e. 8.34e-05. what i have to do, that i get the same number in normal
> notation: 0.834?
See the FORMAT() function:
htt
Hi,
I had MYsql running on a nt4 server and w2k server. I uninstalled it a few weeks ago
and just recently tried installing it again. The install went fine but when I start
the service I
keep getting an error no maater what I try. Using localhost and administrator.
Whats going on? If I instal
The problem is this. Always when I start the server, when I try to show the
table mysql, I get an error message that saids "Access Denied to user "
but when I put the same command with the --user=root it works. the question
is: How can I start the server whit root priviledges?
thxs.
Alex.
-
On Tuesday 21 January 2003 09:56, Saju Pappachen wrote:
> In my MySQL I have 3 tables like this and I have a pblm. in setting the
> foreign key.Pls. help
[skip]
> create table employee_skill_details(EMP_ID int(10) not null references
> employee_details(EMP_ID), SKILL_ID varchar(5) not null refere
Hi Dan,
Thanks for that information, does that mean (for us simple SQL
guys) that even though I am running 5.0RC3 and can compile and install
MySQL just fine (from ports or with my own script) it is using the
threads library from 4-STABLE branch not the new threads?
Also does this have soemthi
Hello,
Here is a set based solution.
Using v4.0.6 gamma on w2k pro.
CREATE TABLE broad (name varchar(10) not null,
groups varchar(20) not null,
primary key (name));
INSERT INTO broad values("DOG","1,3,4,2"),
("CAT","2
At 09:05 21/01/2003 -0500, FlashGuy wrote:
Hi,
Hi,
I had MYsql running on a nt4 server and w2k server. I uninstalled it a few
weeks ago and just recently tried installing it again. The install went
fine but when I start the service I
keep getting an error no maater what I try. Using localhost
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Alex --
...and then Alejandro C. Garrammone said...
%
% The problem is this. Always when I start the server, when I try to show the
% table mysql, I get an error message that saids "Access Denied to user "
% but when I put the same command with t
David T-G wrote:
Hmmm... Speaking as a SysAdmin, that looks like a cover-all-bases
general announcement.
I was going to say the same thing; its always good (legally) to say you
might be down, instead of doing it and having people sue you.
Indeed. If your provider is going to take down your
Hi
We are upgrading our mysqlserver to 3.23.54 from a old one.
But we can't get mysqldump to import all the tables to the new
server becouse some of the table names have - sign in it. Like ip-number
Is it any way to come around this error or do we have to contact our
customers
to make them chan
Steve Quezadas wrote:
However. I notice that if I do two separate searches it goes quicker
(about 2.5 seconds combined). I can do a criteria search on defendants
and then put all the resulting case numbers in a temporary table. Then
do a join of that temporary table to the much smaller Cases t
Roger Baklund:
> * Philipp Sutter
> > I have a Mysql-table with a field of type double. when i retrieve
> > very small
> > numbers from this table I get them allways in a scientific notation:
> > i.e. 8.34e-05. what i have to do, that i get the same number in normal
> > notation: 0.834?
>
>
Hi,
I want to change a field in a table. Currently the data is in the
format --> 4818.50.00
I want to remove the decimal points so that it is like --> 4818.50.00
I tried the sql code below but am getting a syntax error. Can someone
please
point out the error of my ways?
UPDATE DocComms SET Item
Hi,
RESENT DFUE TO TYPO
I want to change a field in a table. Currently the data is in theformat -->
4818.50.00
I want to remove the decimal points so that it is like --> 48185000
I tried the sql code below but am getting a syntax error. Can someone
please point out the error of my ways?
UPDATE
Hi,
Thanks a lot for all those replies! It seems like my hosting company is using the
cheapest and/or easiest way to make a full, consistent backup. And I guess the
ideal method from those mentioned is to have a slave server you can take down for
backup.
The question is then whether such backup i
Read up on the GRANT command in MySQL. This sets up the security level
for the tables, hosts and even columns. MySQL defaults to only allowing
the localhost to connect ot the database, which is fine if you are
running the webserver and something like PHP on that computer. Once you
separate them
In the last episode (Jan 21), Ken Menzel said:
>Thanks for that information, does that mean (for us simple SQL
> guys) that even though I am running 5.0RC3 and can compile and
> install MySQL just fine (from ports or with my own script) it is
> using the threads library from 4-STABLE branch no
Clemente wrote:
The question is then whether such backup is necessary on a daily basis
I run incremental tapes hourly at some client locations. You may only
need weekly backups. If the server room filled with water tomorrow and
you had to return to your last backup, when do you want that b
On Tuesday 21 January 2003 17:11, Jonas Eriksson wrote:
> We are upgrading our mysqlserver to 3.23.54 from a old one.
> But we can't get mysqldump to import all the tables to the new
> server becouse some of the table names have - sign in it. Like ip-number
>
> Is it any way to come around this e
On Tuesday 21 January 2003 16:06, Alejandro C. Garrammone wrote:
> The problem is this. Always when I start the server, when I try to show the
> table mysql, I get an error message that saids "Access Denied to user "
> but when I put the same command with the --user=root it works.
> the questi
* Philipp Sutter
> Am Die, 2003-01-21 um 15.03 schrieb Roger Baklund:
> > * Philipp Sutter
> > > I have a Mysql-table with a field of type double. when i retrieve
> > > very small
> > > numbers from this table I get them allways in a scientific notation:
> > > i.e. 8.34e-05. what i have to do, that
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Clemente --
...and then Clemente said...
%
% Hi,
Hi!
% Thanks a lot for all those replies! It seems like my hosting company is using the
cheapest and/or easiest way to make a full, consistent backup. And I guess the
Happy to help. Yes, it sound
* Jonas Eriksson
> We are upgrading our mysqlserver to 3.23.54 from a old one.
> But we can't get mysqldump to import all the tables to the new
> server becouse some of the table names have - sign in it. Like ip-number
>
> Is it any way to come around this error or do we have to contact our
> cust
* Don
> I want to change a field in a table. Currently the data is in
> theformat -->
> 4818.50.00
> I want to remove the decimal points so that it is like --> 48185000
> I tried the sql code below but am getting a syntax error. Can someone
> please point out the error of my ways?
>
> UPDATE DocC
I have three tables, people, events and epeople. epeople includes a person
id and an event id and works as a list of people attending events in the
database.
The following query returns a list of all the people participating in a
particular event
given an event id.
select people.id as pid, conca
Hi, i'm new at this list and to the mysql world. I'm a delphi/firebird
developer and have to acomplish some tasks using a mysql based database. So
i'm looking about how things work in mysql.
My question... i created a table TEST, with two columns, ID_TEST int(11) and
NAME varchar(50).. and added
Hi,
substr() doesn't exist in MySQL.
Use substring().
UPDATE DocComms SET ItemHSCode = concat(substring( ItemHSCode, 1, 4 ),
substring( ItemHSCode, 6, 2 ), substring( ItemHSCode, 9, 2 ))
On Tue, 2003-01-21 at 15:34, Don wrote:
> Hi,
> RESENT DFUE TO TYPO
>
> I want to change a field in a tab
Hi
I am building my 1st app in php with Mysql and I hope you can help.
I want to have users give a description in a form and varchar(255) wont give
me enough space so I thought I would use text(650) but it seems the 'text'
type wont take the limit of (650), it simply offers the user (65535): way
EL día Mon, 20 Jan 2003 16:22:55 -0500
Walter <[EMAIL PROTECTED]> escribió:
-->I have a Red Hat 7.3 box running MySQL 3.23.49 (installed with the Red Hat
-->rpms). I am about to upgrade to 4.0.9 and would prefer using the RPMs from
-->MySQL. My plan was to just un-install the Red Hat rpms and
Hi,
I didn't test this.
Assuming that Swordfish.scanner.scanner_id <> 0 for all rows (and
that's why it doesn't appear in the results list from the first query):
SELECT InteractV2.Job_Queue.TargetRange AS TargetIP,
IFNULL(INET_NTOA(Swordfish.scanner.ipaddr),'ANY SCANNER') AS ScannerIP
FROM In
I would like to get the difference of the results from query 2 and query 1,
or the people not attending event [id 2] (referenced by epeople.eid).
Thought the answer would be query three, but as you see, I get an empty
set. Any advice would be appreciated.
jb
Here is everyone attending the event [
Hey All,
I want to install the mySql 4.0.9 to try out some features but I want to
make sure my 3.23.54 release stays 100% as is.
I'd like to have both servers running, using different data dirs etc. etc.
In short I don't want anything at all shared between the two.
I've read a bunch of docs on th
Hey all,
I hope you can help with this issue, as it seems to be something wrong with my MySQL
installation: I recently upgraded my RedHat install, and in doing so upgraded Java and
MySQL. I had JDBC code which worked perfectly prior to the upgrade, but now cant
connect. It continuously tells me
If you want to limit the amount of text coming in or going out, wouldn't it
be easier to it either in your php script or constrain the html textarea?
Just a thought.
-Chris
>> -Original Message-
>> From: Craig melia [mailto:[EMAIL PROTECTED]]
>> Sent: Tuesday, January 21, 2003 12:28 PM
Your joins are probably not using indexes and the tables could be joining in
an inefficient order. Try running an explain on your query to see how it is
being done.
-Original Message-
From: Steve Quezadas [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 1:31 AM
To: [EMAIL PROT
At 17:27 + 1/21/03, Craig melia wrote:
Hi
I am building my 1st app in php with Mysql and I hope you can help.
I want to have users give a description in a form and varchar(255) wont give
me enough space so I thought I would use text(650) but it seems the 'text'
type wont take the limit of (6
At 15:02 -0200 1/21/03, Valdir Stiebe Junior wrote:
Hi, i'm new at this list and to the mysql world. I'm a delphi/firebird
developer and have to acomplish some tasks using a mysql based database. So
i'm looking about how things work in mysql.
My question... i created a table TEST, with two column
Yep Jermey are right what he says - Anyone know about using Database link in Mysql???
Regards
Frank
- Original Message -
From: "Jeremy Zawodny" <[EMAIL PROTECTED]>
To: "Egor Egorov" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, January 20, 2003 4:35 PM
Subject: Re: Mysql and
On 21 Jan 2003, at 17:27, Craig melia wrote:
> I want to have users give a description in a form and varchar(255)
> wont give me enough space so I thought I would use text(650) but it
> seems the 'text' type wont take the limit of (650), it simply offers
> the user (65535): way too much.
Use a TE
> I don't know why it returns the first two rows, but (assuming you didn't
> really end your query with two question marks) what error are you
expecting
> to occur?
I didn't end my query with the two question marks. :)
And if i put 0 instead of (2 or any different of zero) after the equal sign
the
On Tue, Jan 21, 2003 at 08:43:29AM -0800, Josh L Bernardini wrote:
>
> I have three tables, people, events and epeople. epeople includes a person
> id and an event id and works as a list of people attending events in the
> database.
>
> The following query returns a list of all the people partici
Well...I uninstalled mysql and installed it again and I still can't get the service to
run!!!???
==BEGIN FORWARDED MESSAGE==
> From: "FlashGuy" <[EMAIL PROTECTED]>
> To: "FlashMX" <[EMAIL PROTECTED]>
> Date: Tue, 21 Jan 2003 09:05:52 -0500
> Reply-To: "FlashGuy
You are looking for a list of people rather than a list of events and
the people attending them. So you want to start your select from People,
not from Events. Get a list of all the people, then filter out those
attending event id 2. You don't want to start you select from epeople
because then
Craig,
> I want to have users give a description in a form and varchar(255)
wont give
> me enough space so I thought I would use text(650) but it seems the
'text'
> type wont take the limit of (650), it simply offers the user (65535):
way
> too much.
In MySQL, you have TINYTEXT (2**8 = 256, like
Sorry, correcting my last email, the sql result the two rows when i use
'NAME = 0'.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Valdir Stiebe Junior" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, January 21, 2003 4:33 PM
Subject: Re: Hi and why
> At 15:02
Frank,
> Yep Jermey are right what he says - Anyone know about using Database
link in Mysql???
This is not built in. You will have to do this within your application.
You can also use some of the MySQL helper apps for this, like mysqldump
in combination with mysql (the command line tool), like t
I can't come up with the join syntax to mimic this subselect query to list
people not attending an event (*epeople.eid == event.id):
select people.id as pid, concat(lastname, ", ", firstname) as name from
people where people.id not in
(select epeople.pid from
epeople
left join people on epeo
At 16:47 -0200 1/21/03, Valdir Stiebe Junior wrote:
> I don't know why it returns the first two rows, but (assuming you didn't
really end your query with two question marks) what error are you
expecting
to occur?
I didn't end my query with the two question marks. :)
And if i put 0 instead
> I'm stlll surprised that NAME = 2 returns anything. When I tried your
> example, it returned no rows. I get two rows with NAME = 0, nothing
> with NAME = 2. Are you sure you're not mixing up your test results?
Sorry, my mistake.
> NAME = 0 is a string-to-number conversion. MySQL converts th
At 18:11 -0200 1/21/03, Valdir Stiebe Junior wrote:
> I'm stlll surprised that NAME = 2 returns anything. When I tried your
example, it returned no rows. I get two rows with NAME = 0, nothing
with NAME = 2. Are you sure you're not mixing up your test results?
Sorry, my mistake.
NAME =
Hi !!!Anybody can help me with this problem?
Thanks
I've just installed Control Center
Version:
0.8.9-beta Linux (Intel glibc 2.2 systems, static) (3.1M)
Operating System RedHat 7.1
When I try to execute the program it have the following error
[root@LINUX1 mysqlcc]# ./mysqlcc
Segmenta
I just tried it myself and I get an empty set as expected.
What do you get when you do a 'select * from test'?
> -Original Message-
> From: Valdir Stiebe Junior [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, 22 January 2003 5:48 am
> To: [EMAIL PROTECTED]
> Subject: Re: Hi and why
>
> > I
"ppl1" converted to numeric is 0.
You are compareing to a number.
Valdir Stiebe Junior wrote:
Sorry, correcting my last email, the sql result the two rows when i use
'NAME = 0'.
- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Valdir Stiebe Junior" <[EMAIL PROTECTED]>;
I have a fairly basic mysql database running on unix. Now I need to make this
data available to other people. These would be various engineers and
administrators using every version of windows from 95 (japanese version) to
XP all using laptops connected to our internal network. I am looking fo
Hi,
Indeed...this happend in both main version of MySQL (ver. 3.x and 4.0.x)
However ,if you use :
select * from test_table where NAME='2';
you will have the correct result.
Regards,
Gelu
___
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAI
Hi,
I'm running Connector/J 2.0.14 with J2SDK1.4.1_01. Prior to these upgrades, all my
code ran fine. However, I upgraded all my packages (MySQL, J2SDK, and to Connector/J,
as already stated) and now I keep getting an IOException. Why is this happening? I've
thought about the timeout scenario b
Bob,
First of all, thank you. I never would have gotten here on my own. Only I
am not quite there.
Using your example, I have managed to list all the events a person is
attending and not attending. Wondering if you might provide some further
clues as to how to restrict the query to those events a
Hello all,
sorry if this maybe a bit OT, but we've seem to be getting this error 110:
Connection timed out.. from our Perl scripts connecting to our MySQL database...
is this perl or the mysql server related issue ?
thx's
--
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Inter
Solaris 8 (sparc)
gcc 3.2
Configuring from source version mysql-3.23.54a
2 problems:
1. I get a checksum error when untar'ing the tgz file found on any of the
download servers.
2. config.status: error: cannot find input file: readline/Makefile.in
The directory exists, but there are no files.
An
Hi!
On Jan 21, Dennis Kruyt wrote:
> Hi,
>
> When I try the hoagie_mysql exploit from http://void.at/releases.html
> on a 3.23.54a MySQL server (witch sould be safe) then i can crash the
> database with this.
>
> How did I do it?
>
> I start hoagie_mysql with a valid db user (not root). Then pr
On Mon, Jan 20, 2003 at 02:20:10PM -0500, Grigor, Peter wrote:
> Alrighty then!
>
> Now FreeBSD 5.0 has been released, what are the plans for mysql to evaluate
> the new (really new :) thread implementation.
What's wrong with LinuxThreads on FreeBSD? It works great with
FreeBSD 4.x.
Jeremy
--
Kris,
- Original Message -
From: ""Krzysztof Karski"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, January 21, 2003 11:35 AM
Subject: replication problems with InnoDB tables...?
> So I have been reading a lot lately about replication but I can't find a
> good sum
>I am looking for an
>easy to use, easy to install mysql client which would enable users to
query
>my database. It seems that installing mysql server for windows on
each
>machine would do this but it seems like using a shovel to swat a fly.
>Suggestions? Cheap is good too.
Try SQlyog
http://
Have you check out MyCC from mysql.com ?? It can be used as a front-end of
MySQL.
Cheers,
Michael
-Original Message-
From: David Driscoll [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, January 21, 2003 3:53 PM
To: [EMAIL PROTECTED]
Subject: simple windows client for mysql
I have a fairly ba
Nothing's wrong with Linuxthreads :)
But eventually the SA stuff that FreeBSD has chosen to implement will give
better performance than kernel threads, so I was asking when the Mysql team
was thinking of tackling getting a binary out for 5.0.
Peter
<^_^>
-Original Message-
From: Jeremy Z
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
Hi,
I'm running Connector/J 2.0.14 with J2SDK1.4.1_01. Prior to these upgrades, all my code ran fine. However, I upgraded all my packages (MySQL, J2SDK, and to Connector/J, as already stated) and now I keep getting an IOExcep
Dave,
> I am looking for an
> easy to use, easy to install mysql client which would enable users to
query
> my database.
What about a web browser? It's most probably installed on all laptops.
You could use some simple PHP script (not as mighty as phpMyAdmin, I
would suggest) to convert SQL queri
Is it possible to detect mysql servers on the network without knowing the hostname?
cheers
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive
On Tue, Jan 21, 2003 at 01:38:42PM -0800, Josh L Bernardini wrote:
>
> Bob,
> First of all, thank you. I never would have gotten here on my own. Only I
> am not quite there.
> Using your example, I have managed to list all the events a person is
> attending and not attending. Wondering if you migh
hi,
would someone please tell me how to create mysql user? and how to set the
mysql root password?
Thanks
_
The new MSN 8: advanced junk mail protection and 2 months FREE*
http://join.msn.com/?page=features/junkmail
On Tue, 2003-01-21 at 23:12, [EMAIL PROTECTED] wrote:
> 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:
>
> sql,query,queries,smallint
>
> If you just reply
Okay, I found User Comments at the end of the section of the user manual
online that contained the info I needed to get the option of loading a
textfile into a table.
The startup line I use for that is:
/usr/local/bin/mysql -u root --local-infile -p menagerie
where 'menagerie' is the databa
At 15:33 +1300 1/22/03, Defryn, Guy wrote:
Is it possible to detect mysql servers on the network without
knowing the hostname?
cheers
Is there a discovery protocol? No.
sql, query
-
Before posting, please check:
http://w
1 - 100 of 129 matches
Mail list logo
