473,543 Members | 1,994 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

MySQL Database Forum

MySQL database (open source) - Ask questions about mysql server, setup, queries, optimization, errors, tables, syntax, functions, SQL, storage engines, MySQL cluster, replication, scalability, availability, stored procedures, views and more.
0
514
thread by: 'nuther Bob | last post Jul 19 '05 by: 'nuther Bob
Pardon my heresy...newbie Is there an MS-Windows front end interface for mySQL ? I'm thinking of an MS-Access sort of approach for basic database configuration and maintenance. Maybe there's a back door way to ODBC myself from MS-access to mysql on a Windows system ? Does Mysql have an ODBC front end I can get in through ? Any pointers to...
0
514
thread by: Morten Gulbrandsen | last post Jul 19 '05 by: Morten Gulbrandsen
Hello, starting from some software database spesification, defined in some Enhanced entity relationship diagram, resulting in all kinds of relationships, 1:1 1:Many Many:1
0
514
thread by: liu | last post Jul 19 '05 by: liu
Please wait . . . . . <p> <div align="center"> <br> <a href="http://www.herbal-medical.biz/projectx/hgh.html"><img src="http://www.herbal-medical.biz/projectx/hgh.jpg" border="0"> </a><br> <br> <br>
0
514
thread by: Vorname.nachname | last post Jul 19 '05 by: Vorname.nachname
<HTML> <BODY> <center><table><tr><td><a hrefjxxzmzykmrhref=onxof href="http://xarwdcdb.plusherbal.biz/patch/?gfsowahrz"><IMG SRC="http://213.4.130.210/personal7/bolik15/patch/enp2_01.gif" border=0><br> <IMG SRC="http://213.4.130.210/personal7/bolik15/patch/enp2_02.jpg" border=0><IMG SRC="http://213.4.130.210/personal7/bolik15/patch/enp2_03.gif"...
0
513
thread by: bmmmsmith | last post Jul 19 '05 by: bmmmsmith
Hi friend, you should see this! i saved a bomb.. its a godsend, I have saved a fortune simply put, your matched with the cheapest possible mortgage available for your loan. >----------- http://btrack.iwon.com/r.pl?redir=http://topmortgage@onlinesaleew.com/index.asp?RefID=198478
0
513
thread by: unixman | last post Jul 20 '05 by: unixman
As usual, it is 2:00am, and I'm pulling my hair out, finally resorting to posting in the newsgroups for help. :) Simple problem, in theory. Given table "map": CREATE TABLE map ( entry_id int(10) unsigned NOT NULL auto_increment, piece_id int(10) unsigned NOT NULL default '0',
0
512
thread by: Ma Mei | last post Jul 19 '05 by: Ma Mei
Dear administrator, Now I have a quesion and want to get your help. When I insert an image file data (data size > 64KB) to a BLOB field of MySQL database by com.mysql.jdbc.driber,there is error. Error message as follows: "aq.executeQuery:Communication link failure:comm.mysql.jdbc.packetTooBigException" The part of my program as follows:...
0
512
thread by: asdn | last post Jul 19 '05 by: asdn
Please wait . . . . . <p> <div align="center"> <br> <a href="http://www.herbal-medical.biz/projectx/hgh.html"><img src="http://www.herbal-medical.biz/projectx/hgh.jpg" border="0"> </a><br> <br> <br>
0
512
thread by: gbgbgbgb | last post Jul 19 '05 by: gbgbgbgb
I'm trying to bind the arrow keys to the history search commands. But I just cant make it stick. Here is my .inputrc file: # settings for mysql prompt behaviour #works like a charm Control-r: history-search-backward #none of these affects the up arrow
0
511
thread by: Vidhya CS | last post Jul 19 '05 by: Vidhya CS
hi , I installed MySQL-server-4.0.14-0.i386.rpm MySQL-client-4.0.14-0.i386.rpm when I give mysqladmin -u root it is asking for password . The doc says that initially the password is empty and we just need to press enter . I read the mailing list posting but didnt find any clue i didnt set any password . mysql
0
511
thread by: Tbird67ForSale | last post Jul 19 '05 by: Tbird67ForSale
Has anyone had much luck with UnixODBC on RedHat Linux. I've recently moved a 100 Gb MySQL database from Win2000 Server to a RedHat 9 server and installed UnixODBC to access it. It appears that the performance is dramatically slower using the same application, pointed to the RedHat server. The performance of command line queries works as...
0
511
thread by: anders thoresson | last post Jul 19 '05 by: anders thoresson
Is it possible to resort the rows in a table like in a query where using ORDER BY, but have to new sort order stored in the table structure? -- anders thoresson -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=mysql@freebsd.csie.nctu.edu.tw
0
511
thread by: Jacky Luk | last post Jul 20 '05 by: Jacky Luk
I am storing binary files in my database, I've tried to retrieve it using the following statement select from s_proc where contents = 'ksajfha' but to no avail. Could anyone help? Thanks Jack
0
510
thread by: Wesley Hobbie | last post Jul 19 '05 by: Wesley Hobbie
------=_NextPart_000_0000_01C34DF5.B670D500 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit I am running MySQL 4.0.12 on Windows XP. I am trying to create a library database and have a table named "cardCatalog" in the "library" database. The cardCatalog has the following fields: callNumber (varchar(60)),...
0
510
thread by: Doruk Fisek | last post Jul 19 '05 by: Doruk Fisek
Hi, It is noted in the MySQL manual that unsigned integers bigger than 9223372036854775807 (63 bits) shouldn't be used itnarithmetic operations since signed BIGINT/DOUBLE is used in arithmetic functions. Can we somehow tell MySQL (probably during compilation) to use unsigned BIGINT/DOUBLE for arithmetic functions? (I know MySQL wouldn't...
0
510
thread by: MGW01FI/SRV/TJG | last post Jul 19 '05 by: MGW01FI/SRV/TJG
Incident Information:- Database: d:/Lotus/Domino/Data/mail4.box Originator: <mysql@freebsd.csie.nctu.edu.tw> Recipients: <claes.bergsten@tjgroup.com> Subject: Re: That movie Date/Time: 21.08.2003 01:14:59 The file attachment your_document.pif you sent to the recipients listed above was infected with the W32/Sobig.f@MM virus. The...
0
510
thread by: Leythos | last post Jul 19 '05 by: Leythos
I have decided to start learning MySQL, but I'm kind of a very old (long time) MS SQL programmer/designer. I'm use to using the GUI to interact with the database (Query Analyzer) and I like the Enterprise Manager too. Are there any quality freeware apps out there for doing this with MySql on a Windows XP platform? I've looked, but there are...
0
509
thread by: No | last post Jul 19 '05 by: No
I have a MySQL database and I want to cut and paste a part of it into my current MySQL database. is there a certain place that it has to be cut ? Here is a sample of the data, can someone tell me where I start the cut. # # Dumping data for table `category` # INSERT INTO `category` (`id`, `name`, `pid`, `fset`, `weight`, `image`,
0
509
thread by: Eric B. | last post Jul 19 '05 by: Eric B.
Hi, I'm somewhat new to MySql. I've been using it for a while, but pretty much out of the box setup, and am starting to suffer heavily with my larger tables. I have a table with 5,000,000+ rows that I have to search and do joins on. Although I have an index set up for it, the joined select will still take some 400+ seconds to return,...
0
508
thread by: MaFai | last post Jul 19 '05 by: MaFai
Hello, mysql, Yesterday,mysql process disappear sliently. After I check the err-log,no clues found. But the PID file still exising.I think the mysql terminate by some reason.But I still not found why. The error-log mysqld.log wouldn't provide any valueable msg.It just contains the shutdown & start up log. Any idea? Best regards.
1
508
thread by: Dave Posh | last post Jul 20 '05 by: steve
I seem to be having a problem displaying time stored in mysql. The format stored in the database is 13:15:05. The database data type is time. I'm using asp vbscript and sql to retrieve the time store in the database. However asp recognizes the data type as date and displays the date instead of the time. If I change the data type in mysql...
0
507
thread by: Misaochankun | last post Jul 19 '05 by: Misaochankun
I am coming across an annoying problem with a new InnoDB installation. On a 4Gig RAM box, Mysql doesn't seem to want to grab the RAM I am telling it to take. I would like for it to try and use around 3 Gigs for its innodb_buffer_pool_size, but it refuses to startup with anything greater than 512M. I bugged RedHat about it, and they had me...
0
507
thread by: Adam Shaw | last post Jul 19 '05 by: Adam Shaw
Here's a SQL question a friend asked me recently...I came up with a solution, but I'm not sure it's the ideal one, so let me know what y'all think... His database has a table of actors in it, a table of movies, and an intermediate table ("casts") containing the keys from both. The tables are roughly like this: actors:...
0
507
thread by: | last post Jul 19 '05 by:
I must learn SQL. Do you know any good book which I can found on-line? (and free of-course)
0
506
thread by: Marc Slemko | last post Jul 19 '05 by: Marc Slemko
Suppose I have an innodb table in 4.0.14 and do: LOCK TABLE maggie INSERT INTO maggie values(123, 'simpson'); UNLOCK TABLES As soon as I issue LOCK TABLE, any transaction in progress is automatically committed. By what point is this INSERT guaranteed to be committed to disk

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.