Hi Nils,
I have to test to unicode(utf8 & ucs2).
but It was frontend client enviroment matter(native supported by
Unicode-16).
I was compiled by my self.
Then I tried uft8 and it was successful.
but ucs2 was doesn't work by the same step.
Thank you.
Yujis
--
MySQL General Mailing List
For list
> I'd like to use ucs2 character set for MySQL.
You do understand that Unicode support is not yet complete in MySQL,
including the current alpha?
Also, I would expect UTF-8 to be in better condition that UTF-16.
--
Joel Rees <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives
Hi Yuji,
I have never heard of a character set thats named ucs2
This are the character sets which came with 4.1 alpha:
baby-bumble-bee:/usr/share/mysql/charsets # ls
. READMEcp1250.xml cp1257.xml cp866.xml hebrew.xml
koi8r.xml latin2.xml macce.xml
.. armscii8.xm
Hello
I need some information about it
- access to remote data base
- implementation X/Open DTB
some links ... ??
thanks a lot
mec
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hi Nils,
I have no ucs2.xml in the "/usr/local/share/mysql/charsets/" .
but I was looking for about ucs2 in the
"/usr/local/share/mysql/charsets/Index.xml" .
Unicode
UCS-2 Unicode
What should I do?
Japanese:こちらこそ宜しくお願いします。
Nils Valentin wrote:
Hi Yuji
Error 2 means the file doesnt ex
HI I'm not sure whether it's a bug or my configuration problem??
I have upgraded mysql from 3.23.53 to 4.0.12 so that the on update
cascade will work! then the I got mysql crash when I did the update.
Any idea??
mysql> CREATE TABLE software (
-> softwareID CHAR(20) NOT NULL,
Hi Yuji
Error 2 means the file doesnt exist. (here:
'/usr/local/share/mysql/charsets/ucs2.xml').
Please make sure the file is in the foldr specified and not misspelled.
Best regards
Nils Valentin
Tokyo/Japan
Japanese: 宜しくお願いします
2003年 6月 11日 水曜日 14:44、Yuji Sato さんは書きました:
> I'd like to use ucs
I'd like to use ucs2 character set for MySQL.
(B
(BMy enviroment is shown below:
(BOS FreeBSD 4.8
(BDB MySQL4.1.0-alpha
(B
(BA)
(Bconfigure option:
(B --with-charset=ucs2 \
(B --with-extra-chasets=all \
(Bdefine to /etc/my.cnf by ucs2.
(B [mysqld]
(B default-character-set=ucs2
(B
On Wed, Jun 11, 2003 at 10:08:47AM +0500, Sohail Hasan wrote:
> Hi there,
>
> How can I see per table size of all tables in a particular database.
SHOW TABLE STATUS
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.
Hi there,
How can I see per table size of all tables in a particular database.
Sohail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Wed, Jun 11, 2003 at 12:22:58PM +0800, Kaming wrote:
>
> Jeremy Zawodny wrote:
>
> > On Tue, Jun 10, 2003 at 07:37:19PM +0800, Kaming wrote:
> > >
> > > Then after the checking, the table seems being fixed and then I start
> > > the MySQL again. I can run query in that table after that. Then s
Hi Jeremy,
here is the value when I typed 'ulimit -a'.
core file size (blocks) unlimited
data seg size (kbytes) 524288
file size (blocks) unlimited
max locked memory (kbytes) unlimited
max memory size (kbytes)unlimited
open files 32768
pipe size (512 bytes)
At 11:54 +0800 6/11/03, William IT wrote:
I do mysqlamin shutdown and copy all /var/lib/mysql file from another MySQL
server. And then run:
chmod -R 660 *
chown -R mysql:mysql *
shutdown now -r
But I can't logon to Mysql. What's wrong?
We don't know.
Did the server start up correctly?
If it did, h
I do mysqlamin shutdown and copy all /var/lib/mysql file from another MySQL
server. And then run:
chmod -R 660 *
chown -R mysql:mysql *
shutdown now -r
But I can't logon to Mysql. What's wrong?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:htt
Upgrading to 4.0.13 will allow you to drop foreign keys. The innodb manual has
info:
http://innodb.com/ibman.html
Chris
Joe Gaffney wrote:
Can someone help with trying to remove a foreign key constraint from a
table. Each time I run the alter table statement to drop the foreign key I
get the f
Hi Victoria, Heikki, List members
From another thread "Re: Foreign Key in Innodb and Index Usages" I found this:
>Both tables have to be InnoDB type and there must be
>an index where the foreign key and the referenced key
>are listed as the FIRST columns.
an tried to do it in another way f.e
m
>I started troubleshooting the code and discovered the
>problem was the
>new
>register globals which is defaulted to off in PHP
4.22. >The PHP
>wasn't
>holding session and wasn't inserting the records into
>the mySQL
>database.
>I got it working now by switching the register
globals >back to
Hi Victoria,
I believe that the User column is indexed (please see below):
show index from user;
+---++--+--+-+---+-+--++--++-+
| Table | Non_unique | Key_name | Seq_in_index | Column_name
Hi Joe,
Yup, thats what it means.
I try to make some - what I believe will be useful - documents extracting the
info from this mailing list responses. So far it looks more like a
construction place but you are free to browse at my site:
http://www.knowd.co.jp/staff/nils
Best regards
Nils Va
Hey Nils:
So that means exporting the data first, then dropping the table, recreating the new
table without the foreign key and then finally re-importing the data. Does that sound
about right?
Thanks,
Joe
-Original Message-
From: Nils Valentin [mailto:[EMAIL PROTECTED]
Sent: Tuesda
I just migeate from MS SQL to MySQL but have problem on "Cascade Update".
Suppose I have BOOK and LIST_TYPE tables like this:
BOOK, field: Book_Name, Book_Type
LIST_TYPE, field: Book_Type
If I already define Cascade Update between BOOK and LIST_TYPE, then when I update the
content of Book_Type (
HiJoe,
thats not supported yet. You will have to recreate the table to remove the
foreign key.
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 11日 水曜日 10:13、Joe Gaffney さんは書きました:
> Can someone help with trying to remove a foreign key constraint from a
> table. Each time I run the alter table
Hi all,
By default, data dir is located at /var/lib/mysql. I have run mysql
for serveral month with data in that path. Now, I want to move all
database data to another path, say /var2/lib/mysql. What is the
suitable purpose to do it? Is it only shutdown mysql and move all data
file from /var
Is it possible to dump an XML file into a database? Can you do the reverse
of
mysqldump X dbname¹
???
R/Tim
Can someone help with trying to remove a foreign key constraint from a
table. Each time I run the alter table statement to drop the foreign key I
get the following error:
Error Code : 1005
Can't create table
Here is the table structure and the alter table statement I am executing:
ALTER TABLE c
Hi Dan,
I wanted to comment on the comparison between the scsi cards - plase see
below.
2003年 6月 10日 火曜日 16:55、Jeremy Zawodny さんは書きました:
> On Mon, Jun 09, 2003 at 05:27:00PM -0700, Dan Edwards wrote:
> > > Can you grab the output of 'vmstat' or iostat or something that'll
> > > measure disk I/O n
I have three boxes. Mysqlhotcopy works on box1, but it generates a
segmentation fault on box2 and box3. I want it to work on all boxes.
I am prepared to upgrade them all to the level of box3 (but
mysqlhotcopy doesn't work with that configuration). Does anyone know
of a solution?
Box 1: Debian
At 11:39 -0400 6/10/03, Peter J. Milanese wrote:
subselects were slated for release with 5.0 Not 4.1
P
The earliest that subselects were planned for that I know of was
3.23. Then 3.24 (during 3.23 development). 3.24 got renamed to
4.0 (I guess), and subselects didn't appear there, either. :-)
No
On Tue, Jun 10, 2003 at 12:33:10PM -0600, Mike Hillyer wrote:
> I think the other thing to remember is that this is only the Core exam,
> and as far as I can tell a fair amount of the content you suggest will
> be part of the Pro exam. I remember once seeing stirrings of a DBA exam
> as well, so I
Hi,
If you want this to run faster, you can use the 'truncate table' syntax as
explained here:
http://www.mysql.com/doc/en/TRUNCATE.html
Cheers,
Andrew
-Original Message-
From: Roger [mailto:[EMAIL PROTECTED]
Sent: Tuesday 10 June 2003 23:01
To: Fabio Bernardo
Cc: [EMAIL PROTECTED]
S
Alex,
- Original Message -
From: ""Alex Behrens"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Wednesday, June 11, 2003 12:57 AM
Subject: Install on RH9
> Hey All,
>
> Sorry I'm very new to the linux environment and I just recently installed
> RH9 that comes bundled with
Carsten Pedersen wrote:
Quick words of introduction before you read on: I'm the MySQL AB
Certification Manager :-)
Glad to meet you!
Balance: A good exam will test both skill AND knowledge -- knowing how
to change the table type from MyISAM to InnoDB is knowledge -- realizing
when and why to do i
I installed from the BSDOS distribution.
However, with the upgrade, nysql may not be seeing the Databases.
Why?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Try:
delete from 'tablename';
Around Tue,Jun 10 2003, at 06:32, Fabio Bernardo, wrote:
> Hi there, Im a new user
> Whats the statemant to empty a table... I mean
> I dont wanna delete one or two rows ...and not drop the table, i just wanna
> empty it... i tried something like: empty tabl
Mike Hillyer wrote:
I think the other thing to remember is that this is only the Core exam,
and as far as I can tell a fair amount of the content you suggest will
be part of the Pro exam.
Fair enough. But that leaves the issue of exactly what is appropriate
to test in the Core exam.
The problem
http://www.mysql.com/truncate
- Rich
From: Fabio Bernardo <[EMAIL PROTECTED]>
To: "Mysql (E-mail)" <[EMAIL PROTECTED]>
Subject: empty a table
Date: Tue, 10 Jun 2003 18:32:57 -0300
Hi there, Im a new user
Whats the statemant to empty a table... I mean
I dont wanna delete one or two rows ..
Try TRUNCATE TABLE tablename-->http://www.mysql.com/doc/en/TRUNCATE.html
Or DELETE FROM tablename
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Fabio Bernardo [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 3:33 PM
To: Mysql (E-mail)
Subject: empty a table
Jeremy Zawodny wrote:
On Tue, Jun 10, 2003 at 12:50:04PM -0500, Paul DuBois wrote:
At 7:51 -0700 6/10/03, Jeremy Zawodny wrote:
What's the point of such a question? Anyone with access to MySQL can
find out by simply running the query.
You don't have access to MySQL during the test.
Hey All,
Sorry I'm very new to the linux environment and I just recently installed
RH9 that comes bundled with Mysql 3.23 and I'm having troubles upgrading to
4.0.
When I try to install the latest client and server build it tells me I have
failed dependences for mod_auth_mysql, php_mysql, and per
Hi there, Im a new user
Whats the statemant to empty a table... I mean
I dont wanna delete one or two rows ...and not drop the table, i just wanna
empty it... i tried something like: empty table, but it didnt work...
thanks a lot
Ah - I missed the weighting requirement - forget my last post then...
You could try increasing the "0.1" weighting factor until it gave you the
required result instead..
Cheers,
Andrew
-Original Message-
From: Eric Wagner [mailto:[EMAIL PROTECTED]
Sent: Tuesday 10 June 2003 21:36
To: D
Try this instead...
SELECT val_column, 0.1+RAND() as rand_col from TABLE ORDER BY rand_col limit
10;
Cheers,
A
-Original Message-
From: Eric Wagner [mailto:[EMAIL PROTECTED]
Sent: Tuesday 10 June 2003 21:36
To: Dathan Vance Pattishall; [EMAIL PROTECTED]
Subject: RE: Hmm looks like this
Hello,
Quick words of introduction before you read on: I'm the MySQL AB
Certification Manager :-)
As Mike's comments (below) to a large extent states much of what I was
planning to say when I sat down to write this, I'll keep it short by
adding a few comments to his response.
Yes, there are some
At 9:28 +0100 6/10/03, Martin Waite wrote:
Hi,
I reworked my code so that my parent process opened the
DBI connection after the child was forked, and
everything works fine. So it looks like Robin is right.
The one thing I don't understand just now is how the
parent automatically re-connected to
It depends on what you want to do with the font end. You would always
look at MyCC and SQLyog at
http://www.mysql.com/products/mysqlcc/index.html and
http://www.webyog.com/ respectively.
Regards,
Mike Hillyer
www.vbmysql.com
-Original Message-
From: David Brodbeck [mailto:[EMAIL PROTECTE
Addslashes()
http://us3.php.net/manual/en/function.addslashes.php
-M
-Original Message-
From: Steve Marquez [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 4:28 PM
To: MySQL List; PHP eMail List
Subject: Characters
I am inserting a file via a PHP form. It works great, however, i
Are there any open-source database front-ends that have similar
functionality to MS Access? We're currently using Access with tables
linked
to MySQL, but find it leaves something to be desired when it comes to
stability and license flexibility. We'd really like to move to something
open-source.
I think your query will just return the first 10 values in the table sorted in random
order due to how MySQL handles queries that use ORDER BY and LIMIT:
[from mysql documentation]
If you use LIMIT # with ORDER BY, MySQL will end the sorting as soon as it has found
the first # lines instead of s
Check your PHP installation. Create a PHP file with the following lines
then check te output, which should be a list of all configuration
parameters for PHP and verify that you have mySQL support.
Should be a part something like
mysql
MySQL Support enabled
Active Persistent Links
I am inserting a file via a PHP form. It works great, however, if there is a
word that has quotes in it, then it does not work at all.
Is there a way to make it so that MySQL will receive a word with "quotes?"
Thanks
-Steve Marquez
[EMAIL PROTECTED]
--
MySQL General Mailing List
For list arch
> -Original Message-
> From: MyLists [mailto:[EMAIL PROTECTED]
> The main thing you should realize right off the bat is that
> Access gives you
> a lot of functionality with buttons and other controls and
> they are quite
> easy to control with macros and/or VBA. However, depending on
You have to have the mysql libraries installed, not the server.
Your PHP does not have mysql support installed.
Sparky Kopetzky wrote:
Good afternoon!
I have Apache w/php installed on one server. I have mysql installed on a windows machine. I keep getting this error
'Call to undefined function:
Assuming you have the proper permissions (which could get confusing), I suppose
it could be done. So, I'll follow up with one of my most frequent responses:
why don't you try it and then let us know?
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Fabi
I want rows with a higher value to show up more often then rows with a
lower value in a column. The constraint is I do not want to have
multiple rows representing the same record. It's easy to solve with say
100 rows verses 30 rows using just RAND: but doing it the way I have
below might achieve t
Good afternoon!
I have Apache w/php installed on one server. I have mysql installed on a windows
machine. I keep getting this error
'Call to undefined function: mysql_connect()' in my php script. Now, according to what
the Redhat RPM is telling me about php-mysql is that I have to have mysql RU
At 16:08 -0300 6/10/03, Fabio Bernardo wrote:
Hi there, Anyone knows if is possible to make a Select command between 2
tables located in differents computers.. I wanna only one statament
I mean..
I have the host named A, database dbA and table tbl_A...
and I have the host named D, databse dbB and t
Some of the best/hardest test I have taken are over at brainbench.com.
They have some free tests and some sample exams that are also free (you
do have to register). The tests are extensive and really test your
breadth of knowledge in a particular area. For instance, I was born and
raised in the
In the last episode (Jun 10), Mojtaba Faridzad said:
> Thanks Mike and Dan. The link explained everything. but why the
> manual which had been installed on my computer ( by downloading and
> installing mysql 4.0) is not as complete as the website? anyways, I
> will look into mysql online document i
Hi there, Anyone knows if is possible to make a Select command between 2
tables located in differents computers.. I wanna only one statament
I mean..
I have the host named A, database dbA and table tbl_A...
and I have the host named D, databse dbB and table tbl_B...
I would like to write a comand
I will let others give their opinions on which one is best, but it is
important to point out that you are not making a one-or-the-other
decision. One of the advantages of using MySQL is that you can choose
the right table handler on a table-by-table basis. This means that you
can have sales and inv
Hi,
I need your experience to help me which table type it's better. I am going
to define my database with more than 100 tables and some tables have more
than 200,000 records. I know that InnoDB has some advantages against MyISAM
such as transactions or foreign keys. But I am not sure that these se
What's your end goal, and for what do you need/desire a "weighted random?" Your
objective will determine if this is actually of use or if it simply appears to
be.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Dathan Vance Pattishall" <[EMAIL PROTECTE
I think the other thing to remember is that this is only the Core exam,
and as far as I can tell a fair amount of the content you suggest will
be part of the Pro exam. I remember once seeing stirrings of a DBA exam
as well, so I guess the Core is just to get your feet wet and show a
knowledge of th
I have recently just changed hosting companies.
It is a shared hosting server using ensim webappliance pro.
This problem keeps happening. Mysql will work for half an hour and then
go down. My admin has confirmed that another site had problems in the
script and was blocking everyone.
I understran
At 13:53 -0400 6/10/03, Mojtaba Faridzad wrote:
Thanks Mike and Dan. The link explained everything. but why the manual which
had been installed on my computer ( by downloading and installing mysql 4.0)
is not as complete as the website? anyways, I will look into mysql online
document instead of the
there's a pretty good comparison on the MySQL website and they were quite
fair about it. MySQL has been adding features slowly because, above all,
they don't want to sacrifice performance for the feature. Each database
has its strengths. The bottom line is that you need to figure out just
w
On Tue, Jun 10, 2003 at 12:50:04PM -0500, Paul DuBois wrote:
> At 7:51 -0700 6/10/03, Jeremy Zawodny wrote:
> >On Tue, Jun 10, 2003 at 12:03:51PM +0200, rich johnson wrote:
> >> Has anyone else tried this? I got 8/10. Going to the exam next week;
> >> I suppose that's a good sign :-)
> >>
> >> h
I have a question. If I wanted to sort randomly on a column weighted by
the value of the column will does this query work
SELECT val_column, val_column*0.1+RAND() as rand_col from TABLE ORDER BY
rand_col limit 10;
This should five me a random row weighted by the value of the column is
this corr
Paul DuBois wrote:
At 7:51 -0700 6/10/03, Jeremy Zawodny wrote:
"Is this syntax valid in MySQL?"
[some query]
What's the point of such a question? Anyone with access to MySQL can
find out by simply running the query.
You don't have access to MySQL during the test. You have to know
whether
:-) I think the first issue is to make sure that the server is running.
Typically the 'sock' file issue will solve itself if the server is running.
-Original Message-
From: Ernesto Silva [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 10, 2003 12:38 AM
To: [EMAIL PROTECTED]
Subject: Re: Ne
> Hi,
> I am using MySQL Connector/J JDBC Driver to support the=20
> ResultSet.CONCUR_UPDATABLE. I am using J2sdk 1.4 Tomcat 4.1.1 with =
> MySQL:
>
> I am using a jsp file to use the Driver. After running the JSP file =
> following Error has been generated.=20
> org.apache.jasper.JasperException:
Thanks Mike and Dan. The link explained everything. but why the manual which
had been installed on my computer ( by downloading and installing mysql 4.0)
is not as complete as the website? anyways, I will look into mysql online
document instead of the downloaded manual. Thanks again.
- Origina
At 7:51 -0700 6/10/03, Jeremy Zawodny wrote:
On Tue, Jun 10, 2003 at 12:03:51PM +0200, rich johnson wrote:
Has anyone else tried this? I got 8/10. Going to the exam next week;
I suppose that's a good sign :-)
http://www.mysql.com/certification/selftest/core/index.php
I don't know if we all get t
How big is the imge file?
How do you check the contents of the table?
How are you determining that it is null?
Did you try to select the column into an outfile?
If so, how big was the outfile?
Titu Kim wrote:
Yes, the image file is on the server and i already
chown and chrgp to mysql for this file
In the last episode (Jun 10), Mojtaba Faridzad said:
> I defined a field as INT type but when I checked in phpMyAdmin, it showed
> INT(11). Still I cannot enter higher 2147483647 (signed int) in this field.
> Does 11 mean that MySQL needs 11 bytes to keep it? I changed the length to
> 2 (for examp
You will have to write a program to read your text files and
insert/update the appropriate records.
Fernando Gerent wrote:
Hi everybody,
I need to use the Load Data Infile to insert different columns from different files in
a table, but I can't figure out how to keep the number of rows, like
f
The 11 is the display width and does not affect the size of values that
can be stored in the column. Here is a quote from
http://www.mysql.com/doc/en/Numeric_types.html:
--BEGIN QUOTE--
As an extension to the ANSI/ISO SQL92 standard, MySQL also supports the
integer types TINYINT, MEDIUMIN
Hi,
I defined a field as INT type but when I checked in phpMyAdmin, it showed
INT(11). Still I cannot enter higher 2147483647 (signed int) in this field.
Does 11 mean that MySQL needs 11 bytes to keep it? I changed the length to
2 (for example) but still I could save higher values such as 999 in
Sure, I have attached both the forms page and the page action page.
-Steve
> Hi
>
> can you post the form/php code
>
> Peter
>
> -Original Message-
> From: Steve Marquez [mailto:[EMAIL PROTECTED]
> Sent: 10 June 2003 14:26
> To: MySQL List
> Subject: Column or Table issue
>
>
> I am
Yes, the image file is on the server and i already
chown and chrgp to mysql for this file. Still the data
is null in the table.
--- gerald_clark <[EMAIL PROTECTED]>
wrote:
>
>
> Titu Kim wrote:
>
> >Hi,
> >I am trying to insert an image directly from
> >command line into mysql table. My ta
At 11:00 +0200 6/10/03, rich johnson wrote:
Hi List,
This is my first mail in this list and thanks in advance.
Does anyone know what version of Mysql has Unicode support for full text
searching? I have a database with information in four languages
(english, german, greek and spanish) in unicode and
Todd Gruben <[EMAIL PROTECTED]> wrote:
> how do your set the index type in 4.1? My tables still appear to hash
> indexes.
Here is an example:
CREATE TABLE t1 (
a INT NOT NULL,
b INT NOT NULL,
PRIMARY KEY USING BTREE (a)
) TYPE=HEAP;
--
For technical support contracts, goto https://order.mysq
I install mysql4.0.13 on windowsXP by using the installation wizard.
Next I start mysql using NET START mysql, then I try to change my root
password 'mysqladmin -u root password "foobarke". Try to login with the
new root passwd I get error access denied. But I can login as root using
nothing as
subselects were slated for release with 5.0 Not 4.1
P
Jeremy Zawodny <[EMAIL PROTECTED]>
06/10/2003 11:21 AM
Please respond to mysql
To: "Peter J. Milanese" <[EMAIL PROTECTED]>
cc: Kaarel <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
Subject:Re: Which datab
MySQL has the backing of many large corporations (for which MySQL was
initially written). MySQL
support/userbase will not go away that easily. They have a plan for
enhancements. They
accomplish these enhancements ahead of schedule.
This is how I translate 'lack of commercial support company m
how do your set the index type in 4.1? My tables still appear to hash
indexes.
-Todd
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
On Tue, Jun 10, 2003 at 10:54:52AM -0400, Peter J. Milanese wrote:
> Hey Kaarel-
>
> I've been sticking with MySQL mostly for it's support. Large
> community, lots of documentation, and they have a future plan (which
> they tend to actually complete ahead of schedule).
Wow. You must be the first
On Tue, Jun 10, 2003 at 02:45:42PM +0200, Roberto Barbieri wrote:
> Hello to all,
>
> I'm requested to build an HA cluster for a mysql master server
> which is running on a redhat 8.0 box .
> Does anyone have done this before?
>
> I've though to use lvs or openmosix as clustering software.
They
On Tue, Jun 10, 2003 at 07:37:19PM +0800, Kaming wrote:
>
> Then after the checking, the table seems being fixed and then I start
> the MySQL again. I can run query in that table after that. Then suddenly
> I saw this error message keeps coming in the mysqld.log
>
> Error Message:
> Out of memory
Hi Rich, Jeremy,, Mysql List
2003年 6月 10日 火曜日 23:51、Jeremy Zawodny さんは書きました:
> On Tue, Jun 10, 2003 at 12:03:51PM +0200, rich johnson wrote:
> > Has anyone else tried this? I got 8/10. Going to the exam next week;
> > I suppose that's a good sign :-)
> >
> > http://www.mysql.com/certification/self
Hey Kaarel-
I've been sticking with MySQL mostly for it's support. Large
community, lots of documentation, and they have a future plan (which they
tend to actually complete ahead of schedule). While the featureset is
'supposedly' not as advanced as pgsql, mysql does in fact work. I hit
On Tue, Jun 10, 2003 at 12:03:51PM +0200, rich johnson wrote:
> Has anyone else tried this? I got 8/10. Going to the exam next week;
> I suppose that's a good sign :-)
>
> http://www.mysql.com/certification/selftest/core/index.php
I don't know if we all get the same questions, but I was disappoin
Without seeing your code, it's hard to gauge what the problem is, but my guess
is that your insert statement in missing a VALUES field (or one has been
transposed). If data types don't match up, this will cause your query to fall
on its face, just as it seems to be doing.
Edward Dudlik
Becoming D
Hi everybody,
I need to use the Load Data Infile to insert different columns from different files in
a table, but I can't figure out how to keep the number of rows, like
for example, if I have a table for people's names, ages and phone numbers, and each of
these information is in a different txt
smaller userbase and no commercial support *combined* mean fewer sources of
support. With MySql, support from this *superb* MySQL list :) and MySql AB
is likely to be better than Postgres support.
Open source support (free or paid for) in general seems to be better than
closed source equivalents
Hi Victoria,
2003年 6月 10日 火曜日 19:16、Victoria Reznichenko さんは書きました:
> "Nils Valentin" <[EMAIL PROTECTED]> wrote:
> > I try to create foreign keys in a innodb database. I read through some
> > threats and the manual, and several online resources, but somehow I am
> > missing something.
> >
> > What
Hello,
I have 140 fields in a HTML survey form that needs to be passed into a
MYSQL database. I am using php script in the HTML form to send the data
to the database. I have successfully been able to insert data from the
HTML form into the database with about 20 fields or so. When I use the
bigger
Hi
can you post the form/php code
Peter
-Original Message-
From: Steve Marquez [mailto:[EMAIL PROTECTED]
Sent: 10 June 2003 14:26
To: MySQL List
Subject: Column or Table issue
I am attempting to insert an article into a MySQL table on a remote server,
via a PHP Forms script.
I am able
Check out make sure you're properly encoding the string. You likely need to use
addslashes() and htmlspecialchars(), possibly htmlentities() as well.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Steve Marquez" <[EMAIL PROTECTED]>
To: "MySQL List" <[
# [EMAIL PROTECTED] / 2003-06-10 14:11:39 +0100:
> (...) lack of commercial support company means you are unlikely to get
> the same level of support.
unlikely? perhaps. but...
how many OS programs do you use, how many of them have commercial
support, and how do those that have co
1 - 100 of 152 matches
Mail list logo
