MySQL Database Forum

Which account privileges are required to execute CREATE DATABASE ? Are the minimum required privileges or does MySQL user must have ALL privileges to execute CREATE DATABASE ? Peter

I'd liek to ask what are the soultions when there are a lot of connections to the db ?? For examlpe in how are builidng the db for mmo web browser based games. There are 15000 users online ... ??

MySQL v5.0.3 -- does this perhaps indicate v5.0.30 ? Or is it kind of like v5.0.03 ? There is MySQL v5.0.15. Can one safely assume that v5.0.15 is newer than v5.0.3 ?

hi, i've searched quite a bit, but cant find any post relating to sql command for setting database passwords. anyone know how? thanks pk

keywords: mysql accounting currency decimal fixed "floating point" Quoting the manual: DECIMAL)] If D is omitted, the default is 0. If M is omitted, the default is 10. All basic calculations (+, -, *, /) with DECIMAL columns are done with a precision of 64 decimal digits. Re: Floating Point limitations and using IEEE format floating...

CREATE TABLE `test`.`buildings` ( `building` VARCHAR NOT NULL DEFAULT '', `location` VARCHAR(45) NOT NULL DEFAULT '', PRIMARY KEY(`building`) ) ENGINE = InnoDB; MySQL Error Number 1064

I am familiar with Microsoft Access, but I have never used MySQL. Does MySQL have the ability to set up Queries and Reports like Access, or do you need separate software in order to do this? It appears PHP is always mentioned in conjuction with MySQL. I really don't want to learn another scripting language and I am not familiar with Unix. Any...

Hi, Has anyone seen where using SELECT * truncates characters ? mysql> SELECT * FROM countries; +-------------+-----------+ | country | capital | +-------------+-----------+ |ghanistan | Kabul |lbania | Tirane

MySQL 3.23.58 - 4.0.17 (yep, several database server instances, don't ask) I have database Spring with table Students I have database Summer with table Students I am tasked to produce a query of all students in both tables with no duplicates. No clue whatsoever.

Hi There, I've got one table that is constantly being added to (every few seconds). I've got a bunch of users that need to report from this table. What's the best way to setup the tables? Create a second table and updates it with tblLive data every let's say 15 minutes and then report off of that? Is there a way to synch tables that...

I wondered if anyone could point me in the direction of a file that lists given names and alternate names such that if you searched on a name such as Robert, you could retrieve all the alternatives (Rob, Robbie, Bob, etc.) I've Googled this up and down, and while I've come up with a lot of name lists (and a post by someone somewhere else in...

My company sells widgets. In our 'shopping cart' that we're building, we want to list out the price for each widget. The problem is that the price varies depends upon which widget package (out of 10) as user selects, as well as which website (out of 8) they visit. So, 80 different possible prices per widget (and there are lots of different...

I install Fedora 4 with web server, after that I installed mysql 5.0.15. Now I can connect to mysql from command line and mysql-administrator and mysql-query-browser. But when I try to test to connect from php code, it told me that "can not connect to local mysql through /tmp/mysql.sock. /tmp/mysql.sock is my sock file to connect and...

What I'd like is given a map id, grab all of the users that point to that map id. Can anybody point me in the right direction? Map ----- id ..... User -------

Hi, Just wondering if anyone could help me optimise this query, it can take up to 3 seconds to execute which makes me think theres probably a better way to do what i'm doing.. SELECT MAX(Latitude) as "MaxLat",MIN(Latitude) as "MinLat",MAX(Longitude) as "MaxLong",Min(Longitude) as "MinLong", count(filtered.serialno) as "count" FROM (

Hi hoping someone might be able to help with this issue, The following query is one i'd love to be able to use, but cant... select nodeid,max(datetimestamp) as datetimestamp,latitude,longitude from trackinglogs group by nodeid order by datetimestamp desc; I'm trying to get the latest rows according to datetimestamp column,

While trying to shorten my files, I tried optimize table - later I found that I need: mysqlcheck -u root -p[password[ --all-databases --analyze --optimize (thanks to Markus Popp). But it gives this error: mysqlcheck: Got error: 1044: Access denied for user 'root'@'localhost' to database 'information_schema' when executing 'OPTIMIZE...

Hi hoping someone might be able to help with this issue, The following query is one i'd love to be able to use, but cant... select nodeid,max(datetimestamp) as datetimestamp,latitude,longitude from trackinglogs group by nodeid order by datetimestamp desc; I'm trying to get the latest rows according to datetimestamp column,

I don't recall exactly what options I selected in September when I installed the beta v5.0.4 on my development machine, But, as I started to develop and then backup data, I noticed that my tables are all using the storage engine: InnoDB. Can someone jog my memory and tell me what options cause that to be the default ? I'm on the fence, b/w...

I install Fedora 4 with web server, after that I installed mysql 5.0.15. Now I can connect to mysql from command line and mysql-administrator and mysql-query-browser. But when I try to test to connect from php code, it told me that "can not connect to local mysql through /tmp/mysql.sock. /tmp/mysql.sock is my sock file to connect and...

Hi. I would like to implementation an application that will connect to a MySQL DB and just monitor a table if a new row is being inserted. If a new row was inserted a sub_method will be triggered. Otherwise, the application will just be idle. Can this be done with MySQL? Thanks!

Hi Everyone I've had a database query page running on a site for a few months: (http://www.learningdirectory.info/search.php) with no problems. The search page contains the following query: SELECT CourseID, tblCourseInfo.ProviderID, tblCourseInfo.OccupationID, tblCourseInfo.AuthorityID, tblOccupations.Occupation,...

Hi Everyone I've had a database query page running on a site for a few months: (http://www.learningdirectory.info/search.php) with no problems. The search page contains the following query: SELECT CourseID, tblCourseInfo.ProviderID, tblCourseInfo.OccupationID, tblCourseInfo.AuthorityID, tblOccupations.Occupation,...

I'm pretty much a newbie on mysql, and I need some help. I am running mysql Ver 12.22 Distrib 4.0.24, for portbld-freebsd5.4 (i386) on a server hosting an active website. The site's developer uses his own php shopping cart to receive customer orders. The configuration was done via cPanel with no external modifications - which produced...

Here's another strange error I'm getting when using ODBC to access MySQL. This time ODBC is being more informative, although all the documentation I've looked at, claims that the function in question (SQLSetPos) should not return the error! I have a result set that has been opened for update. I am trying to delete the current row with a...