OK, here are the last few lines from make. I configured using the
following:
./configure --prefix=/usr/local/mysql --with-mysqld-user=mysql
errors:
libmysql.c: In function `mysql_real_connect':
libmysql.c:1790: warning: passing arg 5 of `gethostbyname_r' from
incompatible pointer type
hi i was wondering if there is a way to check for a table type ?
ie i have an authentication class, in some situations it uses innodb and sometimes its
myisam and currently its not autocomitting
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
hi there i keep getting an error on a table
Lock wait timeout exceeded; Try restarting transaction
i intitally had made the update query but it wasnt committed, as it was using a myisam
query function i have gone back to it with and innodb query function which starts a
transaction , i have
hi there, i am trying to use transactions on some innodb tables although a few things
i am experiencing, on one query the value appears, i refresh the page and the value
dissapears again, i am using persistant connections in php, the value is actually
there in the console, what could be the
that works cheers
Roger Baklund [EMAIL PROTECTED] 09/11/03 10:48am
* Daniel Rossi
Hi there i was wondering if there was anyway to determine the
primary key field instead of explicitly setting it in an update
sql query ?
for instance i'd like to go update table *** where primarykey=1
when is it a good time to do the set auto commit=0 , while doing the update or insert
query or sometime before that in the application ?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Andy Kannberg wrote:
Hi all,
I'm trying to compile MySQL 4.0.14 on a SUN Enterprise 220R, running on Solaris 9
12/02 with the latest patch clusters installed. I use gcc 3.2.3 to compile, along with
gnu make 3.80
I've followed instructions in the MySQL Docs from www.mysql.com, so I've run this
what's wrong?
Thanks!
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com
--
MySQL General Mailing List
For list archives: http
Martin Gainty wrote:
Daniel
Pass thru query executes on an ODBC Database.
Is your MySQL Server setup as an ODBC Database?
-Martin
Yes of course.
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61
and decided to turn it off.
Use PHP's functions:
stripslashes() and
addslashes()
You'll be sorry later if you don't, and continue using magic quotes...
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922
Hi i have just started to use them aswell to do proper relationships
between tables to add data restrictions on deleting records.
1) can you join a MyISAM table to an innodb table in a select?
This seems to work.
2) Under 'Restrictions...' in the manual, it says:
When you restart the MySQL
-locking?
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: http://www.nusconsulting.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
InnoDB of course does not support
FULLTEXT indexes, and so forth.
Which is a pain, because i want the foreign key relationships but fulltext
indexing at the same time :\
As for transactions , is it simply by doing this?
start transaction
do query
commit
if error
rollback
??
--
MySQL
start transaction
do query
if error
rollback
else
commit
--
Heh thats what i meant ;)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
What is all this talk about max db, like why did they go and buy out SAP
DB ? What is going to happen to different databases under the mysql banner
or will the maxdb be implemented in mysql ?
Because some of the features in sap, i think everyone would want into
mysql, man i wish i could code c++
Paul DuBois wrote:
At 12:00 +1000 9/9/03, Daniel Kasak wrote:
It's been suggested that I add 'enable-locking' to the [mysqld]
section of my.cnf.
You might want to reconsider. It's disabled by default on all systems
as of MySQL 4, and was disable by default before that on Linux.
I see.
I had
Really sorry about this i just worked out if i dont select the foreign key
in an insert statement it will return this error i have to include this
into the query, i have also noticed i usually dont add auto inc fields in
the insert query but my departments table has a foriegn key join and is
here is part of the create table
CREATE TABLE `assets` (
`assetID` int(11) NOT NULL auto_increment,
`barcode_number` varchar(20) NOT NULL default '',
`asset_code` varchar(20) NOT NULL default '',
`serial_number` varchar(100) NOT NULL default '',
`asset_user` varchar(100) NOT NULL
Chris Nolan wrote:
Hi all!
Is anyone running MySQL on Linux kernel 2.6 or the kernel shipped with
RedHat 9.0? I am curious as to the impact of the new thread
implementation on MySQL's stellar performance (I like picking on the
Oracle, MS SQL Server and Foxpro admins that I have to work with.
What is the definition of the constraint symbol there is no example of it in the docs ?
Also on a few tables i get errors trying to setup foreign keys
ALTER TABLE departments
ADD FOREIGN KEY (departmentID) REFERENCES departments_join(departmentID)
ON UPDATE CASCADE
this for example gives me
SHOW TABLE STATUS FROM yourdatabasename LIKE 'departments'
which will show us the constraints for table departments..-Martin-
Apologies constraint was missing, this works
ALTER TABLE assets
ADD CONSTRAINT FOREIGN KEY (end_dateID) REFERENCES end_dates(end_dateID)
ON DELETE CASCADE
I worked out the problem, it worked if i emptied the table, what could that be all
about ?
Daniel Rossi [EMAIL PROTECTED] 09/05/03 10:50am
What is the definition of the constraint symbol there is no example of it in the docs ?
Also on a few tables i get errors trying to setup foreign keys
Hi there i am having another issue with key constraints now, i emptied the tables and
made the foreign keys fine although now when i try and insert a row into the table i
get this
ERROR 1216: Cannot add or update a child row: a foreign key constraint fails
What could be the problem ?
--
Mark Matthews wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Spam Bait wrote:
[snip]
Does anyone have a link to some docs on the syntax for 'create procedure'?
I checked on the net for PL/SQL syntax, and found some Oracle and
Postgres examples, but none of them worked for me.
Just a
select value from tableName where date in (select max(date) from
tableName where id = 4);
But, it doesn't work with mysql 4.0.
Any ideas? Does anybody had this problem before?
What about:
SELECT value, date
FROM tablename
WHERE id = 4
ORDER BY date ASC
Just pick the first row.
--
it doesnt work i tried it, case of follow the sheep :D
Paul DuBois [mailto:[EMAIL PROTECTED] writes:
At 15:18 -0700 8/20/03, Michael S. Fischer wrote:
This is trivial to benchmark yourself. Try:
BENCHMARK(10, SELECT yada, yada FROM test WHERE id IN(1,2,3))
And compare to
sorry to be vague but what is the ft_stopword_file i havent been able to be
up to speed on that variable.
At 15:53 -0300 8/21/03, Cleber Hostalácio de Melo wrote:
Hi,
I need to change the stop word file used by the MySQL in fulltext
seach.
The documentation
hi there, i am trying to remove values from a list menu if the join table doesnt have
keys when a key is selected for instance:
locations
locationID
locations_join
locationID shotlistID
SELECT SQL_NO_CACHE l.locationID , l.location FROM locations l LEFT JOIN
locations_join lj ON l.locationID =
ft_stopword_file The file from which to read the list of stopwords for full-
text searches. All the words from the file will be used; comments are not
honored. By default, built-in list of stopwords is used (as defined in
`myisam/ft_static.c'). Setting this parameter to an empty string () will
funny i was just having the same problemo with mysql 3.22 on php3 the most painful
system to debug i hate it to bits, anyway mysql_error doesnt get returned on
permission or database connection errors, i wonder if that is soughted out in mysql4
?? maybe this is a php.net question
Jon Drukman
Hi there i am trying to work out the most efficient way to list say multiple
categories of entries, the database is quite large about 200 meg.
I would like to know if using join tables is more efficient than storing the keys in a
varchar field then within the second loop doing a where in
Hi i have just come across an issue where a word is not being searched up if there is
any punctuation ie. AMROZI'S will not be search upon if you type AMROZI , please help
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Can someone please tell me if my problem with the punctuation in a fulltext search is
a bug or limitation? Ultimately the users of the system i built do not want to have to
try using the + search then trying the * search for all the words which will
obviouslly return a lot of results, is there
the only thing i could think or is check the length of the varchar , is
that value actually stored properly in the database ?
Hi Daniel,
Here's what is echoed back. It looks valid to me.
SELECT * FROM book_details WHERE ISBN = '1---1'
James
-Original Message-
From
you could do that but as i've found out especially with freetext columns it
wont work the first time takes heaps of times to get it right :\
http://darkstar.ist.utl.pt/mysql/doc/en/LOAD_DATA.html
Pay particular attention to
FIELDS TERMINATED BY '\t' ENCLOSED BY '' ESCAPED BY '\\'
for the
i'd so
select compid,company,phone from companies where MATCH (phone) AGAINST
('+27-21-*', IN BOOLEAN MODE); something like that
is it your number in particular or stuff similar to that ?
you could also try
select compid,company,phone from companies where phone REGEXP +27-21-
Hi
I'm trying
Hi is there any noticable efficiency is ordering the position of the field
types?. Like say i place the join keys in a table at the end, and varchars
and text at the top of the table does it really matter?
Also when i do a query like select * from table where id IN (1), where 1 is
usually a
well the obvious difference between a celeron and a p4 is the cpu cache,
celerons are good for home linux dev box's, i have 2 now but one only has
32meg and is really slow on the queries but they are cheap and do the job i
i rebuilt one and built another box for about 180 AUD :D , i also have a
Lennie wrote:
Hello Guys,
Is there support for ADO?
Im a proffesional Delphi developer and must access mySQL via ADO.
Kind Regards,
Lennie De Villiers
There certainly is. I use MySQL-4.0.14, MDAC 2.7 and MyODBC-3.51.06.
They work like a charm!
--
Daniel Kasak
IT Developer
* NUS
I have also had this trouble before if there are say 5 results from the
second table, the first table of results would be duplicated 5 times on a
join, i would also like to know how to get around this.
G'day all,
I'm pretty new to MySQL and very new to v4.
This is probably going to sound
well i'd like to join tables without duplicates, currently i cannot do this
unless i select the category table in a second loop to list all the
categories for that particular row/record
Hi Daniel and Kim,
Isn't
product_name product_category
product_name product_category
product_name
he is getting the same problem as me as i explained
i use joins left join and inner join
SELECT * FROM products p LEFT JOIN product_cat_join pcj ON
p.productID=pcj.productID LEFT JOIN product_category pc ON
pc.catID=pcj.catID;
products
productID
product
product_cat_join
joinID
productID
catID
how can it be confusing ? nobody ever experienced it before?
simply when you join 2 tables together if you get 5 records from the second
table the first table will display 5 times aswell
Hi Daniel,
I am still not sure what exactly you are trying to achieve.
If you specify the WHERE
what ever happend to a unique primary key like userID ?
gord barq [EMAIL PROTECTED] 08/11/03 11:15am
I have a table I'm using for logging purposes with a schema like:
create table results (
user varchar(255)
);
Where user is not a unique field and I want to find out how many
$query to your browser and then copying the query from
your browser into the mysql client and see if it works.
I suspect there may be something wrong with the data after the $ISBN =
$_GET['isbn'] bit, and echoing the query might make it more obvious what
the problem is.
--
Daniel Kasak
lol mysqladmin -u root -p create database desenv ??
Hi,
I was received a error when I was trying to create a new database on
freebsd 5.1, mysql 4.0.14. The test database is working well.
COMMAND:
mysqladmin create desenv
or
mysql
create database desenv;
ERROR:
mysqladmin: CREATE
scuse the ignorance are u saying high cpu usage is better used on one query
or better be freed up for other queries ? ram is always an issue as the
queries get buffered
Jonathan Hilgeman wrote:
Currently, I have a Celeron 1.2 Ghz server with 512 RAM, and I'm
considering moving to a P4 2 Ghz
setup a dsn in odbc and you could import via a tool called sqlyog
??
Hi all,
Does anyone have any suggestion for converting a Sequel database to
MYSQL? I just want to copy a Sequel database data to a Mysql one.
Thanks in advance for any suggestion,
Mike
--
MySQL General Mailing List
Hi all,
I think you misunderstood me. :-) I try to be more detailed, and I will
also give an example.
So, I have these two tables:
CREATE TABLE main (
ID int not null,
Value int,
primary key (ID)) Type = InnoDB;
CREATE TABLE sub (
MainID int not
processes - often in
unrelated tables - would start appearing. mysqladmin shutdown didn't
work ( but mysqladmin processlist did - go figure ) - I had to kill -9
all mysql processes and restart the server.
I always put the problem down to MS Access and it's record-locking 'style'.
--
Daniel Kasak
Hi all,
I have two tables
CREATE TABLE main (
ID int not null,
Value int
);
CREATE TABLE sub (
mainID int not null,
KeyDate date not null,
SubValue int not null
);
I want the Value field in the main table to be set to the latest SubValue
in the sub table.
I suppose this syntax should
I have an osCommerce Site along with another Dating site on a completely
different server. on the oscommerce site I have 1200 products and the
server queries the records very slowwly. I have enabled gzip compression
to try and speed this up. Only very slightly has the oscommerce site been
sped
i got 0.96 on a dual XEON 2G 1G ram , its a dell box
On Tue, Jul 29, 2003 at 01:41:00AM -0400, Asif Iqbal wrote:
Solaris SPARC 420R 4 * 450 MHz, 4GB - 2.93 secs ... Yikes.. Any
suggestion on how to improve it ?
Get a faster CPU.
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux
being depreciated?
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
--
MySQL General Mailing List
For list archives: http
Hi all, hope I can learn a lot from this mailing list!
_
MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.
http://join.msn.com/?page=features/virus
--
MySQL General Mailing List
For list archives:
of this? I've created an ASP web
interface to an Access database and read/written to it like that in the past
so I assume it's the same for MySQL.
Daniel
_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com
it through the pages? Or is this not possible?
From: awards [EMAIL PROTECTED]
To: Daniel Glenfield [EMAIL PROTECTED],[EMAIL PROTECTED]
Subject: Re: MySQL on a website
Date: Wed, 23 Jul 2003 13:23:43 +0200
Hi,
I doubt you will find free host for MySQL because you seem to use ASP,
which
is really
Thanks for your help everyone!
From: Martin Gainty [EMAIL PROTECTED]
To: awards [EMAIL PROTECTED], Daniel Glenfield
[EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: MySQL on a website
Date: Wed, 23 Jul 2003 08:57:54 -0700
get a broadband connection and host the website yourself
Martin
things that result in pretty horrible
performance. Also DAO is being dropped in favour of ADO by M$ soon, so
you might as well bail out now :)
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922
to compatibility
with other DB servers...
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
--
MySQL General Mailing List
For list archives
Paul DuBois wrote:
At 10:46 +1000 7/23/03, Daniel Kasak wrote:
Hi all.
I need to test whether the first bit of a field is numeric.
For example, the field might contain:
154 boxes
Define this more precisely. Is an acceptable match one or more
digits followed by a space? If so, field REGEXP
!
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
on an
i686? I have a K6-2 which only likes things compiled with -march=i586 or
-march=k6
Thanks!
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website
umm say i reindex after a reimport i usually drop all the indexes first ,
then add indexes again one by one , seems to be quicker for me especially
for fulltext indexes , doing it at once tends to be slower, must crunch the
cpu a bit dont know
On Wed, Jul 09, 2003 at 11:51:01PM -0500, Paul
from now on.
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com
on your computer all by yourself because it
certainly doesn't come with MySQL.
Search on Google for 'AdAware'.
Download it. Install it. Run it. Remove Gator.
Be careful what you install from now on.
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North
is known to be compatible with MySQL 4 and
also if
it is known to support 1000 threads?
I'm using glibc-2.3.2 and MySQL-4.0.13 under Gentoo Linux ( at home, not
on a production server ), and it seems to work fine.
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North
hi there i am having a major matching issue trying to import data from an old database
with free text and matching the record and getting the id , ok say i have a record
which is saraw i need to match it to sara winter for instance how can i do this ?
--
MySQL General Mailing List
For list
provide more info upon request.
Sincerely,
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Hey Keith,
Thanks for the quick reply! Actually I read through that page before and I
tried it and still nothing
mysql SELECT ID FROM emails WHERE MATCH(h_subject, body) AGAINST ('V000*');
Empty set (0.00 sec)
any good reason why that wouldn't work?
Thanks again,
Daniel
Keith C. Ivey
hi there i dont think this will help any further on my full text searching but i would
like an example of how to use FORCE INDEX , there is no example on the mysql site and
the hint is misleading i am getting sql errors , lemme know thanks
--
MySQL General Mailing List
For list archives:
sorry i worked it out put it after the table , i got some interesting results
Queried The Database 1 times for 9.9892050027847 seconds
+---+--+--+--+-++--+-+
| table | type | possible_keys
hi there i was wondering if there is anyway to setup static variables in mysql , ie to
setup predefined paths in mysql . so all i can do is go select variablname as path etc
.. ??
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
hi there , i finally worked out union joines are supported in 4.0 i thought it was 4.1
, anyway what are possible examples of its uses ?
say i'm trying to join two tables the second table has 10 rows returned with the key
of the first table i would like to only get one record from the first
oh dear apologies , i meant virtualhosts in an apache server environment,
as in different sites on the same machine
At 8:22 +1000 6/24/03, electroteque wrote:
this has prob been bought up many of times but how would it be possible
to setup different mysql source instances for each individual
compatible more with sql server 7? This would
help out development as they are rather busy with new releases. Just curios.
Thanks for the help if any body has any thoughts.
Andrew
No.
You need MySQL drivers.
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney
not been released yet.
By the way, what do the Commonwealth Bank use MySQL for? (just curious)
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website
of the package
from redhat. Do you have any comments on this?
I would be very grateful for any help, thanks,
Daniel
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
none of these are open source and its under windows
http://www.minq.se/products/dbvis/images/screens/graph.html
this is what i want to do , except its on myisam tables not inondb so there
is no foreign key relations i join them in the query or can i still do
this ?
Hi Daniel,
The question
than Access'
find methods / CTRL + F.
Hope this helps :)
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
--
MySQL General Mailing
hi there i was wondering if there was a table relationship diagram open source tool
around anywhere ? i am trying to document a project at the moment please let me know
thanks.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Table Group
id int auto_increment
name char
Table Member
groupID int auto_increment
name char
Table Relationship
group_id int
member_id int
i'd set it up like this
Table Group
id int auto_increment
name char
Table Member
userID int auto_increment
name char
groupID
How do you create ascii line breaks in a text paragraph in mysql?.
When displaying text taken from a mysql row it displays it all as a flowing paragraph
ie
sdf sdfgfj fgjhgfh fgj fgj hfj hj hg gh hgk ghk gj gh kg k hg hg jh j fgj fg
When i need to look like
sdf sdfgfj fgjhgfh
fgj fgj hfj hj
Out of interest is there any advantage of using a primary key?, or is it
perfectly ok/normal not to specify one?.
Im not quite sure what a primary does. I only used a primary key on one
table which had auto_increment column only because it forced me to add it.
??
Hello
I belive this is not
I have a mysql table column called 'imagecolumn' The rows contain links i.e.
image.gif
image.gif
null
image.gif
image.gif
To display in my web page im using:
img src=?php echo $row_Recordset1['imagecolumn']; ?
This displays the above images in my html page
The problem i have is where the
as standard INCITS/ISO/IEC 9075-1-1999. The older standard is also
available as ANSI INCITS 135-1992 (R1998) at the same price.
Regards,
Neil
Sounds like the end of the world to me ;)
I suppose you have to get excited about something...
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18
in the 'in' section and turn it into a 'create
temporary table' statement, run it first, then run the main query,
linking on the Companyid, then when you are finished, drop the temporary
table (or let it drop itself when your connection is closed).
--
Daniel Kasak
IT Developer
* NUS Consulting
I have one column as an auto increment for adding numbers:
1
2
3
4
5
If i delete row 3 then add a new row and view the results i get:
1
2
4
5
6
As you can see 3 has been deleted and its now added 6!
Is this normal?. How can i get it to always display numbers in this column
in sequence.
TIA
Any ideas how to get sequential numbers to display with results?.
SELECT * FROM musicchart WHERE artistcountry = ''uk''
I need to get the result to show with numbers down the left side such as:
1 mark
2 john
3 pete
4 mike
5 tom
i.e. if it pulls back 3 results show as
1 john
2 mike
3 tom
I
Hi Jay
Its just a query. And theyre being displayed on a webpage.
Its a chart so i need each result displayed with sequential numbers starting
at 1 - ...
down the left hand side of the results ie.
1
2
3
4
5
etc.
Any thoughts?
[snip]
Any ideas how to get sequential numbers to display
Can anyone advise how we should improve this method of updating our database.
We have a Music chart it is a table with 3 columns
Chart Number (ie, 1,2,3,4,5,6,7,8,9,10..)
Artist (Artists Name)
Title (Title of Song)
Each week we login using mysql control center to make changes to the chart
SET @rank:=5;
UPDATE music SET chart=0 WHERE [EMAIL PROTECTED];
UPDATE music SET chart=chart+1 WHERE chart@rank;
Thanks Don
Unfortunately though i think we need to be able to make the changes in
something we can see which is why we are using mysqlcc.
With mysqlcc any of us can simply
until MySQL-4.1.1 and MyODBC-3.52 until trying it out.
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
--
MySQL General Mailing List
hi just reading up on optimising indexes, does it matter what order u set your indexes
?
The first index part should be the most used column. If you are always using many
columns, you should use the column with more duplicates first to get better
compression of the index.
i dont really
i have one multiple column fulltext index for 3 columns i join in a
fulltext match statement
In the last episode (Jun 01), Daniel Rossi said:
hi just reading up on optimising indexes, does it matter what order u
set your indexes ?
The first index part should be the most used column. If you
informative, it only says that DATE/DATETIME checking
is now a bit stricter to support the ability to automatically distinguish
between date, datetime, and time with microseconds.
Thanks,
Daniel DeLorme
--
Daniel 42 DeLorme
hi sorry to got this , ok
say i search for this something1 something2 + something3 something4 that doesnt
work either is the syntax correct ?
Egor Egorov [EMAIL PROTECTED] 05/29/03 08:15pm
Daniel Rossi [EMAIL PROTECTED] wrote:
i have also noticed that the boolean default is OR how can i
It's not a bug, by deafult variable ft_min_word_len=4, but you search word 'DB' has
length 2.
If you want to search both exact matches use + operator in BOOLEAN MODE or phrase
search:
http://www.mysql.com/doc/en/Fulltext_Search.html
ok well i'm soughting that out but how about the
--
Daniel Kasak
IT Developer
* NUS Consulting Group*
Level 18, 168 Walker Street
North Sydney, NSW, Australia 2060
T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989
email: [EMAIL PROTECTED]
website: www.nusconsulting.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
i am getting people to try and break a search engine i built , when we put in the word
DB into the search query i get no results even if its there in the record , why is
this ?
WHERE MATCH (sl.shotlist , sl.slug , sl.summary) AGAINST ('DB' IN BOOLEAN MODE) LIMIT
0 , 10 ;
also how come this
801 - 900 of 1312 matches
Mail list logo