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 locked/unlocked
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 mess
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 GM
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 s
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 =mysql_fetch_arr
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 = @mysq
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 repli
Here:
mailto:[EMAIL PROTECTED]]
Sent: Friday, March 29, 2002 6:18 PM
To: Rodney Broom; [EMAIL PROTECTED]
Subject: Re: Why does my delete not work :(
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... :(
T
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
Pe
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
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
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
--
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?
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
--
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 o
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
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
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
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 collection
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 di
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.],
[ ENABLED_
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 be
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 export_mysql()
$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]
> S
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 "loc
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 upda
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 u
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
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
-
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,'","',
>
>
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 se
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
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
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 MyS
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
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
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 t
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 ge
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 php
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
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 con
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 socket
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 alwa
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
>>
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
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 e:\mys
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 en
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 th
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 s
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 ac
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 t
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
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, 200
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 is
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 Yo
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 w
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 list
>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: [
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 p
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 DE
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
---
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 c
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 va
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 bo
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
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 runnin
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 Au
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 : "Basedir=e:/my
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 i
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
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,
>
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:
http://www.mysql.co
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
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 My
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)
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 Travelocit
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
>
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
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 si
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 locked/unlocked
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 w
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
http
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] l
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: "Dani
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
---
85 matches
Mail list logo
