sguazt sguazt wrote:
Thanks for answering!
Your solution would be right if I can modify the database (and I have no
control on software that populate tables).
Unfortunately I can do only queries on that db; so the due date has to
be recalculated every time I want to perform the main report (that
Hi!
i have a question:
FIELD IN MS SQL SERVER
FiledName: uiAutID
DataType: unique identifier
DefaultValue: newid()
Is RowGuid: Yes
how i can describe the some column in MySQL?
if isn't possible, how can i solve my problem?
P.S.: is necessary for us,
Hi!
From: Philippe Poelvoorde [EMAIL PROTECTED]
Reply-To: 'mysql@lists.mysql.com ' mysql@lists.mysql.com
To: mysql@lists.mysql.com
Subject: Re: Queries inside UDF
Date: Thu, 17 Mar 2005 08:22:46 +
...
You can actually access a DB within a UDF, but you should do the same than
when you're using
Hi,
I am using mysql Ver 14.7 Distrib 4.1.8, for pc-linux (i686)
When running a certain query I get the following error:
DBD::mysql: t execute failed: Illegal mix of collations
(latin1_swedish_ci,COERCIBLE) and (utf8_general_ci,IMPLICIT) for operation
'find_in_set'
I do not understand why I have
Hello.
Please, search in MySQL archives (at lists.mysql.com/mysql) about
successful solutions to your problem. You may use --focre --nodeps
flags for the rpm command.
[snip]
I want to upgrade mysql client 3.23. to mysql 4.1.10
But when I type rpm -Uvh mysql-client-4.1...rpm
It's
MyISAM tables files have MYI suffix. See:
http://dev.mysql.com/doc/mysql/en/full-table.html
Hi,
I have a InnoDB database with MySQL version 4.1.0-alpha installed on my
RedHat Linux 9.0. The data files name is like *.frm, *.MYD, *.MYI.
Currently the table size is
Hello.
Hi, I am trying to install the latest version of MySQL(i am not sure
4.0.23?
Use 4.1.10a. See:
http://dev.mysql.com/downloads/
Hi, I am trying to install the latest version of MySQL(i am not sure
4.0.23? currently in the office). The RH9 comes with some 3.2.xx
version,
Hello.
Please let me know how to install MySQL successfully on Linux.
You may use official binaries. See:
http://dev.mysql.com/downloads/
[snip]
I was installing MySQL on Linux. At that time it was giving some problem
when I did ./configure.
Your libc libraries are not 100%
Hi,
After upgrading to mysql 4.1.10nt
I am being told that some of my tables are read-only
I cannot find where or how you might specify that a table is read/write to
whatever
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
H...
It looks like you upgraded from a MySQL that doesn't know about
collations...
All the tables created with a version of MySQL that doesn't know about
collation are considered by a version that does know... being of collation
latin1_swedish_ci... (on columns where collation makes sense...
Ankur G35 Saxena wrote:
All I had to do was rpm -Uvh --nodeps pkg_name
I have the MySQL AB RPMs running on Red Hat 9 just fine. I didn't have
to force them at all.
I suspect you had to force it because you had MySQL installed already.
The problem is, the Red Hat package is called mysql,
Hi everyone,
I'm following up on my own question. There appears to be a bug in the way
how QUOTE() interacts with the mysql client.
Using --raw mode can apparently solve the problem reported in my original
post:
shell mysql --raw -N -B -e SELECT QUOTE(sometext) FROM foo; test
'Pitt\'s Place'
Hi Jonathan, all!
Am Mi, den 16.03.2005 schrieb Jonathan Stockley um 22:33:
I just downloaded the 4.1.10a release for Solaris 8 and 9 (32bit). It
seems that it is no longer in a tar archive. Was this change
intentional?
Both yes and no:
Yes, it was intentional to create and offer PKG format.
man pkgadd
-J
- Original Message -
From: Joerg Bruehe [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Cc: Jonathan Stockley [EMAIL PROTECTED]
Sent: Thursday, March 17, 2005 9:16 AM
Subject: Re: 4.1.10a packaging for Solaris
Hi Jonathan, all!
Am Mi, den 16.03.2005 schrieb Jonathan Stockley
Is there a free service where I can upload my CSV file to let the
guess_table script go through and suggest create table statement?
I did recently downloaded and tried the guess_table.pl script that is
mentioned in Mysql cookbook. (10.36 Guessing Table Structure)
I could not run the script due to
For those of you watching but still not getting his point: He is saying
that QUOTE() improperly escapes a string where a \ and a ' appear together
in the unquoted text. the sequence \' should look like \\\' when
QUOTE()-ed. It should escape \ as \\ and ' as \'.\\+\' = \\\' .
QUOTE() seems
Okay, I was able to get the MySQL to shut down via command line.
However, not being a Unix person, I'm not sure where I would go to
change the .bash_profile. I've never had to change it for anything up
until now.
I will be curious to see if adding the path affects the problem in any
way
Hi,
We are developing an application that needs to use a massive back-end
database. The database will contain around 75 million rows with around
80 columns per row. We would prefer to use MySQL as the database
platform as it is free. The MySQL database would be hosted on a
dedicated server that
Jeff Justice wrote:
I'm not sure where I would go to
change the .bash_profile.
It's in your home directory. You land there just by opening a new
Terminal window. I suppose if you had to wimp out, you could probably say:
$ TextEdit .bash_profile
But real Unix users don't use GUI text
Hi!
I was able to insert data with the following:
sub insert_sql {
my ( $group_name, $me, $daily, $item, $unit, $qty, $amount, $tax, $total,
$DEBUG ) = @_;
print [EMAIL PROTECTED] if $DEBUG;
( $group_name, $me, $daily, $item, $unit, $qty, $amount, $tax, $total ) =
clean_sql(
Gerald!
Do you have an auto_increment field?
If so, what's it set as?
Richard
Quoting Gerald Preston [EMAIL PROTECTED]:
Hi!
I was able to insert data with the following:
sub insert_sql {
my ( $group_name, $me, $daily, $item, $unit, $qty, $amount, $tax, $total,
$DEBUG ) = @_;
You can't call TextEdit from the command line like that, you have to launch
it in the GUI. That doesn't really matter, though, as you do not want to
use TextEdit, because it saves files as RTF!
Launch a Terminal window. You'll be in your home directory. Enter
ls .bash*
to see if you
Okay...now we're getting somewhere. Thank you. Adding the file wasn't
the problem, I just wasn't sure WHERE it should be added. Yes, I am
using 10.3. Just trying to pin down why the GUI tools can't seem to
start and stop this thing reliably. As I stated before, I'm not a Unix
geek :) so
Maybe it's my setup... but:
whenever I try to login to use the mySQL query browser, it instantlly
turns off the 5.0.2 alpha mySQL instance (stops running). the error I
get is:
mysqld-max-nt.exe - Application Error
the instruciton at 0x00538d34 referenced memory at 0x007f9000. The
memory could
On Thu, 17 Mar 2005 11:31:32 Michael Stassen wrote:
You can't call TextEdit from the command line like that, you have to launch
it in the GUI.
This will do the trick:
open -a /Applications/TextEdit.app .bash_profile
That doesn't really matter, though, as you do not want to use TextEdit,
Interestingly enough, adding the PATH to the .bash_profile has made the
preference pane 100% stable now (the Admin GUI is another story). So
I'm wondering if the pref pane simply calls a shell script or command.
If that is the case, shouldn't the PATH be added or created during
installation
I'm not sure if it's a OS X, PHP or MySQL issue so I apologize in
advance if this is taken as too off topic.
I have a PHP5.x site under development with MySQL 4.1.10. I had the
site running fine and there were no speed issues at all. Everything is
on the same system (a dual G5 Xserve).
Richard,
Explain auto_increment field please.
Thanks,
Jerry
-Original Message-
From: Richard Whitney [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 17, 2005 10:31 AM
To: Gerald Preston
Cc: mysql@lists.mysql.com
Subject: Re: insert was working
Gerald!
Do you have an auto_increment
Lots of users report such instabilities in the 5.0.2-alpha build for
Windows. We went back to 5.0.1.
PB
-
Francisco Tapia wrote:
Maybe it's my setup... but:
whenever I try to login to use the mySQL query browser, it instantlly
turns off the 5.0.2 alpha mySQL instance (stops running). the
I have 2 tables, category product. product contains category_id which
points back to category.id
I'm trying to get all fields for each category plus the total no. of
products in that category. A simple query for this:
SELECT c.*, COUNT(p.id) AS total
FROM category AS c, product AS p
WHERE
brian ally [EMAIL PROTECTED] wrote on 03/17/2005 02:28:46 PM:
I have 2 tables, category product. product contains category_id which
points back to category.id
I'm trying to get all fields for each category plus the total no. of
products in that category. A simple query for this:
When will 5.0.3 come out?
Thanks,
Lily
-Original Message-
From: Peter Brawley [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 17, 2005 10:17 AM
To: Francisco Tapia
Cc: mysql@lists.mysql.com
Subject: Re: 5.0.2 alpha crashes with Query Browser
Lots of users report such instabilities in
At 01:28 PM 3/17/2005, you wrote:
I have 2 tables, category product. product contains category_id which
points back to category.id
I'm trying to get all fields for each category plus the total no. of
products in that category. A simple query for this:
SELECT c.*, COUNT(p.id) AS total
FROM
Hello,
I imported tow tables from an Access database to MySql.
Call them table1 and table2.
Both tables came with unique identifiers (ID1 for table1 and ID2 for
table2)which were generated automatically as a regular integer
index(0,1,2...N-1) for an N set of data. I would like to get rid this
Mahmoud Badreddine [EMAIL PROTECTED] wrote on 03/17/2005 03:16:47
PM:
Hello,
I imported tow tables from an Access database to MySql.
Call them table1 and table2.
Both tables came with unique identifiers (ID1 for table1 and ID2 for
table2)which were generated automatically as a regular
I have Python code that I run on Windows and Solaris. It works properly
on Windows. However, on Solaris, when it inserts records, datetime
columns end up with a value of zero. I suspect that this began
happening after we upgraded the MySQL server to 4.1.10 from a 4.0.x
version (I think we
oix ppl,
Nobody have any sugestion that can me help with this issue?
thanks
mpneves
On Wednesday 16 March 2005 14:09, Marco Neves wrote:
oix ppl,
sorry for the question, but I looked in the Manual online and didn't find
nothing that do this that I'm looking for, so I'm hopping someone
Marco Neves wrote:
oix ppl,
Nobody have any sugestion that can me help with this issue?
thanks
mpneves
On Wednesday 16 March 2005 14:09, Marco Neves wrote:
Look under storage requirements in the manual.
You are MySQL core certified?
oix ppl,
sorry for the question, but I looked in the Manual
Francisco,
Maybe it's my setup... but:
whenever I try to login to use the mySQL query browser, it instantlly
turns off the 5.0.2 alpha mySQL instance (stops running). the error I
get is:
mysqld-max-nt.exe - Application Error
the instruciton at 0x00538d34 referenced memory at 0x007f9000.
Marco Neves wrote:
I'm looking for some way to know the size each row of a table uses in my
database (phisical - real disk space allocated or logical - datasize
ignoring compression and any control data, don't mind, anything is better
than nothing).
You might try using the Data_length and
Hi all,
Using mysqld (mysql Ver 12.22 Distrib 4.0.18, for
pc-linux (i686)) and have come across some funky SQL
code that appears to work occassionally - maybe,
depending on the sql client I'm using, but I'm not
sure why/not.
I'm using mysql from the command line client, as well
as a jdbc client
oix ppl,
thanks a lot for the answers, but if it was this simple I wouldn't ask...
Yes, I am Core Certificate, and yes I did read the show-table-status page.
BUT, that don't satisfy my needs.
The sugestion to use data_length divided by the number of rows is good if all
rows have a fixed
Hi list,
I'm trying to import some data into a MySQL database. The data-file is
5.5G, and consist of about 132 million rows. The machine is a P4 3GHz
with 1G RAM and a single 250 GB ATA-disk for data. The operating system
is Debian GNU Linux testing with kernel 2.6.8 with hyperthreading
support.
My first guess is the indexes. Maybe create them after the import. It will
nonetheless take a bit of time!
--Original Message--
From: Jarle Aase
To: MySQL list
Sent: Mar 17, 2005 11:53 PM
Subject: Problem: Slow LOAD FILE performance with innodb
Hi list,
I'm trying to import some data
Jarle Aase schrieb:
Is there a way to boost the performance? The database is idle, and while
importing, performance is the key priority (record-locking,
transaction-rollbacks and file-integrety/crash-recovery are not required
until the data are imported).
- Disable the foreign key checks
Hi:
I have installed MySQL on two Windows XP PC systems. One system, the one at
school is not thoroughly tested but it appears to work. The other one at
home yields an error when the Administrator is run. I downloaded the zip
version of MySQL It is 36773 KB and all evidence indicates it is version
What are the implications of setting the --bdb-no-sync flag when
using the BDB storage engine. I haven't found alot of documentation on
this in the docs or via google.
Does this mean that after every transaction, sync will not be called?
When will sync be called then?
Will setting this flag
Hi!
Creating the indexes after the import will only slow down the operation.
MySQL recreates the whole table at CREATE INDEX.
We are working on a fast index create in MySQL-5.1. Until then, the fastest
way is to import the rows to a table where indexes have already been
created, just like you
I just installed MySQL 4.1 on Mac OS X Panther Client. I am now having
trouble authenticating users(root, admin) to MySQL. I am able to start
MySQL but not using a specific user name and password.
When I type ./mysql in /usr/local/mysql/bin, I am able to access MySQL.
However, I have no
49 matches
Mail list logo