i have come to realise that temporary tables are only persistent for 30
secs, is there a way to extend that ? My applications is attempting to
store data before and entry is made and then insert the data from the
temporary table after the entry is inserted then drop the temp table.
This should
Thats usually setup in the same table schema no ?
On 02/12/2004, at 9:52 PM, [EMAIL PROTECTED] wrote:
Hi All,
In oracle I can query user_constraints, user_indexes for getting the
constraints and indices for a particular table.
User_constraints and user_idexes are view which holds all the
Hi there, I have Mysql 4.1 on my development machine, I have been
trying to test out if I am going to be able to do this. What I would
like to do is return a one to many resultset but without the duplicated
results in the first query. Hows is this going to be possible ? I would
like to get all
here is how i would do it, a slight change to the if else ..
function filelist($fileID) {
$result=mysql_query(SELECT ID,title,type FROM files);
echo BR;
echo select name=\file\option value=\0\---NONE---/option;
if (mysql_num_rows($result)==0) {
//no files
} else {
while
man i didnt even know you can do this
AND s.date q.date
i assumed that goes in a where clause ?
-Original Message-
From: news [mailto:[EMAIL PROTECTED] Behalf Of Harald Fuchs
Sent: Wednesday, May 26, 2004 8:01 PM
To: [EMAIL PROTECTED]
Subject: Re: need help with a complicated join
Here is a methodology i use
action=updateID=1
action=insert
action=edit
on delete if the delete button is pressed that is $_POST['delete'] it will
delete the entry
i use a switch statement on the action request
-Original Message-
From: David Blomstrom [mailto:[EMAIL PROTECTED]
Man 3 times same thread !
What I could consider to you, I don't really understand what you are getting
at, what is wrong with 1000 users firstly ? And in the entry table store
their userID which is stored in a session when they login ? So when they
enter in data it stores their userID into a
Hi there, I am aware this isnt possible. I would like the power of Innodb,
but one of my applications also requires the boolean search within blocks of
text, how can i do this efficiently ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
your hostname ?
-Original Message-
From: shaun thornburgh [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 01, 2004 10:53 PM
To: [EMAIL PROTECTED]
Subject: MySQL Users Table
Hi,
I have just installed MySQL on Windows 2000, after inspecting the mysql
users table I have noticed that there
i'm using an app called report manager, its a report designer for linux and
windows done in delphi and kylix.
-Original Message-
From: Bob Ramsey [mailto:[EMAIL PROTECTED]
Sent: Saturday, May 01, 2004 8:36 AM
To: [EMAIL PROTECTED]
Subject: Re: Reports
[EMAIL PROTECTED] wrote:
hi,
Huh as in production ?
-Original Message-
From: Victoria Reznichenko [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 20, 2004 5:52 AM
To: [EMAIL PROTECTED]
Subject: Re: when 4.1.2 release
Marek Lewczuk [EMAIL PROTECTED] wrote:
Hello,
when do you plan to release 4.1.2 version
Hi there i was wondering if its possible to have two auto-inc fields ? I am
having to generate ticket numbers and i want it to look like DEP-1,
DEP-2, NEW-1, NEW-02 where NEW and DEP are the first 3 letters
of of the department associated with the ticket. How is this possible ?
-
From: electroteque [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Wednesday, April 14, 2004 5:11 PM
Subject: two auto-inc fields possible ?
Hi there i was wondering if its possible to have two auto-inc
fields ? I am
having to generate ticket numbers and i want it to look like DEP-1
Hehe I've also had a problem with searching for something like it's ,
anything with a single quote doesnt return anything, maybe try adding a
slash , C\+\+ ?? heheh maybe i'm wrong, it could be a limitation.
-Original Message-
From: David Taiwo [mailto:[EMAIL PROTECTED]
Sent: Tuesday,
Ok i worked out a possible bug with mysql 4.1 compiling openssl on solaris
i keep getting this error
gcc -DDEFAULT_CHARSET_HOME=\/usr/local/mysql\ -DDATADIR=\/usr/local/mysql
/var
\ -DSHAREDIR=\/usr/local/mysql/share/mysql\ -DDONT_USE_RAID -I. -I. -I..
-I..
/include
/opt/csw/include/openssl -O3
look for SUBSTRING_INDEX(field,'\.',2)
-Original Message-
From: Keith [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 11, 2004 8:51 PM
To: [EMAIL PROTECTED]
Subject: Limiting Return
g'day,
've had a good look through the manual and archives but can't find an
answer. I'm pulling, among
What is your question?
Lol exactly show some errors man :D
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
well dude u never showed what the parser returned, i am pretty sure u need
curly brackets if u are including more than one line in an if statement
-Original Message-
From: Togochog Enhebatu [mailto:[EMAIL PROTECTED]
Sent: Saturday, February 28, 2004 2:53 PM
To: [EMAIL PROTECTED]
Subject:
i have converted access to mysql easily using the sqlyog gui tool
-Original Message-
From: karl james [mailto:[EMAIL PROTECTED]
Sent: Sunday, February 08, 2004 11:09 AM
To: [EMAIL PROTECTED]
Subject: convert
Hey guys,
I was wondering if there is a converter for access databases to
when when when will it be available for innodb ?
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Saturday, January 24, 2004 11:43 AM
To: Sidar LC.; [EMAIL PROTECTED]
Subject: Re: Fulltext search
At 18:34 -0600 1/23/04, Sidar LC. wrote:
How can I implement fulltext
rollback works on myisam ? this is mysql4 anyway, sweet i'll give it a
try.
On Fri, 2003-09-19 at 08:01, Jeremy Zawodny wrote:
On Thu, Sep 18, 2003 at 03:00:17PM +1000, [EMAIL PROTECTED] wrote:
Hi there i have a couple of projects which required fulltext searching so
was unable to setup
Hi i was wondering if there was ever going to be a time when Innodb can also
be fulltext indexable ? Being that i just started to work with Innodb and
cant believe how proper it feels of a relationional database over Myisam.
Like with Myisiam you cant set relationships up or is that going to
yes mytop is very wicked it helps monitor the queries and gives you
benchmarks
-Original Message-
From: K Old [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 31, 2003 2:02 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: CPU Usage and MySQL...
On Sat, 2003-08-30 at 23:18,
hmm well sorry to be unclear i know this works but it would return more
results than needed also i cant expect users to add this themselves, like i
would have to add the astrerix to every word in that case like i do to get
all words ;\
-Original Message-
From: Egor Egorov [mailto:[EMAIL
when i reimport i usually drop all the indexes first anyway as it takes
forever i have found that a repair table quick usually helps after
reindexing too
-Original Message-
From: Adam Nelson [mailto:[EMAIL PROTECTED]
Sent: Wednesday, August 06, 2003 8:09 AM
To: 'MySQL'
Subject: reindexing
there is an app called sqlyog it imports access directly into mysql
-Original Message-
From: SpamBox [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 7:13 AM
To: Robert Morgan; mysqllist
Subject: Re: importing Access databases
Robert Morgan wrote:
Hi, I'm doing a project for a
the only thing i could see a problem is the decimal but maybe not
-Original Message-
From: Francis Van-Lare [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 12, 2003 4:42 PM
To: [EMAIL PROTECTED]
Subject: MATCH AGAINST () ('XXX' IN BOOLEAN MODE) SYNTEX ERROR
I have run this command
check the cpu load sometimes is gets real intensive , so i have found , the
cpu's are they
-Original Message-
From: Egor Egorov [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 10, 2003 9:55 PM
To: [EMAIL PROTECTED]
Subject: Re: Slow batch load after 500MB
James E Hicks III [EMAIL
when reimporting or reinserting or whatever from a huge db i usually drop
all the indexes reimport then create them again much quicker
-Original Message-
From: Paul DuBois [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 09, 2003 1:09 PM
To: Florian Weimer; [EMAIL PROTECTED]
Subject: Re:
yes i was very impressed with the benchmark on the opteron , frankly i rekon
the opterons are more optimised to a unix environment where xeons are more
optimised for a windoze environment, we just got a dual 2G zeon dell system
for a production box for a project which is doin full text searching
this is a phpbb specific question notice its a custom error message
-Original Message-
From: HA. Mooduto [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 05, 2003 8:13 PM
To: [EMAIL PROTECTED]
Subject: database table is read only
dear all,
i has a problem to installing phpbb using mysql
PROTECTED]
Sent: Monday, June 30, 2003 8:14 AM
To: electroteque; [EMAIL PROTECTED]
Subject: Re: stored procedures in mysql5
insane
you mean extremely fast? or easy to use? i'd like to know what those SPs are
good for...
-yves
-Ursprüngliche Nachricht-
Von: electroteque [EMAIL PROTECTED
ok i have a bleeding edge server instance on my server apache2/php5/mysql5
running alongside the stable server , is stored procedures actually
functioning in it yet ? is this the correct syntax there is no documentation
for it yet.
create procedure test as select * from tablename;
--
MySQL
On Sat, Jun 28, 2003 at 01:47:28PM -0400, Wendell Dingus wrote:
Hello, I've got a situation I'm hoping someone here can help me out with.
We
have a web server serving up data via some PHP programs pulling from MySQL
(3.23.56 currently) in INNODB tables. There are 40+ (active) databases
thanks this is pretty insane cant wait for its release :D
-Original Message-
From: Jeremy Zawodny [mailto:[EMAIL PROTECTED]
Sent: Monday, June 30, 2003 6:07 AM
To: electroteque
Cc: Mysql
Subject: Re: stored procedures in mysql5
On Sun, Jun 29, 2003 at 08:00:29PM +1000, electroteque
lol of course
mysqldump -u username -p databasename databasename.sql
-Original Message-
From: Asif Iqbal [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 28, 2003 3:08 PM
To: [EMAIL PROTECTED]
Subject: mysql database dump
Can I dump a database while the database is running in mysql ?
--
would u have an example of how to use union then ? like on the second select
i need to reutn a heap of rows from a field from the first select
-Original Message-
From: MyLists [mailto:[EMAIL PROTECTED]
Sent: Saturday, June 28, 2003 10:42 AM
To: MySQL List; otherguy
Cc: Terry Vanstory
this has prob been bought up many of times but how would it be possible to
setup different mysql source instances for each individual virtualhost on a
machine ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL
geez mysql is an open source product you cannot expect so much too soon over
a very expensive commercial product which has been out for years , for xml i
usually generate it on the fly when i am extracting the data using the field
names as the xml tag nodes.
-Original Message-
From:
c++ ?
-Original Message-
From: Anthony Ward [mailto:[EMAIL PROTECTED]
Sent: Friday, June 06, 2003 9:49 PM
To: [EMAIL PROTECTED]
Subject: Mysql language
Hi,
I was looking in what language what myslq written in?
Just curious
Anthony
--
MySQL General Mailing List
For list archives:
create fulltext index Name on Table(field) i didnt get this
i usually do add fulltext field (field) i think , is that wrong ??
-Original Message-
From: Santino [mailto:[EMAIL PROTECTED]
Sent: Thursday, June 05, 2003 6:14 PM
To: [EMAIL PROTECTED]
Subject: Re: REPOST: FULLTEXT searching
u need two different instances , totally different source directories for
instance , an they run on ifferent pors say one on 3306 and one on 3307 mind
u php ha problems connecting to something not on 3306
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Thursday,
: ft_boolean_default='AND'
Hi!
On Jun 02, Egor Egorov wrote:
electroteque [EMAIL PROTECTED] wrote:
hi guys , i was wondering if this variable , is available for 4.0.12 ?
we
tried to make it work but mysql would not start , if this is still not
available , what are the best ways for me to try
hi guys , i was wondering if this variable , is available for 4.0.12 ? we
tried to make it work but mysql would not start , if this is still not
available , what are the best ways for me to try and format a search say for
instance currently if i search for two words
something1 something2
44 matches
Mail list logo