How come the query
SELECT
CONCAT('"',CONCAT_WS('";"',title,prio,category,program,bugdesc,created,modif
ied,bugstatus,submitter), '"') FROM tbl_bug;
returns something like
"4","4","4"
"10","10","10"
while only
SELECT
CONCAT_WS(';',title,prio,category,program,bugdesc,created,modified,bugstatus
,
> MySQL doesn't support IN and NOT IN. The manual and mailing lists
describe
> alternatives for many cases, but these are less readable (and maybe
slower).
>
I know that this response was directly related to a question about
subqueries, but I think it's important to point this out, because I alm
Hi Kathir,
On Mon, Mar 19, 2001 at 05:38:55AM -, Rama kathiresan kathiresan wrote:
> This is kathir from Uniware Systems, We are developing project on ASP with Backend
>as MySQL, We having a problem using "IN" and "NOT IN" operators in sub query
>
...
> iam selecting the values from 3 dif
The LIMIT is irrelevant. It doesn't work with or without that there.
I put the die(mysql_error) in and the result wasn't very helpful...
I had another suggestion from a person saying to remove the first set of
column names to make the query like this:
$insert_query = "INSERT INTO news VALUES ('
"Jeremy D. Zawodny" wrote:
>
> On Fri, Mar 16, 2001 at 07:39:01PM -0700, Sasha Pachev wrote:
> >
> > Here is what you can do:
> >
> > server1 -> server2-> server3 -> server4 -> server5 ->
> > ^ |
> > |
What's the "LIMIT 0,30" for ?
Also, you should probably do this:
$insert_result = mysql_query($insert_query) or die(mysql_error());
Then you wouldn't need to wait for an answer ;-)
- Original Message -
From: "Ryan Shrout" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, March
Hi all,
Here are two tables I'm working with. I apologize if you
are not using a monospaced font and they are messed up.
This is used by a gradebook program. When a professor adds an assignment to
a class he teaches, it inserts the information about the assignment into the
assignments table,
Okay, another question from the stumbling idiot: what's wrong with this code:
$insert_query = "INSERT INTO news (NewsID, Title, Date, Author, Source, Link,
Information, Status) VALUES ('', 'asdf', '2001-03-19 00:33:47', '1', 'asdf', 'asdf',
'asdf', '2') LIMIT 0, 30";
$insert_result = mysql_quer
Okay, another question from the stumbling idiot: what's wrong with this code:
$insert_query = "INSERT INTO news (NewsID, Title, Date, Author, Source, Link,
Information, Status) VALUES ('', 'asdf', '2001-03-19 00:33:47', '1', 'asdf', 'asdf',
'asdf', '2') LIMIT 0, 30";
$insert_result = mysql_quer
hi,
This is kathir from Uniware Systems, We are developing project on ASP with Backend
as MySQL, We having a problem using "IN" and "NOT IN" operators in sub query
here i am listing my query as follows:
"select c.pickupdate,c.contno, r.relrefno, r.custname, r.contsize, r.conttype,
r.qtybooke
Gaurav Rishiraj Ahuja wrote:
>
> Dear Sir/ Madam,
>
> I just wanted a small help.
>
> I just wanted to know whether MySql supports A.S.P, functions. And if yes, then how
>do we do the connection of the Database, that is D.S.N. Connections (means how to do
>it by going in Control Panel, ODBC C
You cannot create a temporary table as TYPE=MERGE. I have tried it using
both a temporary and a "normal" on-disk table in the UNION paramater without
success. This might be useful to, say, the guy who posted thread "Tuple
length Question" earlier today...:)
I'm sure you can duplicate this on an
Dear Sir/ Madam,
I just wanted a small help.
I just wanted to know whether MySql supports A.S.P, functions. And if yes, then how do
we do the connection of the Database, that is D.S.N. Connections (means how to do it
by going in Control Panel, ODBC Connections, and then what should be do.)
P
On Mon, Mar 19, 2001 at 02:55:17PM +1200, Quentin Bennett wrote:
> Hi,
>
> To be fair to the anonymous writer, the main reason for introducing
> 3.23.25 was
>
> Changes in release 3.23.35
> --
>
>* Fixed newly introduce bug in `ORDER BY'.
>
> Nothing there about 'i
hi,
thanks for the interest. The error log just prints
an incomplete backtrace that is exactly the same after
every crash. I ran the incomplete backtrace through
resolve, and it showed me functions such as thread
start... etc... This is the backtrace that i've been
getting for all the crashe
1) How was it 'installed' Did you use RPMs, the source, or a bindist?
2) Did you make sure mysqld wasn't already running? 'ps auxwww | grep
mysqld'
Mani kandan Ramachandran wrote:
>
> Respected Sir/Madam
>
> While i configure mysql in my RedHat 7.0,it gives problem.And i do not
> know how t
Okie...I have this book on Proffessional PHP PRogramming and in the section of
PHP & SQL Databases they have given this eg. with the CONSTRAINTS optionit
goes like this.
CREATE TABLE authorsofdoc (
docid INTEGER UNSIGNED NOT NULL,
authorid INTEGER UNSIGNED NOT NULL,
constra
here is what happens with my update command:
update GGProfiles set GGProfiles.city = USzipcodes.city where
GGProfiles.zipcode = USzipcodes.zipcode;
ERROR 1109: Unknown table 'USzipcodes' in field list
the USzipcodes table does exist and the name even filled in from a tab
after the U. it has the
I was wondering if someone can help me, I am new to the list and was looking for some
help on how I can use mysql with my website to keep track of who comes in and giving
them logins
I have just read mysql and don't know anything PHP or CGI but if some one tells me how
to incorporate the scri
It's not implemented in MySQL. It's there for compatibility.
In other flavors of SQL, constraints can be placed on relationships to
enforce referential integrity.
Cal
http://www.calevans.com
-Original Message-
From: Duke [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 19, 2001 3:36 AM
T
Respected Sir/Madam
While i configure mysql in my RedHat 7.0,it gives problem.And i do not
know how tro start tha mysql.When i give the command to start th mysql
/bin/safe_mysqld & it gives [1] 1873 and
A mysql process already excist
how to run the mysql program and how i know server is co
Dear All,
I use Mysql for half year. At this moment, I encounter a big problem
that I can not query any data from my server.
The following is my configuration.
Platform: Solaris 2.7 on Sun Ultra2
Mysql version: 3.22.29
Table Name: mailhead;
Record count: 2003478
Status:
mysql> select count(*
In the CREATE TABLE command there is a create_defn. option called ...
CONSTRAINT symbol
what is that for?
and how does that work?
duke.
Website: http://www.ilug-bom.org.in/
Ftp site: ftp.ilug-bom.org.in
Chat: irc.ilug-bom.org.in
Linuxers mailing list: [EMAIL PROTECTED]
http://ilug-bom.org.in/
I've got a problem running :
shell> scripts/mysql_install_db
the error message is:
"didn't find /usr/libexec/mysqld
you should do a 'make install' before executing this scripts"
But when I check in the '/usr' I found the 'libexec'
so what sould I do?
Thanks for the answer.
Nia.
-
Dear Mysql:
when i execute the configure , it always display:
checking for tgetent in -lncurses... no
checking for tgetent in -lcurses... no
checking for tgetent in -ltermcap... no
checking for termcap functions library... configure:
error: No curses/termcap library found
and the last li
Leo,
There's another alternative that I found intriguing with MySQL that I
haven't tried - but it might be a really good solution for you. Mind you I
haven't tried this, but I found the idea somewhat fascinating.
Have you looked into the temporary table functionality of MySQL?
Suppose you have
On Sun, 18 Mar 2001, Tyler Longren wrote:
> Hello, this is how I'm searching a database now...is there an easier way
> (PHP)? Anything that's short would be nice. This is just really long.
>
> $searchgenre = "punk, hardcore, classical, acoustic";
> $formatted_query = str_replace(", ", ",", $se
> Hello, this is how I'm searching a database now...is there an easier way
> (PHP)? Anything that's short would be nice. This is just really long.
You can do something like this:
> $searchgenre = "'punk','hardcore', 'classical', 'acoustic'";
> $sql_text = "SELECT * FROM artists WHERE genre i
Hello, this is how I'm searching a database now...is there an easier way
(PHP)? Anything that's short would be nice. This is just really long.
$searchgenre = "punk, hardcore, classical, acoustic";
$formatted_query = str_replace(", ", ",", $searchgenre);
$genre_array = split(",", $formatted_quer
Hi,
To be fair to the anonymous writer, the main reason for introducing 3.23.25
was
Changes in release 3.23.35
--
* Fixed newly introduce bug in `ORDER BY'.
Nothing there about 'in Innobase and/or Gemini Tables', and for a release
that is declared Stable to have a b
Hi again
No .. not really that big (the table)
-rw-rw 1 mysqlmysql 100916 Mar 16 17:09 imp_addr.ISD
-rw-rw 1 mysqlmysql1024 Mar 16 17:09 imp_addr.ISM
-rw-rw 1 mysqlmysql8648 Mar 9 11:06 imp_addr.frm
100K the ISD
I have the apache, mysql, php bundle for win. I want to use mysql on IIS
though, will this ver of mysql work or do I need to remove this bundle?
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
At 5:16 PM -0800 3/18/01, Todd Markle wrote:
>Recently, I'm having to match against SET columns quite a bit. Is there a
>fast way to create a bitmask of set data?
>
>For example: A user table has interests as set ('ABX','BX','CXX'...)
>I want to select users where interests include ('CXX','NNX'..
Recently, I'm having to match against SET columns quite a bit. Is there a
fast way to create a bitmask of set data?
For example: A user table has interests as set ('ABX','BX','CXX'...)
I want to select users where interests include ('CXX','NNX'...)
Method 1: select them one at a time
SEL
On Mon, Mar 19, 2001 at 12:34:30AM +, vinod p wrote:
>
> my mysql server restarts automatically when the
> machine touches 100% CPU usage. any ideas why?
What does the error log say? Anything?
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878
hi,
my mysql server restarts automatically when the
machine touches 100% CPU usage. any ideas why?
tx.
vinod.
Do You Yahoo!?
Get your free @yahoo.co.in address at http://mail.yahoo.co.in
--
On Sun, Mar 18, 2001 at 06:40:36PM -0500, Travis Gant wrote:
>
> How do you update the contents of a specific field in a database?
> Say I have a column named Name in a table, and a row has the
> contents of that column set to "Jhon". Now, the user accidently
> spelled John wrong and would like t
Hi there,
I have the following problem which i can not solve.
i try to connect access with odbc to mysql.
i have a table:
name
age
id (primary key, auto_increment)
misc (timestamp)
i can connect but the entries are shown as #deleted-
Why?
i have installed the new MDAC!
i have no float fields
How do you update the contents of a specific field in a database? Say I
have a column named Name in a table, and a row has the contents of that
column set to "Jhon". Now, the user accidently spelled John wrong and would
like to update it, how can I do that?
hi there,
is there a problem with importing data into a table with an auto_increment
field with a primary key, if the data contains values for the auto_increment
field?
I keep getting an error that it can't insert the value "1" more than once.
However, all the values for the auto_increment fiel
Hi,
Habe folgendes Problem:
Ich verbinde über ODBC (MDAC 2.5 ist installiert) Access mit einer MySQL
Datenbank.
Ich kann mit der MySQL Datenbank verbinden,
aber die Einträge in der Tabelle werden als
#gelöscht
angezeigt.
Ich habe aber auch kein float Feld.
Habe ein auto_increment, Primary K
On Sun, Mar 18, 2001 at 03:58:46PM -0500, Ryan Shrout wrote:
>
> Could someone explain to me the difference between the
> Primary/Index/Unique attributes of MySQL? I am coming from using MS
> SQL where there is only the Primary key option.
And INDEXed column may have duplicate values in it. A UN
On Sun, Mar 18, 2001 at 03:31:47PM -0500, [EMAIL PROTECTED] wrote:
>
> On 17-Mar-2001 Jeremy D. Zawodny wrote:
>
> >> Er. Is there any way you guys can actually form a stable branch,
> >> and a development branch? It would be nice to get a stable
> >> version of mysql with replication, and that
Hello.
On Mon, Mar 12, 2001 at 05:16:59PM -0600, [EMAIL PROTECTED] wrote:
> Seems like it would be relatively easy to implement inserting into merge
> tables. I'd like to be able to at an absolute minimum round-robin
> insert, but even better would be something like you can do with
> partitioning
Hi
Hope this helps you to make mysql working on ARM architecture, too.
bye,
-christian-
--
Christian HammersWESTEND GmbH - Aachen und Dueren Tel 0241/701333-0
[EMAIL PROTECTED] Internet & Security for ProfessionalsFax 0241/911879
WESTEND ist CISCO Systems Partner -
Readers of the mailing list!
There is a serious bug in the non-latin1 character set support of
Innobase. The bug causes indexes to be sorted in a wrong order, and
queries to return wrong results. The bug explains why test-ATIS returned
wrong results in a Russian installation.
I assumed that the
Could someone explain to me the difference between the Primary/Index/Unique attributes
of MySQL? I am coming from using MS SQL where there is only the Primary key option.
Sorry if this is too beginner of a question for this list.
Ryan Shrout
Athlonmb.com
Production Manager
http://www.athlonmb.
Hallo,
Kann mir irgend jemand helfen?
Ich kann mit der folgenden Meldung nichts anfangen:
Anbei die Datei zum verbinden zur Datenbank:
_
Yes, we're open! Handle: $conn";
} else {
echo "Oops, something goes wrong";
exit;
}
$select = mysql_select_db("cust
Hallo,
Kann mir irgend jemand helfen?
Ich kann mit der folgenden Meldung nichts anfangen:
Anbei die Datei zum verbinden zur Datenbank:
_
Yes, we're open! Handle: $conn";
} else {
echo "Oops, something goes wrong";
exit;
}
$select = mysql_select_db("cust
On 17-Mar-2001 Jeremy D. Zawodny wrote:
> On Sat, Mar 17, 2001 at 06:56:34AM -0500, [EMAIL PROTECTED] wrote:
>>
>> On 17-Mar-2001 Greg Cope wrote:
>> > Michael Widenius wrote:
>> >>
>> >> Hi!
>> >>
>> >>
>> >> Greg> On the off chance any ideas when this (A Gemini THandler) 3.23.x
>> >> releas
Jan Legenhausen writes:
>
> No other messages at all - simply repeating the query _does_ show the
> expected.
> - no message in the error log (...would have mentioned this... ;-)
> - no special thing in the normal log:
> 010318 20:41:44 7 Query alter table t_webmaster change lfd
Hello Greg,
Sunday, March 18, 2001, 9:29:45 PM, you wrote:
>> The only problem I see here - i don't know how innobase/bdb will
>> handle tables without primary key... i think perfomance should not be
>> so good as with myisam. Still there is a possibility to load all data
>> to myisam and then
>
>
> Hi!
>
> I have tested your case and it works just fine for me.
>
> What error message do you get ??
What i wrote was all i got - so there's just
> mysql> update t_webmaster set status=1 where type='Open';
> Query OK, 0 rows affected (0.01 sec)
No other messages at all - simply repeating
Check the manual to make sure, but I believe that you need to also make sure
that the operating system privileges are set correctly too. Not sure what
you'll need in Windows, but in Linux, your hosting company probably runs
MySQL under the user mysql. Thus, for the database to write out the
Jan Legenhausen writes:
> Hi,
>
> i just upgraded from 3.23.33 to 3.23.35 and found that a little script of
> mine which simply modifys a table went mad completly.
> I figured out a testcase which shows at least one of the strange things
> which happen:
>
> Table definition and data:
>
[EMAIL PROTECTED] writes:
> >Description:
> Sorting (ORDER BY in INNOBASE tables) with LIMIT doesn't work
> >How-To-Repeat:
> CREATE TABLE AUTHOR (ID int(7) NOT NULL auto_increment,
> First_Name_ru varchar(250) NOT NULL default '',
> Last_Name_ru varchar(250) NOT NULL default '',
> Fi
Peter Zaitsev wrote:
>
> Hello Greg,
>
> Saturday, March 17, 2001, 3:31:53 AM, you wrote:
>
> GC> It would be very handy if Innobase (and the GEMINI when it comes along)
> GC> where to support mysqldump in the standard way, as I assume it works as
> GC> such and I and many others would have to
On Sun, Mar 18, 2001 at 11:51:39AM +, Peter Skipworth wrote:
> I'd love to see some benchmarks soonish if anyone has/is about to
> compare each of the table handlers for speed and
> stability. Personally I'd love to have row-level locking, but don't
> want to do it if it means lower stability
Has anyone used MySql with the Orion Application Server, I am trying to set up the
following database-schema to allow the server to talk to a simple Mysql database, (I
want to interact with it using ELBs, I have sucessfully used java and JDBC to connect
to the database, but this pieces of xml i
try distinct(column name)
JCampbell wrote:
> I want to know if it is possible to build a MySQL query which will only
> return the unique values of a specific column. Ie if I had this table:
>
> id | name |date___
> 1 | Jon | 2001-01-03
> 2 | Bob | 2001-01-04
> 3 | Jon | 2001-01-05
>
Hi,
i just upgraded from 3.23.33 to 3.23.35 and found that a little script of
mine which simply modifys a table went mad completly.
I figured out a testcase which shows at least one of the strange things
which happen:
Table definition and data:
CREATE TABLE t_webmaster (
lfdnr int(10) unsigne
After upgrading from 3.23.32 to 3.23.35 I stopped getting statistics
(Records: Deleted: Skipped: Warnings:) when using mysqlimport.
I took a quick look at 3.23.32 mysqlimport.c and it is the same code as
3.23.35.
The command
---
mysqlimport --ignore --verbose --fields-terminated-by=',
Hi Peter,
I'm not sure but I don't think it's possible with MySQL. The best you could
do is make sure you have a primary key on the table that is autoincrement.
This will give you a unique number for each row.
RowNum is very subjective since it is describing the row number in the
cursor you are
Hi,
how do I get something like ROWNUM with mysql?
This means, before every row in a result there would be the Number of
the row. I want a result that looks like this:
No | xyz | abc |
---
1| xyz | abc |
2| xyz | abc |
3| xyz | abc |
.
.
.
10| xyz | a
Hi,
you may know the feature
create table xyz select * from xy...
which is similar to oracles select into table.
It works ok, only thing is that with this statement no indices are
created on the new table. Is this a bug?
Have a nice thread,
Peter
-
So sprach Kelly Alexander Zia am Sat, Mar 17, 2001 at 11:08:04AM -0700:
> Warning: Supplied argument is not a valid MySQL result resource in
> c:\phpweb/searchresults1.php on line 462
The database connection is somehow broken.
Alexander Skwar
--
How to quote: http://learn.to/quote (german) ht
Dear Sir :
MySQL 3.22.32 on my linux 486 PC seems work so good. When I compile
a simple C API program which catched from MySQL tutorial, it
chokes at the end of compile process . The program is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def_pa
I prefer persistent connections because you save time not having to rebuild
the connection each time.
As to how, the actual call to mysql_pconnect is buried deep in my framework
and it's kinda hard to explain how I do it. I would NOT suggest that you
store it as a session variable. That kinda d
Dear Sir :
MySQL 3.22.32 on my linux 486 PC seems work so good. When I compile
a simple C API program which catched from MySQL tutorial, it
chokes at the end of compile process . The program is as follows:
#include
#include
#define def_host_name NULL
#define def_user_name NULL
#define def_pa
I am getting the error error: 22 when opening ISAM-table when trying to do isamchk on
sometables
any hint
Issam
Hello All:
I am looking into mysql as a web solution. I am
implementing a multilanguage scheme.
I am considering separating the different languages by the
following three methods.
1. Use different tables to hold different languages.
2. Use the same table with another key (lang).
3. Add ex
Hi,
My web host just upgraded from a version that did not support the BACKUP
TABLE command (3.22.??) to the latest. What I try to execute the BACKUP
TABLE command it fails with an access denied error. He says I have all the
necessary privileges, but I have the feeling something is missing. Whe
Hi,
some of you work with php and mysql to connect a website with a mysql
database.
do u prefer an simple connection or a persistent connection?
and if u prefer the last one. how can u make this connection in the
index.php3?
do u make this with an "./include"?
thanks
regards
denis
>Description:
Sorting (ORDER BY in INNOBASE tables) with LIMIT doesn't work
>How-To-Repeat:
CREATE TABLE AUTHOR (ID int(7) NOT NULL auto_increment,
First_Name_ru varchar(250) NOT NULL default '',
Last_Name_ru varchar(250) NOT NULL default '',
First_Name_en varchar(250) default NULL, Last_Nam
I'd love to see some benchmarks soonish if anyone has/is about to
compare each of the table handlers for speed and stability. Personally I'd
love to have row-level locking, but don't want to do it if it means
lower stability and/or slower basic select/insert queries.
regards,
P
On Sat, 17 Mar
2
-Ursprüngliche Nachricht-
Von: Peter Zaitsev <[EMAIL PROTECTED]>
An: Andreas Vierengel <[EMAIL PROTECTED]>
Cc: Greg Cope <[EMAIL PROTECTED]>; Heikki Tuuri
<[EMAIL PROTECTED]>; [EMAIL PROTECTED]
<[EMAIL PROTECTED]>
Datum: 18 March, 2001 10:35
Betreff: Re[2]: Innobase in MySQL
>
>Could you
-Ursprüngliche Nachricht-
Von: Heikki Tuuri <[EMAIL PROTECTED]>
An: [EMAIL PROTECTED] <[EMAIL PROTECTED]>
Datum: 17 March, 2001 17:35
Betreff: Re: Innobase in MySQL
>Andy,
>
>thank you for your benchmark :). I was also going to measure these,
>but have not had time yet. But what paramete
Hello Christian,
Sunday, March 18, 2001, 12:22:44 PM, you wrote:
>>
>>If you are going to be committing on every record, you'll want your
>>tablespace and logfile directories on separate disks to avoid
>>thrashing. If you only have one disk and don't care if you lose the
>>last few transactions
hey..
thanks for the info...
This is the my.cnf file that i'm using -
[mysqld]
skip-locking
set-variable= key_buffer=640M
set-variable= max_allowed_packet=10M
set-variable= table_cache=640
set-variable= sort_buffer=6M
set-variable= record_buffer=6M
set-variable= t
Hello Andreas,
Saturday, March 17, 2001, 6:36:17 PM, you wrote:
AV> I noticed that in 3. and 4. the machine load was constantly at 100% during
AV> the inserts.
AV> but during index recreation the load springs wildley between 0 and 100%, so
AV> the machine is not maxed out in terms of CPU utili
At 20:43 Uhr -0600 17.3.2001, Dan Nelson wrote:
>In the last episode (Mar 17), Christian Jaeger said:
>> innobase table:
> > autocommit=0, rollback after each insert: 59 insert+rollback/sec.
>> autocommit=0, one rollback at the end: 2926 inserts/sec.
>> autocommit=0, one commit at the e
Hello Greg,
Saturday, March 17, 2001, 3:31:53 AM, you wrote:
GC> It would be very handy if Innobase (and the GEMINI when it comes along)
GC> where to support mysqldump in the standard way, as I assume it works as
GC> such and I and many others would have to change thier backup scripts.
GC> Del
Richard,
On Fri, Mar 16, 2001 at 06:05:52PM -0600, Richard Reina wrote:
> I am try to do a join with tables that are in two different databases.
>
> I thing I've got the actual SQL syntax down:
>
> my $q = "SELECT i.inv_no, i.inv_date,
> c.cust_name
> FROM receivables.invoice i,
83 matches
Mail list logo
