| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24
Comments:
<0> if you only want the date, do max(date)
<1> eh, yeah, max() right
<0> no where condition
<0> enjoy your swim
<0> don't get electrocuted
<2> SELECT Date FROM Transktionsdetails WHERE date = max(date)?
<0> select max(date) from mytable
<2> ah ok
<3> hi all
<3> a question - if i try to create a database with name 404 on mysql 4.1 i receive this error: ERROR 1064 (42000): You have an error in your SQL syntax;
<3> database name with only number are not accepted ?
<3> *numbers
<0> question 1: why is your database named 404?
<0> question 2: can you rename it?
<0> answer 1: don't do that.
<0> answer 2: create database `404`
<3> oh
<3> thanks
<3> but gleam_ why on answer1 you say "don't do that" ? I mean there are problems ?Security problems ? or what ?
<0> doctor, it hurts when i do this
<0> then don't do it!
<0> not "take some advil"
<3> right answer :P
<0> telling you to use `` is like telling you to take two aspirin and call me in the morning
<0> instead of me telling you to stop hitting a frying pan on your forehead
<4> Hi. Is it possible to create functional indexes on MySQL tables in 4.1? i.e. CREATE INDEX foo ON bar (UPPER(baz));?
<5> is LIMIT 5 OFFSET 10 valid in mysql 3.23?
<0> no purestorm
<4> mow
<0> note that by default the collations are case-insensitive
<0> so 'foo' = 'FOO'
<0> wait
<0> i'm on crack
<0> ignore me
<0> it's case insensitive in most cases
<0> not all
<0> try "select 'foo'='FOO','fOo'='FoO'"
<4> hm, gives 1
<6> hello
<4> OK, thx
<3> gleam_, i tell you: i let users create their own db but now i have to understand a thing: it's just a number related issue or only a code issue(only some particular number do this)?
<6> I want to make a query, and that is order by column1 divided by column2, how do I do that?
<4> uhm
<3> gleam_, i ask you that cause i will insert a check related to your answer
<0> order by col1/col2
<6> gleam_, couldn't be easier :)
<0> !m `dom` legal names
<7> `dom`: (Database, Table, Index, Column, and Alias Names) : http://dev.mysql.com/doc/mysql/en/Legal_names.html
<3> oh thanks
<0> basically avoid anything that could be pretty ambiguous
<0> avoid hyphens, avoid all-numeric
<0> e.g. is "foo-bar" foo minus bar?
<8> Is anyone here?
<0> no
<9> hi everyone, I'm curious about AES encryption in MySQL (I'd like to use 258 bit encryption) - I RTFM (but it just says, "recompile") - I've also read all 3 bug reports dealing with this, but there is no concise answer as to how to use it
<9> anyone have any ideas?
<0> are you willing to recompile mysql?
<10> mick_work: you recompile mysql after changing the key bit length variable in the proper header, then you can use the AES_* encryption functions
<9> gleam_: yes, but I'm not sure where to set it in the code
<0> neither am i :) sorry
<0> i'd imagine you could find it with a good grep
<10> mick_linux: my_aes.h in /include
<0> well nevermind
<10> I know, I did the same thing :)
<0> and lo, there he is
<0> #define AES_KEY_LENGTH 128
<10> though my windows compile didn't really perform as I had hoped
<9> ah thanks :)
<11> Can anyone help me? I have a mysql-account on my school's webserver. And I'm about to install a webpage that need that account. In my first attempt to install, the install-manager got contact with 'mysql' using the login-name and p***word I got from the server-manager. But some other files was missing and the installation faild. I fixed the problem, but now the install-manager reports 'access denied on the mysql-account'... What is the problem and
<11> what do I do...
<9> !m jobar access denied
<7> jobar: (Causes of Access denied Errors) : http://dev.mysql.com/doc/mysql/en/Access_denied.html
<9> my other problem is with UDVs. If I'd like a variable like "@sec" to be persistant between connections, do do I do that?
<0> you don't
<9> gleam_: ?
<8> How do you alias a derived table? (SELECT * FROM table) AS table1 gives me an error at AS
<9> also, how do I return the value of a variable, instead of a variable itself.
<12> is there a way to select the second column without using it's name at all in a select statement?
<9> made up example: @sha:=SHA1(RAND())
<8> jonathan`, Why would you want that?
<12> will[werk], I'm trying to make one script work for various tables where the foreign key is always the second column
<9> select @sha; -- this will return different values each time, sometimes you want the value (the first occurance)
<8> ew
<13> Is there a way to drop an index only if it exists under 4.1?
<14> Hi all!
<15> argh. How do you get a timestamp as an int, unformatted?
<14> I'm trying to create a new user. For that, I just typed "CREATE USER username IDENTIFIED BY 'p***word'", but that command doesn't appear to return (been sitting there for more than 5 minutes now). Should I Ctrl-C out or will that break things?
<9> !m thien add user
<7> thien: (Adding New Functions to MySQL) : http://dev.mysql.com/doc/mysql/en/Adding_functions.html
<9> damnit
<14> Erm. That's what I'm reading mick_work :-)
<9> !m new user
<7> new: (Information Functions) : http://dev.mysql.com/doc/mysql/en/Information_functions.html
<14> Damnit
<9> !m user
<7> Incorrect usage. See 'help m'
<14> Now the entire database doesn't respond anymore
<14> Can creating a user kill the database?
<9> grrr
<9> I hate this, let me check myself
<14> mick_work, the web site I'd been following was http://dev.mysql.com/doc/mysql/en/Adding_users.html
<9> http://dev.mysql.com/doc/refman/5.0/en/adding-users.html
<9> there is also mysqladmin
<14> I tried that and couldn't get it to work
<14> Right now my prob is that apparently the CREATE USER statement seems to have ****ed a production database
<15> welcome to the quirks of mysql?
<15> Sounds odd, though.
<9> thien: what version of mysql
<14> 5.0.18 mick_work
<9> create user came in w/ 5.0.2
<9> use --skip-grant-tables and go in as root and fix the table if it is messed up
<13> Is there a way to drop an index only if it exists under 4.1?
<14> Server load is constant at 1.0.0
<14> I can't understand how a CREATE USER statement would make an entire database server **** up?
<16> heyllo
<16> "group" is a reserverd word?
<17> yes
<18> janez: Indeed it is
<18> !reserved
<18> !man reserved
<7> (Treatment of Reserved Words in MySQL) : http://dev.mysql.com/doc/mysql/en/Reserved_words.html
<19> mysql Admin program freezes when trying to look at the users
<16> salle, thx
<18> janez: Thank to the BOT :)
<9> thien: did you do what I said?
<19> hmmm...
<19> how do i use a .sql file?
<20> .sql is just a text file with the table structure and content
<20> so basicly a dump
<6> Firebird8, if it contains a sql query, you can run it with phpmyadmin
<20> you can reimport it using mysql-admin to or just using a console
<13> Is there a way to drop an index only if it exists under 4.1?
<0> alter ignore table mytable drop index indexname?
<19> ficusplanet, how do i doit with a console?
<19> oops
<14> mick_work: first had to call in the guy who has the root p***word
<19> fidel, how do i reimport with console?
<14> Which he constantly refuses to give to me, so that I could fix things by myself.
<13> gleam_: Doesn't seem like that's how IGNORE works.
<0> what's happenign when you add on ignore?
<13> gleam_: "IGNORE is a MySQL extension to standard SQL. It controls how ALTER TABLE works if there are duplicates on unique keys in the new table or if warnings occur when strict mode is enabled. If IGNORE is not specified, the copy is aborted and rolled back if duplicate-key errors occur. If IGNORE is specified, only the first row is used of rows with duplicates on a unique key, The other conflicting rows are deleted. Incorrect values are truncated to the close
<0> shrug
<0> give it a shot and see if it works
<0> it's your only option
<21> Hi. If I just copy /var/lib/mysql to an usb drive with crontab at night, is it enough to backup database? Or I need to do some sql dump ?
<22> well
<22> if you shut down the database first, then you are copying the right data
<21> without shutting down? What is the right way to backup?
<22> without shutting down you need to use mysqldump
Return to
#mysql
or
Go to some related
logs:
#php
para unjumble
#css
#php
phtread tutorial
kqemu genkernel
unable to open sw_single suse
#kde
10-adic expansions
#mysql
|
|