is there any way of doing a linked list in mysql..
?
the only alternative i've got is to have a table with a fixed number of
columns liike this
item1
item2
item3
item4...etc
is this the only way to do what i'm trying to do.
does anyone get what i'm on about?
cheers
dan
Hi Daniel,
I can think of a table with columns like this:
prvlink
item
nextlink
where prvlink and nextlink points to the previous and next nodes and item is
the current node.
prvlink = 0 for first node
nextlink = 0 for last node
Hope this helps
Joseph
- Original Message -
From:
i think i'm getting in over my head a bit here..
is this something thats gonna be simple to do?
- Original Message -
From: Joseph Jude [EMAIL PROTECTED]
To: Daniel Jarrett [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Friday, March 29, 2002 7:34 PM
Subject: Re: [newbie post] linked
Hello! :)
I want to ask about binary log - what kind of info it
writes and how I can use it. Is this info is connected
with optimizing mysql work.
Thanks.
Kosyo
__
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
ahh.. yes i see where you are coming from.. yes i suppose that would work.
what i'm trying to do is have one table for a member base, and have each
member capable of having a list of items of a varying number.
when i first thought about doing this i thought there may have been a field
type that
I am trying to implement a simple advisory locking system for my application.
It is trying to mimic the functionality of a legacy inhouse database
application, and the mysql GET_LOCK or LOCK TABLE does not seem sufficient
for our purposes, as our application requires tables to be
Daniel,
Was reading an article last night on tree structures and linked list
structures at searchdatabase.com.
As to simple, no linked lists are not, and for that reason not a good
topic for a first foray into the world of databases.
Why don't you work through one of the 'intro to dynamic web
Jeff,
What i want to do seems simple, but i can not for the life of me
figure out
how to do it.
Tables: These tables are not related in any way.
A
--
1
2
3
4
5
B
--
1,Bob
3,Jack
7,Janet
8,Gary
9,Kelly
I would like to combine tables A and B with a SELECT statement to get
Daniel,
I have a question about determining which case
occurred when there are no matches - using two tables.
Scenario:
- two tables, one for photos, and one for collections
- zero or more photos can belong to a collection
- the database may not know the collection_id requested
I need to build a small database for my school project.Is there a way I can interface
GLADE to MySQL?
--
___
Sign-up for your own FREE Personalized E-mail at Mail.com
http://www.mail.com/?sr=signup
Win the Ultimate Hawaiian Experience from
Hello Maxim,
There's a bit of confusion in this discussion: Do you (a) want to have
several databases running on the db-server, and all set to different
time zones, or (b) want each client to see db-stored times stated in
his/her local timezone?
(a) AFAIK (and I claim no special expertise here)
Anoop,
I need to build a small database for my school project.Is there a way
I can interface GLADE to MySQL?
A confusion of tools - further research needed.
GLADE (as in GTK) will interface to various scripting/programming
languages.
Various scripting/programming languages will interface to
Hi Daniel,
You wrote:
what i'm trying to do is have one table for a member base, and have each
member capable of having a list of items of a varying number.
when i first thought about doing this i thought there may have been a
field
type that would act as a linked list.. kinda like a set,
DL Neil wrote:
Various scripting/programming languages will interface to MySQL.
PHP (and therefore C++) fit into that happy intersection.
_^^^
Perl?
-
Before posting, please check:
There is also PHP-GTK, which uses PHP to implement bindings to GTK. So,
within PHP you could build a GUI that could be used for accessing a
MySQL database. But I am wondering why some of the existing GUI tools
for MySQL won't do the trick.
On Fri, 2002-03-29 at 06:24, DL Neil wrote:
Anoop,
What you need is to somehow get an additional column with the rows numbered.
You can do this by creating a temporary table with an AUTO_INCREMENT column
and inserting the records from the original table. Of course, you need an
ORDER BY clause on the INSERT ... SELECT, because SQL doesn't know or
hi
in mysql 3.23.45
I have a numeric field N with null values allowed and null
values in some rows of the database
when i ask select sum(N) from table
the result is the sum of non null values (like if null values
converted to zero) and not null as expected for a sum of
values with null in
Hello,
I try to install MySQL on Windows XP (Enterprise server). I have 3 hard-disk
: C: ,formated on windows 95 fat, D: and E: formated on XP FAT. I need to
install MySQL on XP, disk E . I'd first installed mySQL on C:. Then I
created a file my.cnf with the following information :
I think i stumbled upon a bug that's got something to do with join
size. Detailed information below.
Using 2 intel-linux platforms with replication the query stated
below works fine on one machine:
- mysql Ver 11.15 Distrib 3.23.37, for pc-linux-gnu (i686)
- Linux deedee 2.2.16-SMP #1 SMP Wed
Ian,
Thursday, March 28, 2002, 6:20:29 PM, you wrote:
IL - Redhat 7.2 (Enigma) pre-build installation.
IL - Mysql with the following rpms installed:
IL MySQL-3.23.49a-1.i386.rpm
IL MySQL-client-3.23.49a-1.i386.rpm
Are you sure you are really running
Konstantin,
Friday, March 29, 2002, 11:31:23 AM, you wrote:
KY I want to ask about binary log - what kind of info it
KY writes and how I can use it. Is this info is connected
KY with optimizing mysql work.
mysqld writes in a log file all SQL commands that update data and info about how long
Patrick,
Thursday, March 28, 2002, 5:25:22 PM, you wrote:
PO I use MySQL 3.23 under Solaris 7. The size of the Database
PO is 1Gig 5.
PO What are the limits for propoer MySQL operation.
PO Is there a faster way to copy a DB than using Dump?
mysqlhotcopy, but it can be run only on the same box
pascal,
Friday, March 29, 2002, 2:53:23 PM, you wrote:
pbln in mysql 3.23.45
pbln I have a numeric field N with null values allowed and null
pbln values in some rows of the database
pbln when i ask select sum(N) from table
pbln the result is the sum of non null values (like if null values
Richard,
Thursday, March 28, 2002, 5:19:03 PM, you wrote:
RM I am trying to do a table update. The table I am updating is a results
RM table.
RM I have constructed a query, however, it doesn't seem to work because in the
RM where statement I need to refer to a different table:
RM update
I use mysql php. I created a table.. I entered some record. I want to
order by name as asc. But I have turkish character like ,..
How can I set turkish character to mysql?
Thanks..
Edakom Internet Sorumlusu
Gokce Akkaya
Hi all!
I've got this piece of SELECT statement for MySql.
SELECT *
FROM messages
LEFT OUTER JOIN main
ON messages.topicid=main.topicid
WHERE main.topicid is null;
so the select statement works fine. But what I'd like to do is actually
delete those rows instead. but substituting SELECT with
Hi David,
There is no built in tool for fix length records. If I am importing
the data once or just a few time I use M$ Access, just setup an ODBC
connection and use the import facility in Access to bring the file in
(it's very easy). Where I have to do this automaticaly I have written
perl
From the manual:
DELETE [LOW_PRIORITY | QUICK] FROM table_name
[WHERE where_definition]
[ORDER BY ...]
[LIMIT rows]
Please note: there can be no SELECT clause..
-Original Message-
From: sunny [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 29, 2002 8:15 AM
To:
I think you need to be more detailed. What is your goal? Let's work
from there.
-Original Message-
From: Daniel Jarrett [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 29, 2002 3:19 AM
To: [EMAIL PROTECTED]
Subject: [newbie post] linked lists..
is there any way of doing a linked
admin,
Friday, March 29, 2002, 4:13:26 PM, you wrote:
aect I use mysql php. I created a table.. I entered some record. I want to
aect order by name as asc. But I have turkish character like ,..
aect How can I set turkish character to mysql?
You should set latin5 character set: run mysqld with
You might want to use the mysqlbinlog utility to look at the binlog. The
binlog format has changed at least once in past versions and could change
again. However, the output from mysqlbinlog just a straight text format
of updates/inserts/deletes which happen to a database.
-Marc
Konstantin
Hi,
As I understand it Turkish has some unique features. There is no
current turkish character set in the source tree. I am not sure if
anyone has one. You could look at the other character sets and pick
on that may also work. These can be found in the source
./sql/share/charsets. There
Victor is right, latin5 is for turkish, it's commented at the top of
the character set!
Ken
- Original Message -
From: Victoria Reznichenko [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, March 29, 2002 9:26 AM
Subject: Character Set Problem
admin,
Friday, March 29, 2002,
Hello everybody.
I am working with mysql about one week by now, and a friend of mine did an
ALTER TABLE, and during this he did a cold reboot. After that, I realize
that my tables where somewhat inconsistent. Then I run myisamchk -r, and it
told me that my index definition is not valid, and that
James Riordon wrote:
At 15:07 +0800 03/28/2002, Sammy Lau was thought to have said :
?http://www.mysql.com/doc/C/R/CREATE_INDEX.html
Granted, I should have looked before I spoke for the first question.
2 - Do I have to do anything special like stop requests to the
If I understand you correctly, you are interested in backing up a database
without using the mysqldump command, correct?
You have a couple of options:
1) Issue a 'flush tables with read lock', backup the binary files of the
database, issue a 'unlock tables'. However, no one will be able to
Good morning Sunny,
From: sunny [EMAIL PROTECTED]
...substituting SELECT with DELETE doesn't work :(
That's right, that's how MySQL works. And it doesn't support sub-queries for this
case, either. So you can't say:
delete from table where field in (select field from other_table)
I'd
Jeff
You can make a clean start but it takes work.
1) create new table clients_tmp - same fields - no indexes.
add a field and make it a simple integer - say idx_int
2) insert all the fields into client_tmp from clients
place the client.idx field into client_tmp.idx_int
a) At
There have been a lot of questions here about how to store,
sort, etc. various special characters and alphabets in
MySQL internally. Maybe this isn't really a MySQL question,
but I'd like to know how to deal with such characters over
a Web interface.
I have a database of books that's accessed
Hello José,
I will try this. Error 1067 is an invalid Default value.One
problem I see is you are starting mysql from the C: and telling it it
is installed on e:. Perhaps you only wanted to move the data
directory? In that case use the --datadir or my.cnf with the date dir
set to
More like he installed the rpm's from MySQL.com over the top of the one's
from redhat. The scripts from the MySQL rpm's don't recognize the redhat
rpms and the sripts from the redhat rpm's don't recognize the MySQL.com
rpm's.
The rpms from redhat are out of date (they were out of date when 7.2
At 10:55 AM + 3/29/02, DL Neil wrote:
Scenario:
- two tables, one for photos, and one for collections
- zero or more photos can belong to a collection
- the database may not know the collection_id requested
(i.e. the user on the browser side did something to request
a
Does anyone know of any weird issues with getting the value of an
AutoIncrement Primary Index field into a recordset? I do a sql call
from an ASP page that loads the Index and one other field into a
recordset. The other field contains the expected data, but the Index
field in the recordset
Good afternoon one and all,
Well, I took the plunge and am trying to get to grips with this Linux and
have fallen at the first hurdle with MySQL. When I type mysql from my
shell prompt (logged in as root) I get the following message
ERROR 2002: Can't connect to local MySQL server through
Andy,
Friday, March 29, 2002, 7:04:29 PM, you wrote:
AJ Well, I took the plunge and am trying to get to grips with this Linux and
AJ have fallen at the first hurdle with MySQL. When I type mysql from my
AJ shell prompt (logged in as root) I get the following message
AJ ERROR 2002: Can't
Hi all,
I generate some sql statement with a sql query and make some insert.
But when inserting, I get some surprises with some
strings value which contains ' or , cant be escape because its my string
delimiter.
How can I do to correct this :
is there a mysql function stripslash (eq in
Hey Andy,
mysql is the client connection program. mysqld is the actual mysql
database daemon that runs.
You might want to take a look at the error logs to see what it's
actually complaining about.
That, or go peek at the Mysql documentation first and read up on the
actual install so you can
At 19:07 +0100 3/29/02, David yahoo wrote:
Hi all,
I generate some sql statement with a sql query and make some insert.
But when inserting, I get some surprises with some
strings value which contains ' or , cant be escape because its my string
delimiter.
How can I do to correct this :
is
hi:
i have the next question.
how can i add a user to mysql with the console or shell ?
how can i do the same posses from a php script or application from the
Internet?
thanks
_
Do You Yahoo!?
Get your free @yahoo.com address at
I know that function in php, but I generate sql from a sql queries in order
to export some data
from on database to another.
I make something like that :
select concat('INSERT INTO links VALUES(NULL,99,',link.about,',',
from
links,
...
this queries gives me sql insert command.
but in
Hello everyone,
New to the list, and new to MySQL. Here's the problem we have put our
employment application online and are trying to insert the information into
a MySQL database. The server is RH Linux 6.1 Apache webserver for both SSL
and Non SSL using two different installs, and the latest
hi:
i have the next question.
how can i add a user to mysql with the console or shell ?
how can i do the same posses from a php script or application from the
Internet?
thanks
_
Do You Yahoo!?
Get your free @yahoo.com address at
have you downloaded and read the mysql documentation. If not, I would
suggest that you do it. these are mentioned in the document.
- Original Message -
From: Javier Gloria [EMAIL PROTECTED]
To: mysql [EMAIL PROTECTED]
Sent: Friday, March 29, 2002 7:22 PM
Subject: adding users to mysql
I missed the original question but here is my two cents.
The solution has to do with how you define ... used as a online database. Steve
Rapaport is correct if you want to create a database accessable via a browser, but
if you just want a database available on the net all you need (on the
On Fri, 29 Mar 2002, Anoop Rajendra wrote:
I need to build a small database for my school project.Is there a way I can
interface GLADE to MySQL?
You might give GNUe Forms and GNUe Designer a try. Via the designer
wizards you can create data aware UIs in seconds that provide a great deal
of
In the last episode (Mar 29), David yahoo said:
I know that function in php, but I generate sql from a sql queries in order
to export some data
from on database to another.
I make something like that :
select concat('INSERT INTO links VALUES(NULL,99,',link.about,',',
from
links,
What do you folks out there do to backup your MySQL databases? I'm new
to it and am wondering if there's a good utility for doing it, or some
simple procedure that is already known to be effective and efficient.
Thanks,
Tab
Personally I just tar up the data dir every hour and have a script to
rotate the tar file ( up to 10 tar files.. ).
There are some other utilities out there that are nicer tho. I can't
remember them off the top of my head tho.
--
sh
On Fri, 2002-03-29 at 11:05, Tab Alleman wrote:
What do you
Hello all,
sorry, if I nerve you with a problem, which is allready known -
I didn't find appropr. info in the FAQs (or was too stupid to look
at the right place?)
Trying database replication with cross-wise update (A is master for B
and B is master for A) situations occur after some sucessfule
Hello Michael,
Friday, March 29, 2002, 10:22:27 PM, you wrote:
MZ Hello all,
MZ sorry, if I nerve you with a problem, which is allready known -
MZ I didn't find appropr. info in the FAQs (or was too stupid to look
MZ at the right place?)
MZ Trying database replication with cross-wise update
Hello Tab,
Friday, March 29, 2002, 10:05:20 PM, you wrote:
Which table type do you use ? Well if you do not know it's probably
MYISAM. In this case you may use BACKUP TABLE to make a quick
consistent backup of the table. If you want to have consistent
snapshot of several tables you may use
$sth-execute || die Not successful: $!; doesn't tell you why the
command did not work ... die with $dbh-errstr; That will give you more
info.
-Original Message-
From: Ray Goniea [SMTP:[EMAIL PROTECTED]]
Sent: Friday, March 29, 2002 1:41 PM
To: [EMAIL PROTECTED]
Subject:
Hello all,
Greetings from Scotland.
Can anyone help?
I have and Access 2000 Database. On MS windows 98.
I inserted the access to mysql text
I created the Module and inserted the , and I tried to run the macro.
Action - RunCode and
Function Name - export_mysql () I also tried
I've been using a perl script to insert a very large blob (up to about 8
MB) into a DB successfully, but now I need to do it with a 34 MB BLOB,
so I upgraded to MySQL 4.0.1. First off, I can't get
max_allowable_packet to go higher than 64M, regardless of what I set it
to, but that shouldn't
Hi
In case nobody noticed yet:
configure.in line 590:
# compile with strings functions in assembler
AC_ARG_ENABLE(local-infile,
[ --enable-local-infile
If LOAD DATA LOCAL INFILE is enabled by
default.],
[
Hi,
I wonder if this is the place to ask this question or not!
I have been trying to install DBD::mysql, or any other mysql, or DBD modules
from CPAN on my Linux, and FreeBSD servers.
I just can't get them to install.
The first error that appears is :
Can't exec mysql_config: No such file or
Hi,
I have a suggestion (two, in fact) :
- add a 48-bit integer type, which would nicely fill in the gap
between INT and BIGINT. Some value types are too large for INT
but being forced to use BIGINT is really a waste (for example,
millisecond-precise timestamps, or hash values over a
I am considering the intensive 1 week MySQL class coming up
in SF. Has anyone here been through one of their
classes? How did it go?
The web site doesn't list a location, and
they don't answer the phone (strikes 1 2...)
Off-list responses are fine. I'd just like to know
that someone found
Do the tables on the slave machine have to be *exactly* the same as the
tables on the master? Is it possible to have different indexes on the slave?
I want to use my master as my transaction server and my slave as my
reporting server. In that respect, I'd like to use very few indexes on my
master
On Fri, Mar 29, 2002 at 01:13:50PM -0800, Jeff Kilbride wrote:
Do the tables on the slave machine have to be *exactly* the same as
the tables on the master?
No.
Is it possible to have different indexes on the slave?
Yes.
I want to use my master as my transaction server and my slave as my
It sounds to me that you're exceeding the maximum packet size mysql can
handle.
Adriano Manocchia wrote:
I've been using a perl script to insert a very large blob (up to about 8
MB) into a DB successfully, but now I need to do it with a 34 MB BLOB,
so I upgraded to MySQL 4.0.1. First off,
I am working with the php and when using php.net the documentation requires
compileing with Visual C++ I am in win32. I do not have this program. I
have Visual basics 5 will this work?
If not it there a C++ complier I can download that would get me through
this?
for sql
How precise a location were you seeking? That * is San Francisco, CA.
http://www.mysql.com/training/index.html
Scheduled Courses
Using and Managing MySQL
Hamburg 15-19 Apr 2002 2450 EUR Register now! Questions?
*San Francisco 15-19 Apr 2002 2450 USD Register now! Questions?
Visual Basic and Visual C++ are 2 completely different things, so no, visual
basic will not work.
There might be some free C++ compilers for you to use for windows. You
could always buy a copy of an older version of Visual C++. Older versions
probably won't be too horribly expensive.
Tyler
On Fri, Mar 29, 2002 at 11:38:30PM +0100, [EMAIL PROTECTED] wrote:
Your message cannot be posted because it appears to be either spam or
simply off topic to our filter. To bypass the filter you must include
one of the following words in your message:
sql,query
If you just reply to this
Hi all,
Thanks for helping me with escape previously, a stripslash like (cf php )
mysql function would be easy in next version, i think.
I d like to make another strange query is ::
I have a table with row having some flag column (0/1) several a set.
I d like to retieve each that doesnt have
So you're saying there's no actual DELETE statement for this? There is no
way in hell I can write any SQL to do that?? Thats sucks... :(
Thanks for the example, but how do I run it? I've only used PHP for taking
information out of a database and other simple MySQL queries so while your
Here:
?
$sql = DELETE [columumname] FROM [tablename] WHERE id = '$id';
That's your basic delete statement in PHP.
-Original Message-
From: sunny [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 29, 2002 6:18 PM
To: Rodney Broom; [EMAIL PROTECTED]
Subject: Re: Why does my delete not
On Thu, Jan 24, 2002 at 12:06:14PM +0100, Marcus Mueller wrote:
Hello,
in order to be able to use the replication features of MySQL we
recently gave version 4.0.1alpha a try, since these features are
reportedly more reliable in this version
Really? I haven't heard that about the
Sunny... Pay close attention.. You are trying to execute a query that
is a bit complex for someone new to mySQL and PHP.
$sql = SELECT messages.topicid
FROM messages
LEFT OUTER JOIN main
ON messages.topicid=main.topicid
WHERE main.topicid = 'NULL'
$result =
Ooops... Forgot something
$sql = SELECT messages.topicid
FROM messages
LEFT OUTER JOIN main
ON messages.topicid=main.topicid
WHERE main.topicid = 'NULL' ;
$result = @mysql_query($sql, $connection) or die(Could not
execute query);
While ($row
At 10:55 AM + 3/29/02, DL Neil wrote:
We can hit:
a) no collection
b) a collection that hasn't had any photos moved/uploaded to it yet,
or..
c) a collection with one or more photos (the normal, everything's
fine case)
Let us know how you get on!
Thanks again DL, my first stab at using
Hello DL,
I know about the possibility of having different TimeZones for
different servers (the mysql manual states that it's possible through
setting TZ environment variable). But my situation is that I have a
shared webhosting in GMT+1 (and mysql TZ is GMT+1), but application
needs to have a
Hi sunny,
Yes it is a sad scenario. But hopefully this feature would be available in
the near future.
If you cannot use a programming language the only way AFAIK is to use
temporary tables.
Create temporary table temptable SELECT messages.*, if(main.topicid is
null,1,0) deleteflag
FROM
I am trying to implement a simple advisory locking system for my
application.
It is trying to mimic the functionality of a legacy inhouse database
application, and the mysql GET_LOCK or LOCK TABLE does not seem sufficient
for our purposes, as our application requires tables to be
85 matches
Mail list logo