Tag Info

New answers tagged

1

See my .csv file at bottom of the answer. I created a table xy CREATE TABLE `xy` ( `fred` int(11) DEFAULT NULL, `mary` int(11) DEFAULT NULL, `billy` varchar(50) DEFAULT NULL ); From the documentation here, I tried this LOAD DATA INFILE 'data.txt' INTO TABLE tbl_name FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n' But ...


0

The message is a bit unconcrete, so here's a translation: it appears when the statement 'SELECT @@lower_case_table_names' returns -1 or 0 (only for Win and OS X). So check, if case sensitivity is an issue for you. Update: The message you see is in fact only the title for a (potential) error dialog. The actual message is not listed in that small log. Look ...


0

Instead of DROP + CREATE, simply do TRUNCATE TABLE. That should avoid the error about COMMIT. Drawback: Other code would need to originally do the CREATE and DROP.


0

I did not spot an explicit commit in the code. Therefore the following link lists the MySQL 5.1 operations that can cause an implicit commit. https://dev.mysql.com/doc/refman/5.1/en/implicit-commit.html There are quite a few possibilities. Note this comment: "CREATE TABLE and DROP TABLE statements do not commit a transaction if the TEMPORARY keyword is ...


1

there is a lot of options but choosing the right one is up to you, this is some of the options : 1) Adminer: http://www.adminer.org/ 2) DBeaver: http://dbeaver.jkiss.org/about/ 3)DBVisualizer Free: http://www.dbvis.com/ 4) sql developer (but you need to install the plugins first) : ...


0

OP said: "However I was looking for a "just click and click" solution if you know what I mean. " You can also right click the table you are interested in via the schema inspector tab on the left, and select the option: "Select Rows - Limit 1,000" for a quick view, obviously limited to 1,000 results.


0

Upgrading mySql server is not a fix for this issue. The problem is probably caused by your database name using capital letters on Windows, and windows is case insensitive system. It says in the server options file that you should use 'lower_case_table_names' property set to 2 in case of insensitive file system but even with this setting it still doesn't ...


0

Yes, it's atomic; your domain is the ISBN. If you were storing the domains for ISBNPrefix, ISBNRegistrationGroup, ISBNRegistrant, ISBNPublication and ISBNCheckDigit, then you'd split it up. Consider the North American phone number +1-234-567-8901 ext 234567. Many systems choose to store such a number under two domains, such as PhoneNumber and ...


1

You may need to use shell script for this. First write a script to do so.. a sample is as below !/bin/bash dto=date +%d'_'%b'_'%Y'_'%H_%M_%S mysql -uroot -p dbname -e " select * from table_name into outfile 'file1_$dto' " This will always give you unique names against your files. Hope it helps.


0

Below is the answer to my Service Request related to the same problem from the Oracle Support. "This is a known problem, MySQL Server 5.7 is not in GA yet and currently MEB is not supporting 5.7 versions. Developers are working on it".


1

From the 5.7.6 release notes: If you upgrade to this release of MySQL from an earlier version, you must run mysql_upgrade (and restart the server) to incorporate the changes to the mysql database. mysql_upgrade moves Password column values to the authentication_string column and removes the Password column. For nonupgraded installations that have ...



Top 50 recent answers are included