The problem could be in the HTML page.
I suppose You use a form to submit data.
If You want to pass more than about 1K data You must use POSTs and not GETs.
The Get option has a limit in the URL len so You can not successful
pass more than 1K bytes (browser/platform specific limit). The url in
Thanks Nils, I will just add a little to the original question, I am familar with the
table structure in that I have access to the tables ect. I have even installed a few
versions of osc ;)
I am asking if anyone has gone beyond looking at .sql and actually worrking out how
all the tables
actually just add a little more to this, perhaps what I am after is some kind of tool
that creates a DB schema layout , dare I say it like access ;) Is there something
that does this for MySQL ?
Andrew
-Original Message-
From: Andrew [mailto:[EMAIL PROTECTED]
Sent: 19 July 2003 09:51
this is a test message
Hi,
I need a hint how to use myisamchk
I use this syntax in a shell but it doesn't work
myisamchk -R=ID \mysql\data\db\mytable.myi
ID is the index name I want to use to sort the table
I'm using mysql 4.0.13 on Win 2K server
Thanks for help
Patrizio
test failed
-Original Message-
From: Neeraj Vasudeva [mailto:[EMAIL PROTECTED]
Sent: Samstag, 19. Juli 2003 11:28
To: [EMAIL PROTECTED]
this is a test message
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
I create a database, foo, then designate a user, pooh, with full
privileges, including grant option (pooh is to administer this database,
including creating other users):
grant all on foo.* to 'pooh'@'localhost' identified by 'zoo' with grant
option;
Now pooh logs in to the mysql
Hi, I'm clear as to what is meant by The mysql client in the MySQL core
certification revision check list. I understand that the mysql database
itself is the server. Would client then be any program that talks to the
server? Perhaps it is referring to mysql, the command line tool?
I understand
Thank you for your direction. I posted on both lists under the hope that I
could find someone out there with experience using the API - whether the C
api or the C++ - and who may have encountered a similar problem.
I have been googling for days and found mostly stuff related to PHP and
MySQL,
I know this is quite a bit off topic, but i was wondering if anyone else
out there had any experience with Segue's Silk Performer load testing
tools. More specifically, i am trying to compile a test script to allow
me to perform some transactional database testing to load test a MySQL
4.0.13
is there a tool to view a schematic of a MySQL DB I don't mean the .sql file I
mean a pretty chart type schematic :)
Andrew
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
You probably don't mean the $Nk tools (PowerDesigner, ERWin, Rational Rose
c). MS Visio does it, but Dezign (http://www.datanamic.com/dezign/) does it
better cheaper IMO (no I'm not a principal). PB
-
- Original Message -
From: Andrew
To: MySQL-Lista
Sent: Saturday, July 19,
this is exactly what I am looking for :) Is there a free one of these guys
hanging around somewhere?
Andrew
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: 19 July 2003 17:50
To: MySQL-Lista
Subject: Re: DB Design
You probably don't mean the $Nk tools
At 23:10 -0500 6/24/03, MaFai wrote:
Hello, mysql,
A table contains a column named mydate.
//Wrong sql statement
alter table p_asset add mydate datetime default now();
alter table p_asset add mydate datetime default time();
alter table p_asset add mydate datetime
Assistance required.
I have 3 tables:
TABLE: client_invoice
- client_id *1(show all from client_invoice, only those w/ info from client_info)
- invoice_amount
- invoice_date_due
TABLE: client_info
- client_id*1(show all from client_invoice, only those w/ info from
At 22:20 -0700 7/18/03, Ralph Guzman wrote:
Paul,
I just picked up your book today: MySQL Cookbook and I just wanted to
comment on how great it is.
I've spent hours at the bookstore looking through mySQL books, and by
far this is the best one I come across.
I strongly recommend it to
This is probably easy, but I just can't to put my finger on it. I have a
list of numbers (i.e. 1 to 175) and I want to do a select statement to
get the highest number. I have tried the limit thing but not getting the
right output. Can someone shed some light on this?
TIA
--
MySQL General
At 13:32 -0400 7/20/03, C. Reeve wrote:
This is probably easy, but I just can't to put my finger on it. I have a
list of numbers (i.e. 1 to 175) and I want to do a select statement to
get the highest number. I have tried the limit thing but not getting the
right output. Can someone shed some light
Check this
http://www.fabforce.net/dbdesigner4
olinux
--- Andrew [EMAIL PROTECTED] wrote:
this is exactly what I am looking for :) Is there a
free one of these guys
hanging around somewhere?
Andrew
-Original Message-
From: Peter Brawley
[mailto:[EMAIL PROTECTED]
Sent: 19
using colname like string2search4 doen't seem to work for me w/ mysql
also have tried select * table upb where Desc REGEXP pipe;
as well as creating a (full text) index on the column.
docs seem a little thin in this area, any tips or pointers to resources greatly
appreciated. miked
At 14:53 -0400 7/19/03, [EMAIL PROTECTED] wrote:
using colname like string2search4 doen't seem to work for me w/ mysql
also have tried select * table upb where Desc REGEXP pipe;
as well as creating a (full text) index on the column.
docs seem a little thin in this area, any tips or pointers
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'm trying to add a foreign key to a table. All tables are INNODB. Table a has
following partial Definition:
TableA
( Fld1 int Primary Key,...
)
TableB
(Fld2 int Primary Key,
Fld1 int not null, ...
)
I use the following Statement:
Alter
how do you make a socket or use unix_socket etc. The basics?
--
G Gill mailto:[EMAIL PROTECTED]
Good day list,
I hope that this is an easy one for you guys to help me with, I am
relatively new to DB design, and I realized that I have left out a few
very important Indexing and counting columns.
So my question is this,
What do I need to do to fill in new column, I would like to have it
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Saturday 19 July 2003 17:17, Andrew Rothwell wrote:
So I can add the column, and I can set it to have an auto_increment, but
will that start out at 201? or will it start at 1 and propogate through?
If you don't modify the table definition, it
Michael Satterwhite wrote:
So I can add the column, and I can set it to have an auto_increment, but
will that start out at 201? or will it start at 1 and propogate through?
If you don't modify the table definition, it will start at 1 and propagate
throughout: e.g.
Are you saying that it
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Saturday 19 July 2003 18:17, Jim McAtee wrote:
Are you saying that it will propogate through the _existing_ rows, or only
on rows added later?
It will number all existing rows and continue with rows added later.
- ---Michael
-BEGIN PGP
Michael Satterwhite wrote:
Are you saying that it will propogate through the _existing_ rows, or only
on rows added later?
It will number all existing rows and continue with rows added later.
Interesting. In the case where you want to begin numbering existing rows at 1,
is it necessary
To restate an earlier question more concisely:
Is it true that a user who is given all privileges, including grant
option, on a database (e.g., in order to administer that database) can
create other users with any or all of his privileges, but cannot give
them passwords? Is there some
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Saturday 19 July 2003 19:20, Jim McAtee wrote:
Interesting. In the case where you want to begin numbering existing rows
at 1,
is it necessary to set the autoincrement number to that of the next, i.e:
Alter Table X Auto_Increment = 201;
No.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Friday 18 July 2003 21:28, [EMAIL PROTECTED] wrote:
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use
near
.
Any ideas? I need subselect working.
Hi Andrew,
Thanks for the reply, that makes your question clearer, but I havent had a
chance yet to try the system you described. Sorry, unfortunately at this time
I am unable to help.
Best regards
Nils Valentin
2003 7 20 03:48olinux :
There is a diagram of the database included in the
I installed the current stable release of MySQL from RPMs. I used the client
and server packages.
After installing the server package, the RPM printed a note saying I should
run two commands. I only got the first one, which was
# ./mysqladmin -u root --password
I assume this gave the root user a
when you connect you connect to a running daemon
try running
mysqld beforehand
-Martin
- Original Message -
From: Jeremy Booker [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, July 19, 2003 7:12 PM
Subject: passwords DBI/DBD
I installed the current stable release of MySQL
I guess I forgot to mention that MySQL was running at the time. I could use
mysqladmin (as long as I used the '-p' option and entered that root password
i setup), and I could also run SELECT statements from the command line.
-Jeremy
~
Jeremy Booker - Owner / Webmaster
Jeremy Booker wrote:
I installed the current stable release of MySQL from RPMs. I used the
client
and server packages.
After installing the server package, the RPM printed a note saying I
should
run two commands. I only got the first one, which was
# ./mysqladmin -u root --password
I assume
Hi -
I have an application which is essentially 'read-only' -
once the database is loaded it is only read from. So,
I am trying to implement it with various indices and
a table containg some large content in blob columns.
I observe the max_allowed_packet setting and
'split' blobs too large among
| How are they typing in the information? From a web
| page? From the command line? From a custom program?
They type the information from a web page.
What web programming language are you using to receive the
post request from the web page and form the sql query to
insert the data into the
At 12:32 PM 7/20/2003, you wrote:
This is probably easy, but I just can't to put my finger on it. I have a
list of numbers (i.e. 1 to 175) and I want to do a select statement to
get the highest number. I have tried the limit thing but not getting the
right output. Can someone shed some light on
39 matches
Mail list logo