Hi,
I have a question. I have read that since MySQL 4.1, VARCHAR type can hold
unicode characters. But, it seems that the API of the C library use to send
queries to the server still use 'const char*' for the type of the query.
So, praticaly, if I have a unicode string stored in C, how can I use
Every now and then I am not thking and I am working on the mysql shell and I
send it a
select name from table;
Just so happens there are a few hundred K of records.
What I meant to do is LIMIT 10;
Anyway, how do I get mysql to stop, the best I can do is control-C, but that
leaves mysql
Start another Mysql shell session; then do show processlist; identify
the thread ID of the offending process, then do kill ID. Not sure
how graceful this method is, though. I use it to kill overlooked hanging
connections from time to time.
Cheers,
Vadim.
Scott Haneda wrote:
Every now and
Hi,
I have a question. I have read that since MySQL 4.1, VARCHAR type can hold
unicode characters. But, it seems that the API of the C library use to send
queries to the server still use 'const char*' for the type of the query.
So, praticaly, if I have a unicode string stored in C, how can
Env: Win2003 Server, MySql 4.17
I've the following table
CREATE TABLE TabellaTipi (
id int unsigned NOT NULL AUTO_INCREMENT,
intero int,
lungo bigint,
decimale decimal(20,10),
data datetime,
stringa varchar(100),
booleano tinyint unsigned,
* dan orlic
INSERT INTO cp.Items SELECT distinct g.RecordID as id,'' as
category_id, '' as pattern_id,'' as manufacturer_id, g.Item + g.Desc1
+ g.Desc2 + g.Desc3 as description, g.Desc4 as price,0 as quantity, ''
as comments,'Active' as status,'n' AS is_bridal, 'Gallery' AS type,
now() as
Hi,
When configurating a dual master setup do I need to set
parameter
log-slave-updates ?
/J
_
Hitta rätt på nätet med MSN Sök http://search.msn.se/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To
OK, you use a C char* using an UTF-8 encoding.
On Friday 09 April 2004 11:45, Hirofumi Fujiwara wrote:
Hi,
I have a question. I have read that since MySQL 4.1, VARCHAR type can
hold unicode characters. But, it seems that the API of the C library use
to send queries to the server still use
Pascal Francq wrote:
OK, you use a C char* using an UTF-8 encoding.
That's very commmon in the Unix world. 2-byte encodings are very rare
on Unix-like systems, for compatibility reasons.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi Ciprian,
OK, I'm by no means a DB guru, so a) take this with a grain of salt
and b) feel free to tear it apart if I'm completely wrong! ;]
If in fact your people and city tables aren't going to change very
often, then why don't you just go all the way and keep that
%% Dan Nelson [EMAIL PROTECTED] writes:
dn That is because although Linux binaries can access files over 2gb,
dn they do not do so by default. Apache was probably not compiled
dn with the required defines (-D_LARGEFILE_SOURCE
dn -D_FILE_OFFSET_BITS=64), so that's why it stops at 2gb even
[EMAIL PROTECTED] wrote:
We have been looking and looking for some guidance for installing MySQL with
SSL on a SuSE 9.0 box. By searching the archives, the net using Google,
etc., we keep finding pieces of the puzzle, but no single piece that covers
all of the ground.
The problem is that
Hi!
On Apr 08, Haitao Jiang wrote:
Why Mysql load index ... into cache require the same
size index block when it creates indexes in different
block sizes (1k or 2k)? I don't understand.
It's limitation of the current implementation :(
It reads MYI file successively by fixed chunks
(multiple
I ahve a problem with updating a row using a field from another row in the
same table.
The mySQL manual says:
Error 1093 (ER_UPDATE_TABLE_USED)
SQLSTATE = HY000
Message = You can't specify target table 'x'
for update in FROM clause
This error will occur in cases like this:
I have an application where I want to look for records that match
certain criteria and then for each item found do a second lookup for
additional information. Normally I would do a join. In this case
however I want to display each of the results from the first of the
two criteria whether or not
Can you create a 'fact' table containing the infomration that you are
querying? This goes
against normalization but if the table will only be used for querying
purposes then this
will eliminate your need to perform joins.
-Original Message-
From: Tim McDonough
To: [EMAIL PROTECTED]
Sent:
Perhaps stated a bit more correctly:
Apache is NOT unique to Linux, so any system using Apache would need this
configuration, that would include windows, MAC OS, Solaris, Irix, etc.
Can't blame the OS on a softwares requirements...
Dan.
At 08:07 AM 4/9/2004, Paul Smith wrote:
%% Dan Nelson
* Tim McDonough
I have an application where I want to look for records that match
certain criteria and then for each item found do a second lookup for
additional information. Normally I would do a join. In this case
however I want to display each of the results from the first of the
two
I have an application where I want to look for records that match
certain criteria and then for each item found do a second lookup for
additional information. Normally I would do a join. In this case
however I want to display each of the results from the first of the
two criteria whether or
I'm trying only to update one table from a backup. I have the sql file
stripped down to just the INSERT commands. I have emptied the table from
phpMyadmin to start.
How do I load this sql file so it runs all of the inserts in this file
through ssh (70MB)?
Mark Súsol
Yes, I use JDBC (with the MySQL Connector/J driver). I did not find a
way in the JDBC API to escape a string before inserting it in a SQL string.
The JDBC PreparedStatement class is able to escape parameters (in a
database specific way) with the setString(parameterIndex, string)
method, but
On Friday 09 April 2004 09:52 am, Mark Susol | Ultimate Creative Media wrote:
I'm trying only to update one table from a backup. I have the sql file
stripped down to just the INSERT commands. I have emptied the table from
phpMyadmin to start.
How do I load this sql file so it runs all of the
I found a place that say MYSQL has a limit for the size off the packet
in relation with blob field. They say that you need to put this in the
my.cnf set-variable = max_allowed_packet=15M. With that you increase
the size to 15 mb
You can go and check the code in
Mark Susol|Ultimate Creative Media [EMAIL PROTECTED] wrote:
I'm trying only to update one table from a backup. I have the sql file
stripped down to just the INSERT commands. I have emptied the table from
phpMyadmin to start.
How do I load this sql file so it runs all of the inserts in this
We have a DB of customer comments that we want to display one at a time on
our web site. We want the web pages (wrote in php) to use a user
name/password on the DB that has SELECT ability and that's it.
What's the best way to cycle through the comments so that each page
requested gets the next
Just realized my subject wasn't correct, we don't want the next field, we
want the next row...
Thanks!
We have a DB of customer comments that we want to display one at a time on
our web site. We want the web pages (wrote in php) to use a user
name/password on the DB that has SELECT ability
Hi all--
We have one master and 12 slaves replicating from it. Server is 4.0.16
(havn't wanted to take it down to upgrade), the slaves are 4.0.17, all
running on RedHat AS. Lately, every few hours one of the machines caughs
up this error, and quits replicating:
Could not parse relay log event
We have a DB of customer comments that we want to display one at a time
on
our web site. We want the web pages (wrote in php) to use a user
name/password on the DB that has SELECT ability and that's it.
What's the best way to cycle through the comments so that each page
requested gets
Tim McDonough writes:
The solution I presently have does a query for the first criteria.
Then, I loop through the results of that query and do another query
for each returned row. This produces the desired results but requires
a lot of queries, i.e.-- if the first query returns 1000 customers
On Friday 09 April 2004 09:52 am, Mark Susol | Ultimate Creative Media wrote:
I'm trying only to update one table from a backup. I have the sql file
stripped down to just the INSERT commands. I have emptied the table from
phpMyadmin to start.
How do I load this sql file so it runs all of
That didn't work but it led to something that did. It turned out that
the owning group didn't have full authorization in the data folder. So,
I did a brute force approach. I made mysql the owner of everything,
instead of root, made mysql the group of everything (which it already
was), then
You could do something like this:
$start = 0;
if (isset($_GET['start'])) {
$start = 1 * $_GET['start']; //make sure it's numerical
}
then query:
SELECT .. FROM .. ORDER BY date LIMIT $tart, 1
display the comment
$start++;
provide a link to thispage.php?start=$start
On Friday 09 April 2004 11:40 am, Mark Susol | Ultimate Creative Media wrote:
On Friday 09 April 2004 11:29 am, you wrote:
I'm not getting an error..I'm getting inserts that are NOT in the file
I'm directing it to dump. Maybe I don't understand the dump function and
how it works with a sql
sdf sdf [EMAIL PROTECTED] wrote:
When configurating a dual master setup do I need to set
parameter
log-slave-updates ?
MySQL supports only one master for slave. What do you mean dual master setup?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
Ah..I see now. I was still using mysqldump..instead of mysql. Yes I'm
trying to import the data from backup, into an empty table since the data
was corrupt.
Looks like you are on the right track now! :)
James
Ok now I want to dump tables with names starting with phpads so I can
move them
Michael:
Thanks. It did the trick.
Kirti
-Original Message-
From: Michael Stassen [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 08, 2004 6:32 PM
To: Kirti S. Bajwa
Cc: [EMAIL PROTECTED]
Subject: Re: Perl Modelues
Kirti S. Bajwa wrote:
Ken:
Thank you for your response. I tried
Hello,
I've recently came across a problem I couldn't seem to solve right by myself.
I have a db with objects table, each of those objects may belong to groups
of objects. The number of groups can be about 256 and an object
belongs from one to many different groups at once.
I cannot find a good
Ok i worked out a possible bug with mysql 4.1 compiling openssl on solaris
i keep getting this error
gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql
/var
\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DDONT_USE_RAID -I. -I. -I..
-I..
/include
/opt/csw/include/openssl -O3
Looks like it could be a bug. I'll check it out.
-Original Message-
From: tweewan.wong [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 07, 2004 8:13 PM
To: [EMAIL PROTECTED]
Subject: RE: Using BYTEFX to connect to MySql , closing connection do not
release the connection.
Thanks
hello,
I have installed mysql-3.23.58-pc-linux-i686 on Red Hat 9.0,
while starting daemon i got the following message:
./bin/safe_mysqld --user=mysql
[1] 5240
[EMAIL PROTECTED] mysql-3.23.58-pc-linux-i686]# Starting mysqld daemon with
databases from /usr/local/mysql-3.23.58-pc-linux-i686/data
On Fri, 2004-04-09 at 09:48, [EMAIL PROTECTED] wrote:
Hello,
I've recently came across a problem I couldn't seem to solve right by myself.
I have a db with objects table, each of those objects may belong to groups
of objects. The number of groups can be about 256 and an object
belongs
On Friday 09 April 2004 12:26 pm, Mark Susol | Ultimate Creative Media wrote:
Ok now I want to dump tables with names starting with phpads so I can
move them to another db. How is the mysqldump command run then?
And when I go to move them to the new db, I do use the mysqldump command
since I
Hello,
I am trying to install Mysql (mysql-standard-4.0.18-pc-linux-i686.tar.gz) on my
'SCO_SV 3.2 5.0.5 i386' unix machine.
When unzipping and untarring the file when I try to run the scripts/mysql_install_dn
program I get a bunch of error messages. Here is what I get :-
WARNING: The host
Hello again,
Is there a way to do regex search are replace on all entries in a mysql field?
Or, a way to uppercase or lowercase all characters for all entries in a
filed? Some of the fields are varchars with numbers and letters. In my
particular case, I have a field of serial numbers some of
On Fri, 9 Apr 2004, Mickey wrote:
I am trying to install Mysql
(mysql-standard-4.0.18-pc-linux-i686.tar.gz) on my 'SCO_SV 3.2 5.0.5
i386' unix machine.
This is for linux. Do you have the lxrun installed? If you have lxrun
installed and updated to the lastest libraries then it will work. If
Rohan Shrivastava [EMAIL PROTECTED] wrote:
hello,
I have installed mysql-3.23.58-pc-linux-i686 on Red Hat 9.0,
while starting daemon i got the following message:
./bin/safe_mysqld --user=mysql
[1] 5240
[EMAIL PROTECTED] mysql-3.23.58-pc-linux-i686]# Starting mysqld daemon with
Lecho [EMAIL PROTECTED] writes:
I have a db with objects table, each of those objects may belong to groups
of objects. The number of groups can be about 256 and an object
belongs from one to many different groups at once.
Lecho,
I threw together the following tables/data/queries that I
Brad Tilley [EMAIL PROTECTED] wrote:
Is there a way to do regex search are replace on all entries in a mysql field?
Or, a way to uppercase or lowercase all characters for all entries in a
filed? Some of the fields are varchars with numbers and letters. In my
particular case, I have a
Mark,
- Original Message -
From: Mark Susol|Ultimate Creative Media
[EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Thursday, April 08, 2004 11:25 PM
Subject: Re: Corruption and my.cnf
I've experienced more corruption lately on my main site since I moved to
=
my
own
Philippe,
- Original Message -
From: Philippe Lewicki [EMAIL PROTECTED]
Newsgroups: mailing.database.myodbc
Sent: Wednesday, April 07, 2004 12:51 AM
Subject: Re: read_key: Got error 146 when reading table
Heikki,
Its: mysql-standard-4.0.17-pc-linux-i686
thank you for the bug
Friday, April 09, 2004, 8:59:48 PM, Rohan Shrivastava wrote:
RS there are some tables named
RS columns_priv and tables_priv
RS are you talking about these
Yes.
In this case check permissions on the MySQL data dir and files.
MySQL should be owner of the data dir.
RS Regards
RS Rohan
Rohan
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Christos Karras wrote:
Yes, I use JDBC (with the MySQL Connector/J driver). I did not find a
way in the JDBC API to escape a string before inserting it in a SQL
string.
The JDBC PreparedStatement class is able to escape parameters (in a
database
I'm trying to build a fulltext index on a table with about 4 million
entries with 2 varchar and one text field.
The indexing starts and runs for about 1/2 to 1 hour, then the process
stops without any error message. And leaves me with no index. I checked
for the size in tmp and redirected it to
Hello again,
I have a form that users fill out and submit into a mysql database using php.
The problem I have is that there is only one unique field in the main
table... it's an int that's auto-incremented with each new entry. This works
fine unless the user accidentally submits the data
BT Hello again,
BT I have a form that users fill out and submit into a mysql database using php.
BT The problem I have is that there is only one unique field in the main
BT table... it's an int that's auto-incremented with each new entry. This works
BT fine unless the user accidentally submits
Hi all,
I am still a bit confused as to the license for using MySQL.
If I create an application in PHP, that uses a MySQL database (for
example a shopping cart application) and I want to sell this
application (not open source), am I required to pay a license fee?
I found this quote:
2. Free
Exactly. The license only becomes an issue when you distribute mysql
itself. Essentially, the gist is you can't charge people for mysql; only
mysql can do that. You could, OTOH, let folks get your php app, and provide
a link so they can download mysql themselves.
- Original Message -
MIchael, Point well taken.
Cheers,
Adam
On Apr 8, 2004, at 2:47 PM, Michael Stassen wrote:
Good point. I was focused on the question of using the alias to
restrict results, so I left the function in the SELECT part. As you
say, in this query, that would just give a useless column of '1's, so
Hello:
I have need to declare a column as type integer then default is at '0'
(that is a string with a zero in it).
An example may be:
Create table foo (
foo_id int not null default '0'
)
My question centers on the notion of implicit type conversion. Is the
server converting the type
I thought I read that if your app is not GPL and interacts with MySQL in any
way, you must license MySQL.
on 4/9/04 5:16 PM, Dan Bowkley at [EMAIL PROTECTED] wrote:
Exactly. The license only becomes an issue when you distribute mysql
itself. Essentially, the gist is you can't charge people
Only if you incorporate mysql into your app--for example, if your app is a
database system based on the mysql engine. An app that merely talks to
mysql doesn't require you to license it.
- Original Message -
From: John Mistler [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April
Hi,
I'm new to the list.
By these days I'm facing a system DB migration to MySQL (the last
production version) and I have the followin problem. All the SELECTs
sentences are all over the application, and for date/datetime filters
are using the dd/mm/ format in the WHERE clause. Is the same
62 matches
Mail list logo