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 altogether
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
My final issue is inserting a currency, $500.00 for example into a field
that is a BigDecimal(10,2).
Anyone have any thoughts on how to do that within a SQL statement?
dan
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EM
dan orlic wrote:
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
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 created, now() as
> When I use multi-byte code (especially UTF-8) with data including
> Kanji (Japanese kanji character) and execute SELECT from mysql
> client command, the vertical lines(|) of output table aren't aligned
> as straight lines and the output doesn't look like a table.
>
> When I use SJIS code, the
Kirti S. Bajwa wrote:
Ken:
Thank you for your response. I tried the 'mysql_config' command and got an
error message. I will add 'mysql_config' to the path (if I figure out
how!!!).
You need to add the directory which contains mysql_config to your path.
Adding to your PATH isn't difficult, but th
Are you using a high level library such as Perl::DBI? If so, you should run
all your strings the quote method. That will quote it properly for each
database you connect to. If you are connecting to all the databases yourself
using custom code, I would recommend you find some database neutral
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.
Please help!
__
Do you Yahoo!?
Yahoo! Small Business $15K Web Design Giveaway
http://promotions.yahoo.com/desig
Is there a way to disable the use of the backslash as an escape
character in strings? I need to use an application that's designed to
work on any database server supporting ANSI SQL. When it generates SQL
insert/update queries, it doesn't escape backslashes in strings, because
the ANSI SQL stan
Ken:
Thank you for your response. I tried the 'mysql_config' command and got an
errot message. I will add 'mysql_config' to the path (if I figure out
how!!!).
I noticed that on my installation the 'mysql_config' is in
'/usr/local/mysql/bin' directory whereas you have indicated that it should
be
> I've experienced more corruption lately on my main site since I moved to my
> own server running 4.0.17max. The site is very busy (60GB a month) and the
> tables are large. I didn't have this level of problems on the rental server.
>
> What are the variables to look into regarding why my tables
Keep in mind you can't use truncate in a transaction though. I experienced
this problem
recently when wanting to delete an entire table and reset my auto increment
values. While
keeping it in a transaction.
From: "Dathan Vance Pattishall" <[EMAIL PROTECTED]>
To: "'Arthur Radulescu'" <[EMAIL PR
All you had to do what
CHANGE MASTER TO MASTER_LOG_POS=,
MASTER_HOST=, MASTER_USER=,
MASTER_LOG_FILE=
This essentially forces mySQL to redownload the relay logs and stay in sync.
Its call rewinding the replication thread.
--
DVP
> -Original Message-
> From: Jeff McKeon [mailto:[EMAIL
Try truncate table. It essentially drops the table and recreates it.
--
DVP
> -Original Message-
> From: Arthur Radulescu [mailto:[EMAIL PROTECTED]
> Sent: Thursday, April 08, 2004 10:36 AM
> To: [EMAIL PROTECTED]
> Subject: autoincrement column
>
> Before switching to version 4.0.18 of
Hi Kirti,
mysql_config tell the perl build module how to link with the
driver. The easiest way to fix this is make sure the bin driectory of
MySQL is in your path. If you can type 'mysql_config' at the command
line and get an answer like:
Usage: /usr/local/bin/mysql_config [OPTIONS]
Options:
On 4/8/04 1:05 PM, "Michael Stassen" <[EMAIL PROTECTED]> wrote:
>
> James McConnell wrote:
>
>> On 4/8/04 9:18 AM, "Barry ." <[EMAIL PROTECTED]> wrote:
>>
>>
>>> Hi
>>>
>>> I recently began to work through the Book entitled PHP & MySQL For Dummies
>>> and i am currently stuck towards the end
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 you might as well
leave it out. In that case, though, the alias question is moot. That is,
Here's what I did to fix it... Excert from MySql Manual...
When you back up your slave's data, you should back up these two small
files as well, along with the relay log files. They are needed to resume
replication after you restore the slave's data. If you lose the relay
logs but still have the `
Before switching to version 4.0.18 of MySQL the command "delete from table"
was also reseting the autonincrement column value... It seems that this is
not happening anymore after we have installed this version...
Any idee about this problem? Is there any other way to reset this?
Arthur
--
MyS
iH
is mysql installed and running?
- hcir
On Apr 8, 2004, at 9:53 AM, Kirti S. Bajwa wrote:
cpan> install DBD::mysql
Errors returned:
Can't exec "mysql_config": No such file or directory at Makefile.PL
line 174
readline() on closed filehandle PIPE at Makefile.PL line 176
... (there are 10 such
I upgraded from MySQL 4.0.12 to MySQL 4.0.18 last night and found some
oddities this morning. Apparently some of the varchar data being input into
certain tables had carriage returns: "\n" in the data. This was an
accidental thing, but on 4.0.12, the \n was ignored when matching on that
record.
First a big thanks to Mark, BAO, Beacker, Matthais, Rich & Ken for their
response.
My problem was that I thought that I needed to download "tar" file to start
the installation. Rich's response somewhat cleared that. I ran the following
commands, and got the following errors:
% perl -MCPAN -e sh
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 we seem to complete the install,
James McConnell wrote:
On 4/8/04 9:18 AM, "Barry ." <[EMAIL PROTECTED]> wrote:
Hi
I recently began to work through the Book entitled PHP & MySQL For Dummies
and i am currently stuck towards the end of the forth chapter ive done
everything as said so in the book but i keep getting an error messa
I'm new to mysql, so I thought I'd use the command
center utility, which requires an X server to be
running.
Is there a way to start the xterm and mysqlcc all at
once? I would like a shell script that starts xterm
and then runs mysqlcc.
Any ideas?
TIA.
=
Thanks.
Kevin
-- Enjoy Life, Drin
Typo petColor is meant to be color
From: James McConnell <[EMAIL PROTECTED]>
To: "Barry ." <[EMAIL PROTECTED]>,MySQL Mailing List
<[EMAIL PROTECTED]>
Subject: Re: Learner Here Getting Frustraighted
Date: Thu, 08 Apr 2004 09:34:36 -0500
On 4/8/04 9:18 AM, "Barry ." <[EMAIL PROTECTED]> wr
> Is there an easy way to create an HTML page that will copy selected tables
> to backup copies on the same server? I want to create an administration
> page for my client to be able to "backup" their database whenever they see
> fit. But, I can't give them direct access to the MySQL server and don
> Is there an easy way to create an HTML page that will copy selected tables
> to backup copies on the same server? I want to create an administration
> page for my client to be able to "backup" their database whenever they see
> fit. But, I can't give them direct access to the MySQL server and don
Try using such command from PHP...
system("$MYSQLDUMP --opt --user=$USER --password=$PASSWORD $DATABASE_NAME
$GZIP - > $BKDIR/$newfile.gz",$status);
where
$MYSQLDUMP is the mysqldump path
$GZIP is the path to gzip
$BKDIR is the path to the backup folder
Sound like a great idea!
> Is there an easy way to create an HTML page that will copy selected tables
> to backup copies on the same server? I want to create an administration
> page for my client to be able to "backup" their database whenever they see
> fit. But, I can't give them direct access
Is there an easy way to create an HTML page that will copy selected tables
to backup copies on the same server? I want to create an administration
page for my client to be able to "backup" their database whenever they see
fit. But, I can't give them direct access to the MySQL server and don't
want
* Steijn, B.S.
> I would like to make a connection between 2 databases in
> MySQL that are on the same server.
If you by "connection" mean to join tables from the two databases on the
same server, you can do that.
> The purpose is that a
> class X in database A uses a class Y in database B by a
>
Ginger Cheng <[EMAIL PROTECTED]> wrote:
> Here is the error msg:
>
>
> 040408 08:47:14 mysqld started
> Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
> If you do not want to use transactional InnoDB tables, add a line
> skip-innodb
> to the [mysqld] section of init parameters i
Robb Kerr <[EMAIL PROTECTED]> wrote:
> I can't seem to get a FULLTEXT search in the form of MATCH...AGAINST to
> work. I even copied verbatim the example listed on mysql.com at
> (http://www.mysql.com/doc/en/Fulltext_Search.html). When I use...
>
> SELECT * FROM articles WHERE MATCH (title,body) A
I got it fixed with the msg from --err-log. THank you so much for all your
help. I couldn't have made it without your hints.
ALl the best
ginger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Here is the error msg:
040408 08:47:14 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables
Hello Robb,
Thursday, April 8, 2004, 4:30:46 PM, you wrote:
RK> I've got several tables with FULLTEXT indexes and on none of them can I get
RK> this syntax to work. What's up?
Your version of MySQL perhaps?
--
Best regards,
Richard Davey
http://www.phpcommunity.org/wiki/296.html
--
MySQL
I can't seem to get a FULLTEXT search in the form of MATCH...AGAINST to
work. I even copied verbatim the example listed on mysql.com at
(http://www.mysql.com/doc/en/Fulltext_Search.html). When I use...
SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database')
it works as expected. Howe
I don't have such files. Unfortunately. Am I hopeless?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What information is being logged in *.err?
-Original Message-
From: Ginger Cheng
To: [EMAIL PROTECTED]
Sent: 4/8/04 10:20 AM
Subject: Please HELP !!! Can not restart server
Hi, MySQL Gurus,
Version of mysql is Distrib 3.23.54, for redhat-linux-gnu
(i386). I
started mysql server w
Please look in your data directory and post the contents of the .ERR file that you find there. That will give folks the information
they need to help solve your problem.
-Original Message-
From: Ginger Cheng [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 08, 2004 10:21 AM
To: [EMAIL PRO
Hi, MySQL Gurus,
Version of mysql is Distrib 3.23.54, for redhat-linux-gnu (i386). I
started mysql server with 'safe_mysqld --user=root &' . Then I found some
variables needs to be optimized. SO I shut it down with 'mysqladmin -p
shutdown' using root. But I was connected to the mysql server at
Hi,
I would like to make a connection between 2 databases in
MySQL that are on the same server. The purpose is that a
class X in database A uses a class Y in database B by a
foreign key. Thus, the table in B can be re-used by other
databases which will make my databases more efficient.
I've alrea
At 8:29 -0600 4/8/04, Kevin Jaques wrote:
Thanks for the reply. I feel it is getting me somewhere, but I'm not
there yet.
The log said, regarding the most recent attempt:
040407 09:55:24 mysqld started
040407 9:55:25 InnoDB: Operating system error number 13 in a file
operation.
InnoDB: See h
Hi,
I tried to load a table's indexes into cache, however
I noticed that full-text indexes have a different
block-size than others (2048 vs. 1024), which caused
load index command to fail. Any idea on how to solve
this?
Thanks a lot
__
Do you Yahoo!?
Yahoo! Small
Barry Smith writes:
>i have 2 tables one pet containing petName and petType other table is color
>containgin petName and petColor. The code which i keep getting errors on is:
>
>Select * from pet outer join color using (pet.petName=petcolor.petName) ;
Unfortunately petcolor is not a table. Based
For starters look at pet.petName=petcolor.petName
Try changing it to.
pet.petName=color.petName
You are referencing the color table as petcolor.
Thanks,
Andrew
From: "Barry ." <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Learner Here Getting Frustraighted
Date: Thu, 08 Apr 2004 14:18:10 +
On 4/8/04 9:18 AM, "Barry ." <[EMAIL PROTECTED]> wrote:
> Hi
>
> I recently began to work through the Book entitled PHP & MySQL For Dummies
> and i am currently stuck towards the end of the forth chapter ive done
> everything as said so in the book but i keep getting an error message. Here
> is
I seem to have encountered a corrupt database file,
and was wondering if anyone could shed some light onto
how this occurred. I was able to restore from a
backup, so I'm OK now, but I'd like to know how to
avoid this in the future. I'm running MySql-max
4.0.18, using InnoDB tables. It looks like th
Hi
I recently began to work through the Book entitled PHP & MySQL For Dummies
and i am currently stuck towards the end of the forth chapter ive done
everything as said so in the book but i keep getting an error message. Here
is an outline of the problem:
i have 2 tables one pet containing pet
I've experienced more corruption lately on my main site since I moved to my
own server running 4.0.17max. The site is very busy (60GB a month) and the
tables are large. I didn't have this level of problems on the rental server.
What are the variables to look into regarding why my tables are gettin
Is there any way to fix a corrupted relay log on a slave?
Jeff
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thursday, April 08, 2004, 1:07:27 PM, b wrote:
> hi,
> Error 1064: You have an error in your SQL syntax. Check the manual that corresponds
> to your mySQL for the right syntax to use near 'mysql -u root -p databasename
> however, I tried this.
> \u database name;
> \. scriptfile.sql;
> This w
b <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I'm using mySQL 4.1.18 on Windows XP pro. I tried this syntax and I received error.
>
> mysql -u root -p databasename
> What is the right syntax for this.
>
> I managed to unpack my table structure from the same script into another machine on
> Win2
Hi,
I'm using mySQL 4.1.18 on Windows XP pro. I tried this syntax and I received error.
mysql -u root -p databasename
A Z <[EMAIL PROTECTED]> wrote:
> Hi,
>
> MySQL 4.0.14
> Are there any known issues on windows 2000 advance
> server?
> After installation, on running the WinMySQLAdmin the
> green light comes on for a second or two and then
> disconnected. We tried running MySQLd-nt on its own,
> it simply cannot
"Lou Olsten" <[EMAIL PROTECTED]> wrote:
> I'm in the process of trying to move some of our systems to MySQL from SQL Server and
> Oracle. At this point I'm learning and testing MySQL.
>
> One immediate question I have is regarding getting aggregate information. For
> example,
> the SHOW DATABAS
Hi,
MySQL 4.0.14
Are there any known issues on windows 2000 advance
server?
After installation, on running the WinMySQLAdmin the
green light comes on for a second or two and then
disconnected. We tried running MySQLd-nt on its own,
it simply cannot establish connection.
What could be wrong here?
Hello,
i have a table that contains datetime entries which are stored in GMT. Now I
would like to convert these datetime values in a select statement to local
time. I first thought of someting like this (in germany DST starts at
2004-03-29 02:00:00 and ends "2004-10-31 03:00:00" this year. The
"Terence" <[EMAIL PROTECTED]> wrote:
>
> Can this be done in one sql statment (without the use of sub-queries):
>
Without subqueries - no.
>
> SELECT count(*) as total, status
> FROM table
> GROUP BY status
>
> ---
>
> Absent | 40
> Present|60
>
> and get this re
Hi List,
Can this be done in one sql statment (without the use of sub-queries):
SELECT count(*) as total, status
FROM table
GROUP BY status
---
Absent | 40
Present|60
and get this result:
Absent: 40%
something like:
SELECT ((count(total) OF status=Absent) / cou
Hello,
I have the following structure:
people
-
| id | name |
-
| 1 | John |
| 2 | Mary |
-
cities
| id | city|
| 1 | Glasgow |
| 2 | Madrid |
| 3 | Berlin |
travel_expenditures
Hello all,
I would like to run diverent MySQL-Daemons on the same Linux machine, so
I use mysqld_multi to start the different processes.
The Config looks right to me, I have different Database Directorys,
Pid-Files, Ports, IDs usw. and different Socket-Files and all over it
seems to work.
But!
64 matches
Mail list logo
