On 15-Mar-2003 Mr Orange wrote:
> Hello all : )
>
> Can anyone offer any advice on how to achieve the following with SQL?
>
> Say I have a table.
>
> CREATE TABLE page (
> pgposition int(6) not null,
> pgelement char(20) not null default '',
> pgsize int(4) not null default '0'));
>
I just recently installed MySQL and when I try and connect I get an
error 1045, Access Denied for user. I am running 3.2.55-nt with
local host via TCP/IP on W2000.
I think it has something to do with the local host, because the error
message returns my [EMAIL PROTECTED] rather than just the
On 15-Mar-2003 Sime wrote:
> Andrew wrote:
>> can you explain how I would do this tracking?
>>
>
> Hi Andrew,
>
> Try building the query to a variable first, then output the variable to
> see
> if what MySQL is receiving is what you expected..
>
> eg,
> $querystring="select * from mytable;";
Gelu Gogancea wrote:
You make confusion between terms, CONCEPTS and TECHNOLOGIES.Is not yet
invented the tools which should THINK instead of our BRAIN when must design
a system...any kind of.
You are mistaken if you think that I am confused about this.
There are RDBMS's out there that support
often, mysql in web services, there're many situation make a mysql
connection idle
for example: after php open mysql_pconnect(), finished a request, http
start keep-alive
or service other pages/images which do not require mysql connection
however, the connection is still there, counted as "connec
hi,
access-2000
w2k-prof/xp-prof via
myodbc 3.51
different mysql-servers (win-lin)
if i leave ms-access longer than 25 minutes alone with mysql via myodbc 3.51
i cannot close ms-access:
- free translation:
"this procedure will put the current code back into the interruption
mode. would you like
At 15:58 -0600 3/15/03, Mike Blezien wrote:
Hello all,
we will be upgrading our current MySQL version 3.23.40 to 3.23.55,
compiled from source. We've always had good luck on our machine
compiling from the source as opposed to using binaries.
my question is, I was told, that using the
"--enable
It is probably looking for a socket file that doesn't exist. Check to see if
it does. Also check to see if DB server is running.
Bhavin.
- Original Message -
From: "Jose" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, March 15, 2003 3:03 PM
Subject: Warning: mysql_select_db()
Hello all,
we will be upgrading our current MySQL version 3.23.40 to 3.23.55, compiled from
source. We've always had good luck on our machine compiling from the source as
opposed to using binaries.
my question is, I was told, that using the "--enable-thread-safe-client" when
compiling was a go
Okay, got the system up and running locally. The programmer wants to be
able to access the MySQL server via the internet. We have MySQL
installed on a Linux server, this sits behind a firewall with port 3306
opened. The programmer has phpMyAdmin installed on his laptop (Widows
XP Pro). We keep g
I get this error after upgrade my server aix 4.3.3.10 to 4.3.3.11:
Warning: mysql_select_db() [function.mysql-select-db]: Can't connect to
local MySQL
server through socket '/var/lib/mysql/mysql.sock
Any one can tell me what could be the problem ?
Thanks.
In the last episode (Mar 15), Jesse Guardiani said:
> From: "Warren W. Gay VE3WWG" <[EMAIL PROTECTED]>
> > The OP didn't indicate where the files are being kept, and under
> > FreeBSD this can be significant. I know for example, that using UFS
> > file systems, are very slow compared to newer file
Just a simple point on security. The current stable versions of 3.23.x don't
encrypt passwords or data. Thus you would be logging in unencrypted and
sending all data unencrypted. If this is just a dev box and you don't care
about the data then it probably isn't a big deal. If it's a production box
Hi!
On Mar 14, Maarten LITMAATH wrote:
> Sergei Golubchik wrote:
>
> >On Mar 12, Maarten LITMAATH wrote:
> >
> >>>Description:
> >>
> >>MySQL (e.g. version 4.0.10-gamma) does not check for buffer overflows
> >>when formatting error messages: the code just assumes that no message
> >>will ever be
thank you all for the help!
best
Murad
Dan Nelson wrote:
>
> In the last episode (Mar 14), Murad Nayal said:
> > how can I force mysql interactive client (actually the client library as
> > well) to use a TCP port on the local host
> >
> > if I do:
> >
> > mysql -h localhost -u user -p --port=
Charles-
OK, let's say a person has `n' interest id entries in
tbl_people_interests. It seems like you're wanting a result set with
one row per person and (n + 2) (assuming you're selecting first and
last name with the interests). I'm no UEbergeek with respect to SQL,
but I don't think there's
Jeff,
Thanks. This is ALMOST doing what I need.
Suppose that the person could have from 0 - 5 records in
tbl_peoples_interests and I need to have each one of those interests as
a different name so I can use it in my PHP form?
Thanks,
Charles
On Saturday, March 15, 2003, at 11:30 AM, Jeff Kil
At 8:37 -0600 3/15/03, [EMAIL PROTECTED] wrote:
I have a table called animals (using the example in the MySQL guide). I have a
datetime column type.
Here is the table:
Looks like it's called bug_master, not animals. :-)
create table bug_master (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
Charles-
So, you have a table unique with respect to people (a person appears at
most once), and a table with interests (some number of interests are
associated a person in the first table. This is a one-to-many
relationship. You need to join on the person in the first table.
Something like
SE
Hi all,
My first post to this list.
I have a query which I can't quite get to work. I was hoping that
someone here could educate me a bit. I have two tables.
tbl_people
| id| fname|lname|
---
| 1 |frank |smith |
t
- Original Message -
From: "Warren W. Gay VE3WWG" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, March 14, 2003 4:45 PM
Subject: Re: FreeBSD + MySQL bottleneck
> The OP didn't indicate where the files are being kept, and under FreeBSD
> this can be significant. I know for exa
I have a table called animals (using the example in the MySQL guide). I have a
datetime column type.
Here is the table:
create table bug_master (
id MEDIUMINT NOT NULL AUTO_INCREMENT,
name CHAR(30) NOT NULL,
date DATETIME NOT NULL,
PRIMARY
Andrew wrote:
> can you explain how I would do this tracking?
>
> My code looks exactly like this:
>
> mysql_connect("$DBHost","$DBUser","$DBPass");
> mysql("$DBName","UPDATE items
> SET ItemSKU='$ItemSKU',
> ItemName='$ItemName',
> ItemDescription='$ItemDescription',
> PostCode='$PostCode',
> Cate
Dear sir/Madam
I am a mysql developer and want to keep myself updating the events with
MySQL.
Thanking You
Regards
Amit Prakash
Software Engineer
Savitr Software Services (P) Ltd.
Hyderabad
-
Before posting, please check:
htt
can you explain how I would do this tracking?
Andrew
>Subject: Re: Updat not Updating
>
>
>If this is really exactly what your code looks like, you've got an
>extraneous comma after the Cwww line. But when you're tracking down a bug
>like this, you may find it helpful to output the exact query tha
Yup! Maybe I haven't explained me correct, but yes, that's what I wan't. This is
because as soon as a project is NOT inheriting, then all of it's childs are then also
not able to inherit from the original root, because the project that's NOT inheriting
breaks the node...
But the childs are stil
Brandon,
thank you for the bug report. I will try to fix this in 4.0.xx.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order technical MySQL/InnoDB support at https://order.mysql.com/
See http://www.innodb.com for the online manual and latest news on InnoDB
sql query
- Original Message -
Hi,
You make confusion between terms, CONCEPTS and TECHNOLOGIES.Is not yet
invented the tools which should THINK instead of our BRAIN when must design
a system...any kind of.I hope you feel the difference.For example,a new
concept of databases is : the neural database system.What you will do now?T
On Tuesday 11 March 2003 14:26, jarausch at igpm dot rwth-aachen dot de wrote:
> it seems as if all links on
> http://www.mysql.com/Downloads/mysqlgui/
> are broken.
Link for downloading MySQLGUI is
http://www.mysql.com/downloads/gui-mysqlgui.html
--
For technical support contracts, g
Uttam: Your're great! But there's still one thing I haven't mentioned (my fault)...
If I add more childs to the same node_depth and sets SubProjectB NOT to inherit, then
the query fails...
I now have these records:
project_group_idref_project_group_idnameroot_project_grou
On Wednesday 12 March 2003 20:05, trashMan wrote:
> I've tried to setup a replication but ...i've several problem! I've
> follow the manual istruction
> http://www.mysql.com/doc/en/Replication_HOWTO.html
> But the slave don't start the replica.
>
> SHOW SLAVE STATUS on SLAVE return SLAVE:running
>
On Thursday 13 March 2003 04:45, Dan Cumpian wrote:
> I've been running mysqld-nt on W2K and WinXP for awhile now (using
> MyISAM tables) and I'm a bit confused by what's in the "max" binary. Is
> the biggest difference InnoDB tables?
Difference is described here:
http://www.mysql.com/do
On Thursday 13 March 2003 20:27, Steve Holt wrote:
> I am linking an MS Access front end to MYSQL on the back with ODBC
> If I open the table I can enter a value in the course name field only which
> is the primary key
> and it will save the record even though I have not entered values in the
> fie
Hello all : )
Can anyone offer any advice on how to achieve the following with SQL?
Say I have a table.
CREATE TABLE page (
pgposition int(6) not null,
pgelement char(20) not null default '',
pgsize int(4) not null default '0'));
and it has this data in.
1,"TEXT",20
2,"TEXT",
34 matches
Mail list logo
