Anthony Ward wrote:
SELECT userid FROM place WHERE acos( cos($longitude) * cos($latitude) *
cos(place.latitude) *cos(place.longitude) +cos($longitude) * sin($latitude)
* cos(place.latitude) * sin(place.longitude) +sin($longitude) *
sin($latitude) ) * 3963 <= 1000);
Would you consider this HORRIBLY
hello all,
sorry for the newbe question, but want is the correct command line sytax to
restore table data from a file, table_name.sql
each of our .sql files contains all the table structure and insert data and we
need to restore a whole bunch of tables and data.
TIA
--
MikeBlezien
=-=-=-=-=-=-
Hi folks,
A couple of my sites are intermittently getting the following error:
2014 - Commands out of sync; You can't run this
command now
select configuration_key as cfgKey,
configuration_value as cfgValue from configuration
On one site the error is being reported regularly by
Probably this is what you want
http://www.webyog.com/forums/index.php?act=ST&f=5&t=351&s=7cd9c97584811d72b9305d3e691ab28f
Karam
--- Daniel Crompton <[EMAIL PROTECTED]>
wrote:
> Out of interest is there any advantage of using a
> primary key?, or is it
> perfectly ok/normal not to specify one?.
>
Carlos,
> The character sets in both mysql severs in linux and windows are the same.
> When I query a table which has the same data in spanish with accents I can see the
> characters written are different.
1) So what are the values of the character_set and character_sets
variables, anyway?
2) W
The character sets in both mysql severs in linux and windows are the same.
When I query a table which has the same data in spanish with accents I can see the
characters written are different.
My goal is to extract data from one of the data bases and be able to get then to the
other database betwe
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 no
Hello
I belive this is not the correct place to ask the
question. You can try your discussion forums at
http://www.webyog.com/forums for SQLyog specific
questions.
Karam
--- William IT <[EMAIL PROTECTED]> wrote:
> Why SQLyog can not insert/update Table w/o Primary
> Key? Is there additional sett
Or alternatively, (as I read it), use a char(0). Poss. Values NULL or ''
(empty string).
Kyle
-Original Message-
From: Becoming Digital [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 11:04 AM
To: [EMAIL PROTECTED]
Subject: Re: general questions
Actually, the ideal type for boo
Hi,
I need to calculate distance from a point and for the select statment I have
this
SELECT userid FROM place WHERE acos( cos($longitude) * cos($latitude) *
cos(place.latitude) *cos(place.longitude) +cos($longitude) * sin($latitude)
* cos(place.latitude) * sin(place.longitude) +sin($longitude) *
Daniel,
'auto_increment' won't do that job for you and maybe it's not the right way
to think about it anyway. You really only want to use 'auto_increment' for
records that need to maintain serial numbers. If you are deleting records
and wanting to use the 'deleted' number then your 'serial number'
Hi all,
i am analyzing a very strange behaviour of mysql-3.23-53-log
on a Suse 8.1 system:
I have created a table Customer with a column:
customer_id int(11)
Now i want to select all rows with customer_id=41:
SELECT * from Customer WHERE customer_id=41;
The result is: Empty set (0.13 se
"Mike Walth" <[EMAIL PROTECTED]> wrote:
> I have gone through the documentation, and also the archives, and still
> can't grasp why things happen with privileges.
>
> Here is what I am trying to understand and accomplish. For my own benefit
> I'm trying ot understand the user and db tables of mys
sean peters <[EMAIL PROTECTED]> wrote:
> Hi all, I am wondering if there is a way to transform the following query
> using LIKE & OR into a query using IN, where the IN ( list) contains wildcard
> expressions.
>
> initial query:
> SELECT ID FROM address WHERE Street_Name LIKE "first%" OR Street_
Hu Qinan <[EMAIL PROTECTED]> wrote:
>
> I am wondering whether constant arguments are required in string functions, e.g.
>
> Substring(str, pos, len).
>
> Given MyTable:
>...
>MyString TEXT,(muti-byte characters)
>MyPos UNSIGNED(10),
"Massimo Petrini" <[EMAIL PROTECTED]> wrote:
> It is possibile to make an export dump, excluding some tables ? In other
> word to make a little dump, but with the features of mysqldump (my db has
> around 100 table and I want to export only around 96)
Nope.
--
For technical support contracts,
Karam Chand <[EMAIL PROTECTED]> wrote:
> It seems that an extra column has been added to the
> column information returned from the query]
>
> show fields from `dbname`.`tablename`
>
> the column is called collation and gives some extra
> information.
>
> Can somebody tell the exact version of
Actually, the ideal type for boolean operations is TINYINT(1), which, according
to the MySQL Column Types page, is the equivalent of a BOOL or BIT column.
http://www.mysql.com/doc/en/Column_types.html
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Kier
> SO, there is another language afoot here, right? You have to have
> something to retrieve to the web page, like PHP, PERL, VBScript, etc.
You beat me to it. Adding sequence numbers in PHP or PERL is almost too easy.
It's when you get into making the DB do all the work that you run into trouble.
Hi,
I guess this is right place for this. I'm trying to setup replication
between two hosts over the Internet.
My problem is that i can't seem to solve an authentication problem
between the slave and the master. Before I tried this I setup a test
between two computers here in the office and manag
> You might find the two-volume series of books from Len Silverston,
> entitled 'The Data Model Resource Book: A Library of Universal Data
> Models for All Enterprises' from Wiley to be up your alley:
I hope those books are good bcs I just bought both from Amazon. Fortunately, I
was able to get t
It is possibile to make an export dump, excluding some tables ? In other
word to make a little dump, but with the features of mysqldump (my db has
around 100 table and I want to export only around 96)
Tks in advance
-
Massimo Petrini
c/o Omt
I'm not entirely sure what you're experiencing, but don't you need data types
for (2) and (3)? Perhaps MySQL defaults to INT, but I'm not sure.
Check out http://www.mysql.com/doc/en/String_functions.html for more info, but
look into the above item first. I have a sneaking suspicion that's your
p
Why SQLyog can not insert/update Table w/o Primary Key? Is there additional setting to
enable this?
Dear all,
I am wondering whether constant arguments are required in string functions, e.g.
Substring(str, pos, len).
Given MyTable:
...
MyString TEXT,(muti-byte characters)
MyPos UNSIGNED(10),
MyLength UNSIGNED(10).
While (1) wor
Vielen Dank, Mark
Cheers
Terry
--Original Message-
> Use "source " from the mysql command line
> Start mysql in the bin directory, switch to the db in use via "use
> "
> and run the command "source "
>
> Or read the manual section "3.6 Using mysql in Batch Mode"
>
> Cheers
Yes
--Original Message-
> Hi,
>
> I have written a program that creates statments for me, and sometimes I
> end
> with
> SELECT..WHERE number IN(1)
> instead of
> SELECT... WHERE number IN(1,2,3,4)
> would number IN(1) works,
> for the moment i have no mean to test it, it
On Mon, 2 Jun 2003, Frank Nørvig wrote:
> Hello,
>
> I was wondering if the following could be done with an advanced
> sql-statement in MySQL 3.23:
>
> I have 5 tables with the following columns: id, name, phonenumber
> I need to check for duplicate phonenumbers in the 5 tables, that is if the
> I am using MySql v.4.0.13 and am trying to query the user table from Visual
> Basic using ADO. If the user has an entry, that is uppercase lowercase,
> e.g. Jim, and my query is:"select user from mysql.user where user ='Jim'"
> the recordset returned is empty. But, if the entry in the user fiel
Hi Mike,
there are two reports on devshed which I believe are an excellent source.
There is really nothing to add. Print them off read them carefully on your
way home and tomorrrow you will be 2 steps further.
http://www.devshed.com/Server_Side/MySQL/Access/page1.html
http://www.devshed.com/Ser
Hello
It seems that an extra column has been added to the
column information returned from the query]
show fields from `dbname`.`tablename`
the column is called collation and gives some extra
information.
Can somebody tell the exact version of MySQL from
which this extra information was added.
Hello
MySQLGUI has been deprecated for long. If you are on
Windows then you can try out another client called
SQLyog from http://www.webyog.com/sqlyog which I find
more powerful and easy to use.
Karam
--- Mark Matthews <[EMAIL PROTECTED]> wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
Hello all:
I have gone through the documentation, and also the archives, and still
can't grasp why things happen with privileges.
Here is what I am trying to understand and accomplish. For my own benefit
I'm trying ot understand the user and db tables of mysql.
If I setup a user with no privile
Nils,
(B
(BI agree with you, you do have to have all the log files, which is why I
(Breset the master.
(B
(BAccording to the manual:
(B
(B4.10.7.5 RESET MASTER (master)
(B
(BDeletes all binary logs listed in the index file, resetting the binlog index
(Bfile to be empty. Previously na
PHP is a different topic you have to use a procedure called "mysql_pconnect".
However that is well documented in several PHP documents.
Best regards
Nils Valentin
2003年 6月 3日 火曜日 11:44、Kalin Mintchev さんは書きました:
> On Tue, 3 Jun 2003, Nils Valentin wrote:
> > How do you login to mysql ?
> >
> > m
Hi Calvin,
I am not sure which table format you use, but somehow I assume you use innodb.
If I remember correctly than Innodb will need all log files. If only one is
missing than thats it, you get the error described.
- anybody please correct me if I talk rubbish here
Best regards
Nils Valent
On Tue, 3 Jun 2003, Nils Valentin wrote:
> How do you login to mysql ?
>
> mysql -u user -p -h localhost
>
> should do it.
cool... thanks. BUT it doesn't work within a php script?!
it worked on the command line... any idea why not within php?!
thanks
>
> You dont even need "-h localhost" in
How do you login to mysql ?
mysql -u user -p -h localhost
should do it.
You dont even need "-h localhost" in this case.
Best regards
Nils Valentin
Tokyo/Japan
2003年 6月 3日 火曜日 11:31、Kalin Mintchev さんは書きました:
> hi everybody...
>
> i just installed mysql 4.0.13 on a redhat linux 8.0
> when i cr
Hello,
I'm running MySQL Ver 12.18 Distrib 4.0.12 I had replication set up and
working perfectly between two machines in a round robin fashion. (Serv 1
updates Serv 2 and Serv 2 updates Serv 1.)
Recently serv 2 locked up, upon restarting, it automatically began to
update with the files fr
hi everybody...
i just installed mysql 4.0.13 on a redhat linux 8.0
when i create a database as root and then grant privileges to another user
like this:
GRANT ALL ON somedb.* TO [EMAIL PROTECTED] IDENTIFIED BY "passwd";
everything seems to be fine but then if i log in as "user" and try to get
t
I apologize in advance for what I realize is a rather broad
question, and one that is mostly Perl and not MySQL.
I've been writing Perl scripts for using MySQL databases on
the Web. Paul DuBois' _MySQL and Perl for the Web_ has been
enormously helpful to me, and most of my programs are based on
I think I've managed to change it so "mysql" is the user now. All the files
in /var/lib/mysql are still owned by "root" - should I chown them so they
belong to "mysql"?
[admin admin]$ ps auxw | grep mysqld
root 6936 0.0 0.1 1672 824 ?S15:04 0:00 sh
/usr/bin/safe_mysqld --da
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
aghajani wrote:
> Hello,
> I have downloaded all the following files, but I cannot find the file
> mysqlgui.exe I am interested in using the graphical MySQL client.
Could you
> please help me where I can find this file?
> Thank you very much
> Jaafar
Hello,
I have downloaded all the following files, but I cannot find the file
mysqlgui.exe I am interested in using the graphical MySQL client. Could you
please help me where I can find this file?
Thank you very much
Jaafar Aghajanian
MySQLGUI 1.7.5 Source Code
Statically Compiled MySQLGUI 1.7
On Mon, Jun 02, 2003 at 06:49:42AM -0700, Admin wrote:
> Is there any way to do a hexadecimal search via MySQL? I've found that the
> data I uploaded from text files has some end-of-line characters in it, and
> its causing my data to break in mid-line when spitting out a text file.
> Would be cool
On Mon, Jun 02, 2003 at 12:48:38PM +0200, Dejan Milenkovic wrote:
> I have two tables, one is containing data about courses and the second one
> is containing data about course start date.
> Is it possible to list all courses with one query which should also return
> earliest scheduled start dates
But is it available on AIX 4.3.x ?
-Ares
On 02 Jun 2003 19:50 CST you wrote:
> DATA DIRECTORY and INDEX DIRECTORY is ignored on Windows.
>
>
>
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
--
MyS
Mike-
check out
http://www.mysql.com/doc/en/SHOW_VARIABLES.html
for information on which variables to SET for configuring MySQL
Hth,
Martin
- Original Message -
From: "ComCity" <[EMAIL PROTECTED]>
To: "Peter J. Milanese" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, June 02, 200
Doing more research...found a file called my.cnf. That appears to be the
right file. It has the datadir in there. So if I just point the datadir to
the right place it will simply wake up mySQL to the /datadir/mysql system
table and the databases huh?
I found out that the previous version was 3.
You can set this up in the setup dialog for a database connection or later.
AS you alreay have the connection I explain how to do it later.
Right mouse cick on the database connection (seen on the left side).
Choose "edit" from the right mouse button menu.
Choose the databases tab and then cli
No swearing please, we are not on holiday ;-)
Best regards
Nils Valentin
2003年 6月 3日 火曜日 07:14、electroteque さんは書きました:
> myisam/ft_static.c'.
>
> so i have to edit this and recompile ? what a pain in the ass , i'll have
> to try and format it then
> -Original Message-
> From: Sergei Golu
Hi ED,
The famous error 13 ;-)
Linux permissions not set correctly.
The problem is the user account you specified for the mysql files & directory.
If you look at your database directories f.e /var/lib/mysql do:
ls -al >> look at the user acounts is uses
baby-bumble-bee:/var/lib/mysql # ls -al
To whom it may concern,
I am using MySql v.4.0.13 and am trying to query the user table from Visual
Basic using ADO. If the user has an entry, that is uppercase lowercase,
e.g. Jim, and my query is:"select user from mysql.user where user ='Jim'"
the recordset returned is empty. But, if t
Newbie doing disaster recovery...oh my.
I'm trying to do some diasaster recovery on a machine running mySQL. I
could use a little bit of help...even if its pointing me in the right
direction only...
I can see I have some .MYD, .MYI, and .frm files that look to be the
original database files. I'
Try sub-ing to [EMAIL PROTECTED] and then sending a message
there. That's the list for source code contributors.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Paul G." <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, 02 June, 2003 18:09
Subj
Hi there,
I have a table in which a column is referencing another column in the
same table.
CREATE TABLE `Shops` (
`ShopId` smallint(8) unsigned zerofill NOT NULL auto_increment,
`Shop` varchar(100) NOT NULL default '',
`Node` smallint(8) unsigned default NULL,
`Seq` smallint(5) unsigned
myisam/ft_static.c'.
so i have to edit this and recompile ? what a pain in the ass , i'll have to
try and format it then
-Original Message-
From: Sergei Golubchik [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 03, 2003 12:53 AM
To: Egor Egorov
Cc: [EMAIL PROTECTED]
Subject: Re: ft_boolean_
i have redhat e. v2.1 mysql v. 3.23.54a-3.72, postfix 2.0.10, courier-1.7.3
and amavisd-new (newest version) and i'm successfully running mysql as the
backend for both. My question is this:
all of the data for the above programs is all stored in a bunch of different
tables. aliases_this, virtua
> At 14:38 -0700 6/2/03, Paul G. wrote:
> > > At 14:21 -0700 6/2/03, Paul G. wrote:
> >> >Anyone know where to find the documentation associated with patch
> >> >submittal? That is from inception and determination of need for
> >> >the patch to the final application of a patch?
> >> >
> >>
Try SELECT * FROM table1 ORDER BY RAND() LIMIT 10;
-Original Message-
From: PaT! [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 4:53 PM
To: [EMAIL PROTECTED]
Subject: select with random result
Hi,
how can I write a select where I have a limit result of records but
random.
Someth
Hi,
how can I write a select where I have a limit result of records but
random.
Something like
SELECT * FROM table1 LIMIT RAND(10);
I know this syntax is wrong I need to know the right one
Thanks.
PaT!
mysql
At 14:38 -0700 6/2/03, Paul G. wrote:
> At 14:21 -0700 6/2/03, Paul G. wrote:
>Anyone know where to find the documentation associated with patch
>submittal? That is from inception and determination of need for the
>patch to the final application of a patch?
>
Is this a MySQL question?
Yes.
Hi,
I'm using
MySQL 4.0.13
OS Windows 2000 server SP3
I have the following problem:
I had a local user that used regularly to access with winmysqladmin
User name and no password
Now it can access from the shell but can't from winmysqladmin anymore.
Don't know why, I think I didn't change anythin
> At 14:21 -0700 6/2/03, Paul G. wrote:
> >Anyone know where to find the documentation associated with patch
> >submittal? That is from inception and determination of need for the
> >patch to the final application of a patch?
> >
>
> Is this a MySQL question?
Yes.
Paul G.
>
At 14:21 -0700 6/2/03, Paul G. wrote:
Anyone know where to find the documentation associated with patch
submittal? That is from inception and
determination of need for the patch to the final application of a patch?
Thank you,
Paul G.
Is this a MySQL question?
--
MySQL General Mailing List
F
You need a LEFT JOIN.
SELECT blah, blah, blah
FROM bite bite LEFT JOIN person agency ON agency.person_id =
bite.bite_agency_id
WHERE bite.bite_id = "AC-2003-0004";
Check out http://www.mysql.com/doc/en/JOIN.html to learn more about LEFT
JOIN.
Regards,
Mike Hillyer
www.vbmysql.com
-Original
Anyone know where to find the documentation associated with patch submittal? That is
from inception and
determination of need for the patch to the final application of a patch?
Thank you,
Paul G.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/
Greetings!
I have a query for a report that accesses columns that could possibly be
null. Here's an example:
SELECT blah, blah, blah
FROM bite bite, person agency
WHERE bite.bite_id = "AC-2003-0004"
AND agency.person_id = bite.bite_agency_id;
bite.bite_agency_id and other fields like this could
dbmail.
http://www.dbmail.org/
I'm using it and so far I'm having really good luck with it.
-- Jason
On Mon, 2003-06-02 at 14:13, David Garamond wrote:
> I'm just wondering if there is an MTA/MDA/IMAPD/Exchange-like app/other
> mail-related daemons that stores mail messages in a relational
I'm just wondering if there is an MTA/MDA/IMAPD/Exchange-like app/other
mail-related daemons that stores mail messages in a relational database
like MySQL?
Regards,
--
dave
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EM
Hi all, I am wondering if there is a way to transform the following query
using LIKE & OR into a query using IN, where the IN ( list) contains wildcard
expressions.
initial query:
SELECT ID FROM address WHERE Street_Name LIKE "first%" OR Street_Name LIKE
"second%"
desired format would be somet
Define the field as type ENUM [NOT NULL] with values "N" and "Y", but read
and understand the ENUM type before you use it so you understand what
happens when someone tries to insert something other than Y or N. ENUM (Y/N)
is what MySQL uses in the mysql permissions database. So, examine some of
the
Hi Darryl,
Am Montag, 2. Juni 2003 21:58 schrieb Darryl Hoar:
> Greetings,
> I am trying to figure out how to define a field type as boolean. Is
> there a way? Or must
> I define the field as integer and represent true/false with 1/0 ?
To my knowledge the MySQL "equivalent" to the boolean type i
Hi there, I´m using control center 0.9.1-beta and when I started it, and
write a sql command with a database already selected(green color), I always
need to write first, the name of database which i´m using...
like that:
use dbteste;
select * from..
Is there possible to use a databse by defa
Greetings,
I am trying to figure out how to define a field type as boolean. Is there a
way? Or must
I define the field as integer and represent true/false with 1/0 ?
I have a schema defined for a database. I would like to copy that schema to
another
database. Is there a simple way to accomplish
Is this for display in the MySQL client, or will it get parsed by some
application?
If parsed, you may want to do three separate queries with an UNION, then
add up the resulting three numbers.
SELECT SUM(value) FROM stats_picturecollection_nypl_org.0403_detail
where epoch between 105000 and 1
Hi,
I have written a program that creates statments for me, and sometimes I end
with
SELECT..WHERE number IN(1)
instead of
SELECT... WHERE number IN(1,2,3,4)
would number IN(1) works,
for the moment i have no mean to test it, it is why i'm asking.
Regards,
Anthony
--
MySQL General Mailing
Well
I was thinking about that...
However-
select sum(value) from
stats_picturecollection_nypl_org.0403_detail,stats_picturecollection_nypl_org.0503_detail,stats_picturecollection_nypl_org.0603_detail
where epoch between 105000 and 1054561843 and type='sessions_unk'
Also reports that
You should probably use mysqldump for this. For information on this
program, check out:
http://www.mysql.com/doc/en/mysqldump.html
On Mon, 02 Jun 2003 14:21:06 -0300, Celso wrote:
> Hi people,
> What I need make to copy Struct and Data from Database in my machine
> to another machine (export) i
Hi,
I am creating a StopWord File in Brazilian Portuguese for MySQL based in
statistical ocourrence of common words of a very large database, but it
isn't working correctly:
1) I changed the ft_stopword_file in my.conf pointing to a file where I put
the stopwords (each line one word).
2) Seeing
Ok...
select ref.zipcodes.state as state, count(1) as count
from
BIGTABLE,BIGTABLE2,BIGTABLE3,ref.zipcodes
where tsb between $Start and $End
and bigtable1.zipcode=ref.zipcodes.zipcode
and bigtable2.zipcode=ref.zipcodes.zipcode
and bigtable3.zipcode=ref.zipcodes.zipcode
group by state
order
Read the Foreign Key section of the InnoDB manual
(http://innodb.com/ibman.html#InnoDB_foreign_keys): it explains why you may get
an error code 150. Particularly:
Both tables have to be InnoDB type and there must be an index where the
foreign key and the referenced key are listed as the
[snip]
Its just a query. And theyre being displayed on a webpage.
[/snip]
This just caught my eye ... "And theyre being displayed on a webpage."
SO, there is another language afoot here, right? You have to have
something to retrieve to the web page, like PHP, PERL, VBScript, etc.
You can also
[snip]
You will have to do two things, set a variable to zero and then add to
it on each iteration. Yes...those are variables and that is a colon in
the SELECT statement.
SET @count=0;
SELECT @count:[EMAIL PROTECTED], this_column, that_column, etc
FROM your_table;
[/snip]
I should have mentioned
You will have to do two things, set a variable to zero and then add to
it on each iteration. Yes...those are variables and that is a colon in
the SELECT statement.
SET @count=0;
SELECT @count:[EMAIL PROTECTED], this_column, that_column, etc
FROM your_table;
HTH!
Jay
--
MySQL General Mailing Lis
The basic layout of concerned tables:
BIG1|
BIG2|
BIG3ref.zipcodes
Whereas, BIG# should be treated as one table
"Mike Hillyer" <[EMAIL PROTECTED]>
06/02/2003 01:38 PM
To: "Peter J. Milanese" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
cc:
Subje
Apologies.. I left that out...
The ambiguous column is 'zipcode'. it is common between all tables.
P
"Mike Hillyer" <[EMAIL PROTECTED]>
06/02/2003 01:38 PM
To: "Peter J. Milanese" <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]>
cc:
Subject:RE: Suggestions on
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 with
[snip]
Any ideas how to get sequential numbers to display with results?.
...
Any ideas?
{/snip]
Are you just doing this in a query? Or is there another language
involved?
Jay
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
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 ca
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
sean peters wrote:
> Hi all, I just recently figured out a style of SQL book (or on-line
info) that
> would greatly help me. I have been reading a book entitled "Design
Patterns
> in Object Oriented Programming", and realized that analogous info
proba
What column is MySQL complaining about being ambiguous? Isn't it just a
matter of adding tablename. To the start of the guilty column?
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Peter J. Milanese [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 11:25 AM
To: [EMAIL PROTEC
Wouldn't you just type SELECT.LIMIT 10,10 ??
Mike Hillyer
www.vbmysql.com
-Original Message-
From: Anthony Ward [mailto:[EMAIL PROTECTED]
Sent: Monday, June 02, 2003 11:21 AM
To: [EMAIL PROTECTED]
Subject: Row Number
Hi,
If i have a table with just "Userid,Name,Language"
> If i have a table with just "Userid,Name,Language"
> where userid is primary key.
> now if i search the first 10 people that speaks english i.e
> SELECT * FROM tablex WHERE language='English' LIMIT 10;
>
> Can't i get the row number of the last matched record?
> So i can do
> SELECT...LIM
Greetings:
I have a series of large tables. 5+gb each.
They have identical structures.
Sample of the query I want to run:
select ref.zipcodes.state as state, count(1) as count from
BIGTABLE,BIGTABLE2,BIGTABLE3,ref.zipcodes where tsb between $Start and $End
and zipcode=ref.zipcodes.zipcode group
Hi all, I just recently figured out a style of SQL book (or on-line info) that
would greatly help me. I have been reading a book entitled "Design Patterns
in Object Oriented Programming", and realized that analogous info probably
exists for database design.
So, im looking for literature on SQL
You can use BENCHMARK to test it. I doubt the difference in speed would be
terribly significant, however the longer field will take up more space.
Edward Dudlik
Becoming Digital
www.becomingdigital.com
- Original Message -
From: "Derick Smith" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Hi,
If i have a table with just "Userid,Name,Language"
where userid is primary key.
now if i search the first 10 people that speaks english i.e
SELECT * FROM tablex WHERE language='English' LIMIT 10;
Can't i get the row number of the last matched record?
So i can do
SELECT...LIMIT nex
Hi people,
What I need make to copy Struct and Data from Database in my machine to
another machine (export) in the web ?
The my host in the web work with phpMySQL.
tks,
Celso
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.
MySQL is included in Out-of-the-Box 2.0, an intelligent distribution
of over 100 Open Source projects for Java developers on both Linux and
Windows.
Its graphical installer provides selective and incremental installation and
uninstallation, automatic project dependency management, easy project
con
1 - 100 of 119 matches
Mail list logo