hello Masters,
I am a novice, and I am wanting to know how to achieve this:
1million plus row in a table.
user runs a search, gets some results. I want to store this result in memory in
a way, so that user can fire more SQL searches on this result. How is this
done? I want this to go atleast
when i run the application like this: http://mywebsite.com/phpMyAdmin/index.php
on the home page it shows i am using old version:
Version information: 3.4.3.1, latest stable version: 4.2.7.1
but i have latest phpmyadmin installed (see below) why is it not appearing?
MySQL client version is
I have a column in a table which is epoch time including milliseconds.
e.g. = 1409304102153
now i want to display all fields in the table but this field as: 2014-8-29 Fri
09:21:42: GMT (whatever comes in )
and i am not finding anything on web about how to do that.
can anyone help
when i run the application like this: http://mywebsite.com/phpMyAdmin/index.php
on the home page it shows i am using old version:
Version information: 3.4.3.1, latest stable version: 4.2.7.1
but i have latest phpmyadmin installed (see below) why is it not appearing?
MySQL client version: 5.5.38
Gurus,
I am going to have a big table with lot of records, to expedite searching i
wanted to index on a key field (which is numeric value). BUT, there will be
records which will have same value for the key field (other columns will be
different).
so how can i do this? right now, i am getting
, Rajeev Prasad rp.ne...@yahoo.com wrote:
thx Reindl,
I am using phpMyAdmin, i looked closely and found index is this index you are
talking about? (earlier i used Primary).
My further question is: the index key here is going to be epoch system time. I
currently have it as integer 10. The table
this table has many columns and only 1 record.
select * from table;
generates an unreadable list.
how can i list the record as in two columns? (column name and its value)?
i looked at UNPIVOT, but could not get it to work.
SQL select * from table UNPIVOTE INCLUDE NULLS;
hello,
I have a table with around 2,000,000 records (15 columns). I have to sync this
from an outside source once everyday. not all records are changed/removed
/new-added everyday. so what is the best way to update only those which have
changed/added/or deleted?
i can use update_or_create but
, Rajeev Prasad
I have a table with around 2,000,000 records (15 columns). I have to sync this
from an outside source once every day. not all records are changed/removed
/new-added everyday. so what is the best way to update only those which have
changed/added/or deleted?
i can use update_or_create
I am considering using cryptic username for accessing and working on a database
on my MySQL installation. can anyone with experience provide some suggestion pl?
in documentation, i only see that it can be 16 char long. how complex it can
be? any side effects/bugs of username complexity? can I
i have given select/insert/update/delete rights to a user on a specific
database, from localhost. when i try to login to mysql using the uid, i get
error:
ERROR 1045 (28000): Access denied for user 'myuser'@'localhost' (using
password: YES)
what other privilege do i need to give this user?
' |
+-+
I am using phpmyadmin to manage mysql, including user privileges.
From: Ben Mildren ben.mild...@gmail.com
To: Rajeev Prasad rp.ne...@yahoo.com
Cc: mysql list mysql@lists.mysql.com
Sent
looging in from the same server.
From: Rick James rja...@yahoo-inc.com
To: Rajeev Prasad rp.ne...@yahoo.com; mysql list mysql@lists.mysql.com
Sent: Monday, September 24, 2012 2:09 PM
Subject: RE: user not able to login from localhost
That says that your
friends, i figure that i had to give password in quotes. i was then able to
login. thank you all for your help and time.
From: Rajeev Prasad rp.ne...@yahoo.com
To: Rick James rja...@yahoo-inc.com; mysql list mysql@lists.mysql.com
Sent: Monday, September 24
I have to keep this data in MySql, and i am not sure (as SQL/databse is not my
field) how to organise this into one or many tables? right now I would
represent my info as follows:
device_name|HW_version|SW_version|IP_addr_pvt|IP_addr_pub|data_specific_to_device|associated_service
thx in advance.
Rajeev
From: Peter Brawley peter.braw...@earthlink.net
To: Rajeev Prasad rp.ne...@yahoo.com; mysql@lists.mysql.com
mysql@lists.mysql.com
Sent: Wednesday, August 15, 2012 4:01 PM
Subject: Re: suggestion needed for table design and relationship
here is given string of type:... as23,rt54,yh79
and i have to lookup in a table which has column id which has only one four
letter word. i have to select that row in which the colum 'id' value matches
any of the word in given string...
table column: id
contents like:
| id|
|sd32|
|wa32|
thanks a lot that worked!
From: Rodrigo rodrigol...@gmail.com
To: Rajeev Prasad rp.ne...@yahoo.com; DBIx::Class user and developer list
dbix-cl...@lists.scsys.co.uk
Cc: mysql list mysql@lists.mysql.com
Sent: Saturday, August 11, 2012 11:12 AM
Subject: Re
I changed a name of the table from within phpMyAdmin, and immediately it
crapped. after that when I try to connect using phpMyAdmin
(/phpMyAdmin/index.php) I get error in log:
[Wed Aug 0814:18:582012][error]Query call
failed:Table'mydb.mychangedtbls'doesn't exist (1146)
(I changed the name from
:
2012/02/04 19:13 -0800, Rajeev Prasad
MySQL datetime field type keeps data as: -MM-DD HH:mm:SS is there a way
to store this data as: /MM/DD HH:mm:SS or going much further (optionally)
can we store as: MM/DD/ HH:mm:SS ? if not then whats the best way to
reformat the cell value
Hello,
currently i have mod auth_mysql configured and running as plaintext password:
1. how can i generate crypt_des passwords to store in database?
2. how can i get a user log out once the browser tab is closed. seems i have
to close the browser and reopen, then only i am presented login
21 matches
Mail list logo