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,30
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
fields
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:
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
SHOW
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_idname
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,
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
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 -
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
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 that is
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:
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',
Category='$Category',
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,
- 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
snip
The OP didn't indicate where the files are being kept, and under FreeBSD
this can be significant. I know for
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 |
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
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
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
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
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=2000
I
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 larger than
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
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 systems.
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.
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
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
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()
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
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
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
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
On 15-Mar-2003 Sime wrote:
Andrew wrote:
can you explain how I would do this tracking?
snip
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;;
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 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'));
and it
34 matches
Mail list logo