Is it possible to use phpMyAdmin to add new databases (not tables whole
databases) to my website? I ask because currently my host has provided
me with one database and I don't want to mix database tables when adding
new features (such as shopping carts and bulletin boards)? I am new to
MySQL and
Hi,
I used DbTools as Crecio O. Silva mentioned in his mail and I managed to
import Paradox tables to MySQL successfully..
There is still a problem with the imported data which are not imported
correctly because of the Greek chars that appear in the string fields.
Could anyone have a clue how
Hi All,
I am very new with mysql. I have just installed it to Sun OS but there
is a message ERROR 2002: Can't connect to local MySql server thought
'/tmp/mysql.sock' (2).
Does anyone have knowledge about problem and help me?
Regards,
Jim,
Jim Bailey schrieb:
sql, Query
Hark ye experts!
Here I stand an expert grunt.
Trying to understand,
The syntax of constraint.
I was directed to the constraint doc.
And found the constraint doc doth suck.
Here's my ploy, renewed, refined.
Please see if you can help.
To
Hi All,
I am very new with mysql. I have just installed it to Sun OS but there
is a message ERROR 2002: Can't connect to local MySql server thought
'/tmp/mysql.sock' (2).
Does anyone have knowledge about problem and help me?
Regards,
On Wed, Aug 21, 2002 at 03:59:20AM +0100, Donna Robinson wrote:
Filter fodder: query, sql
On Wednesday 21 August 2002 3:03 am, Nathaniel Mallet wrote:
I haven't read Managing and Using MySQL, but I do own (and read cover to
cover) MySQL and mSQL. While it's not a bad book, it's
Hi
I have a problem with privileges on MySql NT 3.23.52. I hope that someone
can provide me with a solution.
If a user has USAGE privileges on the mysql db (*.*), and ALL privileges on
another db (CUSTOMDB) in the system, that user can't login nor can they
access the CUSTOMDB. The error
A couple of weeks ago I came across this error which effectively closed down
our site.
Two things:
(1) I am using Perl DBI to interface mySQL is there any way to effectively
capture such errors and provide an alternate web page? I guess there has to
be, but I experimented with the 'PrintError'
Description:
Replication cannot be started
How-To-Repeat:
Following the set up instructions in section 4.10 Replication in
MySQL of the MySQL documentation
Fix:
Not known
Submitter-Id:
Originator:B.L. Choy
Organization:
MySQL support: none
Synopsis:
Hi. These last days, after some months of running relatively smoothly,
I've been having some trouble with MySQL. Sometimes (yesterday 4 times) it
just goes astray and virtually hangs. Load goes up to +200%, all
connections are occupied and it just doesn't do anything. The only way to
stop it
Too many connections
Is the message you get when all are used up. The limit is about 1000 (Linux)
but can be set higher.
With MySQL you can set a limit for each user. So I would set this to say 100
for each user and 1000 in total.
What courses this is pconnects or threads that will not drop. If
Hope this is the right term ;-)
Background:
I log my radius logs to mysql
I had a problem (self inflicted) with the table where I logged it into.
I copied the files out and recreated the database so that I don't ose to
many logs.
I took the old files .MYDetc and recreated the database on
Dear Friends
I observed the very strange problem with my Mysql , My be this is the feature or I
have not configured it properly
please do tell me the reasons and remedy.
Problem is
I am inserting the fields through VB.
When I insert the record in the table of Mysql . Mysql inserts the
Hi Neil,
after some help from Aron Pilhofer and the online manual I got this
statement
select (to_days(deadline)) - (to_days(current_date))
thanks!! K:)
on 21/8/02 7:58 Uhr, Neil Mansilla at [EMAIL PROTECTED] wrote:
On Wed, 21 Aug 2002, Kai Vermehr wrote:
how can I calculate the
The MySQL database we use is a 4.0.2 source RPM on a RedHat 7.3
MySQL locks tables while they are being updated and unlocks the table
when the update is finished. But sometimes MySQL doesn't unlock certain
tables. And in the process list their is nothing being processed.
Does anybody know why
Hi,
I use LVM (Linux Volume Manager) on my box. The MySQL datadir is mounted
on a specific ext3-formatted logical volume ; thus I am able to make live
snapshots of the database using the LVM snapshot fonctionnality.
Internally, LVM snapshots function by syncing the original partition to
disk
sql, query
I understand I must use InnoDB tables if I plan to use constraints.
If I:
CREATE TABLE TEMP_TEST(A CHAR(2),B CHAR(2))
TYPE = InnoDB;
Well the test table gets created, but it is, according to
SHOW TABLE STATUS, a MyISAM table. How can I set Type to InnoDB
and make it stick.
Hi!
I have 2 tables
Table 'candidate_index' holds information like
firstName,lastName,phoneNumber etc.
Example
id | firstName | lastName | phoneNumber
1 | Peter | Engström | 3236363
2 | John| Smith | 3773737
...
Table 'candidate_skills' holds the skills a candidate have
* Jaskaran Singh
I am inserting the fields through VB.
When I insert the record in the table of Mysql . Mysql inserts
the record properly (very first record) with the contents of the fields
shorter than the length of the field. If I try to insert another
records in the table with length
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Ozgur,
I would make sure that your MySQL server is running. I believe this
problem has been asked many a-time, and should be covered in the
documentation.
HTH,
Bryant Hester
Juxtapose, inc.
Hi All,
I am very new with mysql. I have just
Antoine wrote:
Hi,
I use LVM (Linux Volume Manager) on my box. The MySQL datadir is mounted
on a specific ext3-formatted logical volume ; thus I am able to make live
snapshots of the database using the LVM snapshot fonctionnality.
Internally, LVM snapshots function by syncing the original
Hi.
I have problem.
I would like to upgrad from 3.23.51 on my win98 to 3.23.52 but with innodb
tables 3.23.52 hang on starting. and my win98 goes slowly and slowly.
ctrl-alt-del helps :)
In log i see:
010820 20:20:13 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 2. Aborting!
010820 20:20:13 Aborting
Hi,
According to the documentation, you can use:
FLUSH TABLES WITH READ LOCK
for that.
See http://www.mysql.com/doc/en/FLUSH.html
for details
Well, that seems perfect. I guess I should have RTFM before ;))
Thanks a lot
Antoine.
You seem to havew a leading space in your newuser account.
Juri Nysschen wrote:
Hi
I have a problem with privileges on MySql NT 3.23.52. I hope that someone
can provide me with a solution.
If a user has USAGE privileges on the mysql db (*.*), and ALL privileges on
another db (CUSTOMDB) in the
Hardware?
Operating System and version?
MySql version?
Precompiled, you compiled?
Which compiler?
[EMAIL PROTECTED] wrote:
Hi. These last days, after some months of running relatively smoothly,
I've been having some trouble with MySQL. Sometimes (yesterday 4 times) it
just goes astray and
I am using MySQL version 3.23.11-alpha on Win98. I have created a
database with a table borrower whose description is as follow:
mysql describe borrower;
+---+-+--+-+-+---+
| Field | Type| Null | Key | Default | Extra |
Hardware?
Operating System and version?
MySql version?
Precompiled, you compiled?
Which compiler?
Intel Dual 1Ghz, 1Gb RAM, RedHat Linux 6.2, kernel 2.4.16, MySQL 3.23.52
from rpms (happened the same with 3.23.46). As I said before, this only
happens the last few days, we were running
Hi.
I have problem.
I would like to upgrad from 3.23.51 on my win98 to 3.23.52 but with innodb
tables 3.23.52 hang on starting. and my win98 goes slowly and slowly.
ctrl-alt-del helps :)
In log i see:
010820 20:20:13 C:\MYSQL\BIN\MYSQLD.EXE: Got signal 2. Aborting!
010820 20:20:13 Aborting
Hello y'all,
I guess this is easy, but it is defeating me.
I am having a problem with this query:
$keyword = search;
SELECT * FROM table WHERE field LIKE '%$keyword%'
The problem is I don't want sear or earch but exactly search.
What am I missing?
..
Regards, Robert (Newbie)
Jim, it must be that the innodb parameters aren't set up in /etc/my.cnf.
Case doesn't matter on the type=innodb.
I've set up a tablespace called pracexpr1 that has the following section for
innodb in my my.cnf:
# Uncomment the following if you are using Innobase tables
innodb_data_file_path =
Robert Macwange wrote:
Hello y'all,
I guess this is easy, but it is defeating me.
I am having a problem with this query:
$keyword = search;
SELECT * FROM table WHERE field LIKE '%$keyword%'
Hint, for 'search' in middle of phrase:
SELECT * FROM table WHERE field LIKE '% $keyword %'
Robert,
... WHERE field LIKE '%search%'
means everything that contains search.
Examples: abcsearch, searchabc, abcsearchabc.
But it doesn't mean abcearch, searcabc, searc.
Best regards,
Mikhail.
- Original Message -
From: Robert Macwange [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent:
Use FullText indexing or a REGEXP.
Brian.
- Original Message -
From: Robert Macwange [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 21, 2002 9:18 AM
Subject: Exact word search
| Hello y'all,
|
| I guess this is easy, but it is defeating me.
| I am having a problem
Hello y'all,
I guess this is easy, but it is defeating me.
I am having a problem with this query:
$keyword = search;
SELECT * FROM table WHERE field LIKE '%$keyword%'
The problem is I don't want sear or earch but exactly search.
like % $keyword %;
Roger,
Tuesday, August 20, 2002, 5:34:25 PM, you wrote:
RB Maybe... :)
RB On the other hand:
RB 1) The documentation on max_allowed_packet talks only about transferring
RB data, not storing. (This should be easy to fix.)
Agreed..
RB 2) The mere existence of LONGBLOB and LONGTEXT suggests
Richard,
Tuesday, August 20, 2002, 9:04:05 PM, you wrote:
RU Is it fixed only in MySQL 4.x, or will it be in the next point
RU release of 3.x as well?
No, it wasn't changed in 3.23, only in 4.0.3..
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is
OZGUR,
Wednesday, August 21, 2002, 10:09:06 AM, you wrote:
OG I am very new with mysql. I have just installed it to Sun OS but there
OG is a message ERROR 2002: Can't connect to local MySql server thought
OG '/tmp/mysql.sock' (2).
OG Does anyone have knowledge about problem and help me?
Check
John,
Tuesday, August 20, 2002, 5:27:27 PM, you wrote:
JW Ta,
JW But is it normal to have Temp table bigger than 10meg? And a lot of them?
JW Here is my latest data from STATUS
JW Created_tmp_disk_tables 46598
JW Created_tmp_tables 87839
JW Uptime 81773
JW And I have set tmp_table_cache to
sherzodr,
Wednesday, August 21, 2002, 9:01:44 AM, you wrote:
s If i have a single quote (') inside the /* */ comments,
s it gives me a syntax error. Why?
Because the single quote even in the comments means that quoted string
begun:
http://www.mysql.com/doc/en/Comments.html
--
For
Randy,
Tuesday, August 20, 2002, 7:49:09 PM, you wrote:
RJ in a innodb table type using mysql max
RJ is a begin statement the same as set autocommitt = 0??
Yes.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net
Jim,
Wednesday, August 21, 2002, 2:51:51 PM, you wrote:
JB sql, query
JB I understand I must use InnoDB tables if I plan to use constraints.
JB If I:
JBCREATE TABLE TEMP_TEST(A CHAR(2),B CHAR(2))
JBTYPE = InnoDB;
JB Well the test table gets created, but it is, according to
JB SHOW
You have carriage returns in your data file.
Try adding a 'terminated by' to your load data.
compo guy wrote:
I am using MySQL version 3.23.11-alpha on Win98. I have created a
database with a table borrower whose description is as follow:
mysql describe borrower;
Robert,
when you use the LIKE statement any word that is similar to your desired
search criteria will be selected.
if you desire an exact match then use:
SELECT * FROM table WHERE field = value
Shaun
- Original Message -
From: Robert Macwange [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
On 21 Aug 2002, at 16:27, tibyke wrote:
$keyword = search;
SELECT * FROM table WHERE field LIKE '%$keyword%'
The problem is I don't want sear or earch but exactly search.
like % $keyword %;
But that won't find search if it's at the beginning or end of a
string, or preceded or
At 05:27 PM 8/20/2002 -0400, walt wrote:
I have added this one, thanks.
Hmmm...
When you set up the master database, did you copy all the *.frm, *.MYD, *.MYI
to the slave database?
Ok, after a lot of hair-pulling, I downgraded and used 3.23, and what do
you know, replication worked out fine
I guess this is easy, but it is defeating me.
I am having a problem with this query:
$keyword = search;
SELECT * FROM table WHERE field LIKE '%$keyword%'
The problem is I don't want sear or earch but exactly search.
If you're looking for an exact match, where field will contain NOTHING
Oi, for gentility!
Could inform which the procedure to share the MySql that is in my machine
with the escritorio friends.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I am trying to install MYSQL on Solaris 9 sparc edition. I am using the
following options:
CFLAGS=-O3 -mcpu=v8 -Wa,-xarch=v8plusa CXX=gcc
CXXFLAGS=-O3 -mcpu=v8 -Wa,-xarch=v8plusa -felide-constructors -fno-exceptio
ns -fno-rtti
./configure --prefix=/usr/local/mysql
(filter bypass words - Mysql, sql, query)
Group,
I have just got into a situation in which I need to explore replication and
I know nothing about it. Can any one direct me to specific documentation on
this and maybe a simple tutorial for the greener of us?
Thanks.
* Victoria Reznichenko
RB 3) How can the server know that the max_allowed_packet for
RB _this_ connection
RB (the UPDATE'ing connection) isn't smaller than the
RB max_allowed_packet value
RB for a future SELECT connection? (I could do the UPDATE ...
RB CONCAT(... with
RB
Is their anyway of finding out what queries are causing tmp tables to write
to disk?
Cheers
John Wards
- Original Message -
From: Egor Egorov [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, August 21, 2002 3:40 PM
Subject: Re: Re: temp tables
John,
Tuesday, August 20, 2002,
Hi,
I am looking for dates for new versions and the bug fixes they will have contained.
I am using 4.0.1... however I have a handles leak. I have been told by another source
that this will be resolved in 4.1
My question is, using MyODBC(3.51.03)... Is this a problem with 3.x stable releases
testing mysql list server to see if my posts are recieved
-
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
Hello
I have a compilation problem with MySQLGUI.
I have downloaded ans installed
MySQL using the following version
mysql-3.23.52
Msql-Mysql-modules-1.2219
DBI-1.18
Data-Dumper-2.101
MySQL pass all the tests and work OK.
then MYSQLGUI using the following version
I have a table with around 150 entries in it. I am querying the table with
the fallowing command.
SELECT * FROM guestbook LIMIT 140,9
This is working fine I am getting the last 9 entries but I would like it to
return them in reverse order. Is there a way to do this? I tried this
SELECT * FROM
On Wed, Aug 21, 2002 at 12:30:02PM -0300, Ray da Costa wrote:
Oi, for gentility!
Could inform which the procedure to share the MySql that is in my machine
with the escritorio friends.
I may be misunderstanding you.
If you have a MySQL database on your machine, and you want other
Fifield, Mike wrote:
I have a table with around 150 entries in it. I am querying the table with
the fallowing command.
SELECT * FROM guestbook LIMIT 140,9
This is working fine I am getting the last 9 entries but I would like it to
return them in reverse order. Is there a way to do this? I
I am guessing that it is quicker to join 2 tables based than it is to do 2
selects in a php script
opinions???
Randy
sql,query
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
I ran out of tables that I can join in
one select (31) and rebuilt MySQL with
table_map's typedef changed from ulong
to ulonglong.
First it all worked fine. But after
half a day of not very heavy load strange
things began happening. Indexes got
corrupted. So some of the joins that
worked before
On Wednesday 21 August 2002 10:40 am, Egor Egorov wrote:
Well, loosely...
SET AUTOCOMMIT=0
does not START a transaction, what it does is signal the database that from
now on transactions will be explicit, not implicit. That means you NEED to
have a transaction to get anything to stick in the
All,
I have been using MySQL version 3.23.33 on my Alpha box for quite a
while now. A month or two ago I tried to update to mysql-max-4.0.1 only
to learn that the binary was built on an EV6 processor and would not
work on the EV56 chip.
I could but knowing what a pain it would be for me to
Description:
How-To-Repeat:
Fix:
Submitter-Id: submitter ID
Originator:root
Organization:
MySQL support: [none | licence | email support | extended email support ]
Synopsis:
Severity:
Priority:
Category: mysql
Class:
Release:
Groups,
I have this snippet of code:
$dbh = DBI-connect( dbi:ODBC:${db_name}, $user, $pass)
or DoError(Unable to connect: $DBI::errstr);
#$dbh-debug(2);
$fsql = qq!select empl_no_a, user_ln, user_fn, user_mi, aka,
longname_a, longname_b, longname_c, useaka from activeempsinfo!;
Why use odbc when native drivers are available?
Norris, Joseph wrote:
Groups,
I have this snippet of code:
$dbh = DBI-connect( dbi:ODBC:${db_name}, $user, $pass)
or DoError(Unable to connect: $DBI::errstr);
#$dbh-debug(2);
$fsql = qq!select empl_no_a, user_ln, user_fn, user_mi, aka,
Agreed except in this case what I have to read is a FoxPro database -
(yuck!)
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 21, 2002 11:28 AM
To: Norris, Joseph
Cc: Mysql_List (E-mail); Perl Database (E-mail); Perl Web (E-mail); Perl
Win32 Users
Hi folks,
I was just wondering, where I can see, which queries are used from the bin-log.
I am using a setup with ...do-table so I restricted it but I am not sure if all the
queries
are taken to update the tables.
is there a log where I can see, what was done?
I looked at the relay-log but
Hello,
Having a problem here. I'm trying to get a Mysql 3.23 database from a Red
Hat 7 machine over to a Mysql 3.23 on a Solaris Sparcstation.
I was able to dump the database using the mysqldump command. The database
has 3 tables, and I used the following syntax:
mysqldump -u username -p
I did not have any problem installing mysql ver 3.23.52 on Windows NT
workstation or xp pro, however, on Windows 2000 server mysql service
does not start. When I try to start it I get error 1067-the process
terminated unexpectedly. In all cases I install the software on drive D
and create the
On Wed, Aug 21, 2002 at 11:37:57AM -0700, abw wrote:
Hello,
Having a problem here. I'm trying to get a Mysql 3.23 database from a Red
Hat 7 machine over to a Mysql 3.23 on a Solaris Sparcstation.
I was able to dump the database using the mysqldump command. The database
has 3 tables,
Hello,
See mysql\data\[hostname].err or mysql\data\mysql.err for what might have
gone wrong.
Also, you could try starting your mysqld with the following (not as a
service): mysqld-(max-)nt --console --standalone
Then, if there's something wrong in the error log, you can copy/paste the
last
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Hi there,
On Wednesday 21 August 2002 20:17, Timothy Olden wrote:
I have been using MySQL version 3.23.33 on my Alpha box for quite a
while now. A month or two ago I tried to update to mysql-max-4.0.1 only
to learn that the binary was built on
- Original Message -
From: Franklin Williams Jr. [EMAIL PROTECTED]
Date: Tue, 20 Aug 2002 18:24:52 -0400
To: Joseph Grundy [EMAIL PROTECTED]
Subject: Re: insert command
- Original Message -
From: Keith C. Ivey [EMAIL PROTECTED]
Date: Tue, 20 Aug 2002 16:50:39 -0400
To:
I am a beginner at SQL and would appreciate any help with a simple
query.
I have two tables:
host
patch
The host table contains details for a particular host (OS, cpus, memory, etc)
and the patch table contains patches installed on that host.
For example:
Host:
hostid hostname
On Wed, 2002-08-21 at 15:20, Lenz Grimmer wrote:
That's correct. We build our Alpha binary with the Compaq C/C++ compiler on a
Compaq DS-20, which has an EV6 processor. So far, we only used the compile
option -fast, which by default optimizes for the platform it is currently
running on
What happens when mysql_fetch_rows() returns a valid pointer to free'd memory?
Is this a bug in the library or ??
To reproduce this I'm running freeradius with about 10 different background
test clients repeatively testing a login feature, at the same time running
a script that randomly sleeps
select hostid,patch.patchnumber from host
left join patch on host.hostid = patch.hostid
where patchnumber isnull
-Original Message-
From: Ajay Patel - SunService [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 21, 2002 2:27 PM
To: [EMAIL PROTECTED]
Subject: help with a query
I am
Ajay Patel - SunService wrote:
I am a beginner at SQL and would appreciate any help with a simple
query.
I have two tables:
host
patch
The host table contains details for a particular host (OS, cpus, memory, etc)
and the patch table contains patches installed on that host.
For example:
I need to figure out values in a column of a given table that do not
exist in a a column of another given table without subselects.
For example:
If I have one table called TABLEA with column name id and values
1,2,3,4,5,6,7,
and another table called TABLEB with column name id and values
Hey all, i'm trying to setup a system in which a slave takes over as master in the
case the master dies.
we're using innodb w/ databases of about 500 megs, so scp/rsyncing those every night
is a pretty daunting task, not to mention we can never be sure that the secondary DB
has the most recent
This is copied from http://www.openoffice.org/issues/show_bug.cgi?id=6600
Hi,
I encountered that MySQL only ask for english locale and doesn't work
if this locale is not available. As I remember they only ask for
LC_ENGLISH or something like that. Sorry that I could say more about,
I don't know
Hello.
On Wed 2002-08-21 at 16:49:06 -0400, [EMAIL PROTECTED] wrote:
I need to figure out values in a column of a given table that do not
exist in a a column of another given table without subselects.
For example:
If I have one table called TABLEA with column name id and values
Then it doesn't belong on the MySQl list, does it?
Norris, Joseph wrote:
Agreed except in this case what I have to read is a FoxPro database -
(yuck!)
-Original Message-
From: Gerald Clark [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 21, 2002 11:28 AM
To: Norris, Joseph
Cc:
I just joined this list, so I hope my question is appropriate. I'm trying to
build mysql-3.23.52 on my UltraEnterprise 3500, running Solaris 7. I can't use
a pre-compiled binary because I need to install it in /opt/local rather than
/usr/local. I'm using GCC/G++ 3.2, in /opt/local/bin. My
Yes,
I see that now in the docs and it makes perfect sense. Sorry about that.
My bad.
--Gabe
Benjamin Pflugmann wrote:
Hello.
On Wed 2002-08-21 at 16:49:06 -0400, [EMAIL PROTECTED] wrote:
I need to figure out values in a column of a given table that do not
exist in a a column of
Being fairly new to mysql, I'm trying to do the following and coming up
empty handed.
I'm in the process of writing a set of sql scripts (aka, text files to be
sourced (\.) inside of the MySQL interpreter)
Ideally, I would like to be able to have the following behaviour:
On error, rollback
The following table uses order_id as the primary key. My problem is that I
need to be able to change order_id so that it is not a primary key. Next, I
want to add a new auto incrementing key. What sql commands should I use to
first back up the table and then to accomplish this modification. This
Hi,
I just want to know if mysql can set the output of a certain currency to
this pattern :
$1,500.00
If I use a comma on a certain amount then I add it up to another amount with
a comma I get the wrong
answer. I'm using php mysql by the way.
Any hints on this one?
Regards,
Delz
I definitely fixed some problems when using Foxpro in DBD::ODBC in the
later/latest versions. However, I do not believe that ActiveState has
caught up with me yet. Use search.cpan.org searching for DBD::ODBC to check
the changes information and compare that with the version you are running
now.
Hi,
We want to set quota per user. Is that possible on MySQL ? If so
how can that be done?
Alex
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the
If I have a query like:
select field1 from table where field2=0 order by field3 desc limit 30;
and I have keys:
key field2 (field2)
key field3 (field3)
Will MySQL use one key to select and one to order? Or do I need a:
key field2_field3 (field2, field3)
This is a big table and i don't want
this is a php question, try:
http://www.php.net/manual/en/function.number-format.php
Hi,
I just want to know if mysql can set the output of a certain currency to
this pattern :
$1,500.00
If I use a comma on a certain amount then I add it up to another amount with
a comma I get the
try select * from table where field2=0 order by field3 desc limit 30
I think you need the column to compare.
If I have a query like:
select field1 from table where field2=0 order by field3 desc limit 30;
and I have keys:
key field2 (field2)
key field3 (field3)
Will MySQL use one
Hi,
I have redhat 7.1 and I am using mysql server 3.23.36
and I could login as a user to the linux server and run
mysql program from the command line and connect to database
I want to and do all SQL commands without any problems...
But when I run a program that has
I find myself in the position where I really would like to use 4.0.x in a
production environment where currently 3.23.x is being used. (Mainly because
of the ability of 4.0.x to use indexes on ORDER BY ... DESC, which are
currently just too slow).
What I need to know is how stable can I
Hey, Im trying to create a db on a server (over which I have no
control) and I keep getting this error:
mysqladmin: CREATE DATABASE failed; error: 'Access denied for user:
'@localhost' to database 'musica''
Any suggestions?
Andrew
My homepage
http://www.andrewski.fr.st
Hi
I'm just getting started with mysql so please bear with me. =8-}
I do a 3 table query like:
SELECT a.x, b.y, c.z
FROM a, b, c
WHERE a.b_fk = b.id AND a.c_fk = c.id;
That works so far.
In c can be rows which aren't active anymore.
There is a good_from and a good_until DATETIME field which
I have a table:
CREATE TABLE `single_table` (
`forum_id` int(10) unsigned NOT NULL default '0',
`id` int(10) unsigned NOT NULL auto_increment,
`datestamp` datetime NOT NULL default '-00-00 00:00:00',
`thread` int(10) unsigned NOT NULL default '0',
`parent` int(10) unsigned NOT NULL
On Thu, Aug 22, 2002 at 02:40:54PM +1000, Jerry van Leeuwen wrote:
I find myself in the position where I really would like to use 4.0.x in a
production environment where currently 3.23.x is being used. (Mainly because
of the ability of 4.0.x to use indexes on ORDER BY ... DESC, which are
On Wed, Aug 21, 2002 at 11:57:53PM -0500, Brian Moon wrote:
I have a table:
CREATE TABLE `single_table` (
`forum_id` int(10) unsigned NOT NULL default '0',
`id` int(10) unsigned NOT NULL auto_increment,
`datestamp` datetime NOT NULL default '-00-00 00:00:00',
`thread` int(10)
On Wed, 21 Aug 2002, Brian Moon wrote:
If I have a query like:
select field1 from table where field2=0 order by field3 desc limit 30;
and I have keys:
key field2 (field2)
key field3 (field3)
Will MySQL use one key to select and one to order? Or do I need a:
key field2_field3 (field2,
1 - 100 of 102 matches
Mail list logo
