Carlos,
> We have a hosting provider with a Linux box and an MySql database.
> We have a local Mysql database.
> In both machines I use phpMyAdmin.
On the startpage (right frame) of phpMyAdmin you should see a link
called "Show MySQL system variables". Look what the values of the
variables charac
sow what would you suggest, Jerry?
( I need a very FAST search on this table's filename field)
Ulterior
> Don't use varchar unless you absolutely have to, that should help.
>
> Jerry
>
> - Original Message -
> From: "Ulterior" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Saturd
So what would be an alternative to varchar? text? but then how mysql will
index such table?
text is a blob record.
Ulterior
- Original Message -
From: "Jerry" <[EMAIL PROTECTED]>
To: "Ulterior" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, May 31, 2003 1:19 PM
Subject: Re: Ins
Don't use varchar unless you absolutely have to, that should help.
Jerry
- Original Message -
From: "Ulterior" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, May 31, 2003 3:13 PM
Subject: Insert query
> Hi,
>
> I have a database table:
>
> CREATE TABLE FTPFILE (
> ID int
Hi,
I have a database table:
CREATE TABLE FTPFILE (
ID int(11) NOT NULL auto_increment,
FTPSITEID int(11) DEFAULT '0' NOT NULL,
FILENAME varchar(254) DEFAULT 'Not defined' NOT NULL,
FILEPATH varchar(254) DEFAULT 'Not defined' NOT NULL,
FILEEXTN varchar(3) DEFAULT '---' NOT NULL,
FILE
Ahem, please ignore this post - I should have been doing:
AND app.id IN (7, 23, etc.)
DOH!
Thanks to everyone for their help though...
Mikey
> -Original Message-
> From: Mikey [mailto:[EMAIL PROTECTED]
> Sent: 31 May 2003 12:53
> To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
> Subject: RE:
> You might try some partial queries before the big one to see if there are
> reasonable results -
>
> select count(*) , list.prodcode
> from application as app, application_list as list
> where app.id=list.appl_id
>AND app.name IN (7, 23, 16, 9, 18, 24, 25, 5, 13, 11, 10, 6,
> 20, 14, 19,
I have a query where I use a LIKE on a DATETIME field and it used to work
i.e.: WHERE article_datetime LIKE '2003-05%'
but when we upgraded to 4.1 it stopped working (it didn't return any
results). In itself I find that increased restrictiveness to accomplish
no purpose. And then I found out that
In a nutshell, I have a query that runs in 28 seconds until I perform a
REPAIR TABLE against one of the tables in the query then execution time
jumps to 51 seconds. The only way to get the query time back down is to
TRUNCATE and repopulate the table. I've been operating under the assumption
that RE
We have a hosting provider with a Linux box and an MySql database.
We have a local Mysql database.
In both machines I use phpMyAdmin.
When I export from Windows to Linux then all the data in Linux is messed up with
respect to special characters, we work in spanish and all accents are lost and
con
Hi All
After stumbling at a few points during "make" of the MySQL 4.0.13 on HP-UX 11.00, I've
come to a point where I will need some help. I'm trying to do "make install" and I get
the following error:
gmake[2]: Entering directory
`/fs32/b/sgsubram/bin/MySQL/HPPA.11.00/usr/src/redhat/SOURCES/m
This select statement will give you the job name and difference between the
actual amounts and quote amounts fo all jobs that have both quotes and
actuals:
SELECT job.name,sum(actual.actual_amount)-sum(quote.quote_amount)
FROM quote, job, actual
WHERE (job.job_id=actual.job_id) and (quote.quote_id
Hi,
I would like to use one query to compare aggregate values from columns
in two separate tables. I am running mysql 3.23.55 (max). Here is a
simplified table structure:
job
- job_id
- name
quote
- quote_id
- job_id
- quote_amount
actual
- actual_id
- job_id
- actual_amount
I'm trying
Hi all,
I'm in the process of designing a database and I'm a bit of an
optimization freak ... I'd like to make sure that the actual structure
of the database is optimal.
With that said, my question is about TEXT fields. In the actual CREATE
TABLE statement, would it make the table "fast
Try this.
', 5) FROM table WHERE
start_date <= CURRENT_DATE ORDER BY start_date DESC;";
$response = mysql_query( $substring, $dbh );
while ( $data = mysql_fetch_array( $response ) ) {
print $data['field_name']."\n";
}
?>
I'm not sure if it does what you want it to, but your original co
Thanks, Jeff. You saved me a lot of typing. ;)
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Jeff Shapiro" <[EMAIL PROTECTED]>
To: "Ted Rogers" <[EMAIL PROTECTED]>
Cc: "Becoming Digital" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, 30 May,
Grettings! I'm new to the list, and I hope this isn't off-topic. I've got
a MyISAM table that is about 3.3 GB in size. The index is around 4.7GB. I
started a REPAIR TABLE nnn QUICK last Sunday in a mysql session, and its
still running. The index keeps getting updated, but I can't tell if it is
Well, it's not blowing up on me and returning a jillion records. Trouble is,
it's also not returning any records at all.
Thanks for the suggestion, though. I'll keep plugging away at it.
susan
-Original Message-
From: William R. Mussatto [mailto:[EMAIL PROTECTED]
Sent: Friday, May 30, 20
> Well, I'm running 3.23.54 on Red Hat 7.3. Given this, how in the world
> do I accomplish the following:
>
> I have these tables:
> dacspriv - with dacspriv_id,dacspriv_name,short_name
> users - with user_id,username
> dacs_access - with dacsaccess_i
It just means you didn't enter the password for root.
2Hosts.com wrote:
Hi Nils,
So if I su to root and try to start mysql, I get the following... does that
mean I'm secure? I am still finding the very confusing, but doing my best
to look it up on dejanews and in books etc so as to not stress t
You have no ON condition for image_cat_location_link.
Chris Cameron wrote:
The gist; the below query doesn't finish, can't figure out why.
-- Query --
SELECT
images.iid,
images.locnetid,
images.path,
images.CD,
lightbox_location_image_LINK.iid
FROM
Hi Nils,
So if I su to root and try to start mysql, I get the following... does that
mean I'm secure? I am still finding the very confusing, but doing my best
to look it up on dejanews and in books etc so as to not stress this group
too much.
[root admin]# mysql
ERROR 1045: Access denied for use
The gist; the below query doesn't finish, can't figure out why.
-- Query --
SELECT
images.iid,
images.locnetid,
images.path,
images.CD,
lightbox_location_image_LINK.iid
FROM
images
CROSS JOIN
image_cat_location_link
LEFT OUTER JOIN
li
OK, first of all thanks for the pointers, however, the query I now have
doesn't seem to work. If I run the query up until "pricelevel IN (1, 2, 3,
4, 5)" it returns a large result set (the clauses are fairly inclusive),
however, when I add in the rest of the query no results are returned. Any
ide
4.8-STABLE and linuxthreads-2.2.3_10 and gcc3.2
It's easy for me to reproduce this bug on my system, but I don't know if I could
come up with a simple test case for someone to play with.
Do you compile with the BUILT_OPTIMIZED flag?
--- Jeremy Zawodny <[EMAIL PROTECTED]> wrote:
> On Wed, May
Foreign keys have been available in InnoDB tables since 3.23.43b.
A here's couple of pages to check out:
>From the InnoDB Manual pages:
4.3 Foreign key constraints
http://www.innodb.com/ibman.html#InnoDB_foreign_keys
>From the MySQL Manual:
1.8.4.5 Foreign Keys
http://www.mysql.com/doc/en/A
-->-Original Message-
-->From: Steven [mailto:[EMAIL PROTECTED]
-->RedHat Linux 7.3
-->MySQL 3.23.56, for pc-linux (i686) (same behavior with 4.0.12 as
well)
-->Apache 1.3.27
-->PHP 4.3.1
-->
-->(most (99%) of the MySQL connections are made through PHP scripts
-->running as an apache mod
On Friday, May 30, 2003, at 05:13 AM, Becoming Digital wrote:
My question is: must I manually enter the value from the "people_id"
(primary key of "people table") into the machine_id field of the
"machines table"? My only question here (unless you see others ;) is
must I manually enter these "cor
Hi all,
I have been having a problem with MySQL lately on my machine - I
apologize for the long post. Specs are:
RedHat Linux 7.3
MySQL 3.23.56, for pc-linux (i686) (same behavior with 4.0.12 as well)
Apache 1.3.27
PHP 4.3.1
(most (99%) of the MySQL connections are made through PHP scripts
runn
No, this was perfect. I had totally misread (I figured out after I
bothered everyone!) --it was I had always been taught and as you say.
I hope you have seen my most recent question to the list? About
manually entering the data? The short and sweet answer there be that
someone ALWAYS has to
Hi.
Lately, I've been banging against the glibc 2GB malloc limit - what a
headache. :/
I believe this is not a mysql-specific problem, so a might be a bit off
topic here. Does anyone know of a way to work around this limit? Does
Redhat Advanced Server also have this problem? Or Suse Enterprise?
> 1) Are your users connected temporarely (disconnecing after a certain time) or
> do you stay connected until the server crashes ;-)
Both temporary connections and persistent connections. The number of
connections fluctuates based on the number of simultaneous clients.
> 2) Check your processl
mike wOZniewski wrote:
Hi... silly question maybe.
I want to execute the following query:
mysql_query("SELECT MIN(order), MAX(order) FROM downloads WHERE class='1'");
order is a reserved word.
try:
MIN(`order`), MAX(`order`)
Note use back ticks ` NOT '
...but it doesn't work and gives me a
Hi... silly question maybe.
I want to execute the following query:
mysql_query("SELECT MIN(order), MAX(order) FROM downloads WHERE class='1'");
...but it doesn't work and gives me a SYNTAX ERROR. If I use my 'id' column
(the primary key) instead of the 'order' column, it works fine:
mysql_query
It looks like the maximum precision for a DECIMAL column is 17 in MySQL.
Is this documented anywhere? I get the following results:
mysql> CREATE TABLE `scale_test6` (`a_dec` decimal(30,23) default NULL)
TYPE=MyISAM;
mysql> INSERT INTO scale_test6 (a_dec) VALUES
(12345678.123456789012345678901234
Maximum precision for DECIMAL column in MySQLMatt,
in 4.1 this restriction has been removed:
[EMAIL PROTECTED]:~/mysql-4.1/client> mysql test
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.1-alpha-debug-log
Type 'help;' or '\h' for
This may be a PHP rather than MySQL issue
I'm using 4.0.13 on Windows XP and Apache 1.3.
My phpinfo() shows (among others) QUERY_STRING and REQUEST_URI in the
Apache environment and _SERVER["QUERY_STRING"] with _SERVER["REQUEST_URI"]
under the PHP variables.
On my ISP, who is running W2K/I
Hi
We are running Mysql 4.0.12 on a FreeBSD 4.5 machine. We are
trying to get Request Tracker 3.0 (http://www.bestpractical.com/rt)
working. Each time we start up the mysqld process, it steadily consumes
processor time until it reaches ~90%. This bogs down the computer and
makes the Requ
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Fri, 30 May 2003 11:40:11 +1000, phieu huynh wrote:
>The problem is my netscape browser, somehow the file had been corrupted.
>I just re-download the file by using another computer and I can unpack
>the file.
>
Yes, navigator can be twitchy abou
>> Short answer is mysql does not do sub-selects (i.e., a select inside
>> of a select). The join part is not this issue.
>
> Wouldn't this depend on the version... I thought the newest versions,
> 4.x+, supported sub-selects.
>
> Ryan
>
> __
> Do you Yahoo!?
> Yahoo
Andre Ribeiro Barros <[EMAIL PROTECTED]> wrote:
> I would like to know how to create a new file "mysql.sock", because it was
> deleted of "/tmp" and i perceive that it don't was in the binary file
> tar.gz.
>
File mysql.sock is created when MySQL server is started. So, just start MySQL server
:
Well, I'm running 3.23.54 on Red Hat 7.3. Given this, how in the world do I
accomplish the following:
I have these tables:
dacspriv - with dacspriv_id,dacspriv_name,short_name
users - with user_id,username
dacs_access - with dacsaccess_id,dac
"ian ward" <[EMAIL PROTECTED]> wrote:
>
> I have created a database using Windows XP Professional OS and granted all
> priviliges to a user called rwuser with a specified password. I am
> attempting to access the data in a table through MySQL ODBC 3.51 Driver on
> Windows XP Professional. I h
mtoth <[EMAIL PROTECTED]> wrote:
> This is on a production server and I would rather not stop and restart it.
> Also I don't think HUPing mysqld will make it read my.cnf again.
>
In version 3.23.51 there are very few options and variables that you can reset via SET
command. In your case you need
> Short answer is mysql does not do sub-selects (i.e., a select inside of a
> select). The join part is not this issue.
Wouldn't this depend on the version... I thought the newest versions, 4.x+,
supported sub-selects.
Ryan
__
Do you Yahoo!?
Yahoo! Calendar - Free
I did find out :-)
I had to edit the mysqld in /etc/rc.d/init.d
It's can be done on a linux partition without problem.
;-)
Jean Christophe
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
> O. I've got a headache trying to understand joins. I'm definitely
> NOT a database guru.
>
> Why in the world doesn't this work?
>
>
> SELECT dacspriv_name
> FROM dacspriv
> WHERE dacspriv_id not in (SELECT dacspriv_id
> FROM dacs_access JOIN users
> ON dacs_access.user_id=users.user_id
> WHE
O. I've got a headache trying to understand joins. I'm definitely NOT a
database guru.
Why in the world doesn't this work?
SELECT dacspriv_name
FROM dacspriv
WHERE dacspriv_id not in (SELECT dacspriv_id
FROM dacs_access JOIN users
ON dacs_access.user_id=users.user_id
WHERE users.username='sa
You are going to have to use the backtrace utility (Stackdump analyzer)
see http://www.mysql.com/doc/en/Using_stack_trace.html
Hth,
Martin
- Original Message -
From: "Sakthivel Muthusamy" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, May 30, 2003 10:19 AM
Subject: Replication: M
Hello
I have a MySQL 4.0.3 server with SSL option. I know
that the SSL option is runnish coz when I do show
variables...i am getting the value for ssl to be true
:)
I am writing a C app to connect to the MySQL server to
do some jobs.
I am using the mysql_real_connect() function to
connect. The
How about
SELECT * FROM book WHERE book_prg IN (1, 4, 6) ;
Dies that make any difference?
|-+>
| | "Anthony Ward" |
| | <[EMAIL PROTECTED]|
| | r> |
| |
Nils:
thank you so much for the response. Below are results related to '%time%' from the db
giving 2013 error:
mysql> SHOW VARIABLES LIKE '%time%';
+--+---+
| Variable_name| Value |
+--+---+
| connect_timeout | 30|
Hello
I have two MySQL 4.1 servers installed. One at home
and at my work. Both run WinXP.
I used mysqldump to export my database at work and
tried to import it at my home server, I am getting the
following error in one of the - create table
defintaion
Error Code : 1064
You have an error in your
Hello
If you are on windows then you can try SQLyog at
http://www.webyog.com/sqlyog which has GUI interface
to do just for what you are looking.
Karam
--- Michael Satterwhite <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> Is there a tool for displaying / printi
Hi,
I have to search a big database.
Now there are many categories i.e computerlanguage = C++, Perl,Php,Visual
Basic, C, Javascript.
In my table
C++ =1
Perl = 2
PhP = 3
VB = 4
C = 5
Java = 6
and i have a select statment like this
SELECT * FROM lang WHERE language = 1 OR language = 2 OR language
Hi,
I am getting this "mysqld got signal 11" error and Server process is shutdown. I
am trying to setup replication on two solaris 2.8 sparc boxes. MySql version is 4.0.12.
Anyone else had this experience?. Any help is appreciated.
Thanks
Sakthi.
Hi folk!
I would like to know how to create a new file "mysql.sock", because it was
deleted of "/tmp" and i perceive that it don't was in the binary file
tar.gz.
Thanks for reply!
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://list
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Stephen Fromm wrote:
> It appears that if I try to insert an illegal value into an INT field, the
> value is set to 0 instead of NULL, even though the field has NULL as a
> default.
>
> Is this documented behavior, and if so, what's the rationale?
Ye
Edward,
Thanks, this worked with the field, however it only works in the shell. I am
trying to make it work in a PHP page.
Here is my code, am I doing something wrong?
', 5) FROM table WHERE
start_date <= CURRENT_DATE ORDER BY start_date DESC;";
$response = mysql_query( $substring, $dbh
It appears that if I try to insert an illegal value into an INT field, the
value is set to 0 instead of NULL, even though the field has NULL as a
default.
Is this documented behavior, and if so, what's the rationale?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
Davy Obdam <[EMAIL PROTECTED]> wrote:
> I am trying to run this query:
>
> UPDATE table1, table2 SET table1.periode = table.periode WHERE table1.id
> = 3 AND SUBSTRING_INDEX( table1.name, '.', - 1 ) = table2.name
>
> But i keep getting the same error message
>
> You have an error in your SQL sy
61 matches
Mail list logo
