Good morning to all
My problem is about the replica.
I have 4 servers all running on NT4 sp6a; 1 master and 3 slave.
>From yesterday in the MASTER server I see a "system user" where the state
is WAITING TO RECONNECT AFTER A FAILED READ and in the mysql.err file I
see:
MySql: ready for connection
i did create those databases in different databases directories.
i saw there r columns_priv, db, host, tables_priv and user tables in the
mySQL database directory. Is all these tables control the user data access ?
and how ?
> grant privileges to users on table only within a specific database.
ca
Andrew,
could Jon Frisby's datadiff
http://freshmeat.net/projects/datadiff/?topic_id=66%2C822%2C836%2C861
help here?
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on In
Hi,
Read a blob field (containing any kind of data) from the database is easy.
You have to do the same thing as in case of other field types. And if you
use TBlobField field type (or dynamic typecast), this field type has a
.SaveToStream (.SaveToFile) method. You can use this to save the data t
Hi,
I would like to know how to store binary data as images, sounds, Rich Text
Format, pdf-files, as BLOB in MySQL. (from
Delphi).
Sincerely,
Adrian Tarniceru
---
Xnet scaneaza automat toate mesajele impotriva virusilor folosind RAV Anti
Hello,
I have a multi-threaded application written in Delphi and I am having a
mysterious problem. There are 4 threads that write to several MySQL
tables, but I am seeing what looks to be some type of deadly embrace
that I dont know how to resolve.
Each thread has a separate database connect
You can create separate databases (database directories) and then grant
privileges to users on table only within a specific database.
So if you have a separate database (create database is the syntax to
create a new database), you can do that.
Bhavin.
- Original Message -
From: "Alice Ta
Hi, all,
I am now using MySQL with MySQL Front, where i knew that it can access
ALL
the databases that store remotely.
My company is doing hosting services. And we are using MySQL as
our database system. Currently, we have our own databases + customer's
databases
store in our hosting serv
Hello all, I wonder if you can help me?
Background:
I have two databases (on different machines).
I have a requirement to move to having multiple slaves to do the queries
involved, at the moment we have data on both machines and our apps choose
the machine that has the necessary data to satisfy th
What would cause the MySQL server to just shutdown, apparently on its own?
This server is running on a Linux (RH 7.3) (Dell) box with 512mb RAM and a
SCSI RAID array. The MySQL version is 3.23.53, installed from RPM's. The
RPM's were downloaded from a MySQL mirror (did not install the versions on
I knew i was doing something stupid :p
I did actually look through the documentation but i had no luck. I also
have a MySQL book (Core MySQL by Leon Atkinson) but I couldn't find
anything in there to help me.
Thanks for your help.
On Thu, 2002-11-28 at 05:06, Keith C. Ivey wrote:
> On 28 Nov 2002
Here's the question, as succinctly as I can formulate it:
The documentation seems to say that one can load a tab-delimited text
file located in the current directory of the client host into a
database by running the client mysql and executing the following
command:
mysql> LOAD DATA LOCA
You cannot get a BLOB back in one piece. I wrote an article at
www.dynamergy.com/mike/blobaccessvb.html that describes how to use the
adodb.stream object to access MySQL BLOB data through VB.
Mike Hillyer
-Original Message-
From: Lalit Chandwani [mailto:[EMAIL PROTECTED]]
Sent: Wednesday
On Wed, Nov 27, 2002 at 01:26:42PM +0100, [EMAIL PROTECTED] wrote:
>
> Anyone knows the reason of this disk usage of innoDB (it's 2 time
> bigger than myISAM)
InnoDB has larger per-record overhead (row headers and such).
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAI
you won't get a large blob back in one piece. to
retrieve blobs, you need to use the getchunk
method.
refer to getchunk in the vb documentation. it
also has an excellent example.
> i am using vb,ado,myodbc,mysql
>
> i have some values in longblob,mblob fields
>
> when i read it with ad
On Wed, Nov 27, 2002 at 03:04:25PM -0800, Steven Roussey wrote:
>
> Does InnoDB support ALTER TABLE ... ORDER BY ...?
No.
> If it weren't for this command, we would never get the continuous
> great performance we get from MySQL. And it keeps us from ever
> really considering InnoDB. :(
Records i
> I need help. I am building a database for a small college that wants to be
> able to update their program information for each department through an
> web/gui program.
>
> I've decided to use, MYSQL, Apache, PHP and FreeBSD as the OS. (I built my
> web page this way)
>
> Here's my QUESTION! Bec
I use the binary from :
http://www.entropy.ch/software/macosx/
Christophe
On Wed, Nov 27, 2002 at 12:35:45PM -0800, Chris Herold wrote:
> i'm trying to install MySQL 3.23.53 on OS X.
>
> It seemed pretty easy as i followed the directions on the devshed
> website, but when i to "make" (for th
On Wed, 27 Nov 2002 07:56:42 -0800, Todd Cary wrote:
>Most of my experience has envolved writing a front end in Delphi
>and using ODBC
I just wrote a short program in Delphi (using MyODBC) to pull
information from an Access MDB and update a MySQL table. Worked fine.
Uploading from the d
Does InnoDB support ALTER TABLE ... ORDER BY ...? If it weren't for this
command, we would never get the continuous great performance we get from
MySQL. And it keeps us from ever really considering InnoDB. :(
Sincerely,
Steven Roussey
http://Network54.com/
I've recently started to use accented characters in MySQL--
nothing extremely fancy, just the usual things in the
ISO-8859-1 character set, mainly just the vowels with acute,
grave, circumflex, and umlauts.
Originally, everything was working fine; things got entered
correctly, and I could search
where member='me ' is not the same as where member='me' ('me ' != 'me')
I've noticed this as well with just about any mysql version, on any
platform.
The tables / columns really isn't important here IMHO... From what I can
see, trailing spaces are always droped, which shouldn't be.
- O
Thanks!
>
> >From http://www.mysql.com/doc/en/Bugs.html:
>
> * All string columns, except BLOB and TEXT columns, automatically
>have all trailing spaces removed when retrieved. For CHAR types
>this is okay, and may be regarded as a feature according to ANSI
>SQL92.
Thanks you very much for all your suggestions. I really appreciate it.
Grant Cooper
- Original Message -
From: "Matthew Baranowski" <[EMAIL PROTECTED]>
To: "Grant Cooper" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Wednesday, November 27, 2002 9:23 AM
Subject: Re: Data base driven web
Ach. I was misreading the original message the entire time.
The reason you see the behavior below for the second query is that
the comparisons are done without regard for trailing spaces.
If you change the column type to TEXT, the second query will
return nothing. (On the other hand, another ef
Tim,
[returned the conversation to the list, so that others may benefit]
> Right now in the config.inc.php file i have it set as:
>
> ### MySQL data
> $mysql_host = "localhost"; // localhost name
> (usually:localhost)
> $mysql_user = "mine"; // MySQL username
> $mysql_pass = "mine2"; // MySQL pass
mysql> select LENGTH(contact) from options where member='me ';
+-+
| LENGTH(contact) |
+-+
| 2 |
+-+
1 row in set (0.01 sec)
On Wed, Nov 27, 2002 at 03:36:03PM -0600, Paul DuBois wrote:
> At 15:06 -0600 11/27/02, [EMAIL PROTECTED] wrot
In the last episode (Nov 27), [EMAIL PROTECTED] said:
> Why? (Note the extra space after "me" in the second select)
>
> Your MySQL connection id is 6021 to server version: 3.23.41-log
>
> mysql> select contact from options where member='me';
> +-+
> | contact |
> +-+
> | me |
At 19:10 27/11/2002 -0200, Marco Querini wrote:
Hi,
When you install MySQL in another directory than the default
C:\mysql, you need to create the c:\winnt\my.ini file and to
edit the variables:
[mysqld]
basedir=d:/mysql #for example
datadir=d:/mysql/data #for example
Dear Sirs,
I installed th
On Wed, Nov 27, 2002 at 09:39:52PM +0100, Benjamin Pflugmann wrote:
> 5. Another hybrid: Do not create the cache pages yourself. Simply
>build the back-end as in solution 1. and put a caching proxy
>(e.g. squid) before it. The main drawback in comparison with.
>Depending on proxy, may
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi,
MySQL 4.0.5, a new version of the world's most popular Open Source Database,
has been released. It is now available in source and binary form for a number
of platforms from our download pages at http://www.mysql.com/downloads/ and
mirror sites.
T
On 11/27/02 1:24 PM, "Tim V" <[EMAIL PROTECTED]> wrote:
> I am trying to create a new db in phpmyadmin with
> MySQL 3.23.53a running on localhost.
>
>
> SQL-query :
>
> CREATE DATABASE `` gulf ``
>
> MySQL said:
>
>
> You have an error in your SQL syntax near 'gulf``' at
> line 1
>
>
>
At 15:06 -0600 11/27/02, [EMAIL PROTECTED] wrote:
member varchar(16) NOT NULL default '',
PRIMARY KEY (member),
Huh. That is weird, then. What does LENGTH(contact) return?
On Wed, Nov 27, 2002 at 03:28:15PM -0600, Paul DuBois wrote:
At 14:48 -0600 11/27/02, [EMAIL PROTECTED] wrote:
>Wh
member varchar(16) NOT NULL default '',
PRIMARY KEY (member),
On Wed, Nov 27, 2002 at 03:28:15PM -0600, Paul DuBois wrote:
> At 14:48 -0600 11/27/02, [EMAIL PROTECTED] wrote:
> >Why? (Note the extra space after "me" in the second select)
>
> Hardly enough information to go on. Apparently you'r
At 14:48 -0600 11/27/02, [EMAIL PROTECTED] wrote:
Why? (Note the extra space after "me" in the second select)
Hardly enough information to go on. Apparently you're using a
column type like BLOB or TEXT for which trailing spaces are not
removed?
Your MySQL connection id is 6021 to server vers
I am trying to create a new db in phpmyadmin with
MySQL 3.23.53a running on localhost.
SQL-query :
CREATE DATABASE `` gulf ``
MySQL said:
You have an error in your SQL syntax near 'gulf``' at
line 1
Why am i getting this?
__
Do you Yah
Why? (Note the extra space after "me" in the second select)
Your MySQL connection id is 6021 to server version: 3.23.41-log
mysql> select contact from options where member='me';
+-+
| contact |
+-+
| me |
+-+
1 row in set (0.00 sec)
mysql> select contact from option
Hi.
On Wed 2002-11-27 at 12:30:05 -0800, [EMAIL PROTECTED] wrote:
> Hi,
> I am using Slackware distribution of Linux. Someone
> has already installed MySQL binary as well as source
> distribution. I would like to un-install that and
> reinstall. But I already have the webserver running
> where MyS
Dear Sirs,
I installed the Mysql 3.23.51 in my Windows NT 4.0 with service pack 6. The
directory that I used was c:\mysql. After that I saw that the C:\mysql was
to small. I uninstalled using the command mysqld-max-nt --remove and after
that I used the option add/remove program from control panel
Hi.
On Tue 2002-11-26 at 22:38:56 -0800, [EMAIL PROTECTED] wrote:
> I need help. I am building a database for a small college that wants to be
> able to update their program information for each department through an
> web/gui program.
>
> I've decided to use, MYSQL, Apache, PHP and FreeBSD as t
i'm trying to install MySQL 3.23.53 on OS X.
It seemed pretty easy as i followed the directions on the devshed
website, but when i to "make" (for the compile) it all came to a halt.
i have included the entire install session below: from decompressing
the .tar.gz file, to the completion of the
Hi,
I am using Slackware distribution of Linux. Someone
has already installed MySQL binary as well as source
distribution. I would like to un-install that and
reinstall. But I already have the webserver running
where MySQL is the database used. If I un install
MySQL, will I be able to retain the da
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 27 November 2002 16:11, Inbal Ovadia wrote:
> how can i know if my mysql is pro or classic?
By connecting to it using the MySQL client - the server will tell you what
version it is. Example:
> ./bin/mysql
Welcome to the MySQL monitor.
Hi,
I'm getting some very strange (and nerve-wracking) behavior and hope
someone here has some ideas.
The subject says mysql_pconnect, but I get the same problem using
mysql_connect. I'm using PHP 4.2 & MySQL 3.23.44 on Red Hat 7.2
In PHP I have a simple db class that more or less serves as a wr
Dyego,
- Original Message -
From: "Dyego Souza do Carmo" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: "Mysql maillist" <[EMAIL PROTECTED]>
Sent: Wednesday, November 27, 2002 2:44 PM
Subject: constraints and InnoDB
> Hi ! :D
>
>I would like you help me to solve the following proble
I am looking into USE_TLS. But yes, I see that mysql_real_data_home is
not corrupted, only mysql_data_home is.
Thanks for your response.
-- Matt
-Original Message-
From: Heikki Tuuri [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 27, 2002 11:40 AM
To: Matt Solnit; [EMAIL PROTECTE
Matt,
thank you for the bug report.
I do not have C# in my computer. Did I understand correctly the bug does not
appear if you use the Embedded Server Library inside C++?
My first note is that you should define USE_TLS in all MySQL modules, like
Monty instructed a week ago. But I guess that cann
On 28 Nov 2002, at 3:24, Chris Barnes wrote:
> i do
> "lock tables jobs read"
>
> everything seemed ok so then i do
>
> "lock tables mechanics read"
>
> again no errors so i guess it worked..now i'm expecting to have my 2
> tables locked for read only.
In the documentation it says
(http://www
Hi ,
At present I am using phpMyAdmin for my mysql data management
Though it is an excellent front end interface , I feel the interface designed
for multitable select quiries by phpMyAdmin is not very good. It is faster to
write query by hand than generate the query by that interface
I have ta
Hi ,
Thanks for reply
I had earlier downloaded mysql-4.1.1 development branch source code and had
noticed that This bug is also present in 4.1.1 development tree source code
I had downloaded mysql-4.0 development source code as mentioned in mysql
documentation but could not compile it as innodb
Try SQLyog - A Windows based Front End for MySQL.
http://www.webyog.com/sqlyog/download.html
Rgds
Insane
- Original Message -
From: "Natale Babbo" <[EMAIL PROTECTED]>
To: "Massimo Bandinelli" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Wednesday, November 27, 2002 9:27 PM
Subject: Re:
Chris,
Wednesday, November 27, 2002, 6:24:12 PM, you wrote:
CB> I keep getting error 1100 (table [table name(s) was not locked with LOCK
CB> TABLES) but I am definitely locking them with LOCK TABLES...
CB> here's examples of what i'm doing...
CB> i have 2 tables i'm trying to work with...jobs and
Hello John,
Wednesday, November 27, 2002, 7:26:09 PM, you wrote:
JC> So does that mean it is a good or bad way of doing it?
The short answer - depends on ..
The bad way is to give all prvileges for the user that can connect from
any host ('%').
JC> At 06:06 PM 11/27/2002 +0200, you wrote:
>>Joh
I really like SQLyog. You can find it at http://www.webyog.com/
JFernando
** sql **
-Original Message-
From: Massimo Bandinelli [mailto:[EMAIL PROTECTED]]
Sent: November 27, 2002 10:26
To: [EMAIL PROTECTED]
Subject: Graphical client
Does anyone know a good graphical mysql client for wi
Hi Grant:
The answer to your question depends on a lot of details. In most cases, the
solution you have chosen is just fine. The real question you need to answer
is, "Does your solution meet your needs?" If you can answer yes to this
question, your solution is fine.
Your solution gives you a coup
Hi
Postgre might be a better bet, as it supports more of the features you are
looking for.
Peter
---
Excellence in internet and open source software
---
Sunmaia
Birmingham
UK
www.sunmaia.net
tel. 0121-242-147
i am using vb,ado,myodbc,mysql
i have some values in longblob,mblob fields
when i read it with ado , if the data is less than 1o
kb then the field having the value otherwise it shows
the null
for ex.
select image from stumaster where id=12
if the image is of <= 10 kb then it returns value
othe
Is there a way to get data statistics (bytes in/out) per
thread/connection with the MySQL C API? I would be interested in
generating statistics for the amount of transmitted data (over the
network) in my program. Thanks.
-
Before
===
Bug report -- MySQL v4.04b, source distribution
===
Machine specs (build machine and test machine are same machine):
Yes, thank you it helps !
Regards,
Jacek.
> I'm not sure if you've gotton your answer or not yet... (i have 150 more
> mailing list messages to go!)
>
> Try http://www.mysql.com/doc/en/Resetting_permissions.html
>
> On Monday 25 November 2002 06:05 pm, Jacek Mach wrote:
>> Hello,
>>
>> I have
This is the query that was given to me:
SELECT e.*, c.* FROM
correspondence e, certificate c, logins l WHERE
c.void <> 1 AND
c.uid = l.uid AND
l.parent = "wd001" AND
e.invoice_num = c.invoice_num AND
e.to_uid = "wd001" AND
e.actioned= 0
ORDER BY e.message_num
Pretty
I personally prefer MySQL-Front, even though its development has been
suspended. You can get it here:
http://mysqlfront.venturemedia.de/index.php?&act=ST&f=2&t=328
MySQLCC is ok: http://www.mysql.com/downloads/gui-mycc.html
SQLyog seems ok: http://www.webyog.com/sqlyog/index.html
As to connecting
On Wed, Nov 27, 2002 at 04:26:21PM +0100, Massimo Bandinelli wrote:
> Does anyone know a good graphical mysql client for windows and linux?
If you have a webserver with PHP, I'd highly recommend phpMyAdmin.
--
Michael T. Babcock
CTO, FibreSpeed Ltd. (Hosting, Security, Consultation, Database
Hi,
I keep getting error 1100 (table [table name(s) was not locked with LOCK
TABLES) but I am definitely locking them with LOCK TABLES...
here's examples of what i'm doing...
i have 2 tables i'm trying to work with...jobs and mechanics
i do
"lock tables jobs read"
everything seemed ok so then i
John,
Wednesday, November 27, 2002, 2:50:09 PM, you wrote:
JC> This is what my users look like:
JC> Host Users PasswordPrivileges
JC> localhost administratoryes has all priv.
JC> localhost root yes has all pr
MarkH,
Wednesday, November 27, 2002, 2:18:24 PM, you wrote:
MaAdn> I need to create a database with tables that can contain either Russian or
MaAdn> Latin1 characters.
MaAdn> Is it right that version 3.23.53 does not support Unicode?
Yes.
MaAdn> If so, how can I
MaAdn> get around this problem
ajitdixit,
Wednesday, November 27, 2002, 7:04:51 AM, you wrote:
aasdcdi> Result for Show Grants is as under
aasdcdi> SQL result
aasdcdi> Host: localhost
aasdcdi> SQL-query: SHOW GRANTS FOR aldixit@localhost;
aasdcdi> Grants for aldixit@localhost
aasdcdi> GRANT CREATE TEMPORARY TABLES, LOCK TAB
charitha,
Wednesday, November 27, 2002, 7:40:07 AM, you wrote:
c> In mysql tables if i want to exclude some tables to do myisamchk how can i
c> do that.
c> As if i use myisamchk *.MYI it is taking too much time to check all the
c> tables. For that i can exclude some previous days dynamic table
check mysql site at
http://www.mysql.com/downloads/index.html
Bye
--- Massimo Bandinelli
<[EMAIL PROTECTED]> ha scritto: > Does
anyone know a good graphical mysql client for
> windows and linux?
>
> Massimo Bandinelli
> System Administrator
> mob +39 335 7324615
> --
Just to contribute our anecdotal experience, we also found a 2x increase
in space required when we converted our MyISAM tables over to InnoDB.
While it was surprising, it wasn't unexpected. We just had to go buy
another 60GB of disk space (luckily we had planned for this). :)
Owen
On Wed, 2002-
I have
created a Web application for a client that uses MySQL for the
DB. Most of my experience has envolved writing a front end in Delphi
and using ODBC to give a client an ability to administer the DB (e.g. do
queries to get lists, etc.). The application is written in PHP and I am
curious what
Does anyone know a good graphical mysql client for windows and linux?
Massimo Bandinelli
System Administrator
mob +39 335 7324615
-
Register.it S.p.A. - Gruppo DADA
tel +39 199 REGIST (+39 199 734478)
fax +39 035 3230312
http://we.register.it
mailto:
ok guyz i need some inside info .
plz help me with:
1. there aint no foreign keys in mysql then what can i do about cascading
updates, deletes and all
2. if i ve to conver a db in foxpro to mysql or sql which one should i
preffer and y
3. and while im converting the foxpro db to
Hi All
how can i know if my mysql is pro or classic?
-
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
Hi,
my name is Ocke Janssen. I'm one the developers of OpenOffice and we
have a little problem.
When we try to get the privileges from MySQL it may happen that the user
hasn't the right to access these. Neither MyODBC nor Connector/J3 can
give us the necessary information we need to allow the u
Thanks for the response!
On Wed, 2002-11-27 at 09:44, Jocelyn Fournier wrote:
> Hi,
>
> MySQL-4.0.5a is compiled again a new patched glibc library, to prevent from
> MySQL having any load issues (which was the case on some systems).
> Features are exactly the same between 4.0.5 and 4.0.5a.
>
> R
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
[EMAIL PROTECTED] wrote:
This problem's similar to one I posted earlier re Russian and English
characters in a database. I'm using the .net MySQLDriverCS driver.
Are you
saying that MySQL tables can hold unicode? If so, how do I set it up
to do
s
For a good choice of Mac sql GUI's, search Google for "mysql gui".
W Johnson
-
This message sent using EMUmail -- http://www.emumail.com
-
Jumping through hoops to get E-mail on the
Hi everyone, I'm trying to setup a mysql base upon a RH7.3 server. The mysql
version is the 3.23.52. I'm trying to re-install it from the sources (as
already did)... Mysql used to run, but i tried to install the perl::dbi and
i did things that might not have done good to the thing... So I decided t
Hi,
MySQL-4.0.5a is compiled again a new patched glibc library, to prevent from
MySQL having any load issues (which was the case on some systems).
Features are exactly the same between 4.0.5 and 4.0.5a.
Regards,
Jocelyn
- Original Message -
From: "Ray Elenteny" <[EMAIL PROTECTED]>
To:
This problem's similar to one I posted earlier re Russian and English
characters in a database. I'm using the .net MySQLDriverCS driver. Are you
saying that MySQL tables can hold unicode? If so, how do I set it up to do
so? If not, how can I store Russian and English characters in MySQL? Will
In 3.23.x versions of MySQL the actual binary log file sizes stayed
fairly consistent. An 'empty' log file for instance on 3.23.53a is 73
bytes. I have a situation where I'm doing a roll-your-own replication
from many sites to one central server where the remote sites are on
everything from dialup
Hi,
I've been trying to determine the difference between MySQL 4.0.5 and
4.0.5a. I can't seem to find any documentation relating to the change.
Can someone point me to the documentation or tell me what has changed?
Thanks,
Ray
-
Never mind, I found the answer to my own question when I got the archive
search engine to respond. (It's *very* slow from here, for some reason --
about 10 minutes per query.) I installed a newer version of the glibc fix
and all is well now.
Sorry for wasting everyone's time.
> -Original Me
On Tue, Nov 26, 2002 at 10:38:56PM -0800, Grant Cooper wrote:
> Here's my QUESTION! Because some of the program information is large I don't
> want to query the data base everytime do I?
Profile it first. You may find MySQL handles the load just fine on the hardware
you're using and you don't ne
I'm having a rather bizarre problem...at least, it seems bizarre to me.
We have a small MySQL database that was running great for about a month.
Last night, I rebooted the system it runs on. Now I can connect locally,
but remote connections fail. The server disconnects during the query and I
get
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ahmed S K Anis wrote:
Hi,
I am using MySql 3.22 on a server with code page set to Japanese.
I am using MM JDBC driver. I insert english and Japanese data into a
few tables, when i query for the data from MySql i get junk
characters in place where
On Wed, 27 Nov 2002 11:53:25 +0200
"Nick Kostirya" <[EMAIL PROTECTED]> wrote:
> Hi, All.
>
> How can I add additional characters (Ukrainian alphabet) to the source
> code
> for parse?
>
> Thanks, Nick.
>
> database,sql,query,table,handler,compile,ChangeSet
>
>
>
Just add a charset.
Tak
Hi,
I am using MySql 3.22 on a server with code page set to Japanese.
I am using MM JDBC driver. I insert english and Japanese data into a few tables, when
i query for the data from MySql i get junk characters in place where Japanese
charaters need to appear. How can i enable MySql for Non engl
>
>Is there a way to create constraints that implements the rules I
>need?
>
Not really. You would have to use deferrable constraints (checked at commit,
not after statement) like in Oracle. For now Innodb doesn't support it.
P.S. query,sql
--
_/_/ _/_/_/ - Rafał Jan
Hejsan MySQL,
Vi sitter med en MySQL-server 3.23. som vi skulle behöva
dokumentation till, men den enda dokumentation jag kan hitta är för
version 4.
Iom. att version 4 börjar skilja sig en del så känns behovet av en
3.23-manual större och större iom. att det kommer att dröja ett tag till
innan v
Is there a website, book, or tips to secure and optimize MYSQL?
This is what my users look like:
Host Users PasswordPrivileges
localhost administratoryes has all priv.
localhost root yes has all priv.
Is thi
Hi ! :D
I would like you help me to solve the following problem:
Suppose the tables below:
create table book
(
Bk_Id integer(4) unsigned not null auto_increment primary key,
Bk_Name varchar(20)
) type = innoDb;
create table page
(
Pg_Id integer(4) unsigned not n
I need to create a database with tables that can contain either Russian or
Latin1 characters.
Is it right that version 3.23.53 does not support Unicode? If so, how can I
get around this problem. Can I create 2 databases one using the Latin1 and
the other using the Russian character set? Indee
Hello all,
I'm using mySQL for many databases, now I want to test innoDB so I have
created another DB (on the same machine) and I have populated it with the
same data of the first DB (via: insert into table_name select * from
db1.table_name);
I have this tables:
tableA: 80.000 recs
tableB, tab
* vinita vigine Murugiah
> I'm using ver 3:23:49 & 3:23:53, I thought
> "A LEFT JOIN B USING (c)" is Identical to "A LEFT JOIN B ON A.c = B.c"
I think it is...
> It seems it is NOT the case if you are joining more that ONE table & one
> of them is EMPTY. Please see the following Example
[...
I have a master/slave setup using MySQL 4.0.5beta on Solaris 2.8. I received the
following error on the slave :-
/usr/local/mysql_4.0.5beta/bin/mysqld: ready for connections
021126 18:48:19 Error in Log_event::read_log_event(): 'Event too big',
data_len=1297040128,event_type=111
Does anybody k
Grant,
> This is correct, only two types of queries. Updating and Deleting.
=deleting is a trivial exercise, whether the data is held in a db or file.
=updating is more of an exercise for the content managers than it is for
you...
> > =Can I assume that the information doesn't change frequentl
> Here's my QUESTION! Because some of the program information is
> large I don't
> want to query the data base everytime do I?
Define large? Are we talking mixed media types (PDF/Word/PowerPoint) or
plain text/HTML? As someone has already suggested, you might be better to
save the files on the d
This is correct, only two types of queries. Updating and Deleting.
> =Can I assume that the information doesn't change frequently?
>
This is correct. The plan is to stream line the web site and get the
information out faster and cut out the red tape. We were thinking intern's
from each department,
1 - 100 of 109 matches
Mail list logo
