|
More site info...
|
|
Forum profile page for MySQL on http://www.sitepointforums.com.
This report page is the aggregated overview from a single forum: MySQL, located on the Message Board at http://www.sitepointforums.com.
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "MySQL" on the Message Board at http://www.sitepointforums.com is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on MySQL:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
78
|
261
|
671
|
|
Post:
|
253
|
866
|
2,256
|
|
|
MySQL Posting activity graph:
|
Top authors during last week:
user's latest post:
Search MySQL Tree String
Published (2009-11-14 21:51:00)
don't forget that FIND_IN_SET (or similar approaches) means the query will not scale, i.e. the more rows you have, the slower the query gets, because it has to do a table scan this is one of the problems of violating first normal form (storing multiple values in a single column)
user's latest post:
Help with database table
Published (2009-11-13 06:18:00)
Using _ instead of - at least saves you from having to use backticks. You can also use non of them, and write everything as one long word, though it might become a bit difficult to read. I always avoid having to use backticks, because I don't have them on my keyboard.
user's latest post:
Using stored procedures to move...
Published (2009-11-13 17:16:00)
OK, I've got it working as I want it to, but it's a bit messy and could really do with cleaning up: MySQL Code: BEGIN DECLARE c BIGINT ( 10 ) ; DECLARE x BIGINT ( 10 ) ; DECLARE passed BIGINT ( 10 ) ; DECLARE failed BIGINT ( 10 ) ; SET x = 0 ;...
user's latest post:
Perfect INNER JOIN query on...
Published (2009-11-13 22:11:00)
Ok let me explain about tables: shops (it's clear i think) widgets (it's clear too) shops_widgets (shop & widget are related here) widget_params (params of a widgets are related here) shop_widget_params (relates the param values of a widget) What i want to fetch is: widget_params.param & shop_widget_params.param_value And Where condition would be shop_id Hope this is much clearer now.
user's latest post:
issue in storing arabic...
Published (2009-11-14 16:40:00)
What server-side langauge are you using? If it's php try adding this to the line imediatly after the database connection to MySQL is established: PHP Code: mysql_set_charset ( 'utf8' , $link_id );
user's latest post:
#1045 - Access denied for user...
Published (2009-11-06 11:58:00)
ok...they didn't oh well ok my error is.... MySQL said: #1045 - Access denied for user 'root'@'localhost' (using password: YES) phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server. and go see images I was trying...
user's latest post:
Removing commas at front of entry
Published (2009-11-09 11:14:00)
Thanks R, think im going to have to look for a developer in SQL as this is double dutch to me. :S
user's latest post:
match records with same value in...
Published (2009-11-11 21:25:00)
Let me rephrase what I am trying to do. - have a form to post 2 users ID - once I posted the 2 IDs, the query should check whether these 2 IDs have the same transaction code in the table. - If there is any, i want to fetch and print out the transaction code that both records have. that is what I am try to accomplish. Thanks
|
|
|
|
Latest active threads on MySQL::
Started 1 day, 6 hours ago (2009-11-15 16:52:00)
by r937
helpful tip for posting a question about a query: don't make us scroll
you may not be able to achieve the same artistic and aesthetic result as this, but you gots to try, man
Code:
SELECT sections.*
, t.id AS pid
, t.stitle
, t.pstatus
, t.pic
FROM sections
LEFT
JOIN ( SELECT id
, stitle
, pstatus
, ...
Started 1 day, 8 hours ago (2009-11-15 14:55:00)
by r937
pls move either to php or to Questions forum
Started 1 day, 19 hours ago (2009-11-15 03:23:00)
by r937
yes it's possible -- just don't repeat the WHERE keyword
Code:
SELECT ...
FROM ...
WHERE MATCH(column1) AGAINST(' word word' IN BOOLEAN MODE)
AND MATCH(column2) AGAINST('word')
Started 6 days, 20 hours ago (2009-11-10 02:17:00)
by guido2004
You can't add the WHERE clause to SHOW COLUMNS, and there is no need for it too. SHOW COLUMNS gives you the names of the columns present in the table, it doesn't give you any data.
Correction: you can add a WHERE to SHOW COLUMNS, but not a WHERE that uses that table's column names.
Read this: http://dev.mysql.com/doc/refman/5.1/...w-columns.h tml
Started 2 days, 1 hour ago (2009-11-14 21:21:00)
by SirAdrian
Use the find_in_set() function.
Started 1 day, 18 hours ago (2009-11-15 04:35:00)
by killerblack
Started 2 days, 10 hours ago (2009-11-14 12:10:00)
by rguy84
After some looking, I found: http://forums.mysql.com/read.php?103...144#msg-210 144
Try what was suggested there. I don't know Arabic, but have you tried to get data out -- like onto a webpage, how does it display?
Started 2 days, 1 hour ago (2009-11-14 21:47:00)
by r937
when you have a long series of values...
Code:
INSERT INTO sometable (column, column, column, ... )
VALUES
( value, value, value, ... )
, ( value, value, value, ... )
, ( value, value, value, ... )
, ( value, value, value, ... )
, ( value, value, value, ... )
, ( value, value, value, ... )
, ( value, value, value, ... )
, ( value, value, value, ... )
, ...
you can easily ...
Started 1 week ago (2009-11-09 04:30:00)
by r937
2000 new rows per day = less than a million in a year
this is not a small table, but it's also not a very large table either
how many tables in your database? sounds like only one
what kind of indexes have you defined? are any of your queries running slowly, and if so, have you done an EXPLAIN on them?
Started 2 days, 22 hours ago (2009-11-14 00:20:00)
by Dan Grossman
Join all 4 tables on their associated keys, that's all there is to it.
|
|
Hot threads for last week on MySQL::
Started 3 days, 14 hours ago (2009-11-13 08:13:00)
by r937
is there always a dash before the number?
Code:
ORDER BY CAST(SUBSTRING_INDEX(c_title ,'-',-1) AS UNSIGNED)
Started 3 days, 15 hours ago (2009-11-13 07:32:00)
by r937
writing "raat" code (row-at-a-time) like you're suggesting will, of course, work
but if it's me, i would simply load the csv into a "landing" table (a table built to hold the data as is from the csv)
then i would use a series of simple SQL statements to manipulate the data from there into the target tables
Started 1 week ago (2009-11-09 14:43:00)
by SJH
Untested, but should work:
sql Code:
UPDATE mytable SET display = CASE WHEN display = 1 THEN 0 ELSE 1 END WHERE title = 'My article title' ;
Btw, TINYINT might be a more suitable datatype for that column
Started 6 days, 15 hours ago (2009-11-10 07:12:00)
by Cups
This sounds like an sql question rather than a PHP one, you'd likely get a better response from someone over there (or the Mysql forum).
Probably be a good idea of you could give a couple of examples of your criteria for "similar value" too.
Started 1 week, 3 days ago (2009-11-06 06:50:00)
by SJH
Something like this maybe:
SELECT SUBSTRING(metakey, 2, (LEN(metakey) - 2)) AS metakey FROM content WHERE metakey LIKE ', %';
Started 1 week ago (2009-11-09 12:30:00)
by Fallen Angel
There are a couple of collations for Spanish - one for modern Spanish, and one for traditional Spanish, xxx_spanish_ci and xxx_spanish2_ci (latin1_spanish_ci) (info from here: http://dev.mysql.com/doc/refman/5.0/...code-sets.h tml ).
I've just come across this post as well that might be useful to you.
Started 4 days, 2 hours ago (2009-11-12 20:47:00)
by r937
column name? atributes? articles? values?
i think maybe you should try to explain in english what the database is supposed to do for you
if you're storing column names in a user table (this is called meta-data ) there's a very good chance that you have a poor design
Started 5 days ago (2009-11-11 22:12:00)
by Kevin Yank
Sure, you can make your ORDER BY clause more complex, so that it first sorts by whether the flag column is set to 1, and then sorts by RAND():
SELECT * FROM table ORDER BY flag = 1, RAND() LIMIT 10
Started 3 days, 18 hours ago (2009-11-13 04:23:00)
by guido2004
In your INSERT, you can't use NULL instead of a column name. Since the
first column is an autoincrement field, try eliminating the NULL and see
what happens.
Started 1 week ago (2009-11-09 17:53:00)
by r937
it morphed into HeidiSQL, which is doing real nicely
|
|
Size: 1,390 bytes
