Is there an MSSQL limit function?

I want to run a query like: select * from table order by rand() limit 3 in MySQL it would work but I need to run it in MSSQL. I've been searching for a limit function in MSSQL and I can't find a way to do it. I'm experienced with MySQL but know nothing about MSSQL. If someone could point me

Re: Statistical analysis query?

Hi. A little explanation of the table usage would have been nice. E.g. it's not clear to me, if shift 232 is also listed in the shifts table or not. I presume the latter from now (in which case shifts is more like a did_show_shifts). Also, you did not specify what special cases are to be taken

Re: Statistical analysis query?

Richard, I'm stumped -- which isn't saying much because I'm hardly a scientist. I am struggling to write a query that will tell me how many times a new volunteer ( defined as a volunteer who has never worked a shift ) did not show up for his shift (first shift). From my data I would

Re: Selecting records with the highest value no greater than x

In Re: Selecting records with the highest value no greater than x, [EMAIL PROTECTED] wrote: IMO, there is one, if I did understand the question correctly: SELECT * FROM NEWS WHERE RATING = 4 ORDER BY RATING DESC, RAND() LIMIT 1; This give back a random news entry of the highest score

Re: [PHP] MySQL question...not sure if this is the correct forum to ask.

Luie, Wouldn't replace change all the entries in your table row, same effect as update? I believe the question is how to test which entry in a form has a new value and replace/update only that value in the table. If I have a form... __ |Employee Record

Re: where to report a bug? (was: mysql from localhost vs. remote)

Hi Benjamin, INSERT INTO mysql.db VALUES ('%','xyz00_%','xyz00','Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); Has the second line anything to do with the behaviour? It shouldn't as you use xyz00 below and user field will match only the user name 'xyz00_%'. nope, has nothing to do with the

Re: Compile error. MySql C++ API

Vipul Kotecha writes: Hi List, I am new to the MySql C++ API and I am compiling one file it gives me error saying Error E2303 ..\..\include\sqlplus\resiter1.hh 56: Type name expected Error E2275 ..\..\include\sqlplus\resiter1.hh 56: { expected Error E2275

SHOW GRANTS not returning anything?

I'm a total newbie to MySQL, so I'm reading the documentation right now. In General Security I read that SHOW GRANTS should give me a picture of who has what rights, but if I use SHOW GRANTS I get the following error: ERROR 1064: You have an error in your SQL syntax near '' at line 1 What am I

Giving root access from another host?

I want to try out MySQL-GUI from my workstation, and I want to connect to my database server, but it says that root has no access rights from this host. How do I give root this kind of acccess? -- Med venlig hilsen/Best regards, Søren Neigaard mailto:[EMAIL PROTECTED] -- Sometimes I think

Re: Giving root access from another host?

Søren Neigaard writes: I want to try out MySQL-GUI from my workstation, and I want to connect to my database server, but it says that root has no access rights from this host. How do I give root this kind of acccess? -- Med venlig hilsen/Best regards, Søren Neigaard mailto:[EMAIL

Changing a query to work with MySQL

Hi, I'm very new to database design and have developed an application running on M$ Access and am currently in the process of moving the back end to MySQL, mainly to make use with a website easier. All is fine except for one query which contains a sub select so therefore will not work. The

Re: SHOW GRANTS not returning anything?

You can SHOW GRANTS FOR foo which gives you information about user 'foo'. To show info about everyone, use SELECT * FROM user; hth Doug On Sat, 16 Feb 2002 13:59:02 +0100, Søren Neigaard wrote: I'm a total newbie to MySQL, so I'm reading the documentation right now. In General Security I read

Giving root access from another host?

Søren, Saturday, February 16, 2002, 3:11:40 PM, you wrote: SN I want to try out MySQL-GUI from my workstation, and I want to connect SN to my database server, but it says that root has no access rights from SN this host. How do I give root this kind of acccess? You should set privileges for

SHOW GRANTS not returning anything?

Søren, Saturday, February 16, 2002, 2:59:02 PM, you wrote: SN I'm a total newbie to MySQL, so I'm reading the documentation right SN now. In General Security I read that SHOW GRANTS should give me a SN picture of who has what rights, but if I use SHOW GRANTS I get the SN following error: ERROR

connections to MySQL

Lonnie, Friday, February 15, 2002, 8:11:59 PM, you wrote: LC Hello All, LC I am new to this list and hope that someone could answer this LC question for me. LC I am running on a fresh install of Redhat 7.2 and am trying to LC connect to MySQL from a program that I have to test the

mysql from localhost vs. remote

Michael, Friday, February 15, 2002, 4:08:42 PM, you wrote: MH Hi mysql list members, MH We use the following statements to setup users and rigts for a mysql MH server which is accessible locally and via internet: MH INSERT INTO mysql.user VALUES MH ('%','xyz00',PASSWORD('...'), MH

Re: Re: Foreign keys in InnoDB tables

Martin, -Original Message- From: Martin Bratbo [EMAIL PROTECTED] Newsgroups: mailing.database.mysql Date: Saturday, February 16, 2002 4:46 PM Subject: Re: Re: Foreign keys in InnoDB tables Heikki here is the statements that i cant get to work: first I create one innoDB table: fk1

Re: Statistical analysis query?

You're stumped!? Where does that leave us? Unfortunately (AFAIK) the sample data you have enclosed does not demonstrate the condition you seek to describe - perhaps it would have been better if you gave us a replicable example, so that we can UNDERSTAND the problem before we try to help you

RE: Suspected Bug

* Miguel Angel Solorzano snip * Roger Baklund mysql rename table U1 to U2; ERROR 7: Error on rename of '.\test\u1.MYI' to '.\test\u2.MYI' (Errcode: 13) mysql alter table U1 rename as U2; Query OK, 0 rows affected (0.01 sec) snip How you can see we don't have a constant behavior of the

RE: Selecting records with the highest value no greater than x

* [EMAIL PROTECTED] In Re: Selecting records with the highest value no greater than x, [EMAIL PROTECTED] wrote: IMO, there is one, if I did understand the question correctly: SELECT * FROM NEWS WHERE RATING = 4 ORDER BY RATING DESC, RAND() LIMIT 1; This give back a random news entry

User Tables

I just reinstalled MySQL 4.01 (Mandrake 8.1) and am having a problem using the GRANT statement. When trying to grant privileges in a database, I get an error message that the User table is read only. I've checked the permissions and they're OK, includes read and write. Am I looking at the

Error untarring MySQL on a RAQ3

While untarring MySQL on a RAQ3 using: tar -xvfz mysql-3.23.32.tar.gz I recieved the following errors: tar: Cannot open z: No such file or directory tar: Error is not recoverable: exiting now Any Help? Should there be a z: directory? And where? Doug Cotton [EMAIL

Re: Distributed Fulltext?

On Fri, 2002-02-15 at 02:44, Alex Aulbach wrote: Wednesday, from David Axmark: Your other point about exact vs. approximate answers is unclear, I expect that Google's answers are exact for their currently available indexes at any given time. But even if they are approximate, I'd be

RE: Error untarring MySQL on a RAQ3

tar -xvfz mysql-3.23.32.tar.gz tar: Cannot open z: No such file or directory tar: Error is not recoverable: exiting now Any Help? Should there be a z: directory? And where? Try: tar zxvf mysql-3.23.32.tar.gz z = gzipped x = eXtract v = verbose f = file You had a 'z'

urgent : Problem in Group by clause

hi all, i have a problem in mysql query... lemme state the scenario... i have a table 'UploadDetails' in which i am storing data regd files... the fields are: FileName, Title, Designer, UploadedBy, SubmittedDate i want to get details about whose files are designed by who..etc... that is i

urgent : Problem in Group by clause

hi all, i have a problem in mysql query... lemme state the scenario... i have a table 'UploadDetails' in which i am storing data regd files... the fields are: FileName, Title, Designer, UploadedBy, SubmittedDate i want to get details about whose files are designed by who..etc... that is i

Re: urgent : Problem in Group by clause

Hi Shankar, This is your old buddy Scott S. Try order by rather than group byThis will get you what you are looking for Scott Salisbury - Original Message - From: SankaraNarayanan Mahadevan [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, February 16, 2002 3:42 PM

RE: Suspected Bug

At 17:59 16/02/2002 +0100, Roger Baklund wrote: Hi, Thanks for the detailed reply. :) I did my tests on a pretty old version, 3.23.30-gamma, on a win2k machine. I was not aware of the lower_case_table_names variable. (This explains why I got lower case filename in my error message, while Fred

suse linux 7.3

well I am running suse linux 7.3 and well to be honest I am a real newbie, so here I go I am gettingh this error msg cant connect to local mysql server through socket /var/liv/mysql/mysql.sock so what should I do_ what does this error msg mean_ cheers

How compressable is a typical MySQL database?

Hi list, How compressible is a typical MySQL database? Is this more dependent on the type of columns used i.e. a lot of text columns as opposed to a lot of columns containing integer values? The uncompressed size of the database is in the region of about 800-MB. Also will it suffice to only

Re: How compressable is a typical MySQL database?

would probably be very dependent on the data within the database. if it's a lot of text data, then very compressable, as text typically compresses nicely. if you store a bunch of binary data (images or something), then probably not as much... tar your mysql dir and gzip it, or gzip -9 or

Re: How compressable is a typical MySQL database?

Sorry, I forgot to ask the folowing as well. When considering the amount by which text can be compressed as compared to other data types, would it be better to store numerical values as text or to store them as integer/float values. If the db needs to be compressed and backed up on a bi-weekly

Re: How compressable is a typical MySQL database?

In that case, i would highly recommend using mysqldump to backup your databases. Simply compressing the actual DB's could give you tables in inconsistent states, UNLESS you first shut down your DB server, then run the backup. Something to think about. j- k- On Saturday 16 February

Cannot create or delete databases

Hello, Just recently I started having problems creating and deleting databases... When I login as the user root I get this error when I try and create or delete a DB. ERROR 1006: Can't create database 'tier2'. (errno: 13) I am fully aware that the errno: 13 is a permissions denied error

beginner question: how many queries via PHP are...

Hello I am new to the subject. I am experimenting in mysql via PHP with a nice book (PHP and MySQL Web development). My question is how many queries to mysql, made via PHP, should considered ok for efficiency. I know it has much to do with the size of databases, but I would like to get an

Re: beginner question: how many queries via PHP are...

I am new to the subject. I am experimenting in mysql via PHP with a nice book (PHP and MySQL Web development). My question is how many queries to mysql, made via PHP, should considered ok for efficiency. I know it has much to do with the size of databases, but I would like to get an idea.

inserting into sets

Would someone please tell me how to insert sets into a MySQL DB? e.g. insert into table_name (x) values ('a', 'b', 'c', 'd'); , where x is a set. I am unsure on what should be inside of the second set of parentheses. Sorry to be posting a syntax question to the list, but I don't see it

operating system error number 3

Hello everyone: I am hoping you can help me. I have Windows 98 SE as my operating system. I have installed MySQL 4.0.1. I originally had Win ME and MySQL 3.23.48 but could not make them work together. Hopefully, someone will be able to help me. The error I am getting is InnoDB: Warning:

I need MySQL-DBI-perl-bin but can only find Mysql-dbi-perl-bin

Hello, I'm sure this is a rehash of a common benchmark installation problem, but my searches have not yielded a satisfactory answer. I've been digging through some old threads related to this subject, but I'm still unable to find MySQL-DBI-perl-bin that is required by

Re: operating system error number 3

At 23:29 16/02/2002 -0500, Loretta wrote: Hi! Hello everyone: I am hoping you can help me. I have Windows 98 SE as my operating system. I have installed MySQL 4.0.1. I originally had Win ME and MySQL 3.23.48 but could not make them work together. Hopefully, someone will be able to help me.

Re: inserting into sets

At 22:47 -0500 2/16/02, John Fulton wrote: Would someone please tell me how to insert sets into a MySQL DB? e.g. insert into table_name (x) values ('a', 'b', 'c', 'd'); , where x is a set. I am unsure on what should be inside of the second set of parentheses. A SET value is a single string

Fw: WIN/Linux Compatibility

Hi all, I was wondering if there is any chance that table information is compatible between Windows and Linux? IE. If I copy windows data files to a linux server, can mySQL on the linux server read this data? I don't believe this is possible, but I couldn't find any posts and wanted to

Re: Fw: WIN/Linux Compatibility

On Sun, 2002-02-17 at 02:54, Alex Charlton wrote: Hi all, I was wondering if there is any chance that table information is compatible between Windows and Linux? Hi Alex, MyISAM tables are (mostly) OS and platform independent. You should be able to copy them between Linux and Windows

Re: How compressable is a typical MySQL database?

On Sat, Feb 16, 2002 at 03:56:42PM -0900, Joshua J.Kugler wrote: In that case, i would highly recommend using mysqldump to backup your databases. Simply compressing the actual DB's could give you tables in inconsistent states, UNLESS you first shut down your DB server, then run the backup.