I have a 2.7meg dump of SQL created by phpMyAdmin [1], however when I try to
import this data back into mysql through phpMyAdmin, it times out
(understandably), so I guess I need to do this from the command line, but
have no idea how to go about this AT ALL... can anyone point me in the right
direc
> is there any table structure design program in a graphical layout for
windows available ? i have tables and
> fields on paper but would like a way to be able to lay them out on a
screen and show which table joins to
> what and what keys it uses let me know thanks
You can use EMS MySQL Manager fo
hi guys , i am trying to sort out if the app i am about to build would require the use
of transactions, there may be a few users simultanously entering data, but possible
not updating the same data and maybe a lot of users accessing the data (search/select)
, will this require some form of trans
hmm a middleware product would be good , extra processing=time ?
also stored procedures would be excellent ,
also maybe a middleware product to load balance between slave and master and delegate
slaves if a master goes down is there such a thing ?
>>> Nitin Nanivadekar <[EMAIL PROTECTED]> 04/0
Hello there!
mysql> show columns from user like 'User' ;
+---++--+-+-+---+
| Field | Type | Null | Key | Default | Extra |
+---++--+-+-+---+
| User | varchar(16) binary | | PRI | |
Dear Friends,
We all know Mysql is a beautiful database engine but
there are some things missing. Even Mysql team
acknowkedges the need in their ToDo list.
i was thinking of designing a Java, C based
application server that acts as a gridge bewween the
applications & the database. This server can t
is there any table structure design program in a graphical layout for windows
available ? i have tables and fields on paper but would like a way to be able to lay
them out on a screen and show which table joins to what and what keys it uses let me
know thanks
--
MySQL General Mailing List
For
I was wondering whether somebody on this list has successfully installed
MyODBC on AIX 4.3.3. I tried it today using the 3.51 binaries and could not
get it to work with either the latest iODBC or unixODBC driver manager. I
someone has experience I happy to post more detailed error messages.
Thanks
ok so we can ingore the last message i've finally convinced that mysql 4 will be the
best option for the searching, i am moving over an access database of a tape library
which is 100,000 records. this is pretty massive search wise , what could be the best
way to go about this , we have a title,
MySQL is installed as a service running locally. Also, this error occurs
with version 3.23.53 onwards (I never tested on older versions than
this).
Thanks,
Dan
-Original Message-
From: Dan Cumpian [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 10:27 PM
To: [EMAIL PROTECTED]
Su
Hello,
I am having the following problem that I've been able to consistently
replicate:
I am using code written in Delphi with Zeos Database components and am
having a problem with a query returning "server connection error". I am
inserting a row into a table and then immediately selecting
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Inserting blob in database with gbk charset
may cause error or data corruption
Description:
When mysql's sql statement lexer (sql/sql_lex.cpp))
analyzes a sql string, it uses the my_ismbchar macro
on the default charset structure to
Matt Gostick wrote:
Well... if you were given a start date of 2003-01-01 and end date of
2003-01-31...
select *
from table_name
where start_date between "2003-01-01" and "2003-01-31"
or end_date between "2003-01-01" and "2003-01-31"
No?
No.
Example: start_date = "2002-01-01" and end_dat
Jeff Shapiro wrote:
If you want to be a bit more generic you could do something like this:
# store the desired OS ID into a variable
SELECT @desired_id := os_id FROM os_table WHERE os_name = "win nt";
# now find the solutions that match with the os_id
SELECT o.os_id, o.os_name, s.os_code, s.solut
Nope. That is not the case here because the connections to the database are
autoReconnect=true.
> -Original Message-
> From: Terrance Win [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, April 02, 2003 7:42 PM
> To: [EMAIL PROTECTED]
> Cc: [EMAIL PROTECTED]
> Subject: Re: MySQL 3.23.39 shuts d
Try
sqlimport (it is in the bin directory)
Martin
- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 4:33 PM
Subject: MySQL 4.0.12 -max-nt Error 1148: Used command is not allowed with
this MySQL Version
> I am trying to load a table from
On Wed, 2 Apr 2003 13:23:29 -0800 (PST), Rachel
Rodriguez <[EMAIL PROTECTED]> wrote:
| I was wondering if anyone on the list has attended any
| of the training listed on the mysql.com site. If yes,
| was it worth the costs in your opinion? I'm trying to
| justify the costs to my management.
I
I am trying to load a table from a test delimited file. This worked in the
previous version. Any advice on how to accomplish this?
D. H. Craig, CSM
Have a grateful day!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[E
hi i was wondering what the differences between the 2 servers with search
engine capabilties, also how does the full text indexing actually work ? i
am planning on a footage archive database, it could be titles, but it also
could be content aswell, text in titles are short so should be ok but would
Hi Rachel,
I attended the week long training last year and I found it to be very
helpful. Even if you
know the basics this will cover some advanced material and also provide
better ways to
do the things you already know.
Bhavin.
- Original Message -
From: "Rachel Rodriguez" <[EMAIL PROTECT
If you want to be a bit more generic you could do something like this:
# store the desired OS ID into a variable
SELECT @desired_id := os_id FROM os_table WHERE os_name = "win nt";
# now find the solutions that match with the os_id
SELECT o.os_id, o.os_name, s.os_code, s.solution
FROM os_table o
In the last episode (Apr 02), Mike South said:
> In load testing I noticed that, even though all the queries in the
> tests are for the exact same tables, at some point in the test
> the Open_files variable (from SHOW STATUS) drops very quickly. Does
> anyone have any idea what would cause that?
At 16:53 -0500 4/2/03, Mike South wrote:
In load testing I noticed that, even though all the queries in the
tests are for the exact same tables, at some point in the test
the Open_files variable (from SHOW STATUS) drops very quickly. Does
anyone have any idea what would cause that?
FLUSH TABLES
In load testing I noticed that, even though all the queries in the
tests are for the exact same tables, at some point in the test
the Open_files variable (from SHOW STATUS) drops very quickly. Does
anyone have any idea what would cause that?
mike
--
MySQL General Mailing List
For list archi
Well... if you were given a start date of 2003-01-01 and end date of
2003-01-31...
select *
from table_name
where start_date between "2003-01-01" and "2003-01-31"
or end_date between "2003-01-01" and "2003-01-31"
No?
Matt.
On Wed, 2003-04-02 at 16:32, Sarah Heffron wrote:
> How would
Hi Rachel,
I attended a MySQL weeklong training last October -- 2002. It was 2 days of
querying and data manipulation and 3 days of administration. I did not have a
very significant history with MySLQ before the training, but I had read the
entire manual, so the first 2 days were very engaging.
How would I do this:
I have a date range (start date and end date) supplied by the user
and I also have information in a table that has start dates and
end dates. I want to select everything in the table whose date range
overlaps in any way with the date range given by the user.
Thanks,
Sara
I should have been more specific: we're looking at the
"Using and Managing MySQL" training. Opinions
appreciated.
~RR
--- Rachel Rodriguez <[EMAIL PROTECTED]>
wrote:
> I was wondering if anyone on the list has attended
> any
> of the training listed on the mysql.com site. If
> yes,
> was it worth
I should have been more specific: we're looking at the
"Using and Managing MySQL" training. Opinions
appreciated.
~RR
--- Rachel Rodriguez <[EMAIL PROTECTED]>
wrote:
> I was wondering if anyone on the list has attended
> any
> of the training listed on the mysql.com site. If
> yes,
> was it worth
The replication now work fine.
I've deleted from my.ini on MASTER
binlog-do-db=database_name
I've tried to insert in my.ini on SLAVE
replicate-ignore-table=db_name.table_name
Without result.
If i insert any option (replicate-ignore-table or binlog-do-db) the
replica is stopped!!
:-/
A
I was wondering if anyone on the list has attended any
of the training listed on the mysql.com site. If yes,
was it worth the costs in your opinion? I'm trying to
justify the costs to my management.
Thank you, Rachel
=
__
Do you Yahoo!?
Ya
Hi all,
I'm wondering if there is some way to setup privileges in the grant
tables such that a user can create or drop any arbitrary table in
databases that user is associated with, but be unable to create or drop
the databases themselves. I was hoping the tables_priv table would come
to my r
Here's The Deal :)
To Pass a username and Password via JDBC, you should pass it in the
'url' string...
Try this :
DriverManager.getConnection("jdbc:mysql://localhost:3306/test?user=[user
]&password=[pass]");
I Find it's about the most reliable Way to go :)
_/_/_/_/ _/_/_/_/ +---Research Progra
Stefan Hinz wrote:
The query I used looks like this:
SELECT files.file_id, filename FROM access, files WHERE
directory_id="0" AND lang_id="1" AND ( files.file_id=access.conn_id AND
access.group_id IN (1) AND access.class_id="4" AND class_tbl="file" )
group by file_id order by filename;
Just a
This one worked. Thank you.
On Wed, 2 Apr 2003, Michael Shulman wrote:
> John,
>
> Looks like I'm first with the wrong answer again.
>
> This time for sure.
>
> How about:
>AND os.os_id & 8 = 8
>
> Where 8 is the value that you're looking for.
>
> -ms
>
>
>
>
> -Original Message-
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kevin Lane wrote:
| I attempted to use the limit and offset features in some of my select
| statements when using mysql-connector-java-3.0.6-bin.jar. I recieve the
| following error :
| java.sql.SQLException: Communication link failure: java.io.IOExcep
Hi,
On Wed, Apr 02, 2003 at 05:01:48PM -0300, Sibusy wrote:
> I'm trying to perform UPDATE with a PHP form , but the UPDATE query doesn't work
> anyway, returning"Can't perform the update", according to code below. It doesn't
> return any error at PHP nor at Mysql, I have tested the variables an
I attempted to use the limit and offset features in some of my select
statements when using mysql-connector-java-3.0.6-bin.jar. I recieve the
following error :
java.sql.SQLException: Communication link failure: java.io.IOException,
underlying cause: Unexpected end of input stream. I attempted the
On Wed, 02 Apr 2003 11:10:04 -0600
gerald_clark <[EMAIL PROTECTED]> wrote:
> AChecks for empty
> B Checks for empty
> AUpdates
> AReads ( and owns record )
> BUpdates
> BReads ( and owns record )
>
Reality says to do it more like this
A Write lock on table
B Tries to
On 02-Apr-2003 Pag wrote:
>
> Hi,
>
> I am kinda new to this mysql thing, so please forgive the basic
> question.
> What i need to do is, list my records on a table with a checkbox for
> each.
> After we choose several of the records, we click a button and i want to
> be
> ab
Hello,
I'm trying to perform UPDATE with a PHP form , but the UPDATE query doesn't work
anyway, returning"Can't perform the update", according to code below. It doesn't
return any error at PHP nor at Mysql, I have tested the variables and they are beeing
sent properly.Could someone help me???
H
John,
Looks like I'm first with the wrong answer again.
This time for sure.
How about:
AND os.os_id & 8 = 8
Where 8 is the value that you're looking for.
-ms
-Original Message-
From: Michael Shulman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 11:38 AM
To: 'John Ho
No problem. Use mod(m,n). To get the records where the "8" bit is set, use
and mod(os.os_id,8) = 0;
mysql> use test
Database changed
mysql> create table t (i integer);
Query OK, 0 rows affected (0.18 sec)
mysql> insert into t values (1);
Query OK, 1 row affected (0.10 sec)
mysql> insert into
so then the next obvious question to ask is... is this just not
implemented yet, or is it not even on the radar as a 'feature'?
Out of curiosity, do other SQL implementations (RDBMS) allow this
syntax?
On Wed, 2003-04-02 at 08:06, Egor Egorov wrote:
> On Wednesday 02 April 2003 04:04, Daevid Vin
thanks for the advice Stephen. I'll admit though I am somewhat loathe to
adding an artifical row in the other tables, but it may not be a bad way
to go. In the past, I've written triggers to do this kind of check, but
mysql doesn't yet support triggers.
what I ended up doing is carefully rethinkin
You can't use a JOIN on an insert, only on a SELECT.
The (simplest) syntax for INSERT is
INSERT INTO (col1, col2, col3) VALUES (val1, val2, val3)
You can also INSERT as a result of a SELECT, but that's not what you want.
Unfortunately, you will need to create multiple INSERT statements to kee
Not quite that simple, Plese read the last of the original post. I need
all solutions that have the 4th bit on, so 8,15,24,31...255 all have the
4th bit in combination with other bits.
On Wed, 2 Apr 2003, Michael Shulman wrote:
> mysql> select solution
> -> from os_table os, solutions_table
HI there, I'm running Solaris9X86 and trying to compile version 4.0.12 from
source.
I'm using the suggested flags and configure options from the reference
manual. However I'm not really sure which of the compile options I can
add/remove/tinker with as I've never really done any c programming.
I'm getting 100 messages a day on this newsgroup. While I love to help, I
don't like having to read each message to figure out if it's something I can
help with.
Here are examples subject lines from the past 24 hours:
How many
Help MySQL Beginner please.
Have a problem
mysql> select solution
-> from os_table os, solutions_table solutions
-> where os.os_id = solutions.os_code
-> and os.os_id = 8;
-ms
-Original Message-
From: John Hoskins [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 10:41 AM
To: [EMAIL PROTECTED]
Subject: select
Eldon,
It looks like you have left in the records with a blank username for
"localhost" and for "UtilServer".
The following description is taken from
http://www.mysql.com/doc/en/Connection_access.html and my own
experimentation to validate that this works on Windows, too.
The authentication syst
Jeff,
Thaks for the reply, let me sum up. Normal order if by CaseID, However,
we have a need to order it by FileNumber (Keeps all the Assignments for One
person together). Assignments for one person may come in over the course of
Months so I can't order it by CaseID. The reason I want t
I am trying to load a table from a test delimited file. This worked in the
previous version. Any advice on how to accomplish this?
D. H. Craig, CSM
Have a grateful day!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[
>
>Please don't take these suggestions as sarcasm. Relying on your tools to catch
>anything other than syntax errors is a bad idea. It builds in a false sense of
>security.
I couldn't possibly disagree that Q/A is a good idea, but so is
defense in depth. That's why we train drivers AND install
My advice is to consider an alternate storage approach.
Instead of storing parent id's, store the trees using the Nested Set
model.
http://www.dbmsmag.com/9603d06.html
About halfway down the article he presents a model where you never store
the parent id, but you do store two columns (LEFT and RI
When you don't specify a hostname (and 'localhost' doesn't count, use
'127.0.0.1') to the mysql commandline client, it uses Unix domain
sockets to connect to the server.
JDBC has to use TCP/IP, because Java doesn't have support for Unix
domain sockets.
What happens if you do:
mysql -h 127.0.0.1 -u
>Description:
Any connection to mysqld over network socket results in segmentation fault and
mysqld restarting. The log records:
= begin log extract ==
bin/mysqld_safe: line 320: 12974 Segmentation fault
$NOHUP_NICENESS $ledir/$MYSQLD $defaults --based
On 2 Apr 2003 at 12:51, Helge Moulding wrote:
> I noticed that there are several mirrors for this ML. Do any of
> them implement a better search than the fairly rudimentary search
> available at the main site?
I haven't found any mirrors that have a useful search function.
Fortunately, the gro
Please consider the following two tables:
mysql> select * from os_table;
+---+--+
| os_id | os_name |
+---+--+
| 1 | mac os |
| 2 | win 95 |
| 4 | win 98 |
| 8 | win nt |
|16 | win 2000 |
|32 | win me |
|64 | xp home |
| 128 | xp p
Attempting to run the makefile for test_libmysqld.c
-I am linking against
/cygdrive/g/mysql/mysql-debug-4.0.12-pc-linux-i686/lib/libmysqlclient.a
$ make
gcc -g -W -Wall -I/cygdrive/g/mysql/mysql-debug-4.0.12-pc-linux-i686/include
-D_
THREAD_SAFE -D_REENTRANT -static
test_libmysqld.c -L -l/cygdr
I like this solution. Gonna cogitate on it for a while.
=C=
- Original Message -
From: "GERST, MICHAEL (SBCSI)" <[EMAIL PROTECTED]>
To: "'Cal Evans'" <[EMAIL PROTECTED]>; "gerald_clark"
<[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 11:59 AM
Subject:
Just noticed this thread.
Here is another method, still using the 'userid' method, but slightly
differently; it claims a job immediately. You then have to run a select by
your own 'userid' to find out what you claimed:
Assumptions:
This assumes that the following table exists, and that unique_jo
On April 1, 2003 07:50, Klepetka, Tom wrote:
> Hi -
>
> I would like to access a mysql database server from a NUMA-Q Sequent
> platform running Dynix/ptx v4.5.2. Does any of mysql's connectivity
> products (Connector/ODBC, Connector/C++) run under this platform/OS?
I am afraid that I don't know
Delete from table where num in ( 1,13,34) ;
Pag wrote:
Hi,
I am kinda new to this mysql thing, so please forgive the basic
question.
What i need to do is, list my records on a table with a checkbox
for each. After we choose several of the records, we click a button
and i want to b
I noticed that there are several mirrors for this ML. Do any of
them implement a better search than the fairly rudimentary search
available at the main site?
--
Helge Moulding
mailto:[EMAIL PROTECTED]Just another guy
http://hmoulding.cjb.net/ with a weird name
_
Hi!
Pag wrote:
If i was too confusing, maybe this helps: How can i delete the
records whose "num" field is 4,78,34 and 23, all in one command?
Something along "delete * in 'table' where num=1 and num=13 and num=34"
etc.
"DELETE FROM table WHERE num=1 OR num=13 OR num=34"
or better:
http:/
I use MDK 9.0 and installed MySQL 4.0.12 Max ... sir
How can i change charset sir ?
i want to use tis-620 .. sir
Any one can help me sir ... ?
Just mean change the my.conf ? ( my-small.conf , my-medium.conf , )
to add
[client]
default-character-set=character-tis620 ? just do it
Jeff,
We faced a similar challenge in an application: Each child record must have
a parent in one of two tables, TabA or TabB, but not both. We "solved" it
by adding a foreign-key field for each possible parent in the child
table. Each column can have the FK constraint. We were using Sybase,
Scott Wong writes:
> I'm not sure if this is a feature or not so i'll just report it as a possible bug.
> I couldnt find anything in the documentation.
>
>
> How to repeat:
>
> create table t1(id int);
> insert into t1 set id=0;
> select @a:max(id)+1 from t1;
> insert into t1 [EMAIL PROTECTED]
Hi,
...the sysntax it's not quite normal.You should try :
select @a:=max(id)+1 from t1;
To test if the variable @a is "loaded" with what you expect, you can do:
select @a;
...if the result is NULL something is working wrong.
Anyhow, i wonder how it works on the master ?
Regards,
Gelu
___
Yes, but both men think they have the record.
So 'A' looses bigtime.
My version catches this.
Cal Evans wrote:
last man wins.
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Cal Evans" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 1
last man wins.
- Original Message -
From: "gerald_clark" <[EMAIL PROTECTED]>
To: "Cal Evans" <[EMAIL PROTECTED]>
Cc: "MySQL" <[EMAIL PROTECTED]>
Sent: Wednesday, April 02, 2003 11:10 AM
Subject: Re: How Many
> AChecks for empty
> B Checks for empty
> AUpdates
> AReads ( a
Michael Shulman wrote,
> Privilege changes (at least on Windows) don't seem to take effect until
> either (a) the server is restarted, or (b) the server is instructed to
> re-read its permissions tables.
Fair enough. I did FLUSH PRIVILEGES whenever I changed the user table. It
seemed to me that t
Hi,
I am kinda new to this mysql thing, so please forgive the basic question.
What i need to do is, list my records on a table with a checkbox for each.
After we choose several of the records, we click a button and i want to be
able to delete the ones selected. Is there a simple mysql command
AChecks for empty
B Checks for empty
AUpdates
AReads ( and owns record )
BUpdates
BReads ( and owns record )
Now What?
Cal Evans wrote:
No. You check for empty. update, check again to make sure you now own it.
The userid is either going to be you OR someone else. not both
I don't enjoy being a PITA but could you teach your MUA to create
proper attributions? This makes it really hard to tell who said
what, leads to confusion, and may piss of quite a few people if a
debate gets somewhat heated...
# [EMAIL PROTECTED] / 2003-04-02 18:18:17 +0200:
> > #
On Tuesday 01 April 2003 23:53, Elby Vaz wrote:
> i installed MySQL (server, max and client) for linux but i`m needing of
> `mysql.sock` file.
> some body has?
mysql.sock is created when MySQL server is started. So, just start MySQL
server.
--
For technical support contracts, goto https://ord
On Wednesday 02 April 2003 04:04, Daevid Vincent wrote:
> Is this a bug or just not implemented in 3.23.56-Max?
>
> mysql> SELECT alarm_notes, DATE_FORMAT(alarm_date,'%m/%d/%y %h:%i %p') AS
> alarm_date_format, IFNULL(CONCAT(contact_fname, ' ', alarm_date),
> alarm_date_format) AS contact_name, con
On Wednesday 02 April 2003 18:10, Webmanhouse at aol dot com wrote:
> The best thing that happened to me today is finding this list on the web. I
> am in deep problem. I am trying to build database for my site and just
> discovered that my hosting server uses mySQL and i am not use to it. I
> don't
On Tuesday 01 April 2003 23:34, Pratchaya Chatuphian wrote:
> I use MDK 9.0 and use MySQL installed with RPM Package
>
> How can i change or set new charset on mysql .
>
> Caz , i want to use tis620 charset ..
>
> I live in thailand and must use charset that i can sort my data correctly
> on my
On Wednesday 02 April 2003 16:17, Tariq Murtaza wrote:
> Hope you are all fine and doing well.
> I would like to know the status of unicode support for mysql.
> I will appreciate if someone share his/her experience regarding data
> manipulation in unicode on mysql.
Unicode is supported since 4.1
Hi,
I have two alternative suggestions.
1. Test your code. Simple test cases will ferret out these problems before they hit a
production environment.
2. Peer review. Let someone else look at your code before you migrate it to a
production environment. This, in my experience, is an effective wa
Thanks,
but I think the lik you provided won't help. I know how to create pk/fk
contraints, and do in our schema, when the foreign key is completely
specified. for example, if my original table was instead:
create table Example (
id int not null auto_increment primary key,
fk_id int
I'm not sure if this is a feature or not so i'll just report it as a possible bug.
I couldnt find anything in the documentation.
How to repeat:
create table t1(id int);
insert into t1 set id=0;
select @a:max(id)+1 from t1;
insert into t1 [EMAIL PROTECTED];
Result on master:
mysql> select *
[EMAIL PROTECTED] wrote on 02.04.2003 17:10
Hi all,
Hello Jef,
The best thing that happened to me today is finding this list on the web. I am in deep
problem. I am trying to build database for my site and just discovered that my hosting
server uses mySQL and i am not use to it. I don
I mean, at least that's how I reacted upon reading..
"
For MyISAM tables, you can work around the lack of ON DELETE by adding
the appropriate DELETE statement to an application when you delete
records from a table that has a foreign key. In practice this is as
quick (in some cases quicker) and much
# [EMAIL PROTECTED] / 2003-04-02 17:37:26 +0200:
> And from this page:
> http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html
> I understand it is rather recommended NOT to use foreign keys, at least
> until mysql integrates it more fully.
which part of that page makes you say that?
--
Fr
David Brodbeck wrote:
I know a lot of people who refuse to use Yahoo Groups because of Yahoo's
very open and ever-changing privacy policy.
Most of the other combination web discussion board/mailing list systems I've seen are not very good at doing mail. They're web chat boards with mail notificat
I've been trying to install MySQL (3.23.55) as a named NT service and using a
specified defaults file and I can't get it to work.
The source code has the example:
mysqld --install-manual mysqldopt --defaults-file=c:\miguel\my.ini
in it. The results in a service ImagePath of
C:\mysql\bin\mysql
Ben Edwards wrote:
Sorry everybody. I assumed that as it had been out for a long time (2
years?) it was stable. I should of chequed.
We are also running 3.23.xx because of long-standing stability. We have
arranged 4.x installations for customers as necessary, but at this
point, only 3.23.x
No. You check for empty. update, check again to make sure you now own it.
The userid is either going to be you OR someone else. not both. It it's you
then you own the record. If it's someone else then someone slipped in and
grabbed it from you.
=C=
- Original Message -
From: "gerald_cla
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Todd O'Bryan wrote:
| I've managed to get mysql up and running again (I don't know how) but
| JDBC won't connect to it.
|
| Here's my little simple code:
|
| import java.sql.*;
| import java.io.*;
|
| pub
Thank you for your explanations, after 4 interventions I now know much
more about the difference between primary, unique, index and I've learnt
that foreign keys exits in my sql ;-)
And from this page:
http://www.mysql.com/doc/en/ANSI_diff_Foreign_Keys.html
I understand it is rather recommended NO
I suggest using the tutorials on the www.mysql.com website. That's how I
learned the basics.
Craig Pyter, CCNA CCDA MCSE
mc.net
720 Industrial Drive, Suite 121
Cary IL 60013
847.594.5111 ext.5733
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
S
http://www.mysql.com
There's a great manual that got me started. I'd also look on WebMonkey for
some basic tutorials.
--Joe
--
Joe Stump <[EMAIL PROTECTED]>
http://www.joestump.net
"Label makers are proof God wants Sys Admins to be happy."
-Original Message-
From: [EMAIL PROTECTED] [ma
I've managed to get mysql up and running again (I don't know how) but
JDBC won't connect to it.
Here's my little simple code:
import java.sql.*;
import java.io.*;
public class MySQLTester {
public static void main(String[] args) th
PHP? www.php.net (click links->tutorials)
PHP/perl/MySQL? www.devshed.com
Others will add quite a few too.
devshed.com is pretty good.
B.
At 10:10 02-04-2003 -0500, [EMAIL PROTECTED] wrote:
Hi all,
The best thing that happened to me today is finding this list on the web.
I am in deep problem. I
You may be able to do something with SquirrelMail. It's an email front
end written in PHP, so you may be able to customize it for your needs.
I actually have a need to store all emails in a database also, mainly
to link emails with people for followups.
I actually do this right now, but I have a
Cal Evans wrote:
Ed,
1: It depends on your hardware. I don't think MySQL imposes a restriction.
2: It doesn't work that way. It's not like VFP or Access where you 'edit' a
record. You can SELECT the contents of a record, you can manipulate them and
then you can UPDATE that record (assuming yo
Hi all,
The best thing that happened to me today is finding this list on the web. I am in deep
problem. I am trying to build database for my site and just discovered that my hosting
server uses mySQL and i am not use to it. I don't know where to start. don't know how
to create table or anything
1 - 100 of 128 matches
Mail list logo
