Terence [EMAIL PROTECTED] wrote on 10/07/2005 03:49:46 AM:
Hi All,
I get a duplicate column error on 5.0.13 when creating a view. Am I
doing something wrong here or do I submit a bug report? This should be
allowed as the col names
are not duplicated.
Reproduce:
create table
Tatjana Cukic [EMAIL PROTECTED] wrote on 10/07/2005 06:07:07 AM:
Hi,
does anybody knows how i can add a new column to
Table1, where new column is made by substracting Col1
from table Table1 and Col2 from Table2. Here is the
synthax:
mysql alter table Table1 add select(x.Col1-y.Col2) as
(please excuse the double post but I wanted to reach the two audiences I
thought could help the best)
This is a question about the interpreting the documentation in the manual
for the C API.
I searched the list archives (all lists) going back 365 days for the terms
(unquoted):
You tried to respond to just one small part of my post. Thank you kindly
for the effort.
However, I am not using a *NIX environment or complier so those directions
are unintelligible to me (I explained that, too). I visited the page you
sent me and that was exactly the kind of information
John, You have just made sense of nearly everything. :-D
I will work with this and let you know if anything else pops up!
ASIDE Hey documentarians! the functions mysql_thread_safe(),
mysql_thread_init(), and mysql_thread_end() are not listed on either one
of the C-API function overview pages
Lefteris Tsintjelis [EMAIL PROTECTED] wrote on 10/07/2005 03:00:29 PM:
John McCaskey wrote:
void *mysql_thread(void *arg) {
mysql_thread_init();
pthread_setcancelstate(PTHREAD_CANCEL_DISABLE,cancelstate);
//regular mysql code and whatever else here
//use
Jonathan Mangin [EMAIL PROTECTED] wrote on 10/07/2005 02:57:28
PM:
I have two tables with date and uid cols. in common.
Table 1 has one row per date, Table 2 has a maximum
of 7 rows per date.
select t1.date, t1.val, t2.val from t1
right join t2 on t1.date = t2.date
where t1.date between
Jonathan Mangin [EMAIL PROTECTED] wrote on 10/07/2005 03:47:48
PM:
- Original Message -
From: [EMAIL PROTECTED]
To: Jonathan Mangin [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Friday, October 07, 2005 2:09 PM
Subject: Re: Joining tables, duplicating none
Jonathan
Donnie Lynch [EMAIL PROTECTED] wrote on 10/06/2005 05:33:01 PM:
Hi,
I'm pretty much an SQL newbie, so apologies in advance if this is
basic stuff. That'll teach me for skipping the databases class in
college...
I just created an app using a table that has entries like this
simplified
Harini Raghavan [EMAIL PROTECTED] wrote on 10/05/2005
11:21:26 AM:
Hi,
I have implemented pagination for the search functionality in my
application. Since I have a lot of data, I thought in memory paging
would not be a good option and opted for paging at the database layer.
To do this I
Jonathan Stockley [EMAIL PROTECTED] wrote on 10/03/2005
08:55:17 PM:
Hi,
We're having a problem with lock wait timeout exceeded errors. We are
exclusively using innodb tables apart from the mysql database. The
problem seems to be with the way we are simulating sequences.
There is a
Andrew Braithwaite [EMAIL PROTECTED] wrote on 10/04/2005 05:39:59
AM:
Hi all,
I have just upgraded a master slave database system from 4.0 to 4.1.
the replication binlogs are now growing at a vastly greater rate. The
queries going through are the same. Did 4.0 use some kind of
Mike Blezien [EMAIL PROTECTED] wrote on 10/04/2005 08:34:56 AM:
Hello,
I am trying to put together a single query from across 4 tables and
not having a
problem getting the results needed. table structure:
##
CREATE TABLE IF NOT EXISTS
Mike Blezien [EMAIL PROTECTED] wrote on 10/04/2005 10:08:24 AM:
Hello,
[EMAIL PROTECTED] wrote:
Mike Blezien [EMAIL PROTECTED] wrote on 10/04/2005 08:34:56
AM:
Hello,
I am trying to put together a single query from across 4 tables and
not having a
problem getting the
Merlin [EMAIL PROTECTED] wrote on 10/04/2005 10:21:00 AM:
Hi there,
I just discovered, that I do have some old rows I do not need anymore. A
result from forgeting to empty the table before starting to go into
production :-)
However, I do try to find the rows which are not asociated with
Merlin [EMAIL PROTECTED] wrote on 10/04/2005 10:58:21 AM:
[EMAIL PROTECTED] wrote:
Merlin [EMAIL PROTECTED] wrote on 10/04/2005 10:21:00 AM:
Hi there,
I just discovered, that I do have some old rows I do not need
anymore. A
result from forgeting to empty the table before
Harini Raghavan [EMAIL PROTECTED] wrote on 10/04/2005
11:17:48 AM:
Hi,
I am using MYSQL 4.1 database in my J2ee application. I am facing
performance issues with some queries that are being run on text fields.
Since MYISAM storage engine does not support transactions(and my
application
You also forgot to mention how you are dumping
Do you see the trailing \r if you run a normal query on the field? Use the
HEX() function and look for the value 0D anywhere in the output.
Are you 100% certain that the \r is not part of your original data? If
you look at your source data
My favorite SQL tutorial: http://sqlzoo.net/
Do your field names need to be globally unique: yes and no. Some design
philosophies require that every field on every table be uniquely
identified. The only uniqueness requirement you must obey is that no two
fields on the same table can have the
Did you try the pipe operator | ?
The command you wrote as an example uses output redirection, close but not
exactly the same.
To use the output of prog 2 as standard input (console input) to prog1,
you would say
prog1 prog2
To sent the output of prog1 to a file or other device
prog1
That's not dumping. That is loading. Dumping is when you put the data INTO
a file.
Does your source data contain the \r\n pair or not?
You seem to be using the default import parameters as you are not
specifying any values that could apply specifically to your data. Please
RTFM for LOAD DATA
Roy Harrell [EMAIL PROTECTED] wrote on 10/04/2005
03:15:33 PM:
Suppose I have a simple table as follows:
PartName Tolerance Cycles
A 1 10
A 2 11
A 3 13
A 4 15
A 5 18
B 1 12
B 2 14
B 3 16
B 4
Jacek,
Your method would only work so long as each PartA, PartB, and PartC all
have the same tolerance numbers. if PartA and PartB had a tolerance of 20
but PartC didn't, your query would not show just the A and B tolerances.
In fact, it wouldn't show a line for Tolerance 20 at all.
The only
C.R. Vegelin [EMAIL PROTECTED] wrote on 10/01/2005 03:51:41 AM:
Hi List,
I want to call the C API functions from Visual Basic in MS Access 2003.
I assume that I have to use: c:\Program Files\MySQL\MySQL Server 4.
1\Bin\LibMySQL.dll.
In my code at module level I have included various code
Replies embedded:
Patrick [EMAIL PROTECTED] wrote on 10/03/2005 03:43:20 PM:
There are many ways to approach this. How are you receiving the IP
data? Are you reading a file or other stream or are you trying to
process the table creation by reading a column from a previously
populated
Jeff Pflueger [EMAIL PROTECTED] wrote on 10/03/2005 03:46:09 PM:
Hi,
I need to encrypt data as I insert it into a mySQL database.
The data will then be sent as a text file to another institution to be
decrypted.
I am using mySQL version 11.18 Distrib 3.23.58 for RedHat Linux.
I cannot
Barry [EMAIL PROTECTED] wrote on 10/03/2005 04:38:48 PM:
I'm new to MySQL and am using version 4-1-12a on my development
machine locally this query works just fine:
SELECT * FROM actor
WHERE id IN
( SELECT id FROM episode_cast
WHERE episode_number =001)
but when
John Berman [EMAIL PROTECTED] wrote on 09/29/2005 06:05:42 PM:
Hi
We have a database on MySql 4 and it contains many tables. In each field
in
the table in the past were there was no data to display we simply left
the
field blank, we now want to replace a null entry with No Data
I
Rob Agar [EMAIL PROTECTED] wrote on 09/29/2005 08:27:37 PM:
hi Scott
How do I run more than 1 queries in MySQL Query Browser?
The only way I've found is to put the queries in a .sql file and load it
via File Open Script. It doesn't accept multiple typed in queries,
even if they are
Tony Leake [EMAIL PROTECTED] wrote on 09/29/2005 07:08:24 AM:
Hi
I have 2 applications communicating via a mysql database
the db is 4.1.8 running on a debian linux system.
All tables are innodb
app 1 1 runs on a windows machine, is written in c# and talks to the db
with odbc
app 2
Jeff [EMAIL PROTECTED] wrote on 09/29/2005 08:47:52 AM:
Jeff wrote:
Ugh...
mysqladmin -uroot -ptelaurus processlist | grep -c Sleep
And it returned 200 sleeping connections, all persistant
connections
from our app servers and 4 threads_running
Also a show status gave me
Nuno Pereira [EMAIL PROTECTED] wrote on 09/29/2005 11:15:08 AM:
[EMAIL PROTECTED] wrote:
Tony Leake [EMAIL PROTECTED] wrote on 09/29/2005 07:08:24 AM:
Hi
I have 2 applications communicating via a mysql database
the db is 4.1.8 running on a debian linux system.
All tables are
Nick Hird [EMAIL PROTECTED] wrote on 09/29/2005 05:03:53 PM:
Is there a way to have foreign keys and force referential integrity? I
have
a main table and a lookup table, i want to be able to require that the
main
table is using values from the lookup table. I am just not sure how in
MySQL.
Hassan Schroeder [EMAIL PROTECTED] wrote on 09/28/2005 11:58:35 AM:
Wolfram Kraus wrote:
can we execute shell commands inside mysql client
Use \!
Whoa. I didn't know that. Is that controlled in any way by GRANT?
Or by conf/startup options?
It seems like something you might
Chance Ellis [EMAIL PROTECTED] wrote on 09/28/2005 11:56:53 AM:
I am sure this has been asked before but I can't seemed to find it.
Canyou create table names with periods in them? I need to create tables
based on the IP address of machines (x.x.x.x) Currently, Mysql is puking
on
format.
Jeff [EMAIL PROTECTED] wrote on 09/28/2005 02:24:48 PM:
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 28, 2005 13:06
To: Jeff
Cc: mysql@lists.mysql.com
Subject: Re: MyISAM to InnoDB
Jeff wrote:
Cut orignal thread because it
Robert Citek [EMAIL PROTECTED] wrote on 09/28/2005 04:01:33
PM:
On Sep 28, 2005, at 2:37 PM, Sujay Koduri wrote:
I don't know how far this is going to help you. But this is what we
are
following to migrate from Oracle to MySQL.
If we were migrating, that's probably the strategy that
Jason Ferguson [EMAIL PROTECTED] wrote on 09/26/2005 10:58:02 PM:
Many thanks for the earlier response to why LOAD DATA INFILE wasnt
working
for me. However, another problem has appeared.
In the file I am reading, 2 of the fields are SUPPOSED to be float
values.
However, in several
Jigal van Hemert [EMAIL PROTECTED] wrote on 09/27/2005 03:35:59 AM:
Mysql Lists wrote:
I'm hoping they get replication setup by diffs, only sending the
diffs
that are tracked from the master.. replicated to the slave.. That
would
be sweet :)
On 9/27/05, *Jigal van Hemert*
Bulent [EMAIL PROTECTED] wrote on 09/27/2005 04:19:56 AM:
Hello
I am a novice about mysql
I use mysql4.0.24 with php4.3.10.
When I upload jpeg/gif files to my webpage I get an error as below;
PHP Warning: mysql_close(): supplied resource is not a valid MySQL-
Link resource in
Neven Luetic [EMAIL PROTECTED] wrote on 09/27/2005 05:02:58 AM:
Hello,
I have a database scheme, containing a table, whichs content should be
unique across all databases with this scheme (on several servers as
well).
It would be possible to define one database, in which all changes
[EMAIL PROTECTED] wrote on 09/27/2005 06:47:50 AM:
Hi,
We are using the same set of query's what we re using in some
other process, where the mysqld CPU utilization is minimum. But for this
process particularly, mysqld is utilising more than 90 % of CPU. Even in
2GB RAM
Neven Luetic [EMAIL PROTECTED] wrote on 09/27/2005 09:35:04 AM:
Within a single server, you only need one copy of a table in one
database. When you need data from it, just use the table's
fully-qualified name and it won't matter which other database you are
currently in (assuming that
Scott Hamm [EMAIL PROTECTED] wrote on 09/27/2005 11:25:15 AM:
While I try to install MySQL 5.0 and start it as QCDA server, and upon
execute it could not start service during MySQL Instance Configuration
Wizard on Windows 2000 Pro. The older and removed Mysql are set disabled
in
services
Scott Hamm [EMAIL PROTECTED] wrote on 09/27/2005 03:00:00 PM:
MySQL 5.0 was installed up to the point where I tried to start it in
Instnace Configuration wizard. It won't start at all even mysqld and
mysqld
--safe-mode
I'm getting frustrated -- hosed hard drive, reinstalled Windows 2000
Claire Lee [EMAIL PROTECTED] wrote on 09/27/2005 03:48:11 PM:
I need to order a few names by the number following
the main name. For example swap2, swap3, swap10 in the
order of swap2, swap3, swap10, not in swap10, swap2,
swap3 as it will happen when I do an order by.
So I came up with the
梁增辉 [EMAIL PROTECTED] wrote on 09/26/2005 09:24:11 AM:
mysql,您好!
I can't find any information about - How to create database
link in MySQL. Can YOU help me please.
致
礼!
梁增辉
[EMAIL PROTECTED]
2005-09-26
What problem are you trying to solve that you
[EMAIL PROTECTED] wrote on 09/26/2005 11:50:11 AM:
Hi,
When running a process which is a part of my apllication,
mysqld.exe is using 90%-95% of cpu utilization. Here I used mysqld for
starting the mysql server. For other processes in the application, CPU
utilization is very minimum.
Scott Hamm [EMAIL PROTECTED] wrote on 09/26/2005 01:59:52 PM:
How do I set Index to enforce that ONLY 1 QAID can own that order
number,
but nothing else?
For example:
QAID [order] ErrorType
11223 123456789 19 'ALLOWED TO HAVE different ErrorTypes as long as one
QAID
number uses it.
Scott Hamm [EMAIL PROTECTED] wrote on 09/26/2005 02:21:38 PM:
On 9/26/05, [EMAIL PROTECTED] [EMAIL PROTECTED] wrote:
Scott Hamm [EMAIL PROTECTED] wrote on 09/26/2005 01:59:52 PM:
How do I set Index to enforce that ONLY 1 QAID can own that order
number,
but nothing else?
Clyde Lewis [EMAIL PROTECTED] wrote on 09/26/2005 02:44:40 PM:
Guys,
Our production database had a table that was suddently dropped a
mystery. I need to find out if there is a way to find the user account
that performed this function. No one is taking ownership and I need to
know if
Ananda Kumar [EMAIL PROTECTED] wrote on 09/23/2005 05:25:10 AM:
Hi Friends,
Any help on this is highly appreciated.
regards
anandkl
On 9/23/05, Ananda Kumar [EMAIL PROTECTED] wrote:
Hi Friends,
I have set up all the drivers and configured the Hetrogenous service
in
oracle and
Sorry to butt in but I wanted to make sure you didn't do actually do what
you proposed to do, yet. More responses interspersed...
Jeff [EMAIL PROTECTED] wrote on 09/23/2005 08:32:57 AM:
-Original Message-
From: Devananda [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 22,
Jeff [EMAIL PROTECTED] wrote on 09/23/2005 09:57:06 AM:
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, September 23, 2005 09:40
To: Jeff
Cc: mysql@lists.mysql.com
Subject: RE: MyISAM to InnoDB
Sorry to butt in but I wanted to make
Jeff [EMAIL PROTECTED] wrote on 09/23/2005 11:36:01 AM:
rest of thread snipped
Is that the only diff (other than the select count(*) thing) between
InnoDB and MyISAM? Aren't select statements faster from MyISAM tables
than from InnoDB's?
There's also been a statement from our lead
DJ [EMAIL PROTECTED] wrote on 09/23/2005 12:22:58 PM:
i want to insert a row into table1 only if the value being inserted on
table1 exists on table2 primary id.
can i do this with subquery?
thanx.
--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version:
bruce [EMAIL PROTECTED] wrote on 09/23/2005 12:24:25 PM:
hi...
i've been lloking over various open source apps to get a feel for how
the
apps store and manipulate information as it's stored in the mysql db...
i see some apps that put 's around strings that get stored in the db,
as
well
DJ [EMAIL PROTECTED] wrote on 09/23/2005 12:49:35 PM:
[EMAIL PROTECTED] wrote:
DJ wrote on 09/23/2005 12:22:58 PM:
i want to insert a row into table1 only if the value being inserted on
table1 exists on table2 primary id.
can i do this with subquery?
thanx.
Depending
Well, Gordon, looks like you missed the thread. ;-)
What's happening is that DJ wants to add records to a table only if
another table has a certain record in it. I have been trying to convince
him to set up a FOREIGN KEY between the two. Since he didn't give any
real table name I will have
bruce [EMAIL PROTECTED] wrote on 09/22/2005 09:15:56 PM:
hi...
from the docs... it appears the the mysql_real_escape_string function
(from
php) is used to backslash a set of chars in the string for insertion
into
the mysql db...
however, given that the '/' is mysql, vs ansi, i was
Randy Paries [EMAIL PROTECTED] wrote on 09/21/2005 08:56:13 AM:
Hello,
My log file is getting filled with these.
Can someone tell me what these mean?
Thanks
Randy
//-snip-//
050122 20:28:00 Aborted connection 53561 to db: 'unitnet'
John McCaskey [EMAIL PROTECTED] wrote on 09/21/2005 01:25:24 PM:
Ok,
So I had another developer come to me today complaining mysql wouldn't
set a column to NULL. I figured out it was because instead of comma
delimitating his fields to SET he was delimiting with AND, however mysql
took
Martijn Tonies [EMAIL PROTECTED] wrote on 09/21/2005 01:56:16 PM:
Uninstall, reinstall.
That will not work !! MySQL doesnt delete an existing database. No
offense, but you should have known better as professional.
--skip-grant-tables is what the original user wanted to know.
Devananda [EMAIL PROTECTED] wrote on 09/21/2005 03:07:53 PM:
[EMAIL PROTECTED] wrote:
John McCaskey [EMAIL PROTECTED] wrote on 09/21/2005 01:25:24 PM:
Ok,
So I had another developer come to me today complaining mysql wouldn't
set a column to NULL. I figured out it was because
Gerald Williams [EMAIL PROTECTED] wrote on 09/20/2005 10:49:22 AM:
MySQL 5.0.12, P2P Microsoft network
I cannot get the manual's instructions (24.1.9.6) to work for
connecting from a mysql client on a windows machine to a mysql
server running on another windows machine (xp and w2kpro
I know I sent this once Was my advice useful or not?
translated by http://babelfish.altavista.com/tr
Sé que envié esto una vez ¿Era mi consejo útil o no?
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
- Forwarded by Shawn Green/Unimin on 09/19/2005 10:20 AM
Miguel Cardenas [EMAIL PROTECTED] wrote on 09/19/2005 12:13:47 PM:
Hello
Have you try :
select count(*) from mytable where id=x and list=something
if count ==0, it's like fetchrow==NULL from your solution, but without
all the fuss about use_result();
No, but looks fine, I didn't
Vicente [EMAIL PROTECTED] wrote on 09/16/2005 07:45:22 AM:
Hola,
Tengo una base de datos realizada con MySQL y desearía generar informes
mediante Crystal Reports XI. Al intentar conectar a MySQL via ODBC
3.51.10
me sale el siguiente error:
Logon Failed
Details: ADO error Code 0x8000fff
Phong Nguyen [EMAIL PROTECTED] wrote on 09/15/2005 10:56:57 AM:
All,
Could you please tell us what are the differences
between ORACLE SQL plus and MYSQL SQL? We developed
application using ColdFusion with Oracle. Now I like
to point my application to mysql database. How do I
fix my
Ananda Kumar [EMAIL PROTECTED] wrote on 09/15/2005 10:33:16 AM:
Hi,
How can i connect from MYSQL db to an oracle database. Do we need to
create
any database link or use some ODBC.
Please help
regards
anandkl
The only way to get one MySQL database server to directly manage data in a
No. You will need to use an application external to the server to perform
the data collection process. This application can be one you write
yourselves or something you purchase. There are many ways to perform
things on a schedule:
a) you application continuously runs and performs certain
Yes, you can use the same process. You will need to modify your existing
code so that you get the data from Oracle and write it to MySQL. You will
be able to reuse most, but not all, of your existing script. Those
portions that connect to your destination server and write data into the
N. Kavithashree [EMAIL PROTECTED] wrote on 09/14/2005
02:07:01 AM:
hello
i hv one query as explained below :
Table FIRST contains
This is
What is this
how
whom
color
white
Table SECOND contains
WHOM
THIS IS
WHAT
WHITE AND BLACK
i want the result as
This is
what is
Eli [EMAIL PROTECTED] wrote on 09/14/2005 10:13:57 AM:
Hi,
Is it possible, or probably will be possible, to define indexes spanned
on more than one table?
I mean that if I have column col_a from table tbl_A, and col_b from
table tbl_B.. Can I define a KEY with both those columns? Where
Schalk [EMAIL PROTECTED] wrote on 09/14/2005 09:31:23 AM:
Greetings
Is there a way to get the last update date for an entire table not just
a single row? More specifically, is there a way to do this with Java?
--
Kind Regards
Schalk Neethling
Web
Ryan Stille [EMAIL PROTECTED] wrote on 09/13/2005 08:42:05 AM:
Josh Chamas wrote:
Ryan Stille wrote:
Has anyone ever used this MSSQL-to-MySQL converter? It's pretty
reasonable at $40, and the demo output I got looked pretty good. But
I wanted to see if there is anything I should be
Kenji HIROHAMA [EMAIL PROTECTED] wrote on 09/08/2005 08:54:58 PM:
Hi,
Does somebody point me out where I should refer to understand what is
row level replication implemented in 5.1?
I should have read the source comments in the source tree, but the bk
port is closed at my environment.
Filipe Tomita [EMAIL PROTECTED] wrote on 09/09/2005 04:37:01 PM:
Hi people,
I having problems to import a dump generated via mysql dump in mysql
4.0.20slackware version to a mysql
4.1.14.
The dump generated with other table name (Insert into temp, temp2 ,
temp3)
in 20 sql large (420mb.)
RTFM - It is online, it has an index, and it is searchable:
http://dev.mysql.com/doc/mysql/en/select.html (hint: look for the phrase
how many rows on this page)
If you looked in the index for rows, you would find the function
ROW_COUNT() (which is close but not exactly what you wanted).
Then eliminate the subquery and SQL_CALC_FOUND_ROWS will be an option for
you again. If you would like some help refactoring your query, I
volunteer. If I can't help, I know there are several others on the list
just as capable as I (or more so).
Shawn Green
Database Administrator
Unimin
Shaun [EMAIL PROTECTED] wrote on 09/06/2005 03:47:25 PM:
Hi,
Given two dates, can Mysql calculate and return all the dates that occur
between them?
Thanks for your advice.
Given any two dates, MySQL can tell if a third date is within that range.
That's easy.
To actually return
Arno Coetzee [EMAIL PROTECTED] wrote on 09/02/2005 04:37:48 AM:
shuming wang wrote:
Hi,
Could we do a database dump/backup in a query like below ?
mysqldump.exe --default-character-set=gb2312 --opt --host 192.168.0.1
-u root -p -C mydbmydbfile
or restore a database in a query like
[EMAIL PROTECTED] wrote on 09/02/2005 08:46:59 AM:
Hi,
i have a file which i need to import in about 7 tables. For this reason
i need toimport only parts of this file into each of the tables.
Is there a way to do this with LOAD DATA INFILE or what would be the
preferred way with just
Barbara Deaton [EMAIL PROTECTED] wrote on 09/02/2005 11:33:19 AM:
I need help re-writing a query.
When accessing DB2 I can execute the below:
delete from DM_KOHLS.clr_plan_price_change_metrics A
where A.start_dt= Date( '05/15/2005' ) and
exists ( select *
Barbara Deaton [EMAIL PROTECTED] wrote on 09/02/2005 01:07:00 PM:
I apologize for not providing more information. I am currently
using 4.1.8 client and server on windows xp.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Friday, September 02,
Joe, you are not used to using a command line interface, are you
When you do a START - RUN - cmd enter, you are entering the world of
computing that exists outside of Windows (have you ever heard of DOS?).
What you are in is called a shell and on windows it's called the
command shell
Klemens Ullmann [EMAIL PROTECTED] wrote on 09/02/2005 07:37:43 AM:
hello!
I've got two tables for an IT hardware inventory:
### table inventory:
invid model
---
1001 HP Notebook// no attributes
1002 Dell Desktop // only one attribut 'pc-name'
1003 Acer
Answers blended in
YL [EMAIL PROTECTED] wrote on 09/02/2005 04:18:27 PM:
I've 2 basic questions. thanks for responses:
(1) Suppose i have a table with a varchar colum named options which
stores
option id's in the form
(id1, id2, , idk), where id1,... are string
Shaun [EMAIL PROTECTED] wrote on 09/01/2005 05:38:01 AM:
big snip -- see earlier posts in this thread for details
The corrected query should read:
SELECT m.name as month, YEAR(b.Booking_Start_Date) as year,
COUNT(b.Booking_ID) AS Num_Bookings
FROM monthList m
LEFT JOIN Bookings b
JM [EMAIL PROTECTED] wrote on 09/01/2005 06:01:57 AM:
Hi all,
Ive read this link http://dev.mysql.com/doc/mysql/en/gone-away.
html hoping
this has something to do with the error...
Ive already checked based on the page the list of roots of error
to produce
gone-away.. w/c i
Vladimir B. Tsarkov [EMAIL PROTECTED] wrote on 09/01/2005 06:16:12 AM:
Hello!
I've heard that LIMIT is a MySQL specific, and cannot be used in any
other
DBMS. Is there any portable alternative to LIMIT? I'd like to create a
portable PHP pager for a web site, but all the tutorials that
dEeZAcK SweETtY [EMAIL PROTECTED] wrote on 09/01/2005 10:27:28
AM:
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: cannot create
(please, either top-post or bottom-post but don't mix it up)
One way to bypass a broken DNS server is to create complete HOSTS files on
your servers. That way you can keep using your hostnames but avoid the
problems of actual DNS server negotiations going sour as all hostname to
IP address
I don't know how your OS does it or what you need to do to use it, but if
I have a file called HOSTS in my (c:\winnt\system32\drivers\etc\ directory
(each OS has a similar location for this file)) that contains a list of
hostname - IP address pairs then whenever I attempt to do a hostname
If you are NOT in autocommit mode, your connection (or the server, it
doesn't matter which) starts a transaction *when you issue your first
command*. Every command you issue on that connection is in that initial
transaction until you EXPLICITLY commit or rollback (or do something else
that
Nick Jones [EMAIL PROTECTED] wrote on 09/01/2005 03:18:39 PM:
--- J.R. Bullington [EMAIL PROTECTED] wrote:
Automatically populate??
Not that _I_ know of, but of course there are those
on this list that know
much more than I.
I do know that you can export the values into
Bill Duffy [EMAIL PROTECTED] wrote on 08/31/2005 11:32:02 AM:
When I run a query like this
DELETE FROM test_P_Cookie WHERE ViewID IN (SELECT ViewID FROM
test_x_RM_4508_48875 )
it never completes.
test_x_RM_4508_48875 contains 180139 rows. test_P_Cookie contains
22,957,702
rows.
Berman, Mikhail [EMAIL PROTECTED] wrote on 08/31/2005 12:35:19 PM:
Hi everyone,
I am trying to load backup files into a database using a small script
where an actual load command is:
/usr/local/bin/mysql -ux -p -f secdocs -v -e source $dir2
and it is a part of loop that reads
Shaun [EMAIL PROTECTED] wrote on 08/31/2005 02:43:33 PM:
Hi,
This query counts the number of entries in the Bookings table per month,
is
it possible for this query to return a zero where there are no entries
for a
particular month?
SELECT COUNT(Booking_ID) AS Num_Bookings
FROM
Shaun [EMAIL PROTECTED] wrote on 08/31/2005 04:04:20 PM:
[EMAIL PROTECTED] wrote in message
news:[EMAIL PROTECTED]
Shaun [EMAIL PROTECTED] wrote on 08/31/2005 02:43:33 PM:
Hi,
This query counts the number of entries in the Bookings table per
month,
is
it possible for this
401 - 500 of 1587 matches
Mail list logo