| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13
Comments:
<0> !m YazzY DATE DIFF
<1> YazzY: Nothing found
<0> boo
<2> !m YazzY date time functions
<3> jp-: You might be able to set the last autoincrement value but I wouldn't go there myself.
<1> YazzY: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<2> sjrussel: bumped into that one a lot myself :)
<4> thank you
<5> is there anyway for me to undo a DELETE?
<0> :)
<3> Shane-S: backups?
<0> Shane-S, only if you're in an uncommitted transaction
<5> well it said 103 rows affected, so I ***ume its on auto-commit
<3> If you didn't create a transaction, it will be auto-commit
<0> Alt-e-u :)
<0> what strib said... you have backups, right:)
<5> yeah I just logged in and did a DELETE...I forgot quotes on my date and it took it as math and delete all my records
<6> strib: what about changing the field with update later on? looking at the long term, there oculd be hundreds of thousands changes and the auto incrementing filed might eventually grow too large
<0> !bofh
<0> jp- if hundreds of thousands is too big, use an INTEGER
<0> hundreds of thousands isn't big, it's small
<6> that was just an example, the idea a permanent solution
<6> not something that one day just isn't gonna work.
<0> it is a permenent solution
<0> if you can't fit everything in a BIGINT UNSIGNED, fix your code, it's broken.
<6> it's not my code, it's the concept behind the auto increment
<0> the problems if it did re-use old numbers are much, much, MUCH worse
<0> !google referential integrity
<7> Google result: [ ]
<1> referential integrity: http://www.webopedia.com/TERM/R/referential_integrity.html
<6> right, well i understand, i just have to write code to tidy up the id's because cleaning up the gaps doesn't present a problem here.
<8> ehy, why i can't use scripts on my linux/apache2/php server??? php and mysql goes, but it does not run queries!!! register_globals is on!! please help me ! :D
<0> well you're first problem is that register_globasl is on. Very, very bad idea.
<8> in practice the script created the db and tables, but could not fill data in!!
<0> your second, is that the problem is probably not with mysql, ergo...
<8> what can i do?
<0> was there an error?
<8> no
<8> no errors
<0> then check with #php, #php-support, #apache
<8> ok
<8> tnx
<9> god I feel stupid I forgot how to insert an apostrphy do i escape it with a / or what?
<10> \
<8> why cant'i fill data into tables from a php page?? my server is weel-configured!!! please help
<8> ops i wrote in the wrong channel :P
<11> hello
<12> Hey, how can I tell which tables are being replicated on a slave/
<6> Ungy: two, ''
<13> Does anyone know of any issues with full-text indexes in mysql 5.0.18?
<13> I have a full-text index on a table that claims to be corrupt
<13> when I try and repair it, it says ok, but when I go and re-check the table, it's still corrupt
<14> drop and re create the index
<15> hi guys
<15> i has these java cl***
<15> <property name="hibernate.dialect">org.hibernate.dialect.MySQLInnoDBDialect</property>
<15> if i create at the first time , a database i will probably have troubles?
<15> i think when i create a database into mysql these database are MyIsam right?
<16> Kalavera: No, the InnoDBDialect will add "type=InnoDB" to the DDL if you let the hibernate tools generate your schema(s)
<16> That's basically all it does.
<9> archivist what data type do you use in mysql for p***words?
<14> I dont i only use mysql accounts
<9> hmm I am thinking doing char 16 with a hash?
<17> When i use mysql-administrator (as root) and try to go to Users -> (click on rutski89, click on @localhost) -> Schema Privileges -> (Move SELECT & INSERT over a columb) -> Hit "Apply Changes" I get the error "Duplicate User Name, Please Try again", if i hit apply changes again, mysql-administrator crashes
<9> I guess I will go with Char40 and sha1() seesm good enough
<9> rutski89, sorry dunno anythign abotu mysqladministrator
<17> Ungy: ok :-(
<15> mm-mysql, you know how hibernate works
<18> Can someone help me create a user, the instructions on the mysql site aren't working
<19> !m Petaris create user
<1> Petaris: (CREATE USER Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_USER.html
<19> is that the document you're reading?
<18> yep
<18> and I read the grant one
<14> what did you miss out doing then
<19> so what happens when you try it?
<18> ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'USER post IDENTIFIED BY
<18> 'p***word'' at line 1
<18> this is what I typed
<19> can you paste what you're typing in?
<18> CREATE USER post IDENTIFIED BY 'p***word';
<18> This is mysql 4.1
<19> yeah
<19> well I think I see your problem
<19> re-read the CREATE USER page
<18> ?
<18> I left off p***word because I want to specify in plain text
<18> that is correct no?
<18> doesn't like the brackets added either
<19> Petaris: read more carefully ;)
<19> hint: first sentence
<18> ahh
<18> that would be why
<19> !m Petaris grant
<1> Petaris: (GRANT and REVOKE Syntax) : http://dev.mysql.com/doc/mysql/en/GRANT.html
<18> my other server is mysql 5
<18> I've used the create with it before
<18> would explain why it didn't work here
<19> this is why everyone should upgrade
<19> we should have a national upgrade MySQL day
<18> right, but I'm on debian stable on this box and 5 isn't in apt
<19> there are backports though
<18> I'll have to grab the package
<19> or you can grab the Debian source package from testing and compile it
<19> MySQL compiles surprisingly fast
<18> Darien: You think the postfix-mysql package will complain though?
<19> Petaris: nope
<18> Darien: Ok, thanks
<19> Petaris: multiple client libraries can coexist, so all your existing apps will be fine
<18> Darien: I'm attempting to setup postfix+mysql+dovecot
<19> never used dovecot
<19> I just use Courier
<18> I want dovecot because ravencore supports it
<18> other wise I was going to use courier
<19> I'm surprised it doesn't support courier
<19> coruier's the most popular IMAPd out there, afaik
<18> Darien: should I grab standard or max?
<19> standard
<18> ok
<20> Here neon_kl ;)
<21> hello
<21> how to store file path in database and latter to display the file
<21> if i store image file in database will works too slow
<0> !m neon_kl string types
<1> neon_kl: (String Types) : http://dev.mysql.com/doc/mysql/en/String_types.html
<22> Please, i have this registrys in fields, for examploe: 01:01, 01:02....01:98, 01:99, 01:100.. when i do a select to get the max number after ":" it return 99, why?
<22> not 100, 101..
<19> because 9 comes after 1
<0> ...and it's doing a string comparison
<22> yes
<19> alphabetically, 99 comes before 100
<22> do you have any idea what can I do?
<19> use integer types, not string types
<22> to return 100, 101..?
<19> redesign your table
<22> i need to change the structure?
<19> yes
<22> the field in the moment is varchar
<22> its not ok?
<19> no
<19> you are trying to compare numbers
<19> but you are not storing numbers, you are storing strings
<23> hey does innodb have full text too?
<19> and strings work differently
<19> TomH-: not yet, no
<23> ok
<19> you could fake it by duplicating your text column into another table using triggers, and then doing a fulltext search on that
<22> [Darien] and that type i need to change? longtext?
Return to
#mysql
or
Go to some related
logs:
#python
#web
#gentoo
#osdev
intel 220bg ubuntu drivers
#gentoo
mysql Definer is not fully qualified
transcode
#linux
ubuntu msttfont
|
|