Sponsored Links

comp.databases.mysql comp.databases.mysql

Page 8 of 128

108

Last »

Threads in Forum : comp.databases.mysql

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Problems creating a table with foreign keys. the error code makes no sense. Here is the table I am attempting to create. DROP TABLE proc_trans_distinctions IF EXISTS; CREATE TABLE proc_trans_distinctions ( `m_id` int(10)... Ted Byers	02-18-2011 03:21 AM Álvaro G. Vicario	5	6
mysqldump gives Error 2020: Got packet bigger than'max_allowed_packet' I have a InnoDB table that holds large BLOB objects containing PDF files, some of which are up to 100 megs. I have max_allowed_packet set to 512MB... Ignoramus5243	02-17-2011 05:32 PM Ignoramus5243	6	7
Bad query Hello I have table BLOG id, user_id, creation_date, name, content (around 7000 records) And then I have table SITE_USERS id, name (around 20000... pac Man	02-17-2011 08:09 AM Jerry Stuckle	3	4
Whitepaper, Agile Business Intelligence The paper discuses the ability of an Agile BI rollout to respond to changing data analysis and reporting needs, and provide vital insights into an... JTP PR	02-16-2011 09:50 PM JTP PR	0	1
MySQL-Cluster setup partialy working ... Hi! After searching google for a while, not finding anything, RTFM, and trying out varios thing with no result, I finaly ask the profs: I have set... Thomas Schweikle	02-16-2011 05:57 PM Axel Schwenke	3	4
SELECT when WHERE condition is in another table ( 1 2 ) Hi I have a table 'major' containing only two columns 'city' and 'pop'. I have another table 'country' containing 100 columns. I want to SELECT... John	02-16-2011 08:17 AM The Natural Philosopher	17	18
Quit Doesn't Work Hi, If my SQL script file Test.sql contains the 3 lines: SELECT * FROM Table1; QUIT; SELECT * FROM Table2; and I run the script from a Mysql prompt... Joe Hesse	02-14-2011 09:08 AM Luuk	1	2
High concurrency SELECT / UPDATE procedure ( 1 2 ) Hi, I'm messing with this scenario: - MySQL 5.0.x (it should work on 5.5 too) - high concurrency jdbc client connections. The code below is a... Mau C	02-14-2011 08:09 AM Jerry Stuckle	19	20
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 14 Feb... me	02-14-2011 04:32 AM me	0	1
SQL injection attacks against websites I have always been slightly paranoid about sql injections. To that end, I am following certain practices, such as: 1) all user input (received from... Ignoramus20766	02-14-2011 03:19 AM Willem Bogaerts	4	5
Adding to a database ( 1 2 ) Hello, I have a mysql database that keeps track of some users and their files. The database is manipulated with an iphone app that communicates with... Bint	02-11-2011 06:38 AM The Natural Philosopher	13	14
One MySQL table is marked as crashed periodically I have a website algebra.com, and it uses mysql 5.0.51a on Ubuntu Hardy. In the database, I have a sessions table to hold apache session data. I have... Ignoramus14242	02-11-2011 04:28 AM andre	2	3
Nightly backup is killing my db Hi, I have a medium sized site/db that does UPDATEs and SELECTs at almost every single page load, (if you are a registered user). When I run a... Simon	02-09-2011 06:57 AM The Natural Philosopher	4	5
Re: Building a report from two tables... Correction to the sql statement.... Select Customer_Name, Customer_Telephone, Order_Amount from Orders where Order_Amount > 100 SpreadTooThin	02-07-2011 09:05 PM Jerry Stuckle	3	4
Help with default password and sign-in I've forgotten some stuff here and can't find an easy reference. I have a copy of EasyPHP installed on my computer and it has a SQL server. I'm... MikeB	02-07-2011 05:31 PM MikeB	1	2
Selecting a substring SELECT * , SUBSTRING( `Reference` , ( LOCATE( "08", `Reference` ) ) AS TRACK FROM `work` WHERE `Reference` LIKE "%08-%" This is giving me a syntax... Derek Turner	02-07-2011 10:06 AM Bill B	4	5
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 07 Feb... me	02-07-2011 04:30 AM me	0	1
Whitepaper: Social Business Intelligence This paper has defined Social and Collaborative BI as the merging of BI with social networking and Web 2.0 technologies. Direct Link (No Email... JTP PR	02-06-2011 06:15 PM JTP PR	0	1
problem with Lock table Hello I explain my situation: I created a db in which I enter reservations to the hotels, especially in this entry I have carried out over two web... armando	02-06-2011 10:39 AM Axel Schwenke	2	3
Re: Getting the intended LIMIT, OFFSET results from a JOIN? On 2011-02-05 16:18, Puzzled wrote: Can you post create table statements, insert statements with sample data, and the expected output? /Lennart onedbguru	02-05-2011 10:33 AM Lennart Jonsson	1	2
using binary files Hi, is possible to use a binary file as a database with mysql? In other words, i would like to mantain my binary data and use mysql to write/read in... ioson	01-31-2011 04:49 AM Axel Schwenke	4	5
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 31 Jan... me	01-31-2011 04:37 AM me	0	1
convert MSSQL queries to MySQL sybtax We'd like to create the MySQL database structure needed to populate with the csv data contained in http://preview.tinyurl.com/airmen-mssql2mysql All... Greg Russell	01-30-2011 01:29 PM Luuk	4	5
Re: Getting finer DATETIME granularity Puzzled wrote: Think this will be interesting for you to read: http://bugs.mysql.com/bug.php?id=8523 There is a custom fix for this, but then you... J.O. Aho	01-30-2011 10:23 AM J.O. Aho	0	1
How do I get the ID generated? ( 1 2 ) If I add a row to a table that has an auto incremented ID that is a foreign key in another table... How do I get that ID from the last insert... SpreadTooThin	01-29-2011 03:34 PM Jerry Stuckle	15	16
In MySQL Workbench. I'm poking around in MySQL Workbench and am exploring the Entity Relationship diagram editor. Very Cool. In my previous example I had a customer... SpreadTooThin	01-29-2011 12:40 PM Erick T. Barkhuis	7	8
GROUP BY and ORDER BY I have an interesting situation with GROUP BY. I think it's best illustrated by example (I'm doing this toy example by hand, so forgive me if I mess... Scott	01-29-2011 01:22 AM Axel Schwenke	2	3
Insert statements and foreign keys etc.. This is my example scenario. I want to insert into this database. My record comes across having both the customer info and the order info, one... SpreadTooThin	01-28-2011 03:21 AM Álvaro G. Vicario	8	9
Introducing Yellowfin Connect The phenomenal interest in social networking and Web 2.0 technologies at the enterprise level is both unprecedented and growing rapidly. But why? ... JTP PR	01-27-2011 05:58 AM JTP PR	0	1
[ANN] ODB C++ ORM 1.1.0 released Hi, I am pleased to announce the release of ODB 1.1.0. ODB is an open-source object-relational mapping (ORM) system for C++. It allows you to... Boris Kolpackov	01-26-2011 09:28 AM Boris Kolpackov	0	1
Insert vs Alter? I'm a newbie when it comes to SQL... I'll try to explain what I'm doing by an example I found on the net. I once had a table... SpreadTooThin	01-25-2011 05:28 PM Captain Paralytic	6	7
why is mysql restore so slow (when mysqldump is so fast....) I have a database with 80 tables (mysql on Solaris) Of these tables - there are 2 that are particular massive (one has 2,000,000 records... terry433iid@yahoo.com	01-25-2011 09:25 AM Bodo	3	4
Illegal database name? I'm trying to test my database application which uses a mysql community server. I'm trying to force the database creation to fail by passing in... SpreadTooThin	01-24-2011 12:03 PM SpreadTooThin	6	7
openserver 5 Hi, is there someone that have been used mysql on a openserver 5.0.x system ( developing with c) ? Thanks ioson	01-24-2011 09:41 AM Luuk	1	2
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 24 Jan... me	01-24-2011 04:36 AM me	0	1
MySQL 5.1 -- how to move InnoDB tables to another location? I used to move my databases that were based on MyISAM, by simply moving the directory to where I wanted it to be, and then creating a symlink from... Ignoramus3188	01-23-2011 11:25 AM Axel Schwenke	4	5
Avoiding a full table scan Hi, I'm using MySQL 5. I'm writing a simple app that finds the nearest store within a certain radius. So I'm using the query SELECT... laredotornado	01-20-2011 05:24 AM The Natural Philosopher	6	7
delete dupes with a unique id using a temp table ( 1 2 ) I need to delete the dupes across bu's. The records are unique based on bu+ndc but there are 400+ duplicates.. There is a sequential id that is... jr	01-18-2011 02:25 PM Lennart Jonsson	16	17
MATCH ... AGAINST not working as expected ( 1 2 ) Per the MySQL online docs, the statement below: SELECT * FROM `table` WHERE MATCH (Description) AGAINST ('+party +fun +town' IN BOOLEAN MODE) is... EastSideDev	01-17-2011 08:22 AM Erick T. Barkhuis	12	13
SELECT DISTINCT I have 3 tables all with the data field (field1). I want to extract a recordset with distinct values from these tables BUT I do not want null or... bruce	01-15-2011 09:35 PM bruce	2	3
syntax error re increment? Hello I have a htm with a URL new-links.php?id=4 The new-links.php code is as follows - but I get a syntax error reported "near out=out+1 WHERE... Geoff	01-15-2011 04:02 PM Geoff	2	3
Syntax for Query ( 1 2 ) When creating a query to select data from the Mysql database via phpadmin this works... ----------------------------- $paigntontb = 'SELECT * FROM... GarryJones	01-15-2011 11:30 AM Jacek Krysztofik	13	14
What do you call a system that auto-generates I'm working with a client who has a piece of custom website software that has something I haven't seen before. It has a MySQL Database backend, but... Steven Lefevre	01-14-2011 09:55 PM onedbguru	1	2
separate binary log for each database (MySQL 5.0)? Hi, I have binary logging enabled for our MySQL 5.0 instance. We have several databases in the MySQL instance. So one binary log file is recording... Sarah	01-14-2011 02:15 AM Gordon Burditt	3	4
Syntax error .. but why? GRANT ALL PRIVILEGES ON . TO me @'host.domain' IDENTIFIED BY 'mypassword'; Is giving me a syntax error.. I'm on mac os x 10.6 I wonder if this has... SpreadTooThin	01-13-2011 04:11 AM Bodo	3	4
SQL Error (1217): What do I need to do get rid of the SQL Error (1217):Cannot delete or update a parent row: a foreign key constraint fails from the... bruce	01-13-2011 03:52 AM Álvaro G. Vicario	9	10
Time required to design a database ( 1 2 ) On Jan 11, 5:26*am, Michael Vilain <vil... (AT) NOspamcop (DOT) net> wrote: Luckily enough one of the requirements to progress from a... Joe Hesse	01-11-2011 11:35 AM Captain Paralytic	14	15
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 10 Jan... me	01-10-2011 04:30 AM me	0	1
mysqltuner.pl ( 1 2 ) I'm using mysqltuner.pl for some time now, and i'm confused by the output of it, can someone give some more insight? There is: "Variables to adjust:... Luuk	01-08-2011 10:01 AM Luuk	10	11
Can't drop KEY Hey ng Databaseengine: innodb In short terms: When I made two foreign keys in one Table using innodb I cannot drop index on that table. ALTER TABLE... Henrik Hartig	01-07-2011 01:08 PM Henrik Hartig	4	5

Page 8 of 128

108

Last »

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off