msgi "PROD-CAPMSG-opcmsg"enabled1
msgi "PROD-OSSPI-opcmsg" enabled 1
msgi "PROD-OSSPI-procmonMsg" enabled1
msgi "PROD_OSSPI-FilesystemMsg" enabled1
Could you help me
Thx and re
I have opened a bug about this issue: http://bugs.mysql.com/bug.php?id=44914
Joel
On Tue, May 12, 2009 at 10:55 PM, Joel Heenan wrote:
> Mysql List,
>
> I have a crash that has occured a number of times on a production CentOS
> 4.4 machine. It occurs when using a product calle
edir=/var/lib
[mysqld_safe]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
nice = -5
open_files_limit = 8192
[myisamchk]
tmpdir=/home/mysqltmp
key_buffer = 64M
sort_buffer = 64M
read_buffer = 16M
write_buffer = 16M
[mysqldump]
quick
max_allowed_packet = 16M
"""
Thanks
Joel
e
have any suggestions? Am I posting on the correct list to get this
answered? Thanks.
Joel Nimety wrote:
> The default "host" table can possibly have multiple records for a given
> workstation. Presumable the duplicate records are for historical
> purposes, but only one is actually
May 05 13:37:29 EDT 2006
CYB1| 000F20D0272D-453E8A1B-0365-CEED-02D6|
CAL_LAPTOP | Fri Feb 09 09:46:09 EST 2007
CYB1| 00508BE171F3-4587E84F-0540-56B8-003D|
CFWRKSTATION| Tue Feb 06 16:14:03 EST 2007
...
--
Joel Nimety
Product Architect
203.5
place??) to call per-process
initialization and deinitialization routines for UDF's?
- or -
2. Is there another way to do this?
Thanks.
Joel
Does anyone know whether it is possible to override the MySQL connection
variables used in a PHP script? I use Plesk and want it to use a
database that is located on an external server, but I cannot edit the
variables as Plesk is closed source?
Joel Moss
HomepageUniverse.com
--
MySQL General
and came up with the following:
http://www3.ca.com/Solutions/Product.asp?ID=1013
Note that's Computer Associates you would be dealing with on that one.
Mixed in with the links to information about the artist, Jean Auguste
Dominique Ingres, there were other links to potential sources of
informa
s are not carefully used, and I have never seen those problems
when using PHP, but that is less about speed than about programming.)
--
Joel Rees, programmer, Systems Group
Altech Corporation (Alpsgiken), Osaka, Japan
http://www.alpsgiken.co.jp
--
MySQL General Mailing List
For list archi
and
PostGreSQL can be mixed in at will, and ...
--
Joel Rees, programmer, Systems Group
Altech Corporation (Alpsgiken), Osaka, Japan
http://www.alpsgiken.co.jp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
re mysql to use unicode?
Have you looked at section 8 of the MySQL manual?
http://www.mysql.com/doc/en/Charset.html
--
Joel Rees, programmer, Systems Group
Altech Corporation (Alpsgiken), Osaka, Japan
http://www.alpsgiken.co.jp
--
MySQL General Mailing List
For list archives: http://lists.mys
system also has to know
what character set you're going to use. Likewise, you'll have to tell
people's browsers it's Chinese. And if you're using Big-5 with Java,
you'll have to tell Java to convert between Unicode and BIG-5.
HTH
--
Joel Rees, programmer, Systems
ners keep thinking that
\u is a solution for the CJK languages, but that's off-topic.)
--
Joel Rees, programmer, Systems Group
Altech Corporation (Alpsgiken), Osaka, Japan
http://www.alpsgiken.co.jp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/m
ql.com/[EMAIL PROTECTED]
(Hmm. That's changed in the recent month or so.) I assume what you've
tried is the above link?
You should receive a confirmation e-mail, and you need to reply to that.
Did you receive the confirmation e-mail?
--
Joel Rees, programmer, Systems
t;';
$dbh->do($statement) or die "tilt\n";
Upload data from pipe delimited text file. Loads whole table.
LOAD DATA LOCAL INFILE "[path with front slashes] filename.txt" INTO
TABLE tablename
FIELDS TERMINATED BY "|";
Note that some service providers don't
gt; is to blame, but bear it it mind.
Actually, Unicode is much more difficult to handle than the small
character encoding sets. Some slowdown is probably to be expected.
--
Joel Rees, programmer, Kansai Systems Group
Altech Corporation (Alpsgiken), Osaka, Japan
http://www.alpsgiken.co.jp
--
27;t get enough
performance out of PostGreSQL, you should by then have identified what
tables need to be high-performance, and you should be able to use MySQL
for those.
Use all your tools.
--
Joel Rees, programmer, Kansai Systems Group
Altech Corporation (Alpsgiken), Osaka, Japan
http://www.al
> Not sure where these came from, but in my users I've got a [EMAIL PROTECTED] and a
> [EMAIL PROTECTED] Is this redundant, or is there a reason for this?
Well, some people might say it's redundant, but it _is_ by design --
http://www.mysql.com/doc/en/Privileges.html
>
> Todd
I think the word, "package" is the key here.
One would be a traditional unix-ish install, the other would be set up
to install as a package in the Mac OS X definition of a package.
--
Joel Rees, programmer, Kansai Systems Group
Altech Corporation (Alpsgiken), Osaka, Japan
supporting the people who are building your tools.
--
Joel Rees, programmer, Kansai Systems Group
Altech Corporation (Alpsgiken), Osaka, Japan
http://www.alpsgiken.co.jp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
dangerous one, and when
you hear the suits talk about "frictionless economy", tell them to take
their manure generators elsewhere.)
--
Joel Rees, programmer, Kansai Systems Group
Altech Corporation (Alpsgiken), Osaka, Japan
http://www.alpsgiken.co.jp
--
MySQL General Mailing List
ing the script, of
course.
--
Joel Rees, programmer, Kansai Systems Group
Altech Corporation (Alpsgiken), Osaka, Japan
http://www.alpsgiken.co.jp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> Can any one help me?
Hard to tell without more information. Also, since the issues are likely
to be system/CPU dependent, you may need to ask on a netBSD list, as
well.
--
Joel Rees, programmer, Kansai Systems Group
Altech Corporation (Alpsgiken), Osaka, Japan
http://www.alpsgiken.co.jp
nually created was blown away after trying to light
> it up.
Not surprising.
--
Joel Rees, programmer, Kansai Systems Group
Altech Corporation (Alpsgiken), Osaka, Japan
http://www.alpsgiken.co.jp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
cket is supposed to be created in? Do you have a
user for mysqld to run as? What group is mysqld running under? (Etc.)
--
Joel Rees, programmer, Kansai Systems Group
Altech Corporation (Alpsgiken), Osaka, Japan
http://www.alpsgiken.co.jp
--
MySQL General Mailing List
For list archives: http:/
Hello,
What is the level of support for XML in MySQL. Is there any kit similar to the Oracle
XML Developper Kit or the XML features in SQL Server 2000?
--
Joel Amoussou
XML Instructor
IBM XML Certification Practice Test
http://www.xmlmentor.net/xmlexamsim.htm
> At 15:05 +0900 6/12/03, Joel Rees wrote:
> >Paul DuBois advised us that
> >> Alexander Barkov and Peter Gulutzan have written up some documentation
> >> on the new character set support in MySQL 4.1, which has now been added
> >> to the online manual. Y
to be able to get to the data with myphpadmin
> too. But now I know where it is I put the password in. And now I want to
> protect phpmyadmin so that only folks with a username/password can access it.
--
Joel Rees <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archi
to handle latin as if it were single-byte. You
don't get all of the latin sets, though.
--
Joel Rees <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
current for 4.1.1 and some things have changed
> since 4.1.0.
--
Joel Rees <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> 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
. Stretch your terminal window
wide. If that isn't enough, pipe to a file and break out a text editor
that scrolls horizontally as well as vertically.
--
Joel Rees <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
. But, if the entry in the user field is all
> lowercase then, the recordset is returned with the appropriate values.
Sorry to give you a hit-and-run answer, but I think I read something in
the on-line manual about case problems with file names on some OSses.
Might have something to do with i
ntermedia. Hmm. I guess I could look it up.
http://www.google.com/search?hl=en&ie=ISO-8859-1&q=oracle+intermedia
http://www.oracle.com/ip/deploy/database/oracle9i/index.html?cm_imedia.html
Okay, it looks like a set of tools for managing multimedia databases.
Could you explain how
'll know in a day or so when I can check
how the replication is going.
>Submitter-Id:
>Originator:Joel Rowbottom
>Organization:
Fotopic Ltd. www.fotopic.net
>MySQL support: none
>Synopsis: mysqld crashes with signal 11 on replicated slave
>Severity: se
http://www.google.com/search?hl=en&ie=ISO-8859-1&q=encryption+mysql
You might have to dig in a couple of pages, or maybe try a different set
of search keys.
(That's probably not much help, ...)
--
Joel Rees, programmer, Kansai Systems Group
Altech Corporation (Alpsgiken), Osaka, Japan
http://www.alpsgiken.co.jp
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Haven$B!G(Bt been following your thread, but I thought I'd make a stupid
(Bsuggestion ...
(B
(B> At startup, the computer says something about starting a MySQL server.
(B> Could it be that the startup item is still trying to start mysqld even
(B> though it no longer exists and in the proce
t on
> the command line? Could this have something to do with named pipes?
Is localhost folded to the loopback? That seems it might be a little
awkward.
--
Joel Rees <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> I need , obtain the month in spanish, $B%=(Bhow can do it...?
(B>
(B> NOTE: Linux is in spanish , and mysql also.
(B
(BWorst comes to worst, you could always build a small table of the month
(Bnames in Spanish and index the table by the month number.
(B
(B--
(BJoel Rees <[EMAIL P
> ...
> It dawned on me that perhaps the problem had to do with double-byte
> characters,
What language is this text in? Is it by chance a language that does not
use whitespace to delimit words?
--
Joel Rees <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list
otten
about and just can't find in the manual today?
Second, why does it complain about the loopback when I said localhost on
the command line? Could this have something to do with named pipes?
--
Joel Rees <[EMAIL PROTECTED]>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
there.
--
Joel Rees <[EMAIL PROTECTED]>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL
re, but my searching skills seem weak
this week. Anyone know of some good tutorial material on the subject?
(I am not interested in arguments about which is better, by the way. The
requirements of the current project specify that we do both.)
--
Joel Rees <[EM
scussed many times before and since,
of course. My choice of search term wasn't very good, I guess.)
http://marc.theaimsgroup.com/?l=mysql&m=94495471802684&w=2
--
Joel Rees <[EMAIL PROTECTED]>
-
Befor
database with csh,
run ls and get a list of tables, run cat on a table and get a
tab-delimited listing of the contents of the table?
On the surface it didn't seem like such an unreasonable question, ...
--
Joel Rees (thinking distractedly about trying to edit a MySQL table with
vi, amon
Enjoy.
> Joel can I get a copy of that hex convert utility too? I am working on a
> Korean version of mysql yet I currently speak only english. That utility
> would help me gobbs.
>
> -Original Message-----
> From: Joel Rees [mailto:[EMAIL PROTECTED]]
> Sent: Sunday,
Philip Lavine scrawled
> To all,
>
> I can not configure mysql on OS X, using the latest build for that OS.
Oh?
> Thanks
Sure.
(I'm not telepathic. What error messages and/or misbehavior are you
getting during the install?)
--
Joel Rees
; http://www.entropy.ch/software/macosx/mysql/
I was able to install by hand from the instructions in the MySQL docs,
but I am somewhat comfortable with UNIX. Still took me a good piece of a
night, but I needed to know about the stuff going on underneath.
--
Joel Rees <[EMAIL PROTECTED]>
--
more help. I don't use Filemaker myself.
> Before you criticize someone,
> you should walk a mile in their shoes.
> That way, when you criticize them,
> you're a mile away, and you have their shoes.
Yeah, but they probably have your shoes.
;-)
--
Joel Rees <[EMAIL
t your
customer might want to put single or double quotes around something on a
page, and the way it is right now MySQL should be throwing syntax errors
when it gets embedded quotes.
> (The hex value of the backslash is 0x5c, see Joel Rees' previous emails
> for an explanation on how m
k.) They are working on methods for doing this in
MSWindows, but the different user model in MSWindows requires a
different approach than they are using for *NIX.
--
Joel Rees <[EMAIL PROTECTED]>
-
Before posting, ple
How would you set up the database queries to store
those strings?
Say, do you want a little utility program in Java or C that will print
the hexadecimal values of the characters in a string? Basically, it
would be a command-line utility, so you would copy the text and the
> Has anyone created a plugin or script that will allow me to
> convert my filemaker database to MYSQL
Check the archives. There has been some discussion of this in the past.
--
Joel Rees <[EMAIL PROTECTED]>
-
Be
t definitely will fix
the problem with getting your data into MySQL.
But there is something else going on between getting the data out of
MySQL and getting it into your pages. 0x836c somehow morphed to 0x8e4c.
Or was that the other direction? That won't be a topic for the MySQL
list, however.
-
rd is a mess,
it's a hard point to argue right now. But the escape sequence _is_ part
of MySQL's spec.)
> If option 1 were true, then why do the characters show up fine when in a
> static HTML document? (see below).
I want to see that static HTML.
> In Response to
subject come up before on the list, just can't remember
which way the turkey rolled. But your content tool will need to do
something slightly different with the input.
Could you search the archives about escape sequences or the backslash
charac
.
(You should look at the headers you get from some people. It's easy to
understand how a machine could get confused.)
--
Joel Rees <[EMAIL PROTECTED]>
-
Before posting, please check:
http://www.mysql.com/manu
archives today. Probably not enough sleep
last night.)
Oh, yeah:
http://www.google.com/search?hl=en&ie=ISO-8859-1&q=mac+os+x+mysql
--
Joel Rees <[EMAIL PROTECTED]>
-
Before posting, please check:
http:
the OS into either
English or Japanese. (Mac OS X can set the language for the OS at log-in
time, seems like MSW ought to be able to at least switch on boot.)
> Question 3. How do I tell which charset MySQL is using, euc-
James,
I took the liberty of forwarding your requests to
[EMAIL PROTECTED]
I hope you don't mind.
For those who are not familiar with poor James's situation, I offer
(again) these links:
http://home.rica.net/alphae/419coal/
http://www.ksu.edu/InfoTech/news/2002/08-20emailscam.htm
back to MySQL AB. When you start needing answers on a
timely basis, buy the support.
--
Joel Rees <[EMAIL PROTECTED]>
PS: Yes, they are breaking lots of new ground here. The mantra "This is
business software!" has been repeated ad nauseum for longer than you
have been in the busines
amp;w=2
http://marc.theaimsgroup.com/?l=postgresql-general&r=1&w=2
(Some people see MySQL and PostgreSQL as competitors. I've heard from
many who use both as complementary tools.)
http://marc.theaimsgroup.com/?l=ant-user&r=1&w=2
http://marc.theaimsgroup.com/?l=str
r Mac OS X (10.1), I had to mkdir
the socket directory and chown/chmod by hand. I think I also built the
bin structure by hand, as well, don't remember why. You might try that,
just to see.
--
Joel Rees <[EMAIL PROTECTED]>
---
with a search
tool to erase them all.
But there are lots of other ways to get bad dates into records.
--
Joel Rees <[EMAIL PROTECTED]>
sql, query
-
Before posting, please check:
http://www.mysql.com/manual.ph
> How do I uninstall mySQL?
MSWindows or *NIX? Which one?
(And have you searched the archives? I think I've seen this question
answered before, perhaps depending on your OS and version.)
--
Joel Rees <[EMAI
mands
and I don't see such a command. I guess I should see if I can figure out
how hard it would be.
--
Joel Rees <[EMAIL PROTECTED]>
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http
some time, and the necessary files
should be in place. The file you need to edit (or make) for MSWinjunk is
probably C:\WINNT\my.ini. Look over the manual carfully.
--
Joel Rees <[EMAIL PROTECTED]>
Ben Koo inquired
> Dear Sirs,
>
> would you mind to tell me how to add "big5
est to use mysqldump. Unless, of course, you're just curious
to see what happens when bits aren't where the CPU thinks they're
supposed to be.
--
Joel Rees <[EMAIL PROTECTED]>
-
Before posting, please che
> Attn: mysql ,
>
> My name is Mr. Oluwafunmi G, the manager, credit
> and foreign bills of Ecobank Plc. I am writing in
Well, they're getting smart enough to vary the story line a bit now:
http://www.google.com/search?hl=en&ie=ISO-8859-1&q=nigeria+money+laundering+419
http://home.rica.net/alph
7;ve seen it
> called ejis in a MySQL context), and was wondering if anyone can point
> me to information on how to do that with MySQL and PHP.
Have you tried setting the language to Japanese and the encoding to
shift-JIS yet?
to pick up some
oddball cases.
Or, you might consider keeping the Japanese and Korean data in separate
tables on separate servers. From what I understand, that should be possible.
> if you can sugest any other package or addin for this, that would
> also be
>
tmp/mysql.sock' (61)
> >>
> >> What do I need to do, please?
I myself made the directory to store the sockets in by hand. I doubt
that was the right thing to do, but I was able to get mySQL to run,
query the permissions table from the command line, etc.
> >> (Does this li
ering if something like to_ascii() is really going to do what
you want. I'm guessing you would prefer auxilliary fields or tables, but
that is just my guess.
--
Joel Rees <[EMAIL PROTECTED]>
> sql,query,table
-
s on how
consistent the authors were.
Japanese has five vowels, a, i, u, e, and o. People don't usually do
anything strange with the consonants, at least not in the last hundred
years or so.
But that doesn't help for Tibet or Myanmar, of course.
Unicode is helping bring these sorts of
Sven Bentlage asked
> Is there a way to get UTF-8 national characters sets working when you
> only have user access to a database (it's my ISP's)?
Whether you use the my.cnf/my.ini configuration file or the startup
parameter, it's a startup option. You have to have access to one or the
other.
-sets-dir=d:\mysql\share\charsets.
> but when I start the client, It continues to look on
> c:\mysql\\share\charsets.
Hmm. Shot in the dark, but you aren't by any chance trying to put your
my.ini file on your d: drive, are you?
Joel Rees
Alps
installing:
http://www.mysql.com/doc/I/n/Installing_binary.html
http://www.mysql.com/doc/L/i/Linux-RPM.html
Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka
-
Before posting, please check:
http://www.mysql.com/
n and retrieve it
> in tact, so there must be a way...
Lasso -- would mean you're on a Mac? Hmm. Does MySQL have a charset for the
Mac version of extended ASCII? You may find yourself making a charset. (If
so, please share it.)
Check under localization in the manual, section 4.something.
openbsd
packages
> > collection? Is it too old? If not, it will probably be the quickest
> > solution for now.
>
> I'm using openbsd to host a server from home, and the default binary isn't
> configured correctly.
What configurations are you having problems with? Most of the
ained, but aren't really related.
Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka
blasted filter fodder: sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manu
n the list can. I'll this to the list and BCC you, hope you
don't mind. (BCCing you means you'll have to watch the list for answers.)
Thanks for making me look up the charset options for MySQL again. Now maybe
I'll get my machine set up right. ;-)
Joel Re
acter sets
they work with, etc. And we don't even know for sure if you are going to try
to keep English and Japanese together in one database, or if you plan to
separate the databases so you don't have to mess too much with keeping the
browser environments and character encodings and dat
ork for 8-bit character sets. Try it and see. The manual
says you must re-compile to get the new character set recognized.
Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka
-
Before posting, please check:
http://w
Have you read section 4.6 of the
manual? Do you know what parts of the database will store Japanese data,
what parts of stored Japanese data will need to be search and/or sorted,
that sort of thing?
Joel Rees
Alps Giken Kansai Systems Develomen
there a reason you don't want to use the binary in the openbsd packages
collection? Is it too old? If not, it will probably be the quickest solution
for now.
Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka
(Does anyone?)
> 2) several weeks go by without use, forget password to mysql
> 3) cannot remember password, at all
> 4) install mysql over itself, doesn't fix problem
When you forget your password, see the manual about the
"--skip-grant-tables" option. And don't forg
manual page
as above). Or you may just want to use 0 and 1 in a TINYINT field. Depends
on what you need.
I note that with neither SET nor ENUM can you define 'FALSE' as zero.
Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka
> Come on - let me out of my misery as im a P
check the archives.
;)
Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka
- Original Message -
From: "Marcus - Videomoviehouse.com" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, April 03, 2002 11:59 AM
Subject: Is Addition To Previous Post
&
se I have yet to convince the management at my
current shop of the advantages of perl "over PHP or Java". Still have to
show them that it gains more than it costs to have perl as an additional
tool.)
Don't have much time, but if you have some short tasks that might help lay
some gr
ing links:
http://www.filemaker.com/ti/105748.html
http://www.profdata.nl/pdm/generic.jsp?taxonomy_id=5
(I asked in the devoloper discussions area, if anyone's curious.)
Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka
---
DL Neil wrote:
> Various scripting/programming languages will interface to MySQL.
> PHP (and therefore C++) fit into that happy intersection.
_^^^
Perl?
-
Before posting, please check:
http://www.mysql.co
he disk, it is usually best to avoid actual
linked lists in tables.
Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.
orted on Mac OS X, but they seem to indicate
they are working on it. It looks like it supports JDBC, so you may be in
luck if you use Java.
Not much information.
Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka
sql, query
--
ILE Syntax.
http://www.mysql.com/doc/L/O/LOAD_DATA.html
6.4.9 LOAD DATA INFILE Syntax
HTH
Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka
sql, query
-
Before posting, please check:
http://www.mysql.com/manua
make your index (in this case, client ID) so huge
that you don't care if there are gaps. An unsigned INT (instead of
MEDIUMINT) will give you so many keys that it will take over thirteen years
at an average ten new clients per second to overflow.
Joel Rees
Alps Giken Kansai Systems Deve
2. A result of 1 says it's a hit,
0
says it's a miss.
Incidentally, have you considered using a SET type here (manual section
6.2.3.4)?
Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka
-
Before posting,
in a database? that the database software has to either allocate the
maximum width for each variable length field, or use an additional level of
indirection in the indexing?
Just a thought.
Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka
Filter fodder: sql,query
(I thought the filter als
f MySQL, or a separate
instance of MySQL, per the manual, section 4.1.4, "Running Multiple Copies"?
Am I off base thinking this would be appropriate?
(Just a thought.)
Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka
> phpmyadmin (saves using the command line!) to gr
. Or perhaps a server for each party. Again, you would have a
lot of trade-offs to consider.
Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka
-
Before posting, please check:
http://www.mysql.com/manual.php (t
encodable space, allowing all the current additions (Unicode 3.1) in the
first extension plane?
Joel Rees
Alps Giken Kansai Systems Develoment
Suita, Osaka
mysql, tables, select good food
-
Before posting, please check:
http
1 - 100 of 177 matches
Mail list logo
