dbTalk Databases Forums  

Sponsored Links


comp.databases.mysql comp.databases.mysql


Discuss in the comp.databases.mysql forum.



Post New Thread
Threads in Forum : comp.databases.mysql Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
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 Go to last post
12 13
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 Go to last post
3 5
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 Go to last post
4 6
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 Go to last post
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 Go to last post
11 14
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 Go to last post
14 15
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 Go to last post
8 9
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 Go to last post
11 12
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 Go to last post
16 17
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 Go to last post
6 12
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 Go to last post
6 7
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 Go to last post
7 13
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 Go to last post
9 10
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 Go to last post
9 10
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 Go to last post
9 10
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 Go to last post
2 3
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 Go to last post
11 12
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 Go to last post
6 7
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 Go to last post
6 7
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 Go to last post
1 2
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 Go to last post
6 7
"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 Go to last post
0 2
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 Go to last post
4 11
Hi I can get most accented characters into MySQL but ô or &ocirc; - which is the lower case o with circumflex causes problem. It is not...
John
03-06-2010 07:26 AM
Robert Hairgrove Go to last post
1 23
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 Go to last post
2 17
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 Go to last post
13 16
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 Go to last post
3 14
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 Go to last post
20 21
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 Go to last post
1 10
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 Go to last post
5 15
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 Go to last post
1 17
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 Go to last post
4 17
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 Go to last post
2 15
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 Go to last post
7 25
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 Go to last post
0 11
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 Go to last post
2 11
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 Go to last post
2 9
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 Go to last post
1 9
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 Go to last post
0 14
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 Go to last post
2 18
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 Go to last post
22 56
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 Go to last post
2 11
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
.. Go to last post
0 14
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 Go to last post
1 23
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 Go to last post
3 9
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 Go to last post
1 14
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 Go to last post
1 9
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 Go to last post
2 20
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 Go to last post
17 39
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 Go to last post
2 7
Post New Thread

Display Options
Showing threads 1 to 50 of 5536
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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


Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.