| |
| |
| |
|
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 25
Comments:
<0> hai all i use database name asterisk and table name cdr
<0> how i can look the feild in my cdr table
<0> hemm what command to use
<1> Fedoracore6: use SQL?
<0> hemm mysql
<0> i type comand use asterisk
<0> and show table;
<0> i can look one table name cdr
<0> hemm now i wanna look feild in my cdr table
<2> !m Fedoracore6 select syntax
<3> Fedoracore6: (SELECT Syntax) : http://dev.mysql.com/doc/mysql/en/SELECT.html
<2> !m Fedoracore6 show create table
<3> Fedoracore6: (SHOW CREATE TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/SHOW_CREATE_TABLE.html
<2> pick whichever answers your question
<0> oic thank all
<4> hey guys, i am having a lot of trouble working out how to get what I want in one query. Is there that much of an overhead doing a 3 queries in a row ?
<5> StarScream: Yes. But that might be the right solution for you.
<5> Later all.
<6> is there a way, when using the mysql shell, to "write-protect" the database one is working on? sometimes i want to do some queries but disable the possibility of making unwanted changes.
<6> if other processes are writing to the db, that's fine, i just want to keep my commands from accidentally screwing something up.
<7> jgarbers: perhaps you want the --i-am-a-dummy option (no joke)
<8> jgarbers: create a user that only has SELECT privs, then log in as that user
<7> that, too.
<6> pCarsten's solution sounds a little less humiliating. infi- are you serious? is there really that option? what does it do?
<8> jgarbers: mysql --help
<2> it prevents deletes and updates without where clauses
<6> ah.
<8> jgarbers: if you want less humiliating, just use --safe-updates instead :-)
<6> that's quick and easy. i like the read-only user option too. thanks, folks
<4> jgarbers: you could copy the database to another database and use that as a test
<6> so to do that it'd be GRANT READ ON blah TO readonlyuser IDENTIFIED BY whatever?
<6> StarScream: that's another good idea
<8> GRANT SELECT on *.* TO ...
<6> what's the easiest way to copy tables or the whole DB to another DB?
<6> mysqldump?
<9> depends
<8> if they are MyISAM, you could shut down the server and copy the db dir to another one, then restart the server
<9> shut down mysql and scp
<10> do I need a MySQL licence if I want to use MySQL for commercial purposes?
<11> That's the general idea. If you don't distribute the source code as GPL, that is.
<10> ow, let me rephrase. I just want to use MySQL in my company (use the database). So I don't mean editing the code and redistributing it
<11> You should be okay then.
<10> ow cool. I thought I would require then also
<6> what's the select syntax to find rows whose column 'created_date' is less than 30 days ago?
<10> G_SabinoMullane, thanks
<6> i'm looking at the date functions and am having trouble figuring that out.
<12> hello all
<12> i would like to know its possible to creat a link betwen 2 table
<10> Buny, yes
<10> using foreign keys
<12> okay i am googling ;)
<13> arjenAU: do we have a little thingi in the bot that explains the license basics?
<10> Buny, it's basic database design. You should find TONS of hits. Good luck
<10> lsmith, good idea. I couldn't find a proper explanation on mysql.com either, so I tried asking here :)
<13> ah well
<13> mysql ab does like to keep things slightly non transparent
<13> their license and support is not very expensive
<2> !m jgarbers date time functions
<3> jgarbers: (Date and Time Functions) : http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html
<10> lsmith, I'm curious because I'm about to start a business and I need to know if I need to pay :-)
<13> so they are hoping maybe that some people will just pay up to get rid of the doubt
<6> shabbs: yep, that's what i was looking at. i figured it out... datediff(curdate(), created_date) < 30 seems to work
<13> SWAT: keep in mind .. most (all?) open source licenses are concerned solely with distribution
<13> if you download them, you can do with them what you want
<13> for internal purposes
<13> including rewriting parts of them
<13> integrating them with proprietary code
<10> so even webhosts who 'rent' mysql databases can use it without a licence.
<13> whatever
<13> yes .. though afaik the gpl3 tries to get at "ASP style distribution"
<10> I'm still remembering/living a few years back. Before the big MySQL licence change
<13> again .. the key is if you distribute or not
<10> lsmith, yet I thank you for your information :-) (You've made me a happy man)
<13> if you dont .. you can lean back
<2> which also depends on one's definition of distribute
<13> just dont forget that mysql ab is happy to take your money once you require support (and can afford it too)
<10> well when I'm making tons of money, I can imagine I could donate some ;)
<2> you can donate some to me anytime :D
<13> you dont have to donate .. just buy their service :-)
<10> shabbs, rofl :0
<14> what is quicker to drop a InnoDB table with millions of rows? TRUNCATE or DROP?
<2> !m dschn truncate syntax
<3> dschn: (TRUNCATE Syntax) : http://dev.mysql.com/doc/mysql/en/TRUNCATE.html
<15> dschn: depends on which version you're using
<2> Therion is a bitch, don't listen to him
<16> lol @ shabbs
<14> Using 4.1. Seems truncate is similar to delete until 5.0 ;/
<15> yes, master
<15> dschn: s/similar/identical/
<2> fark gentoo and their mysql-500 crap
<17> hello
<18> hi
<14> ah, where else can socially inept people be jack***es
<17> I just recently updated a database that is in french. But I'm trying to import the english version back but is not updating the field variables?
<2> 0.o I'm not socially inept, just bitter
<17> does it have to do with the french special characters???
<17> ...which is not allowing for the updates?
<2> Roger: define 'updating the field variables' and 'is in french'
<15> shabbs: you ran off dschn. i am saddened.
<2> you run off people all the time
<17> shabbs: all the content ***ociated with the default table variables are updated in french. What I don't understand is that when I imported the english equivalent, the contents still showing up as french?
<17> what do I need to do to resolve this/
<2> how are you importing?
<17> shabbs: I'm using phpmyadmin tool to browse and import the sql file...
<17> shabbs: it said it successfully updated but did not translate it back to english?
<19> Us socially inept people can be jack***es in ##php also.
<19> Although, #mysql takes the cake.
<19> Which only means yet another award for MySQL
<19> Therion: how's that thong that I got you going?
<15> groundup: seksay
<15> shabbs: yeah, but when I run them off I don't give them a chance to make stupid comments first
<15> shabbs: don't even know what the guy was talking about :P
<2> me neither
<2> off to get an oil change
<20> synthetic gear oil tastes awfull
<21> why do i need to index a primary key so that it is also a foreign key? isn't a primary key already indexed by default automatically?
<22> yes
<22> I'd read it!
<23> Including a chapter on how to swueeze the most performance from you LAMP on a thumbdrive setup!
<20> lots to fiddle with, should take longer than 2 minutes
<23> archivist: But then how would I compete with the blog posts on PlanetMySQL advertising performance tuning in 5 minutes and performance tuning in 3 minutes?
<21> phpmyadmin warns me not to index a field twice, but its the only way to have a primary key also a foreign key. am i right?
<22> mogbit: no
<1> mogbit: primary key is just a special key, but it is still a key
<1> if that made sense
<21> right, but i cant relate the primary key unless it has an index separate from its primary key index
<1> mogbit: where?
<24> http://pastebin.com/589147 I'm getting a syntax error on line 3 and/or 4. Any idea what is wrong?
<23> Oh I would never read that.
<1> arex\: what version?
<1> arex\: that's for 4.1 and above
<25> can MYSQL do cascading updates
<24> 4.0.26 :\
<1> arex\: there you go, just use 'timestamp' as type, will update automatically, the first TIMESTAMP field that is
<1> darkdrgn3k: no?
<25> no ? :(
<25> to bad would save me some headachs LoL
<23> As in cascading updates on foreign keys? yes
<24> Kemurii: what should i replace with timestamp?
<1> or yes
<1> darkdrgn3k: never used it to be honnest, delete yes
<1> darkdrgn3k: check it out
<17> shabbs: can you direct me to some online tutorials that covers the french-english content converter?
<25> Kemurii: it has delete? cool where can i find that info
<1> arex\: http://pastebin.com/589156
<1> !man CREATE TABLE
<3> (CREATE TABLE Syntax) : http://dev.mysql.com/doc/mysql/en/CREATE_TABLE.html
Return to
#mysql
or
Go to some related
logs:
installing freeciv ubuntu
You require additional pylons
#asm
#css
jeeves gentoo
#bash
apt get midnigth
hba0 megaraid
initng chroot gentoo
ubuntu network install
|
|