14,954
edits
Microsoft Excel: Difference between revisions
Jump to navigation
Jump to search
m
→Export MySQL query to Excel file
| Line 10: | Line 10: | ||
#* Using {{kbd | key =LIMIT 1048576}} for EXCEL 2007 | #* Using {{kbd | key =LIMIT 1048576}} for EXCEL 2007 | ||
integrated solution for Excel limit 1 | integrated solution for Excel limit 1 ~ limit 3 | ||
* {{kbd | key =<nowiki>SUBSTRING(IF(LEFT(string_column, 1) = '-' OR LEFT(string_column, 1) = '=', CONCAT('\'', string_column), string_column), 1, 32767)</nowiki>}} | * {{kbd | key =<nowiki>SELECT SUBSTRING(IF(LEFT(string_column, 1) = '-' OR LEFT(string_column, 1) = '=', CONCAT('\'', string_column), string_column), 1, 32767) FROM <table> LIMIT 1048576</nowiki>}} | ||
相關文章 | 相關文章 | ||