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 upto
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 is 5.5
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.3
ajeev
On Wednesday, May 28, 2014 3:29 PM, Rajeev Prasad 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 t
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 er
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;
thx all, the source data is in text file.
- Original Message -
From: "h...@tbbs.net"
To: mysql list
Cc:
Sent: Saturday, April 6, 2013 8:02 PM
Subject: Re: update a row only if any column has changed, in a very large table
>>>> 2013/04/06 13:56 -0700, Rajee
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_crea
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
To: Rick James ; mysql list
Sent: Monday, September 24, 2012 4:11 PM
Subject: Re: user not able to login from
sql>
I am looging in from the same server.
From: Rick James
To: Rajeev Prasad ; mysql list
Sent: Monday, September 24, 2012 2:09 PM
Subject: RE: user not able to login from localhost
That says that your password in not correct. You have not go
ase`.* TO
'myuser'@'localhost' |
+-+
I am using phpmyadmin to manage mysql, including user privileges.
________
From: Ben Mildren
To: Rajeev Prasad
Cc: mysql list
Sent: Monday, Sep
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 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 us
thx in advance.
Rajeev
From: Peter Brawley
To: Rajeev Prasad ; "mysql@lists.mysql.com"
Sent: Wednesday, August 15, 2012 4:01 PM
Subject: Re: suggestion needed for table design and relationship
On 2012-08-15 1:54 PM, Rajeev Prasad wrote:
> I
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
|associated_
thanks a lot that worked!
From: Rodrigo
To: Rajeev Prasad ; DBIx::Class user and developer list
Cc: mysql list
Sent: Saturday, August 11, 2012 11:12 AM
Subject: Re: [Dbix-class] search any matching word in given string in table
column which has only one
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|
|wa
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
a
session-by-session basis if you prefer. Refer to the documentation
page below for details on manipulating system variables either
globally or on a per-session basis.
http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html
- michael dykman
2012/2/5 Halász Sándor :
>>>&
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 box.
21 matches
Mail list logo
