Sponsored Links

comp.databases.mysql comp.databases.mysql

Page 1 of 111

101

Last »

Threads in Forum : comp.databases.mysql

Forum Tools

Rating Thread / Thread Starter	Last Post	Replies	Views
Is MySQL index a B+ tree ? ( 1 2 ) Assume I have 930 milliom records. Doing a binary search takes 30 disk-reads, which I think, are too slow. 1. Is MySQL index a B-tree ? 2. Can I... sl@my-rialto	Today 03:54 AM Jerry Stuckle	12	13
MySQL Query Browser's replacement? According to <http://dev.mysql.com/downloads/gui-tools/5.0.html>, MySQL Query Browser and all the MySQL GUI Tools Bundle have been replaced with... yawnmoth	Today 03:13 AM J.O. Aho	3	5
REGEXP question Hello! I am trying to identify values in a table column that start with an uppercase later. select * from tw_g3 where Term RLIKE '^{1}.+' But I... Michael Preminger	Yesterday 08:02 AM Scott Johnson	4	6
In your opinion, what method is the most efficient for looping thedata... i'm always trying to optimize my code even if the one in place works ok... I've read, a long time ago, that to make it more efficient when looping... SM	Yesterday 07:06 AM Jerry Stuckle	1	2
relations that contain queries ( 1 2 ) I'm trying to figure out a good way of representing any kind of discounts. I.E., you have a bunch of consumers with various attributes (age, student... nchubrich	Yesterday 01:57 AM Nilone	11	14
Old MySQL remnants shagging MySQL in Wampserver ( 1 2 ) OK .... so I have totally disinstalled previous implementations of both Tomcat and MySQL. I then deleted all the various folders they left... Richard	03-12-2010 12:52 PM The Natural Philosopher	14	15
query: use 2 fields in combination; one field to sort and another todisplay.. is this feasable? Hello, I have a bunch of tracks. Some tracks start with special characters like Á or ¿ or ¡ ... I want to be able to sort the tracks. I've tried a... SM	03-12-2010 11:46 AM Lennart	8	9
Performance MySQL Linux vs. Windows ( 1 2 ) Hi experts, we are benchmarking MySQL with PHP client on different operating systems. We use a set of small db operations (selects, updates,... Keith Sauvant	03-12-2010 10:38 AM J.O. Aho	11	12
extending query ( 1 2 ) With the help of the good folks in this group I have this query working with the table shown. Query: $query = "select event.eventID,... Derek Turner	03-12-2010 06:52 AM Erick T. Barkhuis	16	17
Export the database tables to schema. How can I in workbrench export the whole database schema (create table) to a file ? Thanks :) Mr. X.	03-12-2010 06:12 AM Erick T. Barkhuis	6	12
date format Please help an absolute beginner. Am creating a table that contains a date in mm/dd/yyyy format. Have used all kinds of combinations on 'date... frank	03-10-2010 03:54 PM Peter H. Coffin	6	7
bash: mysqlcheck: command not found Gurus, Obviously from my previous post I an new to MySQL. I have it running on a Linux server. I have navigated to the directory where MySQL and... Spin	03-10-2010 09:26 AM The Natural Philosopher	7	13
Syntax of delete statement I have two tables : t1(a1 integer) and t2(a1 integer). I am trying a dlete statement which works in Oracle but not on MySql server. delete from t2... dn.perl@gmail.com	03-10-2010 07:45 AM Lennart	9	10
How to create a 1 to 1 relationship or 1 to many...not sure Hello, I'm trying to create a db model for a discography, for one artist. I have a very basic model that i will improve with time. Here's a summary... SM	03-09-2010 03:36 PM Jerry Stuckle	9	10
in a loop, can't kill a mysql process, start it or stop it These are the commands I used. I changed the mysql.socket location and restarted the web server. NOw it can't find the old mysqld_safe process to... JRough	03-09-2010 01:37 PM The Natural Philosopher	9	10
InnoDB slowness I found out that the Myisam does not allow transactions so i decided to change some tables on my machine so that they use the InnoDB engine instead... monkeys paw	03-09-2010 10:49 AM Axel Schwenke	2	3
mysqli socket error ( 1 2 ) How do you configure the mysqli socket in php.ini? I'm getting this sql socket warning:warning: msqli::mysqli() : (HY000/2002): Can't connect to... JRough	03-09-2010 07:57 AM Peter H. Coffin	11	12
INSERT puzzle Steve Ackman: Well, in MySQL, you can still use field names that are reserved words, but then you have to use backticks. So, SELECT `lines` from... Steve Ackman	03-08-2010 02:19 PM Steve Ackman	6	7
help with insert with subquery on locked table Hi, What I am trying to do: LOCK TABLES profilename WRITE; INSERT INTO profilename (profilename,email) SELECT concat('user',count(*)+1),'my (AT)... jonbbbb	03-08-2010 02:15 PM Peter H. Coffin	6	7
insert with subquery into a locked table Hi, What I am trying to do: CREATE TABLE IF NOT EXISTS profilename(profilename VARCHAR(255) UNIQUE, INDEX(profilename), email VARCHAR(255),... jonbbbb	03-08-2010 08:21 AM Jerry Stuckle	1	2
CREATE FUNCTION not working in MYSQL 5.1 Would anyone know why this doesn't run delimiter // CREATE FUNCTION hello (s CHAR(20)) RETURNS CHAR(50) RETURN CONCAT('Hello,... scooper	03-08-2010 08:18 AM Jerry Stuckle	6	7
Stats comp.databases.mysql (last 7 days) "Caveat: Quantity is not necessarily a measure of Quality" Newsgroup.................: comp.databases.mysql Stats Were Taken..........: Mon, 08 Mar... me	03-08-2010 03:16 AM me	0	2
SQL Select query - please help if you can I have 4 tables, say - tblItems ID, Item, ClientID, ManufID, CatalogID tblClients ID, ClientName tblManufs ID, ManufName tblCatalog ID,... Ken Ashton	03-07-2010 09:58 PM toby	4	11
o circumflex - ô Hi I can get most accented characters into MySQL but ô or ô - which is the lower case o with circumflex causes problem. It is not... John	03-06-2010 07:26 AM Robert Hairgrove	1	23
using mysqldump data for mysqld --bootstrap When moving data from machine 1 to machine 2, I tried to script the moving of mysql data, basically in pseudocodish: foreach db mysqldump the... Mark Huizer	03-05-2010 10:24 AM Mark Huizer	2	17
change the password of root ( 1 2 ) I have mysql version 5.1.44 I have MySQL workbrench How can I change the root password (Besides, I am new to google group, and I would be glade for... Mr. X.	03-05-2010 08:16 AM Jerry Stuckle	13	16
CONVERT or CAST? I've got an SQL query that asks for input and returns info (big surprise there!). Trouble is, the query gets messed up when you give... Mike Jacoubowsky	03-05-2010 03:43 AM Lennart	3	14
Help! behaviour changed in some upgrade on select! ( 1 2 3 ) Not quite sure what is going on here.. I have a test database running on 5.2.6-1 and production is on 5.2.0-8 A select that works on production... The Natural Philosopher	03-04-2010 02:49 PM The Natural Philosopher	20	21
SELECT when only a member of one group Hi, I have a db in which I have a users table containing a list of all the users and a groups table containing a list of all the different security... Graham Drabble	03-04-2010 02:32 PM Erick T. Barkhuis	1	10
Problem with a LEFT JOIN query... Hello, I'm not sure if the query i'm trying to do is possible. I've done half the work but i'm stuck on the last part. Let me exlain. I have 3... SM	03-04-2010 11:48 AM SM	5	15
MySQL 5.1.44 GUI Tools for Mac OS X Snow Leopard platform Hello, I work with MySQL 5.1.44 on Mac OS X Snow Leopard Platform. I can do all the commands and scripts by command line, but I don't find... Forum	03-03-2010 07:24 PM Banana	1	17
triple join with distinct clause....where am I going wrong? Disclaimer: my MySQL skills are pretty rusty. On top of that, I'm working with a poorly planned schema I had nothing to do with. Go easy on me... Adam	03-03-2010 06:37 PM Gordon Burditt	4	17
Problem with an 80040E21 Error I'm using the code shown below in a VB6 program to update a record in a MySQL database. When it gets to the line where it's assigning a value to the... Martin	03-03-2010 10:26 AM Martin	2	15
newbie: secure protection of selected tables Hello, I have little experience in PHP5+MySQL. I created a website with database of 23 tables. Some of these tables contain data that are important... Jivanmukta	03-03-2010 04:41 AM strawberry	7	25
Whitepaper on Location Intelligence The Yellowfin BI team have produced a new paper on "Location Intelligence", the mashup of BI with GIS Extract More than 70% of your organizational... JTP PR	03-03-2010 04:02 AM JTP PR	0	11
get error information and store it in a table Hello, Does any one know a way to catch an error n° from a query to be stored in a table. I have a procedure wich calls others procedures. At the... jero	03-03-2010 02:40 AM jero	2	11
Re: [OT] [Crobots] Tournament 2010 Mau C wrote: So it's based on MySQL. It's still SPAM. And not at all on topic. -- ================== Remove the "x" from my email address Jerry... Jerry Stuckle	03-02-2010 09:42 AM Mau C	2	9
Twitter style followees feed subscriptions Dear All, I am trying to implement Twitter style followee feed subscriptions for my users. For example, If I want to select the most recent 25... Moodang	03-02-2010 06:36 AM Doug Miller	1	9
a brand new query tool is out on beta, we need feedback, so you get afree copy We at Nob Hill Software are working on a new query tool: http://www.nobhillsoft.com/MarieAlix.aspx?HeardVia=ptut You can read all about it on the... Mia	03-01-2010 07:37 AM Mia	0	14
SELECT INET_NTOA(ip) not putting into array as expected Hopefully I can explain this in a way people will understand. I have been playing with INET_NTOA() and INET_ATON() just to fullfill my own... kgray	03-01-2010 06:01 AM Tony Mountifield	2	18
relations between tables ( 1 2 3 ) Hi, I'm using Access as a front-end of Mysql-server via odbc connector. I've already made tables on Mysql and now i doubt if relations between them... remigio	03-01-2010 01:02 AM remigio	22	56
Troubleshooting 'Access denied' message Hi, I'm using the latest version of MySQL on WinXP. As root, I created a database and a user, and I confirmed I was able to login and create a temp... laredotornado	02-28-2010 12:34 PM Luuk	2	11
Solar cells for less than 1 USD per Watt Do you know that you can find solar cells for less than 1 USD per Watt on www.ebay.com ? Regards. ..	02-28-2010 04:17 AM ..	0	14
Connection string. Hello. I have succeeded to create mysql database. I did the following code : Try ConnStr... Mr. X.	02-26-2010 07:32 PM Jerry Stuckle	1	23
mysql - several configuration. Hello. I am first using mySql on Windows-7. Should I set the path on the environment ? (so I can run by cmd.exe the mysqladmin, etc. of... Mr. X.	02-26-2010 07:27 PM Jerry Stuckle	3	9
using mySql WorkBench to see queries. Hello. my database instance is myInstance. I have created the instance OK. When do on menu : database + query database I see a tree of : 1.... Mr. X.	02-26-2010 05:00 PM Jerry Stuckle	1	14
First using mySql Hello. I am first using Mysql. I have installed the mysql server 5.1 and MySql WorkBench 5.2 OSS. I want to create a new database instance via the... Mr. X.	02-26-2010 04:29 PM J.O. Aho	1	9
Mysql double entries when using a table with an index I have a php script that inserts some purchase order items into a mysql database. None of the fields are defined as primary or unique and shouldn't... Chad B	02-26-2010 04:07 PM Chad B	2	20
How do I get started with mysql? ( 1 2 ) I am trying to use it with linux Mint. I run mysqld as root and I see a process running. Now what. I've tried the MySQL Administrator GUI and I... A Watcher	02-25-2010 12:04 PM A Watcher	17	39
refer to complex expression value in where clause I have a query where I have a complex date expression as one of the columns. SELECT date_column + INTERVAL( complex_jimmy_jam ) DAY... steve lefevre	02-25-2010 11:15 AM steve lefevre	2	7

Page 1 of 111

101

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